diff options
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/all.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_2.25.sql | 6 |
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'; + |