|
From: Benjamin C. <bc...@us...> - 2001-08-20 22:33:32
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv9969 Modified Files: dbchanges.sql Log Message: Added a field to the user table for storing the columns to show in the bug list Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.6 retrieving revision 1.7 diff -u -r1.6 -r1.7 --- dbchanges.sql 2001/08/19 03:30:56 1.6 +++ dbchanges.sql 2001/08/20 22:33:28 1.7 @@ -143,13 +143,14 @@ `email` char(60) NOT NULL default '', `password` char(40) NOT NULL default '', `user_level` tinyint(3) unsigned NOT NULL default '1', + `bug_list_fields` char(255) NOT NULL default '', `created_by` int(10) unsigned NOT NULL default '0', `created_date` bigint(20) unsigned NOT NULL default '0', `last_modified_by` int(10) unsigned NOT NULL default '0', `last_modified_date` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`) ); -insert into user select UserID, FirstName, LastName, Email, Password, UserLevel, 0, CreatedDate, 0, CreatedDate from User; +insert into user select UserID, FirstName, LastName, Email, Password, UserLevel, '', 0, CreatedDate, 0, CreatedDate from User; CREATE TABLE `version` ( `version_id` int(10) unsigned NOT NULL default '0', |