diff options
-rw-r--r-- | lib/Multi/Wikidata.pm | 1 | ||||
-rw-r--r-- | lib/VNDB/Util/Misc.pm | 2 | ||||
-rw-r--r-- | util/sql/schema.sql | 3 | ||||
-rw-r--r-- | util/updates/update_20191108.sql | 1 |
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[]; |