diff options
author | Yorhel <git@yorhel.nl> | 2021-03-06 13:07:44 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-03-06 13:08:51 +0100 |
commit | bac0c95c220e0a210c6aa618ab62d68776ab337c (patch) | |
tree | 1aa4f4fc0f70e6198063bc2709beff3a7d8c4e23 | |
parent | 691c73a4aff6ef6467805c8b96491817269c0ba3 (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.pm | 1 | ||||
-rw-r--r-- | sql/schema.sql | 2 | ||||
-rw-r--r-- | util/updates/2021-03-06-medium-cassette-tape.sql | 1 |
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'; |