|
From: Jirka P. <fi...@us...> - 2002-06-18 15:24:01
|
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 ( |