diff options
| author | Yorhel <git@yorhel.nl> | 2009-01-04 10:09:01 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-01-04 10:09:01 +0100 |
| commit | e954078d3e8d26724e07d3275dc789083421bd86 (patch) | |
| tree | 7bd156d469f4d01c6f93fc7b6e13fba6ce38a90f /util | |
| parent | 0980838bd848cf5facfed799d7bc86989012a251 (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')
| -rw-r--r-- | util/dump.sql | 6 | ||||
| -rw-r--r-- | util/updates/update_2.2.sql | 3 |
2 files changed, 7 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 diff --git a/util/updates/update_2.2.sql b/util/updates/update_2.2.sql index 6052eac5..50ca7471 100644 --- a/util/updates/update_2.2.sql +++ b/util/updates/update_2.2.sql @@ -2,3 +2,6 @@ -- custom CSS ALTER TABLE users ADD COLUMN customcss text NOT NULL DEFAULT ''; +-- patch flag +ALTER TABLE releases_rev ADD COLUMN patch BOOLEAN NOT NULL DEFAULT FALSE; + |