Skip to content

Drop revision_sha1, add user_central_id

Xcollazorequested to merge
drop-sha1-add-central-id into main

In this MR we:

  • Drop column revision_sha1 from both wmf_content.mediawiki_content_*_v1 tables.
  • Add column user_central_id to both wmf_content.mediawiki_content_*_v1 tables.
  • Modify the code as needed for the above.

For now, we do not consider reconciling user_central_id. We will do that work later.

As part of getting these changes to production, we will have to run the following ALTERs:

ALTER TABLE wmf_content.mediawiki_content_history_v1 DROP COLUMN revision_sha1;
ALTER TABLE wmf_content.mediawiki_content_current_v1 DROP COLUMN revision_sha1;

-- the AFTER clause makes SELECT * output be more natural
ALTER TABLE wmf_content.mediawiki_content_history_v1 ADD COLUMN user_central_id BIGINT COMMENT 'Global cross-wiki user ID. See: https://www.mediawiki.org/wiki/Manual:Central_ID' AFTER user_id;
ALTER TABLE wmf_content.mediawiki_content_current_v1 ADD COLUMN user_central_id BIGINT COMMENT 'Global cross-wiki user ID. See: https://www.mediawiki.org/wiki/Manual:Central_ID' AFTER user_id;

Bug: T406515

Bug: T405641

Edited by Xcollazo

Merge request reports