projects
/
gnucomo.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
7ac4517
)
Fixed type_of_issueid indices.
author
arjen
<arjen>
Fri, 22 Nov 2002 07:01:43 +0000
(07:01 +0000)
committer
arjen
<arjen>
Fri, 22 Nov 2002 07:01:43 +0000
(07:01 +0000)
Fixed 'usr' table.
src/database/create.sql
patch
|
blob
|
history
src/database/destroy.sql
patch
|
blob
|
history
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);
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 "unprocessed_log";
DROP TABLE "user_gnucomo";
-DROP TABLE "us
e
r";
+DROP TABLE "usr";