diff options
| author | Yorhel <git@yorhel.nl> | 2011-01-02 10:14:14 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2011-01-02 10:14:14 +0100 |
| commit | 33a8b46e8a402fe0a6cc80786b0bdab9fb5d513e (patch) | |
| tree | 98476981c3cde3f8a98072ce10469024ced9ca31 /util | |
| parent | b932e475e9ed2b0b1e89a5954fc1872a131890e0 (diff) | |
Bugfix: allow a VN to be available for more than 7 platforms
This constraint was caused by the character length limit on
vn.c_platforms. Trying to add or edit a release in such a way that a
platform would be added to c_platforms would result in a 500.
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/schema.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_2.16.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index ec5d8e58..676d6400 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -291,7 +291,7 @@ CREATE TABLE vn ( rgraph integer, c_released integer NOT NULL DEFAULT 0, c_languages language[] NOT NULL DEFAULT '{}', - c_platforms varchar(32) NOT NULL DEFAULT '', + c_platforms varchar NOT NULL DEFAULT '', c_popularity real, c_rating real, c_votecount integer NOT NULL DEFAULT 0, diff --git a/util/updates/update_2.16.sql b/util/updates/update_2.16.sql index 12f28121..2d354f03 100644 --- a/util/updates/update_2.16.sql +++ b/util/updates/update_2.16.sql @@ -81,3 +81,6 @@ ALTER TABLE users DROP COLUMN notify_dbedit; ALTER TABLE users DROP COLUMN notify_announce; +-- remove size constraint on vn.c_platforms +ALTER TABLE vn ALTER COLUMN c_platforms TYPE varchar; + |