Difference between revisions of "T174030: Implement DB schema migration tools for MCR"

Revision as of 07:54, 2 March 2020

Phabricator Link	T174030
Status	resolved
Priority	Medium (orange)
Points
Phabricator Task Created	2017/08/24 10:34 AM
Wiki Page Created	2019/06/09 01:17 PM
Phabricator Task Last Modified	2018/07/11 06:45 PM
Wiki Page Last Updated	2020/10/16 12:25 PM
Phabricator Task Closed	2018/06/20 01:30 PM
Authored By	daniel (Daniel Kinzler)
Assigned To	Anomie
Projects	Epic Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1) (Done) StructuredDataOnCommons (SDC General) (Continuous tasks / Epics) Wikidata (monitoring)
Platform Engineering Initiative Column
Platform Team Workboards Column
Subtasks	T182678: [MCR] Script for populating empty ar_rev_id fields (resolved) T174028: Finalize database schema for MCR content meta-data (resolved) T182682: [MCR] Script(s) for populating new tables (slots, content, content_models, slot_roles) (resolved)
Parent Tasks	T174038: Initial implementation of MCR page update interface T174045: DB schema migration for MCR T183488: MCR schema migration stage 2: populate new fields

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

Project	Column	Date
MediaWiki-Platform-Team	⇐ Inbox	13 October 2017
MediaWiki-Platform-Team	⇒ MWPT-Q2-Oct-Dec-2017	13 October 2017
StructuredDataOnCommons (SDC General)	⇐ Backlog	17 November 2017
StructuredDataOnCommons (SDC General)	⇒ Continuous tasks / Epics	17 November 2017
Multi-Content-Revisions	⇐ Inbox	20 November 2017
Multi-Content-Revisions	⇒ Duplicate	20 November 2017
Wikidata	⇐ incoming	18 December 2017
Wikidata	⇒ monitoring	18 December 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)	⇒ Ready	2 January 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ Ready	11 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ Watching	11 February 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)	⇒ Watching	4 April 2018
Multi-Content-Revisions	⇐ Duplicate	7 May 2018
Multi-Content-Revisions	⇒ In Progress	7 May 2018
⇓ Multi-Content-Revisions		8 May 2018
Multi-Content-Revisions	⇐ In Progress	8 May 2018
Multi-Content-Revisions	⇒ MCR-SDC Storage Layer - phase 1	8 May 2018
⇑ Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)		8 May 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇐ Backlog	8 May 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇒ Done	8 May 2018
⇑ Epic		10 May 2018
⇓ Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)		10 May 2018
Multi-Content-Revisions	⇐ MCR-SDC Storage Layer - phase 1	10 May 2018
Multi-Content-Revisions	⇒ Epic	10 May 2018
⇑ Multi-Content-Revisions		10 May 2018
⇓ Multi-Content-Revisions		30 May 2018
⇑ Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)		30 May 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇐ Done	30 May 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇒ Epic	30 May 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇐ Epic	26 June 2018
Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)	⇒ Done	26 June 2018
⇓ MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)		11 July 2018

