[phpBT-dev] CVS: phpbt/schemas mysql.in,1.41,1.42

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

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

Modified Files:
	mysql.in 
Log Message:
Multiple statuses can now be set as 'open' or 'closed' -- no longer will 
just BUG_CLOSED show up in most-recently-closed-bugs, etc.

Admin ui allow reassigning open/closed bit to statuses. mysql DB 
touched, rolling to version 4.

Fixed install.php DB_VERSIONing problem.


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -r1.41 -r1.42
--- mysql.in	4 Jun 2003 18:47:20 -0000	1.41
+++ mysql.in	24 Jul 2003 04:47:13 -0000	1.42
@@ -221,6 +221,7 @@
   status_name varchar(30) NOT NULL default '',
   status_desc text NOT NULL,
   sort_order tinyint(3) unsigned NOT NULL default '0',
+  bug_open tinyint(1) unsigned NOT NULL default '1',
   PRIMARY KEY  (status_id)
 ) TYPE=MyISAM;
 
@@ -338,8 +339,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 ('GROUP_ASSIGN_TO', '3', 'The group to whom bugs can be assigned', 'multi');
 INSERT INTO TBL_CONFIGURATION VALUES ('EMAIL_DISABLED', '0', 'Whether to disable all mail sent from the system', 'bool');
 
 INSERT INTO TBL_OS VALUES (1,'All',1,'');
@@ -395,13 +394,13 @@
 create table TBL_SEVERITY_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_SEVERITY_seq values (7);
 
-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 table TBL_STATUS_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_STATUS_seq values (7);