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

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

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

Modified Files:
	dbchanges.sql 
Log Message:
Lengthen the bug title field and add a close_date field to the bug table

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- dbchanges.sql	2001/08/17 19:30:07	1.4
+++ dbchanges.sql	2001/08/18 03:20:40	1.5
@@ -13,7 +13,7 @@
 
 CREATE TABLE `bug` (
   `bug_id` int(10) unsigned NOT NULL default '0',
-  `bug_title` varchar(30) NOT NULL default '',
+  `bug_title` varchar(100) NOT NULL default '',
   `bug_desc` text NOT NULL,
   `bug_url` varchar(255) NOT NULL default '',
   `severity_id` tinyint(3) unsigned NOT NULL default '0',
@@ -30,9 +30,10 @@
   `component_id` int(10) unsigned NOT NULL default '0',
   `op_sys_id` tinyint(3) unsigned NOT NULL default '0',
   `browser_string` varchar(255) NOT NULL default '',
+	`close_date` bigint(20) unsigned NOT NULL default '0',
   PRIMARY KEY  (`bug_id`)
 );
-insert into bug select * from Bug;
+insert into bug select *, 0 from Bug;
 
 CREATE TABLE `bug_history` (
   `bug_id` int(10) unsigned NOT NULL default '0',