cvs: php-bugs-web / bugs.sql

bjori Thu Sep 28 18:11:07 2006 UTC Modified files: /php-bugs-web bugs.sql Log: Update table structure #Thanks Derick! http://cvs.php.net/viewvc.cgi/php-bugs-web/bugs.sql?r1=1.7&r2=1.8&diff_format=u Index: php-bugs-web/bugs.sql diff -u php-bugs-web/bugs.sql:1.7 php-bugs-web/bugs.sql:1.8 --- php-bugs-web/bugs.sql:1.7 Thu Jun 20 04:32:39 2002 +++ php-bugs-web/bugs.sql Thu Sep 28 18:11:07 2006 @@ -6,7 +6,9 @@ CREATE TABLE bugdb ( id int(8) NOT NULL AUTO_INCREMENT, - bug_type char(32), + project tinyint(4) NOT NULL default '1', + bug_type varchar(32) NOT NULL default '', + severity tinyint(4) NOT NULL default '0', email varchar(40) NOT NULL, sdesc varchar(80) NOT NULL, ldesc text NOT NULL, @@ -15,12 +17,17 @@ status varchar(16), ts1 datetime, # bug created date ts2 datetime, # bug last updated date + dev_id varchar(16) default NULL, assign varchar(16), passwd varchar(20),# user password - PRIMARY KEY (id), - INDEX (php_version(1)), - FULLTEXT (email,sdesc,ldesc) -); + bugpack_id int(5) default NULL, + milestone_id int(11) default NULL, + PRIMARY KEY (id), + KEY php_version (php_version(1)), + KEY bug_type (bug_type), + KEY status (status), + FULLTEXT KEY email (email,sdesc,ldesc) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; DROP TABLE IF EXISTS bugdb_comments; @@ -28,21 +35,21 @@ id int(8) NOT NULL AUTO_INCREMENT, bug int(8) NOT NULL, email varchar(40) NOT NULL, - ts datetime NOT NULL, + ts datetime NOT NULL default '0000-00-00 00:00:00', comment text NOT NULL, PRIMARY KEY (id), - FULLTEXT (comment) -); + FULLTEXT KEY comment (comment) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; DROP TABLE IF EXISTS bugdb_votes; CREATE TABLE bugdb_votes ( bug int(8) NOT NULL, ts timestamp NOT NULL, - ip int unsigned NOT NULL, + ip int(10) default NULL, score int(3) NOT NULL, /* 1-5 */ reproduced int(1) NOT NULL, tried int(1) NOT NULL, sameos int(1), samever int(1) -); +) ENGINE=MyISAM DEFAULT CHARSET=latin1;