[phpBT-dev] CVS: phpbt/schemas mysql.in,1.1,1.2 pgsql.in,1.1,1.2

[Benjamin C. <bc...@us...>]

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',