summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-14 12:36:54 +0000
committerYorhel <git@yorhel.nl>2009-07-14 12:36:54 +0000
commit9a07126464f4ca05f33e7375883ada66abe7dcf4 (patch)
treed6392c0f28f3f58210fbd8f3c439a2f7714bf910 /util/dump.sql
parenta130a4f79e04f8a6ccd4514b9a1d0285c63edfea (diff)
Removed old and unused table/column definitions from dump.sql
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 22e80099..b169f02c 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -248,7 +248,6 @@ CREATE TABLE users (
rank smallint NOT NULL DEFAULT 3,
passwd bytea NOT NULL DEFAULT '',
registered bigint NOT NULL DEFAULT 0,
- flags integer NOT NULL DEFAULT 7,
show_nsfw boolean NOT NULL DEFAULT FALSE,
show_list boolean NOT NULL DEFAULT TRUE,
c_votes integer NOT NULL DEFAULT 0,
@@ -321,16 +320,6 @@ CREATE TABLE vn_screenshots (
PRIMARY KEY(vid, scr)
);
--- vnlists
-CREATE TABLE vnlists (
- uid integer DEFAULT 0,
- vid integer NOT NULL DEFAULT 0,
- status smallint NOT NULL DEFAULT 0,
- date bigint NOT NULL DEFAULT 0,
- comments varchar(500) NOT NULL DEFAULT '',
- PRIMARY KEY(uid, vid)
-);
-
-- votes
CREATE TABLE votes (
vid integer NOT NULL DEFAULT 0,