[phpBT-dev] CVS: phpbt/schemas mysql.in,1.40,1.41 oci8.in,1.24,1.25 pgsql.in,1.42,1.43

[Ken T. <ke...@us...>]

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

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
finished storage handler for user's default #-of-results returned
discovered and fixed bug in user preferences page ("set" appeared many times)
pushed db_version pointer up to 3, adding def_results to TBL_USER_PREF
   - updated schemas
   - update.php
languages for def_results



Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.40
retrieving revision 1.41
diff -u -r1.40 -r1.41
--- mysql.in	7 May 2003 14:32:06 -0000	1.40
+++ mysql.in	4 Jun 2003 18:47:20 -0000	1.41
@@ -246,6 +246,7 @@
     user_id int(11) NOT NULL default '0',
     email_notices tinyint(1) NOT NULL default '1',
     saved_queries tinyint(1) NOT NULL default '1',
+    def_results int(11) NOT NULL default '20',
     PRIMARY KEY (user_id)
 ) TYPE=MyISAM;
 

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -r1.24 -r1.25
--- oci8.in	14 May 2003 00:13:27 -0000	1.24
+++ oci8.in	4 Jun 2003 18:47:21 -0000	1.25
@@ -250,7 +250,8 @@
     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)
+    def_results number(10) default '20' NOT NULL,
+	PRIMARY KEY (user_id)
 );
 
 CREATE TABLE TBL_VERSION (

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- pgsql.in	14 May 2003 00:13:27 -0000	1.42
+++ pgsql.in	4 Jun 2003 18:47:21 -0000	1.43
@@ -243,7 +243,8 @@
     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)
+    def_results INT4 NOT NULL DEFAULT '20',
+	PRIMARY KEY (user_id)
 );
 
 CREATE TABLE TBL_VERSION (