Schema changes
From Wikitech
(Difference between revisions)
(→To be scheduled: "Add index pp_propname_page" merged now) |
(page props done) |
||
| Line 61: | Line 61: | ||
| All wikis || iwlinks || Add index <code>iwl_prefix_from_title</code> || Pending review || | | All wikis || iwlinks || Add index <code>iwl_prefix_from_title</code> || Pending review || | ||
* {{gerrit|I607e8bf9}} (maintenance/archives/patch-iwlinks-from-title-index.sql) | * {{gerrit|I607e8bf9}} (maintenance/archives/patch-iwlinks-from-title-index.sql) | ||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 125: | Line 122: | ||
|- | |- | ||
| meta || cn_notices, cn_assignments, cn_notice_log || Add banner bucketing to CentralNotice || ? || {{gerrit|I36be97e8}} (See patch-bucketing.sql) | | meta || cn_notices, cn_assignments, cn_notice_log || Add banner bucketing to CentralNotice || ? || {{gerrit|I36be97e8}} (See patch-bucketing.sql) | ||
| + | |- | ||
| + | | All wikis || page_props || Add index <code>pp_propname_page</code> || Merged || | ||
| + | * {{gerrit|Iea778eb7}} (maintenance/archives/patch-page_props-propname-page-index.sql) | ||
|} | |} | ||
Latest revision as of 00:13, 26 February 2013
Contents |
[edit] 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 deployments.
[edit] Pending
[edit] To be scheduled
| Wiki(s) | Table | Change | Commit status | More info |
|---|---|---|---|---|
| Meta | cn_* | Updating CentralNotice schema for upcoming features | In review | gerrit 48332 |
| All wikis | image, oldimage | Truncate SHA-1 indexes | Merged |
No patch available, was changed within a release |
| All wikis | recentchanges | Dropping rc_moved_to_title |
Merged |
Table recentchanges contains rc_moved_to_title field. Dropping... |
| All wikis | site_status | Dropping ss_admins |
Merged |
Table site_stats contains ss_admins field. Dropping... |
| All wikis | page, revision, archive | Content handler columns | Merged |
Adding rev_content_format field to table revision... Adding rev_content_model field to table revision... Adding ar_content_format field to table archive... Adding ar_content_model field to table archive... Adding page_content_model field to table page... |
| All wikis | category | Dropping cat_hidden |
Merged |
Table category contains cat_hidden field. Dropping... |
| All wikis | filejournal | Drop fj_new_sha1 field | Unknown | |
| See ticket | user_newtalk | Fix schema inconsistency | Unknown | |
| Most wikis | change_tag and tag_summary | Index updates | ||
| All wikis | iwlinks | Add index iwl_prefix_from_title |
Pending review |
|
[edit] In progress
| Wiki(s) | Table | Change | Commit status | More info |
|---|
[edit] Completed
| Wiki(s) | Table | Change | Commit status | More info |
|---|---|---|---|---|
| wikidatawiki | terms_search_key | New column and index | [1] [2]
Combined: ALTER TABLE /*_*/wb_items_per_site ADD ips_row_id INTEGER PRIMARY KEY AUTO_INCREMENT FIRST; ALTER TABLE /*_*/wb_terms ADD COLUMN term_row_id INTEGER PRIMARY KEY AUTO_INCREMENT FIRST, ADD COLUMN term_search_key VARCHAR(255) NOT NULL, ADD INDEX /*i*/wb_terms_search_key (term_search_key); | |
| Meta | cn_template_log | Adding new log columns to support logging priority language changes | Merged | gerrit 45672 |
| All wikis | uploadstash | Adding us_props |
Merged | |
| All wikis | job | Job queue improvements | Merged | |
| All wikis | filearchive | Add fa_sha1 field to filearchive | ? | gerrit Ie54a513f |
| 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 | |
| meta | cn_notices, cn_assignments, cn_notice_log | Add banner bucketing to CentralNotice | ? | gerrit I36be97e8 (See patch-bucketing.sql) |
| All wikis | page_props | Add index pp_propname_page |
Merged |
|
[edit] 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
