wikidatawiki_p currently contains the following tables:
MariaDB [wikidatawiki_p]> SHOW TABLES;
+--------------------------+
| Tables_in_wikidatawiki_p |
+--------------------------+
| abuse_filter |
| abuse_filter_action |
| abuse_filter_history |
| abuse_filter_log |
| archive |
| archive_userindex |
| category |
| categorylinks |
| change_tag |
| externallinks |
| geo_killlist |
| geo_tags |
| geo_updates |
| global_block_whitelist |
| globalblocks |
| hitcounter |
| image |
| imagelinks |
| interwiki |
| ipblocks |
| ipblocks_ipindex |
| iwlinks |
| l10n_cache |
| langlinks |
| logging |
| logging_logindex |
| logging_userindex |
| math |
| module_deps |
| msg_resource |
| msg_resource_links |
| oldimage |
| oldimage_userindex |
| page |
| page_props |
| page_restrictions |
| pagelinks |
| protected_titles |
| recentchanges |
| recentchanges_userindex |
| redirect |
| revision |
| revision_userindex |
| site_identifiers |
| site_stats |
| sites |
| tag_summary |
| templatelinks |
| transcode |
| updatelog |
| updates |
| user |
| user_former_groups |
| user_groups |
| valid_tag |
| wb_changes |
| wb_changes_dispatch |
| wb_entity_per_page |
| wb_id_counters |
| wb_items_per_site |
| wb_terms |
+--------------------------+
61 rows in set (0.03 sec)
The federated version only contains a very small subset of these:
MariaDB [wikidatawiki_f_p]> show tables;
+----------------------------+
| Tables_in_wikidatawiki_f_p |
+----------------------------+
| image |
| logging |
| logging_userindex |
| page |
| revision |
| revision_userindex |
| user |
+----------------------------+
7 rows in set (0.03 sec)
I would like to see all the missing tables added, but that seems to be a bridge to far at this moment. So to get about this deadlock please at least add these tables:
- pagelinks
- recentchanges
- recentchanges_userindex
- wb_changes
- wb_changes_dispatch
- wb_entity_per_page
- wb_id_counters
- wb_items_per_site
- wb_terms
Version: unspecified
Severity: enhancement