@@ Line 35: / Line 35: @@
 |subtasks=174028,182682,182678
 |transitions={{Transition
+|date=1531349146
+|type=Removed Project
+|project=MWPT-Q4-Apr-Jun-2018
+}}{{Transition
+|date=1529987112
+|type=Entered Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Done
-|transitionDate=1529987112
-|transitionType=Entered Column
 }}{{Transition
+|date=1529987112
+|type=Exited Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Epic
-|transitionDate=1529987112
-|transitionType=Exited Column
 }}{{Transition
+|date=1527720506
+|type=Entered Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Epic
-|transitionDate=1527720506
-|transitionType=Entered Column
 }}{{Transition
+|date=1527720506
+|type=Exited Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Done
-|transitionDate=1527720506
-|transitionType=Exited Column
 }}{{Transition
+|date=1527720393
+|type=Removed Project
+|project=Multi-Content-Revisions
+}}{{Transition
+|date=1527720393
+|type=Added Project
+|project=MCR-SDC Storage Layer - phase 1
+}}{{Transition
+|date=1525969167
+|type=Removed Project
+|project=MCR-SDC Storage Layer - phase 1
+}}{{Transition
+|date=1525969167
+|type=Added Project
+|project=Multi-Content-Revisions
+}}{{Transition
+|date=1525969167
+|type=Entered Column
 |project=Multi-Content-Revisions
 |column=Epic
-|transitionDate=1525969167
-|transitionType=Entered Column
 }}{{Transition
+|date=1525969167
+|type=Exited Column
 |project=Multi-Content-Revisions
 |column=MCR-SDC Storage Layer - phase 1
-|transitionDate=1525969167
-|transitionType=Exited Column
 }}{{Transition
+|date=1525969058
+|type=Added Project
+|project=Epic
+}}{{Transition
+|date=1525812361
+|type=Entered Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Done
-|transitionDate=1525812361
-|transitionType=Entered Column
 }}{{Transition
+|date=1525812361
+|type=Exited Column
 |project=Multi-Content-Revisions (MCR-SDC Storage Layer - phase 1)
 |column=Backlog
-|transitionDate=1525812361
-|transitionType=Exited Column
 }}{{Transition
+|date=1525784003
+|type=Removed Project
+|project=Multi-Content-Revisions
+}}{{Transition
+|date=1525784003
+|type=Added Project
+|project=MCR-SDC Storage Layer - phase 1
+}}{{Transition
+|date=1525784003
+|type=Entered Column
 |project=Multi-Content-Revisions
 |column=MCR-SDC Storage Layer - phase 1
-|transitionDate=1525784003
-|transitionType=Entered Column
 }}{{Transition
+|date=1525784003
+|type=Exited Column
 |project=Multi-Content-Revisions
 |column=In Progress
-|transitionDate=1525784003
-|transitionType=Exited Column
 }}{{Transition
+|date=1525689471
+|type=Entered Column
 |project=Multi-Content-Revisions
 |column=In Progress
-|transitionDate=1525689471
-|transitionType=Entered Column
 }}{{Transition
+|date=1525689471
+|type=Exited Column
 |project=Multi-Content-Revisions
 |column=Duplicate
-|transitionDate=1525689471
-|transitionType=Exited Column
 }}{{Transition
+|date=1522868143
+|type=Entered Column
 |project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
 |column=Watching
-|transitionDate=1522868143
-|transitionType=Entered Column
 }}{{Transition
+|date=1522868143
+|type=Exited Column
 |project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
 |column=Ready
-|transitionDate=1522868143
-|transitionType=Exited Column
 }}{{Transition
+|date=1522868077
+|type=Removed Project
+|project=MWPT-Q3-Jan-Mar-2018
+}}{{Transition
+|date=1522868077
+|type=Added Project
+|project=MWPT-Q4-Apr-Jun-2018
+}}{{Transition
+|date=1518390237
+|type=Entered Column
 |project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
 |column=Watching
-|transitionDate=1518390237
-|transitionType=Entered Column
 }}{{Transition
+|date=1518390237
+|type=Exited Column
 |project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
 |column=Ready
-|transitionDate=1518390237
-|transitionType=Exited Column
 }}{{Transition
+|date=1514909986
+|type=Entered Column
 |project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
 |column=Ready
-|transitionDate=1514909986
-|transitionType=Entered Column
 }}{{Transition
+|date=1514909986
+|type=Exited Column
 |project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
 |column=Ready
-|transitionDate=1514909986
-|transitionType=Exited Column
 }}{{Transition
+|date=1513873157
+|type=Entered Column
 |project=MediaWiki-Platform-Team
 |column=MWPT-Q3-Jan-Mar-2018
-|transitionDate=1513873157
-|transitionType=Entered Column
 }}{{Transition
+|date=1513873157
+|type=Exited Column
 |project=MediaWiki-Platform-Team
 |column=MWPT-Q2-Oct-Dec-2017
-|transitionDate=1513873157
-|transitionType=Exited Column
 }}{{Transition
+|date=1513609957
+|type=Entered Column
 |project=Wikidata
 |column=monitoring
-|transitionDate=1513609957
-|transitionType=Entered Column
 }}{{Transition
+|date=1513609957
+|type=Exited Column
 |project=Wikidata
 |column=incoming
-|transitionDate=1513609957
-|transitionType=Exited Column
 }}{{Transition
+|date=1511206853
+|type=Entered Column
 |project=Multi-Content-Revisions
 |column=Duplicate
-|transitionDate=1511206853
-|transitionType=Entered Column
 }}{{Transition
+|date=1511206853
+|type=Exited Column
 |project=Multi-Content-Revisions
 |column=Inbox
-|transitionDate=1511206853
-|transitionType=Exited Column
 }}{{Transition
+|date=1510940254
+|type=Entered Column
 |project=StructuredDataOnCommons (SDC General)
 |column=Continuous tasks / Epics
-|transitionDate=1510940254
-|transitionType=Entered Column
 }}{{Transition
+|date=1510940254
+|type=Exited Column
 |project=StructuredDataOnCommons (SDC General)
 |column=Backlog
-|transitionDate=1510940254
-|transitionType=Exited Column
 }}{{Transition
+|date=1507925819
+|type=Entered Column
 |project=MediaWiki-Platform-Team
 |column=MWPT-Q2-Oct-Dec-2017
-|transitionDate=1507925819
-|transitionType=Entered Column
 }}{{Transition
+|date=1507925819
+|type=Exited Column
 |project=MediaWiki-Platform-Team
 |column=Inbox
-|transitionDate=1507925819
-|transitionType=Exited Column
 }}
 }}