summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--data/global.pl2
-rw-r--r--data/icons/plat/fmt.pngbin0 -> 430 bytes
-rw-r--r--data/icons/plat/pce.pngbin0 -> 3467 bytes
-rw-r--r--data/icons/plat/x68.pngbin0 -> 486 bytes
-rw-r--r--data/lang.txt36
-rw-r--r--util/sql/all.sql2
-rw-r--r--util/updates/update_2.25.sql6
7 files changed, 44 insertions, 2 deletions
diff --git a/data/global.pl b/data/global.pl
index d9201b28..392d987a 100644
--- a/data/global.pl
+++ b/data/global.pl
@@ -68,7 +68,7 @@ our %S = (%S,
age_ratings => [-1, 0, 6..18],
release_types => [qw|complete partial trial|],
# The 'unk' platform and medium are reserved for "unknown".
- platforms => [qw|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|],
+ platforms => [qw|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|],
media => {
#DB qty?
cd => 1,
diff --git a/data/icons/plat/fmt.png b/data/icons/plat/fmt.png
new file mode 100644
index 00000000..c9625e91
--- /dev/null
+++ b/data/icons/plat/fmt.png
Binary files differ
diff --git a/data/icons/plat/pce.png b/data/icons/plat/pce.png
new file mode 100644
index 00000000..b8b42d4d
--- /dev/null
+++ b/data/icons/plat/pce.png
Binary files differ
diff --git a/data/icons/plat/x68.png b/data/icons/plat/x68.png
new file mode 100644
index 00000000..4731e374
--- /dev/null
+++ b/data/icons/plat/x68.png
Binary files differ
diff --git a/data/lang.txt b/data/lang.txt
index 3cd556c0..cd9beb37 100644
--- a/data/lang.txt
+++ b/data/lang.txt
@@ -548,6 +548,18 @@ tr : Blu-ray oynatıcı
uk : Blu-ray Player
it : Blu-ray Player
+:_plat_fmt
+en : FM Towns
+ru*:
+cs*:
+hu*:
+nl*:
+de*:
+es*:
+tr*:
+uk*:
+it*:
+
:_plat_gba
en : Game Boy Advance
ru : Game Boy Advance
@@ -632,6 +644,18 @@ tr : PC-98
uk : PC-98
it : PC-98
+:_plat_pce
+en : PC Engine
+ru*:
+cs*:
+hu*:
+nl*:
+de*:
+es*:
+tr*:
+uk*:
+it*:
+
:_plat_pcf
en : PC-FX
ru*:
@@ -776,6 +800,18 @@ tr : Nintendo 3DS
uk*:
it*:
+:_plat_x68
+en : X68000
+ru*:
+cs*:
+hu*:
+nl*:
+de*:
+es*:
+tr*:
+uk*:
+it*:
+
:_plat_xb1
en : Xbox
ru*:
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';
+