diff options
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; + |