summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-09-03 10:11:58 +0200
committerYorhel <git@yorhel.nl>2019-09-03 10:11:58 +0200
commit875619604dce6447db86fb00dd9dd77b110efc0a (patch)
tree9511f467e1ee61b21c220d898518ff181deb8403 /util
parentb5adee24115f784a114abb6f6f6a3e31fbd699c1 (diff)
Fetch some more IDs from Wikidata + display IGDB & Pixiv links
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql9
1 files changed, 8 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 836c597c..bea433a0 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -901,7 +901,14 @@ CREATE TABLE wikidata (
acdb_char integer[], -- [pub] P7013
acdb_source integer[], -- [pub] P7017
indiedb_game text[], -- [pub] P6717
- howlongtobeat integer[] -- [pub] P2816
+ howlongtobeat integer[], -- [pub] P2816
+ crunchyroll text[], -- [pub] P4110
+ igdb_game text[], -- [pub] P5794
+ giantbomb text[], -- [pub] P5247
+ pcgamingwiki text[], -- [pub] P6337
+ steam integer[], -- [pub] P1733
+ gog text[], -- [pub] P2725
+ pixiv_user integer[] -- [pub] P5435
);
-- wlists