|
From: Benjamin C. <bc...@us...> - 2001-07-30 13:50:42
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv17178 Modified Files: createdb.sql Log Message: Added the BugHistory table Index: createdb.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/createdb.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- createdb.sql 2001/07/11 03:36:04 1.3 +++ createdb.sql 2001/07/30 13:50:38 1.4 @@ -282,3 +282,12 @@ PRIMARY KEY (name,sid), KEY changed (changed) ); + +CREATE TABLE `BugHistory` ( + `BugID` int(10) unsigned NOT NULL default '0', + `ChangedField` char(20) NOT NULL default '', + `OldValue` char(255) NOT NULL default '', + `NewValue` char(255) NOT NULL default '', + `CreatedBy` int(10) unsigned NOT NULL default '0', + `CreatedDate` bigint(20) unsigned NOT NULL default '0' +); |