summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql28
1 files changed, 0 insertions, 28 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index a3a94a49..ed5315c6 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -913,25 +913,6 @@ CREATE TABLE vn_staff_hist (
PRIMARY KEY (chid, aid, role)
);
--- vnlists
-CREATE TABLE vnlists (
- uid integer NOT NULL, -- [pub]
- vid integer NOT NULL, -- [pub]
- status smallint NOT NULL DEFAULT 0, -- [pub]
- added TIMESTAMPTZ NOT NULL DEFAULT NOW(), -- [pub]
- notes varchar NOT NULL DEFAULT '', -- [pub]
- PRIMARY KEY(uid, vid)
-);
-
--- votes
-CREATE TABLE votes (
- vid integer NOT NULL DEFAULT 0, -- [pub]
- uid integer NOT NULL DEFAULT 0, -- [pub]
- vote integer NOT NULL DEFAULT 0, -- [pub]
- date timestamptz NOT NULL DEFAULT NOW(), -- [pub]
- PRIMARY KEY(vid, uid)
-);
-
-- wikidata
CREATE TABLE wikidata (
id integer NOT NULL PRIMARY KEY, -- [pub]
@@ -966,12 +947,3 @@ CREATE TABLE wikidata (
pixiv_user integer[], -- [pub] P5435
doujinshi_author integer[] -- [pub] P7511
);
-
--- wlists
-CREATE TABLE wlists (
- uid integer NOT NULL DEFAULT 0, -- [pub]
- vid integer NOT NULL DEFAULT 0, -- [pub]
- wstat smallint NOT NULL DEFAULT 0, -- [pub]
- added timestamptz NOT NULL DEFAULT NOW(), -- [pub]
- PRIMARY KEY(uid, vid)
-);