T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table added maintenance/archives/patch-archive-MCR.sql which drops the archive columns

T161671: Compacting the revision table, T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table, T215466: Remove revision_comment_temp and revision_actor_temp added maintenance/archives/patch-revision-actor-comment-MCR.sql which drops the revision columns

Ah, it's mentioned in rEWBA508f8b7dab9a: Use 'wikibase-item' as content model id....

But that's hardly usefully referenced...

Change 621930 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/core@master] Remove maintenance/storage/drop_content_model_info.sql

https://gerrit.wikimedia.org/r/621930

This requires not only code review, but also investigating if this file is still needed. It seems like these columns should still be dropped, but they might be getting dropped elsewhere.

In T261059#6410441, @eprodromou wrote:

This requires not only code review, but also investigating if this file is still needed. It seems like these columns should still be dropped, but they might be getting dropped elsewhere.

They are not all being dropped elsewhere.

ALTER TABLE /*$wgDBprefix*/archive  DROP COLUMN ar_content_model;
ALTER TABLE /*$wgDBprefix*/archive  DROP COLUMN ar_content_format;

ALTER TABLE /*$wgDBprefix*/revision  DROP COLUMN rev_content_model;
ALTER TABLE /*$wgDBprefix*/revision  DROP COLUMN rev_content_format;

ALTER TABLE /*$wgDBprefix*/page  DROP COLUMN page_content_model;

is mostly covered in T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table

ALTER TABLE /*_*/archive
	...
	DROP COLUMN ar_content_model,
	DROP COLUMN ar_content_format;

ALTER TABLE /*_*/revision
	...
	DROP COLUMN rev_content_model,
	DROP COLUMN rev_content_format,
	...

But page_content_model still exists. See T230607: stop using page_content_model

Change 621930 merged by jenkins-bot:
[mediawiki/core@master] Remove maintenance/storage/drop_content_model_info.sql

https://gerrit.wikimedia.org/r/621930

Change 624286 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/core@REL1_35] Remove maintenance/storage/drop_content_model_info.sql

https://gerrit.wikimedia.org/r/624286

Change 624286 merged by jenkins-bot:
[mediawiki/core@REL1_35] Remove maintenance/storage/drop_content_model_info.sql

https://gerrit.wikimedia.org/r/624286