Difference between revisions of "T167246: Refactor "user" & "user_text" fields into "actor" reference table"

Latest revision as of 13:09, 27 April 2021

Phabricator Link	T167246
Status	open
Priority	Needs Triage (violet)
Points
Phabricator Task Created	2017/06/06 10:14 PM
Wiki Page Created	2019/06/09 01:18 PM
Phabricator Task Last Modified	2021/04/27 12:54 PM
Wiki Page Last Updated	2021/04/27 02:09 PM
Phabricator Task Closed
Authored By	brion (Brion Vibber)
Assigned To
Projects	Epic MW-1.33-notes (1.33.0-wmf.12; 2019-01-08) MediaWiki-General Platform Team Initiatives (Revision Storage Schema Improvements) Schema-change (Cleanup)
Platform Engineering Initiative Column	Revision Storage Schema Improvements
Platform Team Workboards Column
Subtasks	T205353: Clean up empty ar_user_text and rev_user_text fields (open) T188710: Adapt grabbers to support the new actor table (resolved) T188183: Add the "actor" table to the database layout documentation (resolved) T229092: Investigate migrateActors script failing due to duplicate empty actor_name (open) T29615: Convert fa_deleted_user to fa_deleted_actor in filearchive table to allow deleting files by anon (open)
Parent Tasks	T227047: Complete actor table and comment table migration

Column Transitions: (Added project: ⇑, Removed project: ⇓,Entered column: ⇒, Exited column: ⇐)

