/lenasys/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/trunk

« back to all changes in this revision

Viewing changes to db.sql

  • Committer: mattman-03
  • Date: 2013-04-09 09:32:13 UTC
  • mfrom: (11.2.6 smallFix)
  • mto: This revision was merged to the branch mainline in revision 22.
  • Revision ID: mattman-03-20130409093213-8qwluai3ydk0lgwp
wikxen merged

Show diffs side-by-side

added added

removed removed

Lines of Context:
db.sql
10
10
    ssn CHAR(11), /*YYMMDD-XXXX*/
11
11
    name VARCHAR(100),
12
12
    loginName VARCHAR(50) UNIQUE, /*a02leifo */
13
 
    passw VARCHAR(50), /*MD5 hashed password*/
 
13
    passw VARCHAR(32), /*MD5 hashed password*/
14
14
    PRIMARY KEY(ssn)    
15
15
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_swedish_ci;
16
16
 
99
99
 
100
100
CREATE TABLE QSystemUser(
101
101
    userName     VARCHAR(16) UNIQUE NOT NULL,
102
 
    passw        VARCHAR(41) NOT NULL,
 
102
    passw        VARCHAR(32) NOT NULL,
103
103
    userType     VARCHAR(10) NOT NULL,
104
104
    PRIMARY KEY(userName)
105
105
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_swedish_ci;