[phpBT-dev] CVS: phpbt/schemas mysql.in,1.44,1.45 oci8.in,1.25,1.26 pgsql.in,1.46,1.47

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

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

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
Patch 989398 - Sequence and assignable field fixes, by Antti Merenluoto


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.44
retrieving revision 1.45
diff -u -r1.44 -r1.45
--- mysql.in	25 Oct 2004 12:07:02 -0000	1.44
+++ mysql.in	25 May 2005 18:04:48 -0000	1.45
@@ -419,3 +419,15 @@
 INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
 create table TBL_SITE_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_SITE_seq values (4);
+
+#-- Sequences for the tables with no initial entries
+create table TBL_BUG_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_BUG_seq values(1);
+create table TBL_COMMENT_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_COMMENT_seq values(1);
+create table TBL_COMPONENT_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_COMPONENT_seq values(1);
+create table TBL_PROJECT_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_PROJECT_seq values(1);
+create table TBL_VERSION_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_VERSION_seq values(1);

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -r1.25 -r1.26
--- oci8.in	4 Jun 2003 18:47:21 -0000	1.25
+++ oci8.in	25 May 2005 18:04:48 -0000	1.26
@@ -20,6 +20,7 @@
   group_id number(10)   default '0' NOT NULL,
   group_name varchar2(80)  default '' NOT NULL,
   locked number(1)   default '0' NOT NULL,
+  assignable number(1) default '0' NOT NULL,
   created_by number(10)   default '0' NOT NULL,
   created_date number(20)   default '0' NOT NULL,
   last_modified_by number(10)   default '0' NOT NULL,
@@ -409,3 +410,10 @@
 INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
 INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
 CREATE SEQUENCE TBL_SITE_seq START WITH 5 NOCACHE;
+
+-- Sequences for the tables with no initial entries
+CREATE SEQUENCE TBL_BUG_seq START WITH 1 NOCACHE;
+CREATE SEQUENCE TBL_COMMENT_seq START WITH 1 NOCACHE;
+CREATE SEQUENCE TBL_COMPONENT_seq START WITH 1 NOCACHE;
+CREATE SEQUENCE TBL_PROJECT_seq START WITH 1 NOCACHE;
+CREATE SEQUENCE TBL_VERSION_seq START WITH 1 NOCACHE;

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.46
retrieving revision 1.47
diff -u -r1.46 -r1.47
--- pgsql.in	25 Oct 2004 12:27:57 -0000	1.46
+++ pgsql.in	25 May 2005 18:04:48 -0000	1.47
@@ -433,32 +433,15 @@
 
 CREATE INDEX group_id_TBL_BUG_GROUP_index ON TBL_BUG_GROUP (group_id);
 
-CREATE SEQUENCE phpbt_auth_user_seq;
-CREATE SEQUENCE phpbt_auth_group_seq;
-CREATE SEQUENCE phpbt_os_seq;
-CREATE SEQUENCE phpbt_resolution_seq;
-CREATE SEQUENCE phpbt_severity_seq;
-CREATE SEQUENCE phpbt_status_seq;
-CREATE SEQUENCE phpbt_database_server_seq;
-CREATE SEQUENCE phpbt_site_seq;
-CREATE SEQUENCE phpbt_version_seq;
-CREATE SEQUENCE phpbt_component_seq;
-CREATE SEQUENCE phpbt_bug_seq;
-CREATE SEQUENCE phpbt_attachment_seq;
-CREATE SEQUENCE phpbt_auth_perm_seq;
-CREATE SEQUENCE phpbt_bug_cc_seq;
-CREATE SEQUENCE phpbt_bug_dependency_seq;
-CREATE SEQUENCE phpbt_bug_group_seq;
-CREATE SEQUENCE phpbt_bug_history_seq;
-CREATE SEQUENCE phpbt_bug_vote_seq;
-CREATE SEQUENCE phpbt_comment_seq;
-CREATE SEQUENCE phpbt_group_perm_seq;
-CREATE SEQUENCE phpbt_project_seq;
-CREATE SEQUENCE phpbt_project_group_seq;
-CREATE SEQUENCE phpbt_saved_query_seq;
-CREATE SEQUENCE phpbt_user_group_seq;
-CREATE SEQUENCE phpbt_user_perm_seq;
-CREATE SEQUENCE phpbt_user_pref_seq;
+-- Sequences for the tables with no initial entries
+--
+CREATE SEQUENCE TBL_BUG_seq;
+CREATE SEQUENCE TBL_COMMENT_seq;
+CREATE SEQUENCE TBL_COMPONENT_seq;
+CREATE SEQUENCE TBL_PROJECT_seq;
+CREATE SEQUENCE TBL_VERSION_seq;
+
+--
 
 COMMIT;