|
From: Ulf E. <ulf...@us...> - 2005-08-23 21:12:51
|
Update of /cvsroot/phpbt/phpbt/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23167/phpbt/schemas Modified Files: mssql.in mysql.in oci8.in pgsql.in Log Message: Updates Index: mssql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mssql.in,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- mssql.in 23 Aug 2005 21:09:42 -0000 1.2 +++ mssql.in 23 Aug 2005 21:12:38 -0000 1.3 @@ -26,7 +26,6 @@ group_id smallint NOT NULL default '0', group_name varchar(80) NOT NULL default '', locked bit NOT NULL default '0', - assignable bit NOT NULL default '0', created_by smallint NOT NULL default '0', created_date int NOT NULL default '0', last_modified_by smallint NOT NULL default '0', @@ -69,6 +68,14 @@ #-- +# TBL_BOOKMARK +CREATE TABLE TBL_BOOKMARK ( + user_id smallint NOT NULL default '0', + bug_id smallint NOT NULL default '0' +); + + +#-- # TBL_BUG CREATE TABLE TBL_BUG ( bug_id smallint NOT NULL default '0', @@ -170,6 +177,7 @@ component_desc text NOT NULL, owner smallint NOT NULL default '0', active bit NOT NULL default '1', + sort_order tinyint NOT NULL default '0', created_by smallint NOT NULL default '0', created_date int NOT NULL default '0', last_modified_by smallint NOT NULL default '0', @@ -220,6 +228,18 @@ #-- +# TBL_PRIORITY +CREATE TABLE TBL_PRIORITY ( + priority_id tinyint NOT NULL default '0', + priority_name varchar(30) NOT NULL default '', + priority_desc text NOT NULL, + sort_order tinyint NOT NULL default '0', + priority_color varchar(10) NOT NULL default '#FFFFFF', + PRIMARY KEY (priority_id) +); + + +#-- # TBL_PROJECT CREATE TABLE TBL_PROJECT ( project_id smallint NOT NULL default '0', @@ -349,6 +369,7 @@ project_id smallint NOT NULL default '0', version_name char(30) NOT NULL default '', active bit NOT NULL default '1', + sort_order tinyint NOT NULL default '0', created_by smallint NOT NULL default '0', created_date int NOT NULL default '0', last_modified_by smallint NOT NULL default '0', @@ -373,23 +394,28 @@ # Start off with three user levels... INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1); INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1); -INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked, assignable) VALUES (3, 'Developer', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1); CREATE TABLE TBL_AUTH_GROUP_seq ([id] [int] IDENTITY (3, 1) NOT NULL, [vapor] [int] NULL) -# ... and three permissions +# ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); -# Admins can do all the admin stuff, and +# Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs +# users can edit bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +# developers are users who can own bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); @@ -412,6 +438,7 @@ INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to ''dot'' and @ change to ''at''?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool'); +INSERT INTO TBL_CONFIGURATION VALUES ('USE_PRIORITY_COLOR','0','Should the query list use the priority colors as the row background color','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool'); @@ -504,6 +531,19 @@ # +# -- Initialize the PRIORITY table -- +# + +INSERT INTO TBL_PRIORITY VALUES (1,'Low','Fix if possible',1,'#dadada'); +INSERT INTO TBL_PRIORITY VALUES (2,'Medium Low','Must fix before final',2,'#dad0d0'); +INSERT INTO TBL_PRIORITY VALUES (3,'Medium','Fix before next milestone (alpha, beta, etc.)',3,'#dac0c0'); +INSERT INTO TBL_PRIORITY VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0'); +INSERT INTO TBL_PRIORITY VALUES (5,'High','Fix immediately',5,'#daaaaa'); + +CREATE TABLE TBL_PRIORITY_seq ([id] [int] IDENTITY (5, 1) NOT NULL, [vapor] [int] NULL) + + +# # -- Initialize the STATUS table -- # Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.50 retrieving revision 1.51 diff -u -r1.50 -r1.51 --- mysql.in 23 Aug 2005 21:09:42 -0000 1.50 +++ mysql.in 23 Aug 2005 21:12:38 -0000 1.51 @@ -360,11 +360,11 @@ #-- # TBL_USER_PREF CREATE TABLE TBL_USER_PREF ( - 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) + 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.29 retrieving revision 1.30 diff -u -r1.29 -r1.30 --- oci8.in 23 Aug 2005 21:09:42 -0000 1.29 +++ oci8.in 23 Aug 2005 21:12:38 -0000 1.30 @@ -30,7 +30,6 @@ created_date number(20) default '0' NOT NULL, last_modified_by number(10) default '0' NOT NULL, last_modified_date number(20) default '0' NOT NULL, - assignable number(1) default '0' NOT NULL, PRIMARY KEY (group_id) ) ; @@ -68,6 +67,14 @@ #-- +# TBL_BOOKMARK +CREATE TABLE TBL_BOOKMARK ( + user_id number(10) default '0' NOT NULL, + bug_id number(10) default '0' NOT NULL +); + + +#-- # TBL_BUG CREATE TABLE TBL_BUG ( bug_id number(10) default '0' NOT NULL, @@ -173,6 +180,7 @@ component_desc varchar2(4000) NOT NULL, owner number(10) default '0' NOT NULL, active number(1) default '1' NOT NULL, + sort_order number(3) default '0' NOT NULL, created_by number(10) default '0' NOT NULL, created_date number(20) default '0' NOT NULL, last_modified_by number(10) default '0' NOT NULL, @@ -193,6 +201,16 @@ #-- +# TBL_DATABASE +CREATE TABLE TBL_DATABASE ( + database_id number(3) default '0' NOT NULL, + database_name varchar2(40) default '' NOT NULL, + sort_order number(3) default '0' NOT NULL, + PRIMARY KEY (database_id) +); + + +#-- # TBL_GROUP_PERM CREATE TABLE TBL_GROUP_PERM ( group_id number(10) default '0' NOT NULL, @@ -215,6 +233,18 @@ #-- +# TBL_PRIORITY +CREATE TABLE TBL_PRIORITY ( + priority_id number(3) default '0' NOT NULL, + priority_name varchar2(30) default '' NOT NULL, + priority_desc varchar2(4000) NOT NULL, + sort_order number(3) default '0' NOT NULL, + priority_color varchar2(10) default '#FFFFFF' NOT NULL, + PRIMARY KEY (priority_id) +); + + +#-- # TBL_PROJECT CREATE TABLE TBL_PROJECT ( project_id number(10) default '0' NOT NULL, @@ -285,6 +315,16 @@ #-- +# TBL_SITE +CREATE TABLE TBL_SITE ( + site_id number(3) default '0' NOT NULL, + site_name varchar2(50) default '' NOT NULL, + sort_order number(3) default '0' NOT NULL, + PRIMARY KEY (site_id) +); + + +#-- # TBL_STATUS CREATE TABLE TBL_STATUS ( status_id number(10) default '0' NOT NULL, @@ -340,6 +380,7 @@ project_id number(10) default '0' NOT NULL, version_name varchar2(30) default '' NOT NULL, active number(1) default '1' NOT NULL, + sort_order number(3) default '0' NOT NULL, created_by number(10) default '0' NOT NULL, created_date number(20) default '0' NOT NULL, last_modified_by number(10) default '0' NOT NULL, @@ -348,30 +389,11 @@ ) ; -#-- -# TBL_DATABASE -CREATE TABLE TBL_DATABASE ( - database_id number(3) default '0' NOT NULL, - database_name varchar2(40) default '' NOT NULL, - sort_order number(3) default '0' NOT NULL, - PRIMARY KEY (database_id) -); - - -#-- -# TBL_SITE -CREATE TABLE TBL_SITE ( - site_id number(3) default '0' NOT NULL, - site_name varchar2(50) default '' NOT NULL, - sort_order number(3) default '0' NOT NULL, - PRIMARY KEY (site_id) -); - - # # -- Insert initial data -- # + INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', @@ -383,22 +405,28 @@ # Start off with three user levels... INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1); INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1); -INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked, assignable) VALUES (3, 'Developer', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1); CREATE SEQUENCE TBL_AUTH_GROUP_seq START WITH 4 NOCACHE; -# ... and only two permissions +# ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); -# Admins can do all the admin stuff, and +# Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs +# users can edit bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +# developers are users who can own bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); @@ -421,6 +449,7 @@ INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to dot and @ changed to at ?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool'); +INSERT INTO TBL_CONFIGURATION VALUES ('USE_PRIORITY_COLOR','0','Should the query list use the priority colors as the row background color','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool'); @@ -441,7 +470,6 @@ INSERT INTO TBL_CONFIGURATION VALUES ('BUG_PROMOTED','2','The status to assign a bug when it is promoted (if enabled).','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_ASSIGNED','3','The status to assign a bug when it is assigned.','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('BUG_REOPENED','4','The status to assign a bug when it is reopened.','multi'); -INSERT INTO TBL_CONFIGURATION VALUES ('BUG_CLOSED','7','The status to assign a bug when it is closed.','multi'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool'); @@ -514,16 +542,29 @@ # +# -- Initialize the PRIORITY table -- +# + +INSERT INTO TBL_PRIORITY VALUES (1,'Low','Fix if possible',1,'#dadada'); +INSERT INTO TBL_PRIORITY VALUES (2,'Medium Low','Must fix before final',2,'#dad0d0'); +INSERT INTO TBL_PRIORITY VALUES (3,'Medium','Fix before next milestone (alpha, beta, etc.)',3,'#dac0c0'); +INSERT INTO TBL_PRIORITY VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0'); +INSERT INTO TBL_PRIORITY VALUES (5,'High','Fix immediately',5,'#daaaaa'); + +CREATE SEQUENCE TBL_SEVERITY_seq START WITH 6 NOCACHE; + + +# # -- Initialize the STATUS table -- # -INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1); -INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2); -INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3); -INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4); -INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5); -INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6); -INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7); +INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1,1); +INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2,1); +INSERT INTO TBL_STATUS VALUES (3,'Assigned','Assigned to a developer',3,1); +INSERT INTO TBL_STATUS VALUES (4,'Reopened','Closed but opened again for further inspection',4,1); +INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5,0); +INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6,0); +INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7,0); CREATE SEQUENCE TBL_STATUS_seq START WITH 8 NOCACHE; Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.49 retrieving revision 1.50 diff -u -r1.49 -r1.50 --- pgsql.in 23 Aug 2005 21:09:42 -0000 1.49 +++ pgsql.in 23 Aug 2005 21:12:38 -0000 1.50 @@ -26,7 +26,6 @@ group_id INT4 NOT NULL DEFAULT '0', group_name varchar(80) NOT NULL DEFAULT '', locked INT2 NOT NULL DEFAULT 0, - assignable INT2 NOT NULL DEFAULT 0, created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', last_modified_by INT4 NOT NULL DEFAULT '0', @@ -68,6 +67,14 @@ #-- +# TBL_BOOKMARK +CREATE TABLE TBL_BOOKMARK ( + user_id INT4 NOT NULL DEFAULT '0', + bug_id INT4 NOT NULL DEFAULT '0' +); + + +#-- # TBL_BUG CREATE TABLE TBL_BUG ( bug_id INT4 NOT NULL DEFAULT '0', @@ -169,6 +176,7 @@ component_desc TEXT DEFAULT '' NOT NULL, owner INT4 NOT NULL DEFAULT '0', active INT2 NOT NULL DEFAULT '1', + sort_order INT2 NOT NULL DEFAULT '0', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', last_modified_by INT4 NOT NULL DEFAULT '0', @@ -219,6 +227,18 @@ #-- +# TBL_PRIORITY +CREATE TABLE TBL_PRIORITY ( + priority_id INT4 NOT NULL DEFAULT '0', + priority_name varchar(30) NOT NULL DEFAULT '', + priority_desc TEXT DEFAULT '' NOT NULL, + sort_order INT2 NOT NULL DEFAULT '0', + priority_color varchar(10) NOT NULL DEFAULT '#FFFFFF', + PRIMARY KEY (priority_id) +); + + +#-- # TBL_PROJECT CREATE TABLE TBL_PROJECT ( project_id INT4 NOT NULL DEFAULT '0', @@ -348,6 +368,7 @@ project_id INT4 NOT NULL DEFAULT '0', version_name varchar(30) NOT NULL DEFAULT '', active INT2 NOT NULL DEFAULT '1', + sort_order INT2 NOT NULL DEFAULT '0', created_by INT4 NOT NULL DEFAULT '0', created_date INT8 NOT NULL DEFAULT '0', last_modified_by INT4 NOT NULL DEFAULT '0', @@ -372,23 +393,28 @@ # Start off with three user levels... INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1); INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1); -INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked, assignable) VALUES (3, 'Developer', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1); CREATE SEQUENCE TBL_AUTH_GROUP_seq START 4; -# ... and three permissions +# ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); -# Admins can do all the admin stuff, and +# Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs +# users can edit bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +# developers are users who can own bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); @@ -411,6 +437,7 @@ INSERT INTO TBL_CONFIGURATION VALUES ('MASK_EMAIL','1','Should email addresses have . changed to ''dot'' and @ change to ''at''?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('HIDE_EMAIL','1','Should email addresses be hidden for those not logged in?','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool'); +INSERT INTO TBL_CONFIGURATION VALUES ('USE_PRIORITY_COLOR','0','Should the query list use the priority colors as the row background color','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool'); INSERT INTO TBL_CONFIGURATION VALUES ('STRICT_UPDATING', '0', 'Only the bug reporter, bug owner, managers, and admins can change a bug', 'bool'); INSERT INTO TBL_CONFIGURATION VALUES ('NEW_ACCOUNTS_DISABLED', '0', 'Only admins can create new user accounts - newaccount.php is disabled', 'bool'); @@ -503,6 +530,19 @@ # +# -- Initialize the PRIORITY table -- +# + +INSERT INTO TBL_PRIORITY VALUES (1,'Low','Fix if possible',1,'#dadada'); +INSERT INTO TBL_PRIORITY VALUES (2,'Medium Low','Must fix before final',2,'#dad0d0'); +INSERT INTO TBL_PRIORITY VALUES (3,'Medium','Fix before next milestone (alpha, beta, etc.)',3,'#dac0c0'); +INSERT INTO TBL_PRIORITY VALUES (4,'Medium High','Fix as soon as possible',4,'#dab0b0'); +INSERT INTO TBL_PRIORITY VALUES (5,'High','Fix immediately',5,'#daaaaa'); + +CREATE SEQUENCE TBL_PRIORITY_seq START 6; + + +# # -- Initialize the STATUS table -- # |