1 files changed, 10 insertions, 0 deletions
diff --git a/util/updates/update_1.5.sql b/util/updates/update_1.5.sql
new file mode 100644
index 00000000..970aa0e1
--- /dev/null
+++ b/util/updates/update_1.5.sql
@@ -0,0 +1,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;