diff options
author | Yorhel <git@yorhel.nl> | 2020-04-02 11:00:03 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-04-02 11:00:05 +0200 |
commit | aedc25ae190037aa241d11b3ea17c8a3e0eed7ca (patch) | |
tree | d00141fddbcd8769a3f38ceb869b095bd71adfad | |
parent | 8251405d805fd096839194df9e822092e5463140 (diff) |
Increase max release title length to 300
https://vndb.org/t2520.377
-rw-r--r-- | lib/VNWeb/Releases/Edit.pm | 2 | ||||
-rw-r--r-- | util/sql/schema.sql | 4 | ||||
-rw-r--r-- | util/updates/2020-04-02-releases-original-title-size.sql | 2 |
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); |