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");
"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);
--
--
--
--
-CREATE TABLE "user"
+CREATE TABLE "usr"
(
"username" text NOT NULL,
"active_sessionid" bigint,
"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);