[phpBT-dev] CVS: phpbt/schemas mysql.in,1.31,1.32 oci8.in,1.15,1.16 pgsql.in,1.32,1.33

[Jirka P. <fi...@us...>]

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

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
Added column (everything else is only code cleanup) for saved queries checkbox on personal page, but I think it'll be better to have only 3 columns for user_id, option_name, option_value. Thoughts?


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- mysql.in	14 Jun 2002 15:30:45 -0000	1.31
+++ mysql.in	18 Jun 2002 15:23:58 -0000	1.32
@@ -237,10 +237,11 @@
 ) 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;  
+    user_id int(11) NOT NULL default '0',
+    email_notices tinyint(1) NOT NULL default '1',
+    saved_queries 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',

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- oci8.in	14 Jun 2002 15:30:45 -0000	1.15
+++ oci8.in	18 Jun 2002 15:23:58 -0000	1.16
@@ -242,10 +242,11 @@
 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) 
-) ;
+    user_id number(10) default '0' NOT NULL,
+    email_notices number(1) default '1' NOT NULL,
+    saved_queries number(1) default '1' NOT NULL,
+    PRIMARY KEY (user_id)
+);
 
 CREATE TABLE TBL_VERSION (
   version_id number(10)   default '0' NOT NULL,

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- pgsql.in	14 Jun 2002 15:30:45 -0000	1.32
+++ pgsql.in	18 Jun 2002 15:23:58 -0000	1.33
@@ -235,9 +235,10 @@
 );
 
 CREATE TABLE TBL_USER_PREF (
-  user_id INT4  NOT NULL DEFAULT '0',
-  email_notices INT2  NOT NULL DEFAULT '1',
-  PRIMARY KEY  (user_id)
+    user_id INT4 NOT NULL DEFAULT '0',
+    email_notices INT2 NOT NULL DEFAULT '1',
+    saved_queries INT2 NOT NULL DEFAULT '1',
+    PRIMARY KEY (user_id)
 );
 
 CREATE TABLE TBL_VERSION (