[phpBT-dev] CVS: phpbt/schemas mysql.in,1.13,1.14 pgsql.in,1.14,1.15

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

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