summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--lib/Multi/Wikidata.pm1
-rw-r--r--lib/VNDB/Util/Misc.pm2
-rw-r--r--util/sql/schema.sql3
-rw-r--r--util/updates/update_20191108.sql1
4 files changed, 6 insertions, 1 deletions
diff --git a/lib/Multi/Wikidata.pm b/lib/Multi/Wikidata.pm
index a4abf5bb..a618f623 100644
--- a/lib/Multi/Wikidata.pm
+++ b/lib/Multi/Wikidata.pm
@@ -83,6 +83,7 @@ my %props = (
P1733 => [ 'steam', 'integer' ],
P2725 => [ 'gog', 'text' ],
P5435 => [ 'pixiv_user', 'integer' ],
+ P7511 => [ 'doujinshi_author', 'integer' ],
);
diff --git a/lib/VNDB/Util/Misc.pm b/lib/VNDB/Util/Misc.pm
index 9227d22a..77d61702 100644
--- a/lib/VNDB/Util/Misc.pm
+++ b/lib/VNDB/Util/Misc.pm
@@ -186,6 +186,7 @@ sub entryLinks {
$lnk->($w->{musicbrainz_artist}, 'MusicBrainz', 'https://musicbrainz.org/artist/%s');
$lnk->($w->{vgmdb_artist}, 'VGMdb', 'https://vgmdb.net/artist/%s');
$lnk->($w->{discogs_artist}, 'Discogs', 'https://www.discogs.com/artist/%s');
+ $lnk->($w->{doujinshi_author}, 'Doujinshi.org','https://www.doujinshi.org/browse/author/%d/');
}
# Producer links
@@ -193,6 +194,7 @@ sub entryLinks {
$lnk->($w->{twitter}, 'Twitter', 'https://twitter.com/%s');
$lnk->($w->{mobygames_company}, 'MobyGames', 'https://www.mobygames.com/company/%s');
$lnk->($w->{gamefaqs_company}, 'GameFAQs', 'https://gamefaqs.gamespot.com/company/%s-');
+ $lnk->($w->{doujinshi_author}, 'Doujinshi.org','https://www.doujinshi.org/browse/author/%d/');
push @links, [ 'VNStat', sprintf 'https://vnstat.net/developer/%d', $obj->{id} ];
}
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[];