diff options
Diffstat (limited to 'util/updates/update_1.21.sql')
-rw-r--r-- | util/updates/update_1.21.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/util/updates/update_1.21.sql b/util/updates/update_1.21.sql new file mode 100644 index 00000000..c8457498 --- /dev/null +++ b/util/updates/update_1.21.sql @@ -0,0 +1,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; + + |