Page MenuHomePhabricator
Paste P8774

Db table audit for dumps 2019 part 2
ActivePublic
Actions

Authored by ArielGlenn on Jul 19 2019, 9:03 AM.
Tags
None
Referenced Files
F30002812: raw.txt
Aug 9 2019, 6:56 AM
F29938099: raw.txt
Aug 2 2019, 10:35 AM
F29938011: raw.txt
Aug 2 2019, 9:55 AM
F29839433: raw.txt
Jul 22 2019, 10:27 AM
F29839366: raw.txt
Jul 22 2019, 10:19 AM
F29811953: raw.txt
Jul 19 2019, 9:03 AM
Subscribers
None
To review:
these are all related to the wb_terms migration and are not yet ready:
wbt_text
wbt_type
wbt_text_in_lang
wbt_term_in_lang
wbt_property_terms
wbt_item_terms
--------------
could be dumped, probably useful
flaggedimages
flaggedpage_config
flaggedpage_pending
flaggedpages
flaggedrevs
flaggedrevs_promote
flaggedrevs_statistics
flaggedrevs_tracking
flaggedtemplates
wbqc_constraints
wbs_propertypairs -- really only useful for the property suggester, but public so why not
--------------
obsolete or deprecated
ep_articles
ep_cas
ep_events
ep_instructors
ep_oas
ep_orgs
ep_revisions
ep_students
ep_users_per_course
geo_updates -- removed from extension
geo_killist -- ""
flaggedrevs_stats -- replaced by flaggedrevs_statistics
flaggedrevs_stats2
--------------
may not be useful
global_group_permissions -- CentralAuth related, doubtful there's a use case given we can't dump the user table
global_group_restrictions
global_user_groups
localuser
pagetriage_log -- all of these are used for enwiki page triage only, a mirror might only care about new triage
pagetriage_page Are they useful for crunching numbers for researchers? Unclear. Can't see a bot use case though.
pagetriage_page_tags
pagetriage_tags
wb_changes -- these relate to propagation of changes from a wikibase repo (e.g. wikidata) to client wikis
wb_changes_dispatch
wb_changes_subscription
wb_terms -- deprecated
wb_id_counters -- this should be rebuilt by looking at the largest id in use for items/properties/lexemes;
if it is simply dumped and used, it will be out of sync with the other tables
wbqc_constraints -- config settings for WikiBase Quality Constraints extension provides these
wikiset -- from CentralAuth, only exists there, not useful generally for mirrors
-------
already dumped
wbc_entity_usage
wb_items_per_site
wb_property_info
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits