diff options
author | Yorhel <git@yorhel.nl> | 2019-12-30 09:29:03 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-12-30 09:29:03 +0100 |
commit | e146ed7bda12d369532e485ca0c2e3d823811854 (patch) | |
tree | f5e86b31f0255c89397fcb201af5c38a62bc9d4b /util/sql/schema.sql | |
parent | 40ef00116cc12aef4ce08fc1136e329c58abda4b (diff) |
ulist: Remove remnants of old votes/vnlists/wlists tables
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 28 |
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) -); |