|
From: Benjamin C. <bc...@us...> - 2001-08-18 03:20:42
|
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', |