diff options
Diffstat (limited to 'util')
| -rw-r--r-- | util/dump.sql | 12 | ||||
| -rw-r--r-- | util/updates/update_1.20.sql | 13 |
2 files changed, 25 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql index ce0f8be4..54dd9f6b 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -113,6 +113,16 @@ CREATE TABLE releases_vn ( PRIMARY KEY(rid, vid) ); +-- rlists +CREATE TABLE rlists ( + uid integer NOT NULL DEFAULT 0, + rid integer NOT NULL DEFAULT 0, + vstat smallint NOT NULL DEFAULT 0, + rstat smallint NOT NULL DEFAULT 0, + added bigint NOT NULL DEFAULT DATE_PART('epoch', NOW()), + PRIMARY KEY(uid, rid) +); + -- threads CREATE TABLE threads ( id SERIAL NOT NULL PRIMARY KEY, @@ -247,6 +257,8 @@ ALTER TABLE releases_rev ADD FOREIGN KEY (id) REFERENCES changes ALTER TABLE releases_rev ADD FOREIGN KEY (rid) REFERENCES releases (id) DEFERRABLE INITIALLY DEFERRED; ALTER TABLE releases_vn ADD FOREIGN KEY (rid) REFERENCES releases_rev (id) DEFERRABLE INITIALLY DEFERRED; 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 threads_posts ADD FOREIGN KEY (tid) REFERENCES threads (id) DEFERRABLE INITIALLY DEFERRED; ALTER TABLE threads_posts ADD FOREIGN KEY (uid) REFERENCES users (id) DEFERRABLE INITIALLY DEFERRED; ALTER TABLE threads_tags ADD FOREIGN KEY (tid) REFERENCES threads (id) DEFERRABLE INITIALLY DEFERRED; diff --git a/util/updates/update_1.20.sql b/util/updates/update_1.20.sql index 9c02e184..4abd2211 100644 --- a/util/updates/update_1.20.sql +++ b/util/updates/update_1.20.sql @@ -2,3 +2,16 @@ -- deleted user INSERT INTO users (id, username, mail, rank) VALUES (0, 'deleted', 'del@vndb.org', 0); + + + +-- release lists +CREATE TABLE rlists ( + uid integer NOT NULL DEFAULT 0 REFERENCES users (id) DEFERRABLE INITIALLY DEFERRED, + rid integer NOT NULL DEFAULT 0 REFERENCES releases (id) DEFERRABLE INITIALLY DEFERRED, + vstat smallint NOT NULL DEFAULT 0, + rstat smallint NOT NULL DEFAULT 0, + added bigint NOT NULL DEFAULT DATE_PART('epoch', NOW()), + PRIMARY KEY(uid, rid) +) WITHOUT OIDS; + |