[phpBT-dev] CVS: phpbt/schemas mysql.in,1.16,1.17 oci8.in,1.2,1.3 pgsql.in,1.18,1.19

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

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv25298/schemas

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
Added bug dependencies

Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -r1.16 -r1.17
--- mysql.in	17 Mar 2002 01:36:08 -0000	1.16
+++ mysql.in	18 Mar 2002 17:47:07 -0000	1.17
@@ -84,6 +84,12 @@
   PRIMARY KEY  (bug_id,user_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_BUG_DEPENDENCY (
+  bug_id int(10) unsigned NOT NULL default '0',
+  depends_on int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (bug_id,depends_on)
+) 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: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- oci8.in	17 Mar 2002 01:36:10 -0000	1.2
+++ oci8.in	18 Mar 2002 17:47:07 -0000	1.3
@@ -84,6 +84,12 @@
   PRIMARY KEY  (bug_id ,user_id)
 ) ;
 
+CREATE TABLE TBL_BUG_DEPENDENCY (
+  bug_id number(10)   default '0' NOT NULL,
+  depends_on number(10)   default '0' NOT NULL,
+  PRIMARY KEY  (bug_id ,depends_on) 
+) ;
+
 CREATE TABLE TBL_BUG_GROUP (
   bug_id number(10)   default '0' NOT NULL,
   group_id number(10)   default '0' NOT NULL,

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- pgsql.in	17 Mar 2002 01:36:10 -0000	1.18
+++ pgsql.in	18 Mar 2002 17:47:07 -0000	1.19
@@ -87,6 +87,12 @@
   PRIMARY KEY  (bug_id,user_id)
 );
 
+CREATE TABLE TBL_BUG_DEPENDENCY (
+  bug_id INT4  NOT NULL DEFAULT '0',
+  depends_on INT4  NOT NULL DEFAULT '0',
+  PRIMARY KEY  (bug_id,depends_on)
+);
+
 CREATE TABLE TBL_BUG_GROUP (
   bug_id INT4  NOT NULL DEFAULT '0',
   group_id INT4  NOT NULL DEFAULT '0',