summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-05-11 13:03:42 +0200
committerYorhel <git@yorhel.nl>2015-05-11 13:17:36 +0200
commit179b8a64a978cd81b71f4fcd995da3325cf39a87 (patch)
tree0c9c3987e59667f9f3112b5a4a5fac11674726a8 /util
parent887607bb3744c727ec617508c17b2b7df46c2287 (diff)
Three new platforms: FM Towns, PC Engine, X68000
Diffstat (limited to 'util')
-rw-r--r--util/sql/all.sql2
-rw-r--r--util/updates/update_2.25.sql6
2 files changed, 7 insertions, 1 deletions
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';
+