[phpBT-dev] CVS: phpbt/schemas mysql.in,1.10,1.11 pgsql.in,1.12,1.13

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

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

Modified Files:
	mysql.in pgsql.in 
Log Message:
Changes for project -> group management

Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- mysql.in	2001/12/04 14:32:24	1.10
+++ mysql.in	2001/12/06 14:28:31	1.11
@@ -173,6 +173,13 @@
   PRIMARY KEY  (project_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_PROJECT_GROUP (
+  project_id int(10) unsigned NOT NULL default '0',
+  group_id int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (project_id,group_id),
+  KEY group_id (group_id)
+) TYPE=MyISAM;
+
 CREATE TABLE TBL_RESOLUTION (
   resolution_id int(10) unsigned NOT NULL default '0',
   resolution_name varchar(30) NOT NULL default '',

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- pgsql.in	2001/12/04 14:32:24	1.12
+++ pgsql.in	2001/12/06 14:28:31	1.13
@@ -176,6 +176,14 @@
   PRIMARY KEY  (project_id)
 );
 
+CREATE TABLE TBL_PROJECT_GROUP (
+  project_id INT4  NOT NULL DEFAULT '0',
+  group_id INT4  NOT NULL DEFAULT '0',
+  created_by INT4  NOT NULL DEFAULT '0',
+  created_date INT8  NOT NULL DEFAULT '0',
+  PRIMARY KEY  (project_id,group_id)
+);
+
 CREATE TABLE TBL_RESOLUTION (
   resolution_id INT4  NOT NULL DEFAULT '0',
   resolution_name varchar(30) NOT NULL DEFAULT '',