summaryrefslogtreecommitdiff
path: root/util/updates/update_1.5.sql
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;