|
From: Benjamin C. <bc...@us...> - 2002-01-26 16:10:08
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv9428/schemas Modified Files: mysql.in pgsql.in Log Message: Added bug_vote table Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- mysql.in 2001/12/24 20:00:49 1.13 +++ mysql.in 2002/01/26 16:10:02 1.14 @@ -109,6 +109,14 @@ created_date bigint(20) unsigned NOT NULL default '0' ) TYPE=MyISAM; +CREATE TABLE TBL_BUG_VOTE ( + user_id int(10) unsigned NOT NULL default '0', + bug_id int(10) unsigned NOT NULL default '0', + created_date bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (user_id, bug_id), + KEY bug_id (bug_id) +) TYPE=MyISAM; + CREATE TABLE TBL_COMMENT ( comment_id int(10) unsigned NOT NULL default '0', bug_id int(10) unsigned NOT NULL default '0', Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- pgsql.in 2001/12/24 20:00:49 1.14 +++ pgsql.in 2002/01/26 16:10:04 1.15 @@ -113,6 +113,13 @@ created_date INT8 NOT NULL DEFAULT '0' ); +CREATE TABLE TBL_BUG_GROUP ( + user_id INT4 NOT NULL DEFAULT '0', + bug_id INT4 NOT NULL DEFAULT '0', + created_date INT8 NOT NULL DEFAULT '0', + PRIMARY KEY (user_id,bug_id) +); + CREATE TABLE TBL_COMMENT ( comment_id INT4 NOT NULL DEFAULT '0', bug_id INT4 NOT NULL DEFAULT '0', |