Project	Column	Date
MediaWiki-Platform-Team	⇐ Inbox	8 June 2017
MediaWiki-Platform-Team	⇒ Watching	8 June 2017
Wikimedia-Rdbms	⇐ Untriaged	6 July 2017
Wikimedia-Rdbms	⇒ Schema changes	6 July 2017
MediaWiki-Platform-Team	⇐ Watching	13 October 2017
MediaWiki-Platform-Team	⇒ MWPT-Q1-Jul-Sep-2017	13 October 2017
MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)	⇐ Ready	13 October 2017
MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)	⇒ In Progress	13 October 2017
MediaWiki-Platform-Team	⇐ MWPT-Q1-Jul-Sep-2017	13 October 2017
MediaWiki-Platform-Team	⇒ MWPT-Q1-Jul-Sep-2017	13 October 2017
MediaWiki-Platform-Team	⇐ MWPT-Q1-Jul-Sep-2017	19 October 2017
MediaWiki-Platform-Team	⇒ MWPT-Q2-Oct-Dec-2017	19 October 2017
MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017)	⇐ Ready	19 October 2017
MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017)	⇒ In Progress	19 October 2017
MediaWiki-Platform-Team	⇐ MWPT-Q2-Oct-Dec-2017	21 December 2017
MediaWiki-Platform-Team	⇒ MWPT-Q3-Jan-Mar-2018	21 December 2017
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ Ready	2 January 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ In Progress	2 January 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ In Progress	20 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ Waiting for Review	20 February 2018
⇑ MW-1.31-release-notes (WMF-deploy-2018-02-27 (1.31.0-wmf.23))		23 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ Waiting for Review	26 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ In Progress	26 February 2018
⇓ MW-1.31-release-notes (WMF-deploy-2018-02-27 (1.31.0-wmf.23))		12 March 2018
⇑ MW-1.31-release-notes (WMF-deploy-2018-03-13 (1.31.0-wmf.25))		12 March 2018
⇓ MW-1.31-release-notes (WMF-deploy-2018-03-13 (1.31.0-wmf.25))		16 March 2018
⇑ MW-1.31-release-notes (WMF-deploy-2018-03-20 (1.31.0-wmf.26))		16 March 2018
⇓ MW-1.31-release-notes (WMF-deploy-2018-03-20 (1.31.0-wmf.26))		21 March 2018
⇑ MW-1.31-release-notes (WMF-deploy-2018-03-27 (1.31.0-wmf.27))		21 March 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ In Progress	2 April 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ Waiting for Review	2 April 2018
⇓ MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)		4 April 2018
⇑ MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)		4 April 2018
MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)	⇐ Ready	4 April 2018
MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)	⇒ Waiting for Review	4 April 2018
⇓ MW-1.31-release-notes (WMF-deploy-2018-03-27 (1.31.0-wmf.27))		12 April 2018
⇑ MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30))		12 April 2018
Multi-Content-Revisions	⇐ Inbox	19 April 2018
Multi-Content-Revisions	⇒ In Progress	19 April 2018
⇑ MW-1.32-notes (WMF-deploy-2018-05-01 (1.32.0-wmf.2))		24 April 2018
⇓ MW-1.32-notes (WMF-deploy-2018-05-01 (1.32.0-wmf.2))		3 May 2018
⇑ MW-1.32-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3))		3 May 2018
⇓ Multi-Content-Revisions		15 May 2018
⇓ MW-1.32-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3))		29 May 2018
⇑ MW-1.32-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6))		29 May 2018
⇓ MW-1.32-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6))		11 June 2018
⇑ MW-1.32-notes (WMF-deploy-2018-06-12 (1.32.0-wmf.8))		11 June 2018
⇓ Patch-For-Review		9 July 2018
⇓ MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)		11 July 2018
⇑ Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)		11 July 2018
Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)	⇐ Backlog	11 July 2018
Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)	⇒ Paused	11 July 2018
⇓ Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)		1 October 2018
⇑ Platform Team Legacy (Next)		1 October 2018
⇓ Platform Team Legacy (Next)		2 October 2018
Platform Team Legacy	⇐ Next	2 October 2018
Platform Team Legacy	⇒ Epics	2 October 2018
⇑ Platform Team Legacy		2 October 2018
⇑ Platform Engineering		2 October 2018
⇓ Platform Engineering		3 October 2018
Platform Engineering	⇐ Inbox	3 October 2018
Platform Engineering	⇒ Needs Cleaning - Code Health (TEC13)	3 October 2018
⇑ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
⇑ Platform Engineering		3 October 2018
⇓ Platform Engineering		3 October 2018
⇓ Platform Team Legacy		3 October 2018
⇑ Platform Team Legacy (Epic)		3 October 2018
⇑ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
Platform Engineering	⇐ Needs Cleaning - Code Health (TEC13)	3 October 2018
Platform Engineering	⇒ Needs Cleaning - Code Health (TEC13)	3 October 2018
Platform Team Legacy	⇐ Epic	3 October 2018
Platform Team Legacy	⇒ Epic	3 October 2018
⇑ Patch-For-Review		8 November 2018
⇑ MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)		6 January 2019
⇓ Platform Team Legacy (Epic)		5 July 2019
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		9 July 2019
⇑ Platform Engineering (Revision Storage Schema Improvements)		9 July 2019
⇓ MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30))		18 July 2019
⇓ MW-1.30-release-notes (WMF-deploy-2017-07-11_(1.30.0-wmf.9))		18 July 2019
⇓ Wikimedia-Rdbms		18 July 2019
⇓ MW-1.32-notes (WMF-deploy-2018-06-12 (1.32.0-wmf.8))		18 July 2019
⇑ MediaWiki-General		18 July 2019
⇑ Schema-change		18 July 2019
⇓ Patch-For-Review		18 July 2019
⇓ Platform Engineering (Revision Storage Schema Improvements)		26 July 2019
Platform Engineering	⇐ Revision Storage Schema Improvements	26 July 2019
Platform Engineering	⇒ mop	26 July 2019
⇑ Platform Team Initiatives (Revision Storage Schema Improvements)		26 July 2019
Schema-change	⇐ Unsorted	29 November 2019
Schema-change	⇒ Cleanup	29 November 2019

@@ Line 3: / Line 3: @@
 |status=open
 |color=violet
+|points=
 |dateCreated=1496801652
