path: root/util
diff options
authorYorhel <>2011-01-02 10:14:14 +0100
committerYorhel <>2011-01-02 10:14:14 +0100
commit33a8b46e8a402fe0a6cc80786b0bdab9fb5d513e (patch)
tree98476981c3cde3f8a98072ce10469024ced9ca31 /util
parentb932e475e9ed2b0b1e89a5954fc1872a131890e0 (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')
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;