Tasks By Project

Project: Schema-change

Switch to Active Tasks 30 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Author	Assignee	Projects	Subtasks	Parent Tasks
T13181	T13181: Mark bot edits in histories	open	Low (yellow)			MediaWiki-Change-tagging (Backlog) MediaWiki-Page-history (Backlog) Schema-change (Add / Create)		T19433: add bot flag info to (rv/uc)prop=flags
T153815	T153815: Allow global groups to be assigned temporarily (expire)	open	Medium (orange)			Patch-For-Review Stewards-and-global-tools (Temporary-UserRights) (Backlog) MW-1.38-notes (1.38.0-wmf.17; 2022-01-10) Platform Team Workboards (External Code Reviews) (External Code Review Needed) Schema-change (Add / Create) MediaWiki-extensions-CentralAuth (Incoming)	T245413: Prepare CentralAuth db for global groups expiration
T161671	T161671: Compacting the revision table	stalled	Medium (orange)			Platform Team Initiatives (Revision Storage Schema Improvements) Epic Schema-change (Cleanup) Platform Team Workboards (Epics) (Paused) Multi-Content-Revisions (Watching) Patch-For-Review MediaWiki-Revision-backend (Revision store)	T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table T6715: Allow comments longer than 255 bytes T227047: Complete actor table and comment table migration T215445: comment and actor view challenges for Cloud Services T251343: Drop unused columns from revision table in DatabaseUpdater (CommentStore, Actor, MCR) T278917: Clean up obsolete ActorMigration usages for non-temp tables
T163532	T163532: Drop index rev_page_id (rev_page, rev_id)	open	Low (yellow)			Patch-For-Review Schema-change (Delete / Drop / Remove) Platform Team Initiatives (Revision Storage Schema Improvements) User-Ladsgroup (Incoming) MW-1.38-notes (1.38.0-wmf.16; 2022-01-03) MW-1.30-release-notes
T167246	T167246: Refactor "user" & "user_text" fields into "actor" reference table	open	Needs Triage (violet)			Platform Team Initiatives (Revision Storage Schema Improvements) Epic Schema-change (Cleanup) MediaWiki-General MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)	T205353: Clean up empty ar_user_text and rev_user_text fields T188710: Adapt grabbers to support the new actor table T188183: Add the "actor" table to the database layout documentation T229092: Investigate migrateActors script failing due to duplicate empty actor_name T29615: Convert fa_deleted_user to fa_deleted_actor in filearchive table to allow deleting files by anon	T227047: Complete actor table and comment table migration
T174045	T174045: DB schema migration for MCR	stalled	Medium (orange)			Structured-Data-Backlog (Tracking) Multi-Content-Revisions (Deployment) (Epic) Platform Team Workboards (Epics) (Paused) Platform Team Initiatives (MCR) Epic Structured Data Engineering (Monitoring) Schema-change (Change) Wikidata (monitoring)	T174030: Implement DB schema migration tools for MCR T174028: Finalize database schema for MCR content meta-data T183490: MCR schema migration stage 4: Migrate External Store URLs (wmf production) T184446: Configure Toolforge replica views and dumps for the new MCR tables	T174043: Deploy Multi-Content Revisions
T183486	T183486: MCR schema migration stage 0: create tables	resolved	Medium (orange)			DBA (Blocked external/Not db team) MW-1.32-notes (WMF-deploy-2018-07-31 (1.32.0-wmf.15)) Multi-Content-Revisions (Done) StructuredDataOnCommons (SDC General) (Backlog) Schema-change (Unsorted) MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018) (Done) Wikidata (incoming) Patch-For-Review		T183489: MCR schema migration stage 1: Fix Legacy Archive Rows
T184615	T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table	duplicate	Low (yellow)			Multi-Content-Revisions (Tech Debt) Schema-change (Delete / Drop / Remove) Analytics (Analytics-Radar) (Radar - Watching) Platform Team Initiatives (MCR)	T174044: Deploy MCR storage layer	T161671: Compacting the revision table
T187089	T187089: Fix WMF schemas to not break when comment store goes WRITE_NEW	resolved	High (red)			Core-Platform-Team-Old (Watching) Schema-change (Unsorted) MediaWiki-Comment-store DBA (In progress)		T166733: Deploy refactored comment storage T188132: Merge image_comment_temp table into the image table T188327: Deploy refactored actor storage
T188741	T188741: MCR Scheme change - Make rev_text_id DEFAULT 0	resolved	Medium (orange)			MW-1.31-release-notes (WMF-deploy-2018-03-20 (1.31.0-wmf.26)) Multi-Content-Revisions (Done) User-Addshore (Closing ✔️) Patch-For-Review Schema-change (Unsorted)	T190148: Change DEFAULT 0 for rev_text_id on production DBs	T174024: Implement MCR revision retrieval interface
T19237	T19237: Better integration of patrol feature (rc_patrolled, rc_bot in revision: rv_bot, rv_patrolled)	open	Low (yellow)			Community-Tech (2015-2017) (Freezer) Schema-change (Unsorted) MediaWiki-Patrolling (Backlog)	T19433: add bot flag info to (rv/uc)prop=flags	T14394: rcid cannot be easily retrieved - implementation seems patchy
T218446	T218446: Remove use of legacy page.page_restrictions field	open	Medium (orange)			Platform Team Workboards (Clinic Duty Team) (Ready (WIP:5)) MW-1.35-notes (1.35.0-wmf.25; 2020-03-24) MediaWiki-General Technical-Debt (Deprecation process) (<= 2015 / MW 1.26) Performance-Team (Radar) (Perf recommendation) Platform Engineering Code Jam (Inbox) Patch-For-Review Schema-change (Delete / Drop / Remove)	T166184: Run updateRestrictions.php on WMF wikis T248333: Schema change: Make page.page_restrictions column NULL	T251411: page_restrictions field incomplete in current and historical dumps T35334: Remove database column page.page_restrictions from MediaWiki core
T220791	T220791: afl_filter should be split in afl_filter_id and afl_global	resolved	Needs Triage (violet)			Platform Team Workboards (Clinic Duty Team) (External Code Review Completed) MW-1.38-notes (1.38.0-wmf.2; 2021-09-28) Schema-change (Unsorted) MW-1.36-notes (1.36.0-wmf.22; 2020-12-15) AbuseFilter (Overhaul-2020) (In progress) MW-1.34-notes (1.34.0-wmf.25; 2019-10-01)	T234052: Add abuse_filter_log.afl_filter_id and afl_global columns T269712: Migrate afl_filter to afl_filter_id and afl_global T291719: Remove abuse_filter_log.afl_filter column and adjust schema consequently from Wikimedia production	T259377: Migrate AbuseFilter to Abstract Schema
T222224	T222224: RFC: Normalize MediaWiki link tables	open	Medium (orange)			TechCom-RFC (P3: Explore) Schema-change (Unsorted) DBA (Blocked external/Not db team) MediaWiki-Page-derived-data Patch-For-Review Platform Engineering (Tracking/Watching)
T230607	T230607: stop using page_content_model	open	Low (yellow)			Platform Team Initiatives (MCR) Schema-change (Unsorted) Structured-Data-Backlog (Tracking) Structured Data Engineering (To Do)
T233004	T233004: Schema changes for `cu_changes` and `cu_log` table	stalled	Medium (orange)			Patch-For-Review CheckUser (Backlog) Data-Engineering (Datasets) Schema-change (Add / Create) Platform Team Workboards (Clinic Duty Team) (External Code Review Completed)	T253796: Should CheckUser record the log_id of logged actions?	T174022: Implement multi-content revisions T174043: Deploy Multi-Content Revisions T196087: Refactored implementation of MCR page update interface T227047: Complete actor table and comment table migration
T233240	T233240: Remove MySQL aliasing for user_newtalk indexes	resolved	Needs Triage (violet)			Schema-change (Unsorted) User-Marostegui (Watching) MW-1.34-notes (1.34.0-wmf.25; 2019-10-01) Platform Team Workboards (Clinic Duty Team) (Done) MediaWiki-General	T234066: Schema change to rename user_newtalk indexes
T238168	T238168: Convert "user_newtalk" table to use actors	open	Needs Triage (violet)			MediaWiki-General Platform Engineering (Icebox) User-DannyS712 (Others) Schema-change (Change)
T238966	T238966: Apply updates for MCR, actor migration, and content migration, to production wikis.	resolved	Medium (orange)			Platform Team Initiatives (MCR Schema Migration) MW-1.35-notes (1.35.0-wmf.36; 2020-06-09) Platform Team Workboards (Clinic Duty Team) (Waiting for deployment) Schema-change (Unsorted) Cloud-Services (Triage) DBA (In progress)	T252219: Drop MCR-obsoleted fields from the wiki replicas T253289: Remove USE INDEX usertext_timestamp and other references from code T258480: Query plan changes on enwiki.revision queries with MCR change T259524: Review revision table and make sure that the PK is always rev_id	T215466: Remove revision_comment_temp and revision_actor_temp
T245413	T245413: Prepare CentralAuth db for global groups expiration	resolved	Medium (orange)			MW-1.35-notes (1.35.0-wmf.21; 2020-02-25) Patch-For-Review Schema-change (Add / Create) MediaWiki-extensions-CentralAuth (Incoming) Stewards-and-global-tools (Temporary-UserRights) (Backlog)		T153815: Allow global groups to be assigned temporarily (expire)
T249976	T249976: Convert searchindex UNIQUE to PK	open	Medium (orange)			Discovery-Search (watching / waiting) Patch-For-Review Schema-change (Change) Platform Team Workboards (External Code Reviews) (External Code Review Needed) MediaWiki-Search (Backlog)
T250071	T250071: Rename ipb_address index on ipb_address to ipb_address_unique	resolved	Medium (orange)			Schema-change (Unsorted) MW-1.35-notes (1.35.0-wmf.30; 2020-04-28) MediaWiki-User-management (Backlog) DBA (In progress) Platform Team Workboards (Clinic Duty Team) (External Code Review Needed) User-Ladsgroup (Done)
T251343	T251343: Drop unused columns from revision table in DatabaseUpdater (CommentStore, Actor, MCR)	resolved	High (red)			Schema-change (Unsorted) MediaWiki-Revision-backend (Untriaged) Platform Team Workboards (Clinic Duty Team) (Done) MW-1.35-release (To deprecate or remove) Platform Team Initiatives (Revision Storage Schema Improvements) Patch-For-Review MW-1.35-notes (1.35.0-wmf.32; 2020-05-12) Multi-Content-Revisions (Inbox)		T161671: Compacting the revision table
T256841	T256841: slot_revision_origin_role should be a UNIQUE INDEX	declined	Needs Triage (violet)			Platform Engineering (Inbox) User-DannyS712 (Reports) DBA (Backlog) Schema-change (Unsorted)
T256842	T256842: iwlinks indexes should be UNIQUE INDEXes	open	Medium (orange)			Schema-change (Change) User-DannyS712 (Reports) Platform Team Workboards (Clinic Duty Team) (Later)
T283461	T283461: Change datatype of cl_timestamp from timestamp to binary(14)	open	Lowest (sky)			Platform Team Workboards (Clinic Duty Team) (Later) Schema-change (Unsorted) MediaWiki-Categories (Backlog)
T28741	T28741: Migrate file tables to a modern layout (image/oldimage; file/file_revision; add primary keys)	open	Medium (orange)			Patch-For-Review MediaWiki-File-management (Backlog) Multimedia (Backlog) Schema-change (Cleanup) Platform Engineering Roadmap (Later (future inbox)) Commons (Incoming)	T589: RFC: image and oldimage tables
T29615	T29615: Convert fa_deleted_user to fa_deleted_actor in filearchive table to allow deleting files by anon	open	Medium (orange)			Schema-change (Add / Create) MediaWiki-Page-deletion		T167246: Refactor "user" & "user_text" fields into "actor" reference table
T35334	T35334: Remove database column page.page_restrictions from MediaWiki core	stalled	Medium (orange)			MediaWiki-General Patch-For-Review Schema-change (Delete / Drop / Remove)	T218446: Remove use of legacy page.page_restrictions field T166184: Run updateRestrictions.php on WMF wikis	T251411: page_restrictions field incomplete in current and historical dumps T30751: prop=info&inprop=protection sometimes shows protection multiple times
T6715	T6715: Allow comments longer than 255 bytes	resolved	Low (yellow)			MediaWiki-Comment-store Wikimedia-Rdbms (Schema changes) User-notice (Already announced/Archive) Schema-change (Change) Malayalam-Sites (Backlog) Hindi-Sites	T166732: Refactor comment storage in the database and abstract access in MediaWiki T185948: Update web UI for increased comment length T153333: RFC: How should we store longer revision comments? T166733: Deploy refactored comment storage	T161671: Compacting the revision table