[phpBT-dev] CVS: phpbt/schemas mysql.in,1.18,1.19 oci8.in,1.4,1.5 pgsql.in,1.20,1.21

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

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

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
The first user preference: Whether to receive email notifications of bug changes

Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- mysql.in	20 Mar 2002 20:10:09 -0000	1.18
+++ mysql.in	21 Mar 2002 13:44:54 -0000	1.19
@@ -232,6 +232,12 @@
   KEY perm_id (perm_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_USER_PREF (
+  user_id int(11) NOT NULL default '0',
+  email_notices tinyint(1) NOT NULL default '1',
+  PRIMARY KEY  (user_id)
+) TYPE=MyISAM;  
+
 CREATE TABLE TBL_VERSION (
   version_id int(10) unsigned NOT NULL default '0',
   project_id int(10) unsigned NOT NULL default '0',

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- oci8.in	20 Mar 2002 20:10:09 -0000	1.4
+++ oci8.in	21 Mar 2002 13:44:54 -0000	1.5
@@ -237,6 +237,12 @@
 ) ;
 CREATE INDEX PERMUSERIDX ON TBL_USER_PERM ( perm_id );
 
+CREATE TABLE TBL_USER_PREF (
+  user_id number(10)   default '0' NOT NULL,
+  email_notices number(1)   default '1' NOT NULL,
+  PRIMARY KEY  (user_id) 
+) ;
+
 CREATE TABLE TBL_VERSION (
   version_id number(10)   default '0' NOT NULL,
   project_id number(10)   default '0' NOT NULL,

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- pgsql.in	20 Mar 2002 20:10:09 -0000	1.20
+++ pgsql.in	21 Mar 2002 13:44:54 -0000	1.21
@@ -230,6 +230,12 @@
   PRIMARY KEY  (user_id,perm_id)
 );
 
+CREATE TABLE TBL_USER_PREF (
+  user_id INT4  NOT NULL DEFAULT '0',
+  email_notices INT2  NOT NULL DEFAULT '1',
+  PRIMARY KEY  (user_id)
+);
+
 CREATE TABLE TBL_VERSION (
   version_id INT4  NOT NULL DEFAULT '0',
   project_id INT4  NOT NULL DEFAULT '0',