Fixed type_of_issueid indices.

Fixed 'usr' table.

diff --git a/src/database/create.sql b/src/database/create.sql
index 8cd0a4e..880d9c6 100644 (file)
--- 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 (file)
--- 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";