|
From: Benjamin C. <bc...@us...> - 2001-09-22 16:55:36
|
Update of /cvsroot/phpbt/phpbt/schemas In directory usw-pr-cvs1:/tmp/cvs-serv10163/schemas Modified Files: mysql.in pgsql.in Log Message: Added bug CCs Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- mysql.in 2001/09/15 16:22:13 1.1 +++ mysql.in 2001/09/22 16:55:33 1.2 @@ -90,6 +90,14 @@ PRIMARY KEY (bug_id) ) TYPE=MyISAM; +CREATE TABLE TBL_BUG_CC ( + bug_id int(10) unsigned NOT NULL default '0', + user_id int(10) unsigned NOT NULL default '0', + created_by int(10) unsigned NOT NULL default '0', + created_date bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (bug_id,user_id) +) TYPE=MyISAM; + CREATE TABLE TBL_BUG_GROUP ( bug_id int(10) unsigned NOT NULL default '0', group_id int(10) unsigned NOT NULL default '0', Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- pgsql.in 2001/09/15 16:22:13 1.1 +++ pgsql.in 2001/09/22 16:55:33 1.2 @@ -92,6 +92,14 @@ PRIMARY KEY (bug_id) ); +CREATE TABLE TBL_BUG_CC ( + bug_id INT4 NOT NULL DEFAULT '0', + user_id INT4 NOT NULL DEFAULT '0', + created_by INT4 NOT NULL DEFAULT '0', + created_date INT8 NOT NULL DEFAULT '0', + PRIMARY KEY (bug_id,user_id) +); + CREATE TABLE TBL_BUG_GROUP ( bug_id INT4 NOT NULL DEFAULT '0', group_id INT4 NOT NULL DEFAULT '0', |