[WTF CVS] wtf/db create.sql,1.3,1.4
Brought to you by:
gryphonshafer
From: Gryphon S. <gry...@us...> - 2006-12-11 18:12:22
|
Update of /cvsroot/wtf-tracker/wtf/db In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv9688/db Modified Files: create.sql Log Message: Minor SQL syntaxtical error fix; also fixed a duplicate key error bug Index: create.sql =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/db/create.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** create.sql 3 Dec 2006 23:08:22 -0000 1.3 --- create.sql 11 Dec 2006 18:12:15 -0000 1.4 *************** *** 62,66 **** `team_id` INTEGER UNSIGNED NULL, `username` VARCHAR(255) NOT NULL, ! `passwd` VARCHAR(64) NOT NULL DEFAULT ''r@nd0mt3xt'', `name` VARCHAR(255) NOT NULL, `last_login` DATETIME NULL, --- 62,66 ---- `team_id` INTEGER UNSIGNED NULL, `username` VARCHAR(255) NOT NULL, ! `passwd` VARCHAR(64) NOT NULL DEFAULT 'r@nd0mt3xt', `name` VARCHAR(255) NOT NULL, `last_login` DATETIME NULL, *************** *** 198,201 **** (4,1,'Sub-Line 3',NULL,4,1), (5,NULL,'Business Line B',NULL,5,1), ! (6,5,'Sub-Line 1',NULL,6,1), ! (7,5,'Sub-Line 2',NULL,7,1); --- 198,201 ---- (4,1,'Sub-Line 3',NULL,4,1), (5,NULL,'Business Line B',NULL,5,1), ! (6,5,'Sub-Line 4',NULL,6,1), ! (7,5,'Sub-Line 5',NULL,7,1); |