[phpBT-dev] CVS: phpbt/schemas oci8.in,1.21,1.22 pgsql.in,1.39,1.40

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

Update of /cvsroot/phpbt/phpbt/schemas
In directory sc8-pr-cvs1:/tmp/cvs-serv30407/schemas

Modified Files:
	oci8.in pgsql.in 
Log Message:
Adding project_perm table

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- oci8.in	2 Mar 2003 15:28:54 -0000	1.21
+++ oci8.in	9 Apr 2003 12:11:43 -0000	1.22
@@ -189,6 +189,11 @@
 
 CREATE INDEX GROUPPROJIDX ON TBL_PROJECT_GROUP ( group_id );
 
+CREATE TABLE TBL_PROJECT_PERM (
+  project_id number(10) default '0' NOT NULL,
+  user_id number(10) default '0' NOT NULL
+);
+
 CREATE TABLE TBL_RESOLUTION (
   resolution_id number(10)   default '0' NOT NULL,
   resolution_name varchar2(30)  default '' NOT NULL,

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- pgsql.in	2 Mar 2003 15:28:55 -0000	1.39
+++ pgsql.in	9 Apr 2003 12:11:44 -0000	1.40
@@ -184,6 +184,11 @@
   PRIMARY KEY  (project_id,group_id)
 );
 
+CREATE TABLE TBL_PROJECT_PERM (
+  project_id INT4 NOT NULL DEFAULT '0',
+  user_id INT4 NOT NULL DEFAULT '0'
+);
+
 CREATE TABLE TBL_RESOLUTION (
   resolution_id INT4  NOT NULL DEFAULT '0',
   resolution_name varchar(30) NOT NULL DEFAULT '',