[phpBT-dev] CVS: phpbt dbchanges.sql,1.3,1.4

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv8672

Modified Files:
	dbchanges.sql 
Log Message:
Allow for longer color string for non-hex color strings

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- dbchanges.sql	2001/08/17 14:36:30	1.3
+++ dbchanges.sql	2001/08/17 19:30:07	1.4
@@ -114,10 +114,10 @@
   `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',
+  `severity_color` varchar(10) NOT NULL default '#FFFFFF',
   PRIMARY KEY  (`severity_id`)
 );
-insert into severity select * from Severity;
+insert into severity select *, null from Severity;
 
 CREATE TABLE `status` (
   `status_id` int(10) unsigned NOT NULL default '0',
@@ -154,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;
\ No newline at end of file
+insert into version select *, CreatedBy, CreatedDate from Version;