summaryrefslogtreecommitdiff
path: root/util/updates/update_1.20.sql
blob: 4abd22119a2e44e4a3ff313b24a97478dea1ded6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- 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;