|
From: Javier S. <ja...@us...> - 2001-08-17 14:36:33
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv6702 Modified Files: dbchanges.sql Log Message: Adding severity_color field on table severity Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- dbchanges.sql 2001/08/17 03:02:57 1.2 +++ dbchanges.sql 2001/08/17 14:36:30 1.3 @@ -114,6 +114,7 @@ `severity_name` varchar(30) NOT NULL default '', `severity_desc` text NOT NULL, `sort_order` tinyint(3) unsigned NOT NULL default '0', + `severity_color` varchar(6) NOT NULL default 'FFFFFF', PRIMARY KEY (`severity_id`) ); insert into severity select * from Severity; @@ -134,7 +135,7 @@ `email` char(60) NOT NULL default '', `password` char(40) NOT NULL default '', `user_level` tinyint(3) unsigned NOT NULL default '1', - `created_by` int(10) unsigned NOT NULL default '0', + `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', @@ -153,4 +154,4 @@ `last_modified_date` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`version_id`) ); -insert into version select *, CreatedBy, CreatedDate from Version; +insert into version select *, CreatedBy, CreatedDate from Version; \ No newline at end of file |