Schema changes

Guidelines

• All schema changes must be reviewed by DB Ops and/or Platform Engineering
• Add the change to the below table. All fields must be completed.
• Depending on the number of wikis and size of tables being modified, migrations can take anywhere from an hour to multiple days to fully deploy. Reviewed schema migrations should generally be added to this page and explicitly scheduled a week before the correlating software deployment.

Pending

To be scheduled

Wiki(s)	Table	Change	More info
All wikis	page, revision, archive	Proposed Wikidata content handler columns	[1] [2]

In progress

Wiki(s)	Table	Change	More info

Completed

Wiki(s)	Table	Change	More info
All wikis	Various	IPv6 schema fixes (SecurePoll, GlobalBlocking, recentchanges)
All wikis	ipblocks	Addition of ipb_parent_block_id and index	[3]
All wikis	revision	Add sha-1 column of revision text	[4]

Archive (pre-2012)

All wikis:

• patch-filearchive-user-index.sql
• patch-ar_parent_id.sql
• patch-log_user_text.sql
• patch-user_properties.sql
• patch-log_search.sql
• patch-categorylinksindex.sql

AbuseFilter wikis:

• extensions/AbuseFilter/db_patches/patch-global_filters.sql
• extensions/AbuseFilter/db_patches/patch-hide_patrol.sql

Wikis without AbuseFilter are having tables added: extensions/AbuseFilter/abusefilter.tables.sql

FlaggedRevs wikis:

• Apparently already done: extensions/FlaggedRevs/archives/patch-fpc_level.sql
• extensions/FlaggedRevs/archives/patch-flaggedpage_pending.sql

nlwiki, plwiki, svwiki, frwiki:

• patch-rc_user_text-index.sql