summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-04-02 11:00:03 +0200
committerYorhel <git@yorhel.nl>2020-04-02 11:00:05 +0200
commitaedc25ae190037aa241d11b3ea17c8a3e0eed7ca (patch)
treed00141fddbcd8769a3f38ceb869b095bd71adfad
parent8251405d805fd096839194df9e822092e5463140 (diff)
Increase max release title length to 300
https://vndb.org/t2520.377
-rw-r--r--lib/VNWeb/Releases/Edit.pm2
-rw-r--r--util/sql/schema.sql4
-rw-r--r--util/updates/2020-04-02-releases-original-title-size.sql2
3 files changed, 5 insertions, 3 deletions
diff --git a/lib/VNWeb/Releases/Edit.pm b/lib/VNWeb/Releases/Edit.pm
index 7471972e..a2326207 100644
--- a/lib/VNWeb/Releases/Edit.pm
+++ b/lib/VNWeb/Releases/Edit.pm
@@ -5,7 +5,7 @@ use VNWeb::Prelude;
my $FORM = {
id => { required => 0, id => 1 },
- title => { maxlength => 250 },
+ title => { maxlength => 300 },
original => { required => 0, default => '', maxlength => 250 },
rtype => { default => 'complete', enum => \%RELEASE_TYPE },
patch => { anybool => 1 },
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 20f83ab5..a34bc998 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -305,7 +305,7 @@ CREATE TABLE releases ( -- dbentry_type=r
id SERIAL PRIMARY KEY, -- [pub]
locked boolean NOT NULL DEFAULT FALSE,
hidden boolean NOT NULL DEFAULT FALSE,
- title varchar(250) NOT NULL DEFAULT '', -- [pub]
+ title varchar(300) NOT NULL DEFAULT '', -- [pub]
original varchar(250) NOT NULL DEFAULT '', -- [pub]
type release_type NOT NULL DEFAULT 'complete', -- [pub]
website varchar(250) NOT NULL DEFAULT '', -- [pub]
@@ -349,7 +349,7 @@ CREATE TABLE releases ( -- dbentry_type=r
-- releases_hist
CREATE TABLE releases_hist (
chid integer NOT NULL PRIMARY KEY,
- title varchar(250) NOT NULL DEFAULT '',
+ title varchar(300) NOT NULL DEFAULT '',
original varchar(250) NOT NULL DEFAULT '',
type release_type NOT NULL DEFAULT 'complete',
website varchar(250) NOT NULL DEFAULT '',
diff --git a/util/updates/2020-04-02-releases-original-title-size.sql b/util/updates/2020-04-02-releases-original-title-size.sql
new file mode 100644
index 00000000..e59dbbe2
--- /dev/null
+++ b/util/updates/2020-04-02-releases-original-title-size.sql
@@ -0,0 +1,2 @@
+alter table releases alter column title type varchar(300);
+alter table releases_hist alter column title type varchar(300);