summaryrefslogtreecommitdiff
path: root/util/updates/2021-12-06-extlinks-playstation-stores.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/2021-12-06-extlinks-playstation-stores.sql')
-rw-r--r--util/updates/2021-12-06-extlinks-playstation-stores.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/util/updates/2021-12-06-extlinks-playstation-stores.sql b/util/updates/2021-12-06-extlinks-playstation-stores.sql
new file mode 100644
index 00000000..648fb74d
--- /dev/null
+++ b/util/updates/2021-12-06-extlinks-playstation-stores.sql
@@ -0,0 +1,13 @@
+ALTER TABLE releases
+ ADD COLUMN l_playstation_jp text NOT NULL DEFAULT '',
+ ADD COLUMN l_playstation_na text NOT NULL DEFAULT '',
+ ADD COLUMN l_playstation_eu text NOT NULL DEFAULT '';
+ALTER TABLE releases_hist
+ ADD COLUMN l_playstation_jp text NOT NULL DEFAULT '',
+ ADD COLUMN l_playstation_na text NOT NULL DEFAULT '',
+ ADD COLUMN l_playstation_eu text NOT NULL DEFAULT '';
+ALTER TABLE wikidata
+ ADD COLUMN playstation_jp text[],
+ ADD COLUMN playstation_na text[],
+ ADD COLUMN playstation_eu text[];
+\i sql/editfunc.sql