-|dateModified=1570130840
+|dateModified=1619542455
 |author={{Phabricator User
 |type=author
 |username=brion
 |realName=Brion Vibber
-}}
-|owner={{Phabricator User
-|type=owner
-|username=Anomie
-|realName=Brad Jorsch
 }}
 |projects={{Phabricator Project
 |name=MW-1.33-notes
 |column=1.33.0-wmf.12; 2019-01-08
+|entryDate=1496801652
 }}{{Phabricator Project
 |name=Epic
+|entryDate=1496801652
 }}{{Phabricator Project
 |name=MediaWiki-General
+|entryDate=1496801652
 }}{{Phabricator Project
-|name=CPT Initiatives
+|name=Platform Team Initiatives
 |column=Revision Storage Schema Improvements
+|entryDate=1496801652
 }}{{Phabricator Project
 |name=Schema-change
+|column=Cleanup
+|entryDate=1575010021
+}}
+|subtasks=205353,188710,229092,29615,188183
+|transitions={{Transition
+|date=1575010021
+|type=Entered Column
+|project=Schema-change
+|column=Cleanup
+}}{{Transition
+|date=1575010021
+|type=Exited Column
+|project=Schema-change
 |column=Unsorted
+}}{{Transition
+|date=1564168280
+|type=Removed Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168280
+|type=Added Project
+|project=Platform Team Initiatives (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168280
+|type=Entered Column
+|project=Platform Engineering
+|column=mop
+}}{{Transition
+|date=1564168280
+|type=Exited Column
+|project=Platform Engineering
+|column=Revision Storage Schema Improvements
+}}{{Transition
+|date=1563488528
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1563488515
+|type=Removed Project
+|project=MW-1.32-notes (WMF-deploy-2018-06-12 (1.32.0-wmf.8))
+}}{{Transition
+|date=1563488515
+|type=Removed Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30))
+}}{{Transition
+|date=1563488515
+|type=Removed Project
+|project=MW-1.30-release-notes (WMF-deploy-2017-07-11_(1.30.0-wmf.9))
+}}{{Transition
+|date=1563488515
+|type=Removed Project
+|project=Wikimedia-Rdbms
+}}{{Transition
+|date=1563488515
+|type=Added Project
+|project=MediaWiki-General
+}}{{Transition
+|date=1563488515
+|type=Added Project
+|project=Schema-change
+}}{{Transition
+|date=1562699254
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1562699254
+|type=Added Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1562355215
+|type=Removed Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1546815630
+|type=Added Project
+|project=MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)
+}}{{Transition
+|date=1541701227
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1538579901
+|type=Entered Column
+|project=Platform Team Legacy
+|column=Epic
+}}{{Transition
+|date=1538579901
+|type=Exited Column
+|project=Platform Team Legacy
+|column=Epic
+}}{{Transition
+|date=1538575965
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575965
+|type=Exited Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575565
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538575565
+|type=Removed Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1538575565
+|type=Added Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1538575565
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574799
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574799
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574798
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574798
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574798
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538574798
+|type=Exited Column
+|project=Platform Engineering
+|column=Inbox
+}}{{Transition
+|date=1538489395
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538486972
+|type=Removed Project
+|project=Platform Team Legacy (Next)
+}}{{Transition
+|date=1538486972
+|type=Added Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1538486972
+|type=Entered Column
+|project=Platform Team Legacy
+|column=Epics
+}}{{Transition
+|date=1538486972
+|type=Exited Column
+|project=Platform Team Legacy
+|column=Next
+}}{{Transition
+|date=1538401403
+|type=Removed Project
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+}}{{Transition
+|date=1538401403
+|type=Added Project
+|project=Platform Team Legacy (Next)
+}}{{Transition
+|date=1531344569
+|type=Entered Column
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+|column=Paused
+}}{{Transition
+|date=1531344569
+|type=Exited Column
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+|column=Backlog
+}}{{Transition
+|date=1531344556
+|type=Removed Project
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+}}{{Transition
+|date=1531344556
+|type=Added Project
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+}}{{Transition
+|date=1531123064
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1528765252
+|type=Removed Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6))
+}}{{Transition
+|date=1528765252
+|type=Added Project
+|project=MW-1.32-notes (WMF-deploy-2018-06-12 (1.32.0-wmf.8))
+}}{{Transition
+|date=1527573638
+|type=Removed Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3))
+}}{{Transition
+|date=1527573638
+|type=Added Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6))
+}}{{Transition
+|date=1526384354
+|type=Removed Project
+|project=Multi-Content-Revisions
+}}{{Transition
+|date=1525352442
+|type=Removed Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-01 (1.32.0-wmf.2))
+}}{{Transition
+|date=1525352442
+|type=Added Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3))
+}}{{Transition
+|date=1524614435
+|type=Added Project
+|project=MW-1.32-notes (WMF-deploy-2018-05-01 (1.32.0-wmf.2))
+}}{{Transition
+|date=1524148740
+|type=Entered Column
+|project=Multi-Content-Revisions
+|column=In Progress
+}}{{Transition
+|date=1524148740
+|type=Exited Column
+|project=Multi-Content-Revisions
+|column=Inbox
+}}{{Transition
+|date=1523559637
+|type=Removed Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-27 (1.31.0-wmf.27))
+}}{{Transition
+|date=1523559637
+|type=Added Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30))
+}}{{Transition
+|date=1522868303
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+|column=Waiting for Review
+}}{{Transition
+|date=1522868303
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+|column=Ready
+}}{{Transition
+|date=1522868283
+|type=Removed Project
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+}}{{Transition
+|date=1522868283
+|type=Added Project
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+}}{{Transition
+|date=1522719716
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Waiting for Review
+}}{{Transition
+|date=1522719716
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1521669638
+|type=Removed Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-20 (1.31.0-wmf.26))
+}}{{Transition
+|date=1521669638
+|type=Added Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-27 (1.31.0-wmf.27))
+}}{{Transition
+|date=1521230459
+|type=Removed Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-13 (1.31.0-wmf.25))
+}}{{Transition
+|date=1521230459
+|type=Added Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-20 (1.31.0-wmf.26))
+}}{{Transition
+|date=1520888453
+|type=Removed Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-02-27 (1.31.0-wmf.23))
+}}{{Transition
+|date=1520888453
+|type=Added Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-03-13 (1.31.0-wmf.25))
+}}{{Transition
+|date=1519699404
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1519699404
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Waiting for Review
+}}{{Transition
+|date=1519426825
+|type=Added Project
+|project=MW-1.31-release-notes (WMF-deploy-2018-02-27 (1.31.0-wmf.23))
+}}{{Transition
+|date=1519137424
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Waiting for Review
+}}{{Transition
+|date=1519137424
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1514908294
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1514908294
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Ready
+}}{{Transition
+|date=1513873233
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q3-Jan-Mar-2018
+}}{{Transition
+|date=1513873233
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q2-Oct-Dec-2017
+}}{{Transition
+|date=1508448900
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017)
+|column=In Progress
+}}{{Transition
+|date=1508448900
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017)
+|column=Ready
+}}{{Transition
+|date=1508448692
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q2-Oct-Dec-2017
+}}{{Transition
+|date=1508448692
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q1-Jul-Sep-2017
+}}{{Transition
+|date=1507919160
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q1-Jul-Sep-2017
+}}{{Transition
+|date=1507919160
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q1-Jul-Sep-2017
+}}{{Transition
+|date=1507918695
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)
+|column=In Progress
+}}{{Transition
+|date=1507918695
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)
+|column=Ready
+}}{{Transition
+|date=1507918210
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q1-Jul-Sep-2017
+}}{{Transition
+|date=1507918210
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Watching
+}}{{Transition
+|date=1499316066
+|type=Entered Column
+|project=Wikimedia-Rdbms
+|column=Schema changes
+}}{{Transition
+|date=1499316066
+|type=Exited Column
+|project=Wikimedia-Rdbms
+|column=Untriaged
+}}{{Transition
+|date=1496903244
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Watching
+}}{{Transition
+|date=1496903244
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Inbox
 }}
-|subtasks=205353,188710,229092,188183
 }}