summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-01-02 10:14:14 +0100
committerYorhel <git@yorhel.nl>2011-01-02 10:14:14 +0100
commit33a8b46e8a402fe0a6cc80786b0bdab9fb5d513e (patch)
tree98476981c3cde3f8a98072ce10469024ced9ca31
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.
-rw-r--r--ChangeLog1
-rw-r--r--util/sql/schema.sql2
-rw-r--r--util/updates/update_2.16.sql3
3 files changed, 5 insertions, 1 deletions
diff --git a/ChangeLog b/ChangeLog
index 41f9359d..417bcb5a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -22,6 +22,7 @@
- Bugfix: check for validness of form arguments on /[uv]+/votes
- Bugfix: translate screen resolutions on release revision pages
- Bugfix: properly escape search query in links query string
+ - Bugfix: allow a VN to be available for more than 7 platforms
- Implemented permanent release/vn filters
2.15 - 2010-12-15
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;
+