Ladsgroup has uploaded a new change for review. https://gerrit.wikimedia.org/r/213470
Change subject: [WIP] Add BadgesPerSitelink.sql ...................................................................... [WIP] Add BadgesPerSitelink.sql Change-Id: Ia093bfd081531f133dc31bc1b5ccc5ad7d927ccf --- A repo/sql/AddBadgesPerSitelink.sql 1 file changed, 11 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Wikibase refs/changes/70/213470/1 diff --git a/repo/sql/AddBadgesPerSitelink.sql b/repo/sql/AddBadgesPerSitelink.sql new file mode 100644 index 0000000..d7063a4 --- /dev/null +++ b/repo/sql/AddBadgesPerSitelink.sql @@ -0,0 +1,11 @@ +-- Licence: GNU GPL v2+ + +-- Badges to sitelinks +CREATE TABLE IF NOT EXISTS /*_*/wb_badges_per_sitelink ( + bps_badge_id VARBINARY(32) NOT NULL, -- Id of badge entity + bps_site_page VARCHAR(255) NOT NULL, -- Name of the page that has the badge + bps_site_id VARBINARY(32) NOT NULL -- Site of the page +) /*$wgDBTableOptions*/; + +CREATE UNIQUE INDEX /*i*/wb_bps_badges ON /*_*/wb_badges_per_sitelink (bps_badge_id, bps_site_page, bps_site_id); +CREATE INDEX /*i*/wb_bps_pages_per_site ON /*_*/wb_badges_per_sitelink (bps_site_page, bps_site_id); -- To view, visit https://gerrit.wikimedia.org/r/213470 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia093bfd081531f133dc31bc1b5ccc5ad7d927ccf Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/Wikibase Gerrit-Branch: master Gerrit-Owner: Ladsgroup <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
