userTypeCodes obsolete, can be replaced by an ENUM

Bug #1171770 reported by Erik Wikström
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LenaSYS
Fix Committed
Undecided
Unassigned

Bug Description

Using a table to enforce the same job as an ENUM is not good design.. An ENUM is often better to use
Change this in databas.sql

Revision history for this message
Gustav Hartvigsson (gustav-hartvigsson) wrote :

I agree.

Changed in lenasys:
status: New → Confirmed
Revision history for this message
Erik Wikström (wikxen) wrote :

CREATE TABLE `Users` (
  `userName` varchar(20) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `passwd` char(40) DEFAULT NULL,
  `userType` enum('Teacher','Student') DEFAULT 'Student',
  `ssn` char(13) DEFAULT NULL COMMENT 'yyyymmdd-xxxx',
  PRIMARY KEY (`userName`),
  UNIQUE KEY `userName_UNIQUE` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Revision history for this message
Gustav Hartvigsson (gustav-hartvigsson) wrote :

Is this not fixed?

Changed in lenasys:
status: Confirmed → Won't Fix
status: Won't Fix → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.