summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-01-01 15:12:32 +0100
committerYorhel <git@yorhel.nl>2010-01-01 15:12:32 +0100
commit0a4395eb4b186ea91e7a69d1556cb50352ade7f7 (patch)
tree649cbb8a071d65eda7b54a2305727b90bcc4ab16 /util/dump.sql
parentf146569cc560d64cf91e4386e3291fb45fa90c88 (diff)
SQL: Revision insertion abstraction for release entries
Also added a little sanity checking on the edit_(vn|release) table, and added a default value for releases_rev.released.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 4c6a4648..dc910a7f 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -127,7 +127,7 @@ CREATE TABLE releases_rev (
original varchar(250) NOT NULL DEFAULT '',
type release_type NOT NULL DEFAULT 'complete',
website varchar(250) NOT NULL DEFAULT '',
- released integer NOT NULL,
+ released integer NOT NULL DEFAULT 0,
notes text NOT NULL DEFAULT '',
minage smallint,
gtin bigint NOT NULL DEFAULT 0,