blob: c84574984cc99e401c1a965cd3c3139aae9c974e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
-- screenshots
--CREATE SEQUENCE screenshots_seq;
CREATE TABLE vn_screenshots (
vid integer NOT NULL DEFAULT 0 REFERENCES vn_rev (id) DEFERRABLE INITIALLY DEFERRED,
scr integer NOT NULL DEFAULT 0,
nsfw smallint NOT NULL DEFAULT 0,
PRIMARY KEY(vid, scr)
) WITHOUT OIDS;
|