summaryrefslogtreecommitdiff
path: root/util
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 /util
parent8251405d805fd096839194df9e822092e5463140 (diff)
Increase max release title length to 300
https://vndb.org/t2520.377
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql4
-rw-r--r--util/updates/2020-04-02-releases-original-title-size.sql2
2 files changed, 4 insertions, 2 deletions
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);