[phpBT-dev] CVS: phpbt/schemas pgsql.in,1.43.4.1,1.43.4.2

[Benjamin C. <bc...@us...>]

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

Modified Files:
      Tag: htmltemplates
	pgsql.in 
Log Message:
Synching with mysql schema

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.43.4.1
retrieving revision 1.43.4.2
diff -u -r1.43.4.1 -r1.43.4.2
--- pgsql.in	30 Aug 2003 22:08:35 -0000	1.43.4.1
+++ pgsql.in	1 Dec 2003 14:11:59 -0000	1.43.4.2
@@ -23,7 +23,8 @@
   group_id INT4  NOT NULL DEFAULT '0',
   group_name varchar(80) NOT NULL DEFAULT '',
   locked INT2 NOT NULL DEFAULT 0,
-	created_by INT4  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',
   last_modified_date INT8  NOT NULL DEFAULT '0',
@@ -220,6 +221,7 @@
   status_name varchar(30) NOT NULL DEFAULT '',
   status_desc TEXT DEFAULT '' NOT NULL,
   sort_order INT2  NOT NULL DEFAULT '0',
+  bug_open INT2  NOT NULL DEFAULT '0',
   PRIMARY KEY  (status_id)
 );
 
@@ -334,7 +336,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');
 
 INSERT INTO TBL_OS VALUES (1,'All',1,'');
@@ -387,13 +388,13 @@
 INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
 CREATE SEQUENCE TBL_SEVERITY_seq START 8;
 
-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 8;
 
 INSERT INTO TBL_DATABASE VALUES (1,'Oracle 8.1.7',1);