[phpBT-dev] CVS: phpbt/schemas oci8.in,1.11,1.12 pgsql.in,1.28,1.29

[Jirka P. <fi...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv26077/phpbt/schemas

Modified Files:
	oci8.in pgsql.in 
Log Message:
Changed Oracle and PostgreSQL schemas according to my change in MySQL schema. Ben, please, check pgsql.in and let me know, if it's OK. If it's OK, I think I will be able to change all three schemas. 


Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- oci8.in	1 May 2002 12:20:55 -0000	1.11
+++ oci8.in	18 May 2002 15:59:20 -0000	1.12
@@ -62,6 +62,7 @@
   priority number(3)   default '0' NOT NULL,
   status_id number(3)   default '0' NOT NULL,
   resolution_id number(3)   default '0' NOT NULL,
+  database_id number(3)   default '0' NOT NULL,
   assigned_to number(10)   default '0' NOT NULL,
   created_by number(10)   default '0' NOT NULL,
   created_date number(20)   default '0' NOT NULL,
@@ -73,6 +74,8 @@
   os_id number(3)   default '0' NOT NULL,
   browser_string varchar2(255)  default '' NOT NULL,
   close_date number(20)   default '0' NOT NULL,
+  closed_in_version_id number(10) default '0' NOT NULL,
+  to_be_closed_in_version_id number(10) default '0' NOT NULL,
   PRIMARY KEY  (bug_id)
 ) ;
 
@@ -255,6 +258,14 @@
   PRIMARY KEY  (version_id)
 ) ;
 
+CREATE TABLE TBL_DATABASE (
+    database_id number(10) default '0' NOT NULL,
+    database_name varchar2(30) default '' NOT NULL,
+    database_version varchar2(10) default '' NOT NULL,
+    sort_order number(3) default '0' NOT NULL,
+    PRIMARY KEY (database_id)
+);
+
 INSERT INTO TBL_AUTH_USER 
 	(user_id, login, first_name, last_name, email, password)
 	values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 
@@ -365,3 +376,8 @@
 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);
 CREATE SEQUENCE TBL_STATUS_seq START WITH 8 NOCACHE;
+
+INSERT INTO TBL_DATABASE VALUES (1,'Oracle','8.1.7',1);
+INSERT INTO TBL_DATABASE VALUES (2,'MySQL','3.23.49',2);
+INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL','7.1.3',3);
+CREATE SEQUENCE TBL_DATABASE_seq START WITH 4 NOCACHE;

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.28
retrieving revision 1.29
diff -u -r1.28 -r1.29
--- pgsql.in	1 May 2002 12:20:55 -0000	1.28
+++ pgsql.in	18 May 2002 15:59:20 -0000	1.29
@@ -65,6 +65,7 @@
   priority INT2  NOT NULL DEFAULT '0',
   status_id INT2  NOT NULL DEFAULT '0',
   resolution_id INT2  NOT NULL DEFAULT '0',
+  database_id INT2  NOT NULL DEFAULT '0',
   assigned_to INT4  NOT NULL DEFAULT '0',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
@@ -76,6 +77,8 @@
   os_id INT2  NOT NULL DEFAULT '0',
   browser_string varchar(255) NOT NULL DEFAULT '',
   close_date INT8  NOT NULL DEFAULT '0',
+  closed_in_version_id INT4 NOT NULL DEFAULT '0',
+  to_be_closed_in_version_id INT4 NOT NULL DEFAULT '0',
   PRIMARY KEY  (bug_id)
 );
 
@@ -248,6 +251,14 @@
   PRIMARY KEY  (version_id)
 );
 
+CREATE TABLE TBL_DATABASE (
+    database_id INT4 NOT NULL DEFAULT '0',
+    database_name varchar(30) NOT NULL DEFAULT '',
+    database_version varchar(10) NOT NULL DEFAULT '',
+    sort_order INT2 NOT NULL DEFAULT '0',
+    PRIMARY KEY (database_id)
+);
+
 --
 -- -- Insert initial data --
 --
@@ -363,6 +374,10 @@
 INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
 CREATE SEQUENCE TBL_STATUS_seq START 7;
 
+INSERT INTO TBL_DATABASE VALUES (1,'Oracle','8.1.7',1);
+INSERT INTO TBL_DATABASE VALUES (2,'MySQL','3.23.49',2);
+INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL','7.1.3',3);
+CREATE SEQUENCE TBL_DATABASE_seq START 3;
 
 --
 -- Indexes for table TBL_GROUP_PERM
@@ -390,3 +405,4 @@
 
 
 COMMIT;
+