summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-08 11:29:36 +0200
committerYorhel <git@yorhel.nl>2009-07-08 11:29:36 +0200
commitf89f04a1c646e59cdc009ddd677748527e2c3c2e (patch)
treec9f5986c7fc3a3bca3400ecb891ed2b76be066db /util/dump.sql
parent5d6f09f838392f1e2c072f44f904b5f9eab95f45 (diff)
Keep track of users who requested tags
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 6fe4bc08..22e80099 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -175,7 +175,8 @@ CREATE TABLE tags (
meta boolean NOT NULL DEFAULT FALSE,
added bigint NOT NULL DEFAULT DATE_PART('epoch'::text, NOW()),
state smallint NOT NULL DEFAULT 0,
- c_vns integer NOT NULL DEFAULT 0
+ c_vns integer NOT NULL DEFAULT 0,
+ addedby integer NOT NULL DEFAULT 1
);
-- tags_aliases
@@ -375,6 +376,7 @@ ALTER TABLE releases_vn ADD FOREIGN KEY (rid) REFERENCES releases_r
ALTER TABLE releases_vn ADD FOREIGN KEY (vid) REFERENCES vn (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE rlists ADD FOREIGN KEY (uid) REFERENCES users (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE rlists ADD FOREIGN KEY (rid) REFERENCES releases (id) DEFERRABLE INITIALLY DEFERRED;
+ALTER TABLE tags ADD FOREIGN KEY (addedby) REFERENCES users (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE tags_aliases ADD FOREIGN KEY (tag) REFERENCES tags (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE tags_parents ADD FOREIGN KEY (tag) REFERENCES tags (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE tags_parents ADD FOREIGN KEY (parent) REFERENCES tags (id) DEFERRABLE INITIALLY DEFERRED;