blob: 970aa0e12b6804edc3bde9d163c919ea0684d629 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE vn_relations (
vid1 integer NOT NULL,
vid2 integer NOT NULL,
relation smallint NOT NULL,
lastmod bigint NOT NULL,
PRIMARY KEY(vid1, vid2)
);
ALTER TABLE vn ADD COLUMN img_nsfw smallint NOT NULL DEFAULT 0;
ALTER TABLE users ADD COLUMN pign_nsfw smallint NOT NULL DEFAULT 0;
|