projects
/
gnucomo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed type_of_issueid indices.
[gnucomo.git]
/
src
/
database
/
create.sql
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_objectid ON notification USING btree (objectid);
-CREATE INDEX not_type_of_
notificationid ON notification USING btree (type_of_notification
id);
+CREATE INDEX not_type_of_
issueid ON notification USING btree (type_of_issue
id);
CREATE INDEX not_timestamp ON notification USING btree ("timestamp");
CREATE INDEX not_timestamp ON notification USING btree ("timestamp");
@@
-299,11
+299,11
@@
CREATE TABLE "object_issue"
"adjust_setting" text
);
"adjust_setting" text
);
-CREATE UNIQUE INDEX obj_pk ON object_issue USING btree (objectid, type_of_
notification
id);
+CREATE UNIQUE INDEX obj_pk ON object_issue USING btree (objectid, type_of_
issue
id);
CREATE INDEX obj_objectid ON object_issue USING btree (objectid);
CREATE INDEX obj_objectid ON object_issue USING btree (objectid);
-CREATE UNIQUE INDEX obj_type_of_notificationid ON object_issue USING btree (type_of_
notification
id);
+CREATE UNIQUE INDEX obj_type_of_notificationid ON object_issue USING btree (type_of_
issue
id);
--
--
--
--
@@
-499,7
+499,7
@@
SELECT setval ('"type_of_issue_type_of_issue_seq"', 1, true);
--
--
--
--
-CREATE TABLE "us
e
r"
+CREATE TABLE "usr"
(
"username" text NOT NULL,
"active_sessionid" bigint,
(
"username" text NOT NULL,
"active_sessionid" bigint,
@@
-507,11
+507,11
@@
CREATE TABLE "user"
"security_level" integer
);
"security_level" integer
);
-CREATE UNIQUE INDEX us
er_username ON use
r USING btree (username);
+CREATE UNIQUE INDEX us
r_username ON us
r USING btree (username);
-CREATE UNIQUE INDEX us
er_active_sessionid ON use
r USING btree (active_sessionid);
+CREATE UNIQUE INDEX us
r_active_sessionid ON us
r USING btree (active_sessionid);
-CREATE INDEX us
er_account_active ON use
r USING btree (account_active);
+CREATE INDEX us
r_account_active ON us
r USING btree (account_active);
-CREATE INDEX us
er_security_level ON use
r USING btree (security_level);
+CREATE INDEX us
r_security_level ON us
r USING btree (security_level);