From 179b8a64a978cd81b71f4fcd995da3325cf39a87 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Mon, 11 May 2015 13:03:42 +0200 Subject: Three new platforms: FM Towns, PC Engine, X68000 --- util/sql/all.sql | 2 +- util/updates/update_2.25.sql | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) (limited to 'util') diff --git a/util/sql/all.sql b/util/sql/all.sql index f9f8a6dd..c34b53cf 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -14,7 +14,7 @@ CREATE TYPE language AS ENUM ('ar', 'cs', 'da', 'de', 'en', 'es', 'fi', CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc'); CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce'); CREATE TYPE notification_ltype AS ENUM ('v', 'r', 'p', 'c', 't', 's'); -CREATE TYPE platform AS ENUM ('win', 'dos', 'lin', 'mac', 'ios', 'and', 'dvd', 'bdp', 'gba', 'gbc', 'msx', 'nds', 'nes', 'p88', 'p98', 'pcf', 'psp', 'ps1', 'ps2', 'ps3', 'ps4', 'psv', 'drc', 'sat', 'sfc', 'wii', 'n3d', 'xb1', 'xb3', 'xbo', 'web', 'oth'); +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', 'wii', 'n3d', 'x68', 'xb1', 'xb3', 'xbo', 'web', 'oth'); CREATE TYPE prefs_key AS ENUM ('l10n', 'skin', 'customcss', 'filter_vn', 'filter_release', 'show_nsfw', 'hide_list', 'notify_nodbedit', 'notify_announce', 'vn_list_own', 'vn_list_wish'); CREATE TYPE producer_relation AS ENUM ('old', 'new', 'sub', 'par', 'imp', 'ipa', 'spa', 'ori'); CREATE TYPE release_type AS ENUM ('complete', 'partial', 'trial'); diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql index f9168cf7..36fc5d01 100644 --- a/util/updates/update_2.25.sql +++ b/util/updates/update_2.25.sql @@ -12,3 +12,9 @@ UPDATE vn_staff vs SET note = CASE WHEN note = '' THEN 'Scripting' ELSE note || DELETE FROM vn_staff WHERE role = 'script'; COMMIT; + +-- Some new (or, well, old) platforms +ALTER TYPE platform ADD VALUE 'fmt' BEFORE 'gba'; +ALTER TYPE platform ADD VALUE 'pce' BEFORE 'pcf'; +ALTER TYPE platform ADD VALUE 'x68' BEFORE 'xb1'; + -- cgit v1.2.3