summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-01-04 10:09:01 +0100
committerYorhel <git@yorhel.nl>2009-01-04 10:09:01 +0100
commite954078d3e8d26724e07d3275dc789083421bd86 (patch)
tree7bd156d469f4d01c6f93fc7b6e13fba6ce38a90f /util/dump.sql
parent0980838bd848cf5facfed799d7bc86989012a251 (diff)
Added patch flag to releases
TODO: update d3 and automatically convert all 'patch' media releases in the DB to use this flag.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 719f0f75..6d7f1f26 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -103,7 +103,8 @@ CREATE TABLE releases_rev (
released integer NOT NULL,
notes text NOT NULL DEFAULT '',
minage smallint NOT NULL DEFAULT -1,
- gtin bigint NOT NULL DEFAULT 0
+ gtin bigint NOT NULL DEFAULT 0,
+ patch boolean NOT NULL DEFAULT FALSE
);
-- releases_vn
@@ -185,7 +186,8 @@ CREATE TABLE users (
show_list boolean NOT NULL DEFAULT TRUE,
c_votes integer NOT NULL DEFAULT 0,
c_changes integer NOT NULL DEFAULT 0,
- skin varchar(128) NOT NULL DEFAULT ''
+ skin varchar(128) NOT NULL DEFAULT '',
+ customcss text NOT NULL DEFAULT ''
);
-- vn