|
From: Benjamin C. <bc...@us...> - 2002-03-21 13:44:57
|
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', |