summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2008-11-11 23:02:56 +0100
committerYorhel <git@yorhel.nl>2008-11-11 23:02:56 +0100
commitbc369d000b6a4f005cd54f78fd240dc704a5a614 (patch)
treedacdaac118c7bdd381602185b19f33a02250a136 /util/dump.sql
parent6c64733d77cc42d0a53e57ac2b169d43cde83acf (diff)
Removed users.flags and used two boolean columns instead
I wasn't planning on really touching the database in the rewrite, but oh well, I've always wanted to do this, anyway.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 51f17b3b..487950e7 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -175,6 +175,8 @@ CREATE TABLE users (
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,
c_changes integer NOT NULL DEFAULT 0
);