Most of these seem unrelated to MCR, and unneeded for MCR.
- A bigint for rev_id would probably make sense, although that seems mostly a separate concern from MCR. I'd say leave that change for a separate project. The only dependency is the type of
slot_revision
, but there are many other fields in the DB that have a similar dependency.- If we want to do this at the same time as any MCR-related schema changes, it shouldn't be too hard to do it.
- Again, your questions for
rev_page
seem unrelated to MCR. Let's leave that for a separate project, MCR is big enough as it is. -
ar_text
andar_flags
still exist because old rows deleted in MediaWiki before 1.5 were never migrated to the text table. We should really do that someday so we can get rid of this column. - Regarding
ar_rev_id
not referring to an existing revision, it is the "existing" revision. A migration to merge it withar_id
would need to invent IDs for existing pre-1.5 rows without conflicting with any existingrev_id
orar_rev_id
. - Your question on
page_namespace
is entirely unrelated to MCR. -
page_restrictions
may need old rows migrated before being dropped (a count using the enwiki replica on tool labs reports 4102 rows that have a value here). Again, this seems unrelated to MCR.