summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-03-06 13:07:44 +0100
committerYorhel <git@yorhel.nl>2021-03-06 13:08:51 +0100
commitbac0c95c220e0a210c6aa618ab62d68776ab337c (patch)
tree1aa4f4fc0f70e6198063bc2709beff3a7d8c4e23
parent691c73a4aff6ef6467805c8b96491817269c0ba3 (diff)
Add "Cassette tape" medium
The "cartridge" icon for it is terribly wrong, but it also kind of looks like a "notes" icon so it's alright if you hover it.
-rw-r--r--lib/VNDB/Types.pm1
-rw-r--r--sql/schema.sql2
-rw-r--r--util/updates/2021-03-06-medium-cassette-tape.sql1
3 files changed, 3 insertions, 1 deletions
diff --git a/lib/VNDB/Types.pm b/lib/VNDB/Types.pm
index 86cadae9..9c36a4ec 100644
--- a/lib/VNDB/Types.pm
+++ b/lib/VNDB/Types.pm
@@ -227,6 +227,7 @@ hash MEDIUM =>
gdr => { qty => 1, txt => 'GD-ROM', plural => 'GD-ROMs', icon => 'disk' },
blr => { qty => 1, txt => 'Blu-ray disc', plural => 'Blu-ray discs', icon => 'disk' },
flp => { qty => 1, txt => 'Floppy', plural => 'Floppies', icon => 'cartridge' },
+ cas => { qty => 1, txt => 'Cassette tape', plural => 'Cassette tapes', icon => 'cartridge' },
mrt => { qty => 1, txt => 'Cartridge', plural => 'Cartridges', icon => 'cartridge' },
mem => { qty => 1, txt => 'Memory card', plural => 'Memory cards', icon => 'cartridge' },
umd => { qty => 1, txt => 'UMD', plural => 'UMDs', icon => 'disk' },
diff --git a/sql/schema.sql b/sql/schema.sql
index 9ea912fb..f6145c1c 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -55,7 +55,7 @@ CREATE TYPE cup_size AS ENUM ('', 'AAA', 'AA', 'A', 'B', 'C', 'D', 'E',
CREATE TYPE dbentry_type AS ENUM ('v', 'r', 'p', 'c', 's', 'd');
CREATE TYPE gender AS ENUM ('unknown', 'm', 'f', 'b');
CREATE TYPE language AS ENUM ('ar', 'bg', 'ca', 'cs', 'da', 'de', 'el', 'en', 'eo', 'es', 'fa', 'fi', 'fr', 'ga', 'gd', 'he', 'hr', 'hu', 'id', 'it', 'ja', 'ko', 'mk', 'ms', 'lt', 'lv', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ro', 'ru', 'sk', 'sl', 'sv', 'ta', 'th', 'tr', 'uk', 'vi', 'zh');
-CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc');
+CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'cas', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc');
CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce', 'post', 'comment', 'subpost', 'subedit', 'subreview', 'subapply');
CREATE TYPE platform AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'fmt', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pce', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'psv', 'drc', 'sat', 'sfc', 'swi', 'wii', 'wiu', 'n3d', 'x68', 'xb1', 'xb3', 'xbo', 'web', 'oth');
CREATE TYPE producer_type AS ENUM ('co', 'in', 'ng');
diff --git a/util/updates/2021-03-06-medium-cassette-tape.sql b/util/updates/2021-03-06-medium-cassette-tape.sql
new file mode 100644
index 00000000..370a293d
--- /dev/null
+++ b/util/updates/2021-03-06-medium-cassette-tape.sql
@@ -0,0 +1 @@
+ALTER TYPE medium ADD VALUE 'cas' AFTER 'flp';