diff options
Diffstat (limited to 'util/updates/update_1.20.sql')
| -rw-r--r-- | util/updates/update_1.20.sql | 13 |
1 files changed, 13 insertions, 0 deletions
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; + |