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

-- screenshots
CREATE TABLE screenshots (
  id SERIAL NOT NULL PRIMARY KEY,
  status smallint NOT NULL DEFAULT 0, -- 0:unprocessed, 1:processed, <0:error (unimplemented)
  width smallint NOT NULL DEFAULT 0,
  height smallint NOT NULL DEFAULT 0
) WITHOUT OIDS;

CREATE TABLE vn_screenshots (
  vid integer NOT NULL DEFAULT 0 REFERENCES vn_rev      (id) DEFERRABLE INITIALLY DEFERRED,
  scr integer NOT NULL DEFAULT 0 REFERENCES screenshots (id) DEFERRABLE INITIALLY DEFERRED,
  nsfw smallint NOT NULL DEFAULT 0,
  PRIMARY KEY(vid, scr)
) WITHOUT OIDS;