summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql3
-rw-r--r--util/updates/update_20191108.sql1
2 files changed, 3 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index eca69e2e..19720860 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -930,7 +930,8 @@ CREATE TABLE wikidata (
pcgamingwiki text[], -- [pub] P6337
steam integer[], -- [pub] P1733
gog text[], -- [pub] P2725
- pixiv_user integer[] -- [pub] P5435
+ pixiv_user integer[], -- [pub] P5435
+ doujinshi_author integer[] -- [pub] P7511
);
-- wlists
diff --git a/util/updates/update_20191108.sql b/util/updates/update_20191108.sql
new file mode 100644
index 00000000..d1b99e7b
--- /dev/null
+++ b/util/updates/update_20191108.sql
@@ -0,0 +1 @@
+ALTER TABLE wikidata ADD COLUMN doujinshi_author integer[];