[phpBT-dev] CVS: phpbt/schemas pgsql.in,1.45,1.46

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

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

Modified Files:
	pgsql.in 
Log Message:
Create all the postgres sequences, as suggested by Erik Osterman

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -r1.45 -r1.46
--- pgsql.in	25 Oct 2004 12:07:02 -0000	1.45
+++ pgsql.in	25 Oct 2004 12:27:57 -0000	1.46
@@ -242,10 +242,10 @@
 );
 
 CREATE TABLE TBL_USER_PREF (
-    user_id INT4 NOT NULL DEFAULT '0',
-    email_notices INT2 NOT NULL DEFAULT '1',
-    saved_queries INT2 NOT NULL DEFAULT '1',
-    def_results INT4 NOT NULL DEFAULT '20',
+	user_id INT4 NOT NULL DEFAULT '0',
+	email_notices INT2 NOT NULL DEFAULT '1',
+	saved_queries INT2 NOT NULL DEFAULT '1',
+	def_results INT4 NOT NULL DEFAULT '20',
 	PRIMARY KEY (user_id)
 );
 
@@ -262,17 +262,17 @@
 );
 
 CREATE TABLE TBL_DATABASE (
-    database_id INT2 NOT NULL DEFAULT '0',
-    database_name varchar(40) NOT NULL DEFAULT '',
-    sort_order INT2 NOT NULL DEFAULT '0',
-    PRIMARY KEY (database_id)
+	database_id INT2 NOT NULL DEFAULT '0',
+	database_name varchar(40) NOT NULL DEFAULT '',
+	sort_order INT2 NOT NULL DEFAULT '0',
+	PRIMARY KEY (database_id)
 );
 
 CREATE TABLE TBL_SITE (
-    site_id INT2 NOT NULL DEFAULT '0',
-    site_name varchar(50) NOT NULL DEFAULT '',
-    sort_order INT2 NOT NULL DEFAULT '0',
-    PRIMARY KEY (site_id)
+	site_id INT2 NOT NULL DEFAULT '0',
+	site_name varchar(50) NOT NULL DEFAULT '',
+	sort_order INT2 NOT NULL DEFAULT '0',
+	PRIMARY KEY (site_id)
 );
 
 --
@@ -433,5 +433,32 @@
 
 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;
+
 COMMIT;