|
From: Jirka P. <fi...@us...> - 2002-05-18 15:59:23
|
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; + |