cvs: php-bugs-web / bugs.sql

jimw Sun Sep 23 22:33:57 2001 EDT Modified files: /php-bugs-web bugs.sql Log: update table description Index: php-bugs-web/bugs.sql diff -u php-bugs-web/bugs.sql:1.1 php-bugs-web/bugs.sql:1.2 --- php-bugs-web/bugs.sql:1.1 Thu Sep 20 20:59:45 2001 +++ php-bugs-web/bugs.sql Sun Sep 23 22:33:56 2001 @@ -8,8 +8,8 @@ id int(8) NOT NULL AUTO_INCREMENT, bug_type char(32), email varchar(40) NOT NULL, - sdesc varchar(80), - ldesc text, + sdesc varchar(80) NOT NULL, + ldesc text NOT NULL, php_version char(16), php_os varchar(32), status varchar(16), @@ -18,7 +18,8 @@ dev_id varchar(16),# developer who last commented assign varchar(16), passwd varchar(20),# user password - PRIMARY KEY (id) + PRIMARY KEY (id), + FULLTEXT (email,sdesc,ldesc) ); CREATE TABLE bugdb_comments ( @@ -26,6 +27,7 @@ bug int(8) NOT NULL, email varchar(40) NOT NULL, ts datetime NOT NULL, - comment text, - PRIMARY KEY (id) + comment text NOT NULL, + PRIMARY KEY (id), + FULLTEXT (comment) );