From: arjen <arjen>
Date: Fri, 22 Nov 2002 07:01:43 +0000 (+0000)
Subject: Fixed type_of_issueid indices.
X-Git-Tag: V0_0_3~9
X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=677579468a4c263aec3cc8478717555abc1a1076

Fixed type_of_issueid indices.
Fixed 'usr' table.
---

diff --git a/src/database/create.sql b/src/database/create.sql
index 8cd0a4e..880d9c6 100644
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -236,7 +236,7 @@ CREATE UNIQUE INDEX notification_notificationid_key ON notification USING btree
 
 CREATE INDEX not_objectid ON notification USING btree (objectid);
 
-CREATE INDEX not_type_of_notificationid ON notification USING btree (type_of_notificationid);
+CREATE INDEX not_type_of_issueid ON notification USING btree (type_of_issueid);
 
 CREATE INDEX not_timestamp ON notification USING btree ("timestamp");
 
@@ -299,11 +299,11 @@ CREATE TABLE "object_issue"
 	"adjust_setting" text
 );
 
-CREATE UNIQUE INDEX obj_pk ON object_issue USING btree (objectid, type_of_notificationid);
+CREATE UNIQUE INDEX obj_pk ON object_issue USING btree (objectid, type_of_issueid);
 
 CREATE INDEX obj_objectid ON object_issue USING btree (objectid);
 
-CREATE UNIQUE INDEX obj_type_of_notificationid ON object_issue USING btree (type_of_notificationid);
+CREATE UNIQUE INDEX obj_type_of_notificationid ON object_issue USING btree (type_of_issueid);
 
 --
 --
@@ -499,7 +499,7 @@ SELECT setval ('"type_of_issue_type_of_issue_seq"', 1, true);
 --
 --
 
-CREATE TABLE "user"
+CREATE TABLE "usr"
 (
 	"username" text NOT NULL,
 	"active_sessionid" bigint,
@@ -507,11 +507,11 @@ CREATE TABLE "user"
 	"security_level" integer
 );
 
-CREATE UNIQUE INDEX user_username ON user USING btree (username);
+CREATE UNIQUE INDEX usr_username ON usr USING btree (username);
 
-CREATE UNIQUE INDEX user_active_sessionid ON user USING btree (active_sessionid);
+CREATE UNIQUE INDEX usr_active_sessionid ON usr USING btree (active_sessionid);
 
-CREATE INDEX user_account_active ON user USING btree (account_active);
+CREATE INDEX usr_account_active ON usr USING btree (account_active);
 
-CREATE INDEX user_security_level ON user USING btree (security_level);
+CREATE INDEX usr_security_level ON usr USING btree (security_level);
 
diff --git a/src/database/destroy.sql b/src/database/destroy.sql
index 4cccde4..f98a661 100644
--- a/src/database/destroy.sql
+++ b/src/database/destroy.sql
@@ -74,5 +74,5 @@ DROP SEQUENCE "unprocessed_l_unprocessedid_seq";
 DROP TABLE "unprocessed_log";
 
 DROP TABLE "user_gnucomo";
-DROP TABLE "user";
+DROP TABLE "usr";