[phpBT-dev] CVS: phpbt/schemas mysql.in,1.45,1.46

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7041/schemas

Modified Files:
	mysql.in 
Log Message:
RFE #759250 - Table Driven Priorities.


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -r1.45 -r1.46
--- mysql.in	25 May 2005 18:04:48 -0000	1.45
+++ mysql.in	22 Aug 2005 19:44:47 -0000	1.46
@@ -216,6 +216,15 @@
   PRIMARY KEY  (severity_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_PRIORITY (
+  priority_id int(10) unsigned NOT NULL default '0',
+  priority_name varchar(30) NOT NULL default '',
+  priority_desc text NOT NULL,
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  priority_color varchar(10) NOT NULL default '#FFFFFF',
+  PRIMARY KEY  (priority_id)
+) TYPE=MyISAM;
+
 CREATE TABLE TBL_STATUS (
   status_id int(10) unsigned NOT NULL default '0',
   status_name varchar(30) NOT NULL default '',
@@ -320,6 +329,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');
@@ -395,6 +405,14 @@
 create table TBL_SEVERITY_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_SEVERITY_seq values (7);
 
+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 unsigned auto_increment not null primary key);
+insert into TBL_PRIORITY_seq values (5);
+
 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);