Schema changes
From Wikitech
(Difference between revisions)
(moved) |
(completed metawiki.cn_notices) |
||
| Line 14: | Line 14: | ||
| All wikis || page, revision, archive || Proposed Wikidata content handler columns || [http://meta.wikimedia.org/wiki/Wikidata/Notes/ContentHandler] [http://lists.wikimedia.org/pipermail/wikitech-l/2012-March/059358.htmll] | | All wikis || page, revision, archive || Proposed Wikidata content handler columns || [http://meta.wikimedia.org/wiki/Wikidata/Notes/ContentHandler] [http://lists.wikimedia.org/pipermail/wikitech-l/2012-March/059358.htmll] | ||
|- | |- | ||
| − | |||
|} | |} | ||
| Line 31: | Line 30: | ||
|- | |- | ||
! Wiki(s) !! Table !! Change !! More info | ! Wiki(s) !! Table !! Change !! More info | ||
| + | |- | ||
| + | | meta || cn_notices || default value change for new CentralNotice feature[https://gerrit.wikimedia.org/r/#/c/16871/2/patches/patch-notice_preferred2.sql,unified] || We will want to deploy the new feature on the same day as the schema change (although it is not dependent) | ||
|- | |- | ||
| All wikis || abuse_filter_log || add afl_rev_id and afl_log_id columns and indexes || [https://gerrit.wikimedia.org/r/#/c/3435/13/db_patches/patch-afl_action_id.sql] | | All wikis || abuse_filter_log || add afl_rev_id and afl_log_id columns and indexes || [https://gerrit.wikimedia.org/r/#/c/3435/13/db_patches/patch-afl_action_id.sql] | ||
Revision as of 18:36, 8 August 2012
Contents |
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 |
|---|---|---|---|
| meta | cn_notices | default value change for new CentralNotice feature[3] | We will want to deploy the new feature on the same day as the schema change (although it is not dependent) |
| All wikis | abuse_filter_log | add afl_rev_id and afl_log_id columns and indexes | [4] |
| test, enwiki | pagetriage_page | schema changes for PageTriage extension | [5] |
| All wikis | Various | IPv6 schema fixes (SecurePoll, GlobalBlocking, recentchanges) | |
| All wikis | ipblocks | Addition of ipb_parent_block_id and index | [6] |
| All wikis | revision | Add sha-1 column of revision text | [7] |
| bewikimedia, incubatorwiki, mediawikiwiki, metawiki, outreachwiki, testwiki, wikimania2012wiki, wikimania2013wiki | translate_groupstats | Requested by Nikerabbit |
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
