Difference between revisions of "T191231: RFC: Abstract schemas and schema changes"

Latest revision as of 19:12, 3 January 2022

Phabricator Link	T191231
Status	resolved
Priority	Medium (orange)
Points
Phabricator Task Created	2018/04/02 02:21 PM
Wiki Page Created	2019/06/09 01:18 PM
Phabricator Task Last Modified	2022/01/03 05:41 PM
Wiki Page Last Updated	2022/01/03 07:12 PM
Phabricator Task Closed	2021/05/27 07:35 PM
Authored By	Anomie
Assigned To	Ladsgroup (Amir Sarabadani)
Projects	Epic MSSQL (Backlog) MW-1.35-notes (1.35.0-wmf.32; 2020-05-12) MW-1.36-notes (1.36.0-wmf.38; 2021-04-06) MediaWiki-Installer (General) Oracle Database Patch-For-Review Platform Team Initiatives (Abstract Schema) (Backlog) Platform Team Workboards (Initiatives) (Later) PostgreSQL (Backlog) SQLite (Backlog) TechCom-RFC (TechCom-RFC-Closed) (Approved) User-Addshore (Watching 👀) User-Ladsgroup (Done)
Platform Engineering Initiative Column
Platform Team Workboards Column	Initiatives: Later
Subtasks	T230421: Introduce a maintenance script that takes abstract schema(changes\|) and gives out raw SQL (resolved) T230420: Introduce JSON-based Doctrine-DBAL-based SchemaDiffBuilder (resolved) T230419: Introduce JSON-based Doctrine-DBAL-based SchemaBuilder (resolved) T230418: Drop support for MSSQL and Oracle from core (resolved) T230430: Migrate most recent schema changes to use the abstract system (resolved) T230428: Migrate tables.sql to abstract schema (resolved) T237839: Wire abstract schema and schema changes for extension (open) T252305: Evaluate state of abstract schema changes in REL1_35 (resolved) T252313: Document mapping of SQL data types across DBMS (resolved) T252919: Add a test to check if generated sql files are the same as the abstract (resolved) T259374: Convert extensions to using abstract schema (open) T261912: Convert WMF Deployed Extensions to Abstract Schema (open) T261911: Convert Bundled Extensions to Abstract Schema (open)
Parent Tasks

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

Project	Column	Date
⇑ PostgreSQL		2 April 2018
⇑ Epic		2 April 2018
⇑ MSSQL		2 April 2018
⇑ Proposal		2 April 2018
⇑ Oracle Database		2 April 2018
⇑ MediaWiki-Platform-Team		2 April 2018
⇑ SQLite		2 April 2018
⇑ Wikimedia-Rdbms		2 April 2018
MediaWiki-Platform-Team	⇐ Inbox	2 April 2018
MediaWiki-Platform-Team	⇒ Backlog	2 April 2018
Wikimedia-Rdbms	⇐ Untriaged	10 April 2018
Wikimedia-Rdbms	⇒ Schema changes	10 April 2018
MediaWiki-Platform-Team	⇐ Backlog	30 April 2018
MediaWiki-Platform-Team	⇒ Backlog	30 April 2018
⇓ MediaWiki-Platform-Team		11 July 2018
⇑ Core-Platform-Team-Old		11 July 2018
Core-Platform-Team-Old	⇐ Inbox	11 July 2018
Core-Platform-Team-Old	⇒ Backlog	11 July 2018
⇓ Proposal		30 July 2018
⇑ TechCom-RFC		30 July 2018
TechCom-RFC	⇐ P1: Define	1 August 2018
TechCom-RFC	⇒ Old	1 August 2018
⇑ Platform Team Legacy (Later)		1 October 2018
⇓ Core-Platform-Team-Old		1 October 2018
⇑ Core Platform Team Goals (MCR: Uncategorized)		1 October 2018
⇓ Core Platform Team Goals (MCR: Uncategorized)		1 October 2018
⇑ Platform Engineering		1 October 2018
Platform Engineering	⇐ Inbox	1 October 2018
Platform Engineering	⇒ Triage Meeting Inbox	1 October 2018
⇓ Platform Team Legacy (Later)		2 October 2018
Platform Team Legacy	⇐ Later	2 October 2018
Platform Team Legacy	⇒ Epics	2 October 2018
⇑ Platform Team Legacy		2 October 2018
⇓ Platform Team Legacy		3 October 2018
⇓ Platform Engineering		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
TechCom-RFC	⇐ Old	17 October 2018
TechCom-RFC	⇒ Under discussion	17 October 2018
⇑ User-Addshore		21 January 2019
TechCom-RFC	⇐ Under discussion	1 March 2019
TechCom-RFC	⇒ Request IRC meeting	1 March 2019
TechCom-RFC	⇐ Request IRC meeting	12 March 2019
TechCom-RFC	⇒ Under discussion	12 March 2019
⇑ Patch-For-Review		14 March 2019
TechCom-RFC	⇐ Under discussion	12 June 2019
TechCom-RFC	⇒ Request IRC meeting	12 June 2019
⇓ Platform Team Legacy (Epic)		5 July 2019
TechCom-RFC	⇐ Request IRC meeting	17 July 2019
TechCom-RFC	⇒ P1: Define	17 July 2019
⇓ Wikimedia-Rdbms		18 July 2019
⇑ MediaWiki-Installer		18 July 2019
MediaWiki-Installer	⇐ General	22 July 2019
MediaWiki-Installer	⇒ Not my department!	22 July 2019
MediaWiki-Installer	⇐ Not my department!	22 July 2019
MediaWiki-Installer	⇒ General	22 July 2019
TechCom-RFC	⇐ P1: Define	26 July 2019
TechCom-RFC	⇒ P5: Last Call	26 July 2019
⇓ TechCom-RFC		13 August 2019
⇑ TechCom-RFC (TechCom-RFC-Closed)		13 August 2019
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		27 August 2019
⇑ Platform Team Initiatives (Abstract Schema)		27 August 2019
TechCom-RFC (TechCom-RFC-Closed)	⇐ Untriaged	16 October 2019
TechCom-RFC (TechCom-RFC-Closed)	⇒ In progress	16 October 2019
User-Addshore	⇐ Unsorted 💣	22 November 2019
User-Addshore	⇒ Watching 👀	22 November 2019
TechCom-RFC (TechCom-RFC-Closed)	⇐ In progress	19 February 2020
TechCom-RFC (TechCom-RFC-Closed)	⇒ Approved	19 February 2020
⇑ Platform Team Workboards (Initiatives)		17 March 2020
Platform Team Workboards (Initiatives)	⇐ Later	17 March 2020
Platform Team Workboards (Initiatives)	⇒ Next	17 March 2020
Platform Team Workboards (Initiatives)	⇐ Next	17 March 2020
Platform Team Workboards (Initiatives)	⇒ Next	17 March 2020
Platform Team Initiatives	⇐ Abstract Schema	19 March 2020
Platform Team Initiatives	⇒ Abstract Schema	19 March 2020
Platform Team Workboards (Initiatives)	⇐ Next	24 March 2020
Platform Team Workboards (Initiatives)	⇒ Later	24 March 2020
Platform Team Workboards (Initiatives)	⇐ Later	24 March 2020
Platform Team Workboards (Initiatives)	⇒ Later	24 March 2020
⇑ MW-1.35-notes (1.35.0-wmf.32; 2020-05-12)		9 May 2020
⇓ Patch-For-Review		16 October 2020
⇑ Patch-For-Review		17 October 2020
⇑ MW-1.36-notes (1.36.0-wmf.14; 2020-10-20)		18 October 2020
⇓ MW-1.36-notes (1.36.0-wmf.14; 2020-10-20)		21 March 2021
⇑ MW-1.36-notes (1.36.0-wmf.36; 2021-03-23)		21 March 2021
⇓ MW-1.36-notes (1.36.0-wmf.36; 2021-03-23)		5 April 2021
⇑ MW-1.36-notes (1.36.0-wmf.38; 2021-04-06)		5 April 2021
⇑ User-Ladsgroup		27 May 2021
User-Ladsgroup	⇐ Incoming	25 December 2021
User-Ladsgroup	⇒ Done	25 December 2021

@@ Line 1: / Line 1: @@
 {{Phabricator Task
 |name=RFC: Abstract schemas and schema changes
-|status=open
+|status=resolved
-|color=violet
+|color=orange
+|points=
 |dateCreated=1522693290
-|dateModified=1562869690
+|dateModified=1641249705
+|dateClosed=1622158517
 |author={{Phabricator User
 |type=author
 |username=Anomie
-|realName=Brad Jorsch
+|realName=
+}}
+|owner={{Phabricator User
+|type=owner
+|username=Ladsgroup
+|realName=Amir Sarabadani
 }}
 |projects={{Phabricator Project
-|name=Patch-For-Review
+|name=MW-1.35-notes
+|column=1.35.0-wmf.32; 2020-05-12
+|entryDate=1522693290
+}}{{Phabricator Project
+|name=MW-1.36-notes
+|column=1.36.0-wmf.38; 2021-04-06
+|entryDate=1522693290
 }}{{Phabricator Project
-|name=User-Addshore
+|name=Platform Team Initiatives (Abstract Schema)
-|column=Unsorted 💣
+|column=Backlog
+|entryDate=1522693290
 }}{{Phabricator Project
-|name=Core Platform Team
+|name=Epic
-|column=Code Health (TEC13)
+|entryDate=1522693290
 }}{{Phabricator Project
-|name=TechCom-RFC
+|name=Platform Team Workboards (Initiatives)
-|column=Request IRC meeting
+|column=Later
+|entryDate=1585072752
 }}{{Phabricator Project
-|name=SQLite
+|name=MSSQL
 |column=Backlog
+|entryDate=1522693290
+}}{{Phabricator Project
+|name=MediaWiki-Installer
+|column=General
+|entryDate=1563814408
 }}{{Phabricator Project
 |name=Oracle Database
+|entryDate=1522693290
+}}{{Phabricator Project
+|name=Patch-For-Review
+|entryDate=1522693290
 }}{{Phabricator Project
-|name=MSSQL
+|name=PostgreSQL
 |column=Backlog
+|entryDate=1522693290
 }}{{Phabricator Project
-|name=PostgreSQL
+|name=SQLite
 |column=Backlog
+|entryDate=1522693290
+}}{{Phabricator Project
+|name=TechCom-RFC (TechCom-RFC-Closed)
+|column=Approved
+|entryDate=1582153625
+}}{{Phabricator Project
+|name=User-Addshore
+|column=Watching 👀
+|entryDate=1574426918
 }}{{Phabricator Project
-|name=MediaWiki-Database
+|name=User-Ladsgroup
+|column=Done
+|entryDate=1640481323
+}}
+|subtasks=261912,261911,259374,252919,252305,237839,230430,230428,230420,230419,230418,230421,252313
+|transitions={{Transition
+|date=1640481323
+|type=Entered Column
+|project=User-Ladsgroup
+|column=Done
+}}{{Transition
+|date=1640481323
+|type=Exited Column
+|project=User-Ladsgroup
+|column=Incoming
+}}{{Transition
+|date=1622158517
+|type=Added Project
+|project=User-Ladsgroup
+}}{{Transition
+|date=1617670822
+|type=Removed Project
+|project=MW-1.36-notes (1.36.0-wmf.36; 2021-03-23)
+}}{{Transition
+|date=1617670822
+|type=Added Project
+|project=MW-1.36-notes (1.36.0-wmf.38; 2021-04-06)
+}}{{Transition
+|date=1616321007
+|type=Removed Project
+|project=MW-1.36-notes (1.36.0-wmf.14; 2020-10-20)
+}}{{Transition
+|date=1616321007
+|type=Added Project
+|project=MW-1.36-notes (1.36.0-wmf.36; 2021-03-23)
+}}{{Transition
+|date=1603008031
+|type=Added Project
+|project=MW-1.36-notes (1.36.0-wmf.14; 2020-10-20)
+}}{{Transition
+|date=1602923049
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1602868260
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1589040021
+|type=Added Project
+|project=MW-1.35-notes (1.35.0-wmf.32; 2020-05-12)
+}}{{Transition
+|date=1585072752
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Later
+}}{{Transition
+|date=1585072752
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Later
+}}{{Transition
+|date=1585072748
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Later
+}}{{Transition
+|date=1585072748
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Next
+}}{{Transition
+|date=1584624374
+|type=Entered Column
+|project=Platform Team Initiatives
+|column=Abstract Schema
+}}{{Transition
+|date=1584624374
+|type=Exited Column
+|project=Platform Team Initiatives
+|column=Abstract Schema
+}}{{Transition
+|date=1584461086
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Next
+}}{{Transition
+|date=1584461086
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Next
+}}{{Transition
+|date=1584460840
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Next
+}}{{Transition
+|date=1584460840
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Later
+}}{{Transition
+|date=1584460832
+|type=Added Project
+|project=Platform Team Workboards (Initiatives)
+}}{{Transition
+|date=1582153625
+|type=Entered Column
+|project=TechCom-RFC (TechCom-RFC-Closed)
+|column=Approved
+}}{{Transition
+|date=1582153625
+|type=Exited Column
+|project=TechCom-RFC (TechCom-RFC-Closed)
+|column=In progress
+}}{{Transition
+|date=1574426918
+|type=Entered Column
+|project=User-Addshore
+|column=Watching 👀
+}}{{Transition
+|date=1574426918
+|type=Exited Column
+|project=User-Addshore
+|column=Unsorted 💣
+}}{{Transition
+|date=1571264282
+|type=Entered Column
+|project=TechCom-RFC (TechCom-RFC-Closed)
+|column=In progress
+}}{{Transition
+|date=1571264282
+|type=Exited Column
+|project=TechCom-RFC (TechCom-RFC-Closed)
+|column=Untriaged
+}}{{Transition
+|date=1566931404
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1566931404
+|type=Added Project
+|project=Platform Team Initiatives (Abstract Schema)
+}}{{Transition
+|date=1565688150
+|type=Removed Project
+|project=TechCom-RFC
+}}{{Transition
+|date=1565688150
+|type=Added Project
+|project=TechCom-RFC (TechCom-RFC-Closed)
+}}{{Transition
+|date=1564139203
+|type=Entered Column
+|project=TechCom-RFC
+|column=P5: Last Call
+}}{{Transition
+|date=1564139203
+|type=Exited Column
+|project=TechCom-RFC
+|column=P1: Define
+}}{{Transition
+|date=1563814408
+|type=Entered Column
+|project=MediaWiki-Installer
+|column=General
+}}{{Transition
+|date=1563814408
+|type=Exited Column
+|project=MediaWiki-Installer
+|column=Not my department!
+}}{{Transition
+|date=1563813783
+|type=Entered Column
+|project=MediaWiki-Installer
+|column=Not my department!
+}}{{Transition
+|date=1563813783
+|type=Exited Column
+|project=MediaWiki-Installer
+|column=General
+}}{{Transition
+|date=1563481586
+|type=Removed Project
+|project=Wikimedia-Rdbms
+}}{{Transition
+|date=1563481586
+|type=Added Project
+|project=MediaWiki-Installer
+}}{{Transition
+|date=1563373726
+|type=Entered Column
+|project=TechCom-RFC
+|column=P1: Define
+}}{{Transition
+|date=1563373726
+|type=Exited Column
+|project=TechCom-RFC
+|column=Request IRC meeting
+}}{{Transition
+|date=1562355234
+|type=Removed Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1560327648
+|type=Entered Column
+|project=TechCom-RFC
+|column=Request IRC meeting
+}}{{Transition
+|date=1560327648
+|type=Exited Column
+|project=TechCom-RFC
+|column=Under discussion
+}}{{Transition
+|date=1552565505
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1552443781
+|type=Entered Column
+|project=TechCom-RFC
+|column=Under discussion
+}}{{Transition
+|date=1552443781
+|type=Exited Column
+|project=TechCom-RFC
+|column=Request IRC meeting
+}}{{Transition
+|date=1551467542
+|type=Entered Column
+|project=TechCom-RFC
+|column=Request IRC meeting
+}}{{Transition
+|date=1551467542
+|type=Exited Column
+|project=TechCom-RFC
+|column=Under discussion
+}}{{Transition
+|date=1548062145
+|type=Added Project
+|project=User-Addshore
+}}{{Transition
+|date=1539807925
+|type=Entered Column
+|project=TechCom-RFC
+|column=Under discussion
+}}{{Transition
+|date=1539807925
+|type=Exited Column
+|project=TechCom-RFC
+|column=Old
+}}{{Transition
+|date=1538579879
+|type=Entered Column
+|project=Platform Team Legacy
+|column=Epic
+}}{{Transition
+|date=1538579879
+|type=Exited Column
+|project=Platform Team Legacy
+|column=Epic
+}}{{Transition
+|date=1538575970
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575970
+|type=Exited Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575539
+|type=Removed Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1538575539
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538575539
+|type=Added Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1538575539
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538486864
+|type=Removed Project
+|project=Platform Team Legacy (Later)
+}}{{Transition
+|date=1538486864
+|type=Added Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1538486864
+|type=Entered Column
+|project=Platform Team Legacy
+|column=Epics
+}}{{Transition
+|date=1538486864
+|type=Exited Column
+|project=Platform Team Legacy
+|column=Later
+}}{{Transition
+|date=1538448042
+|type=Entered Column
+|project=Platform Engineering
+|column=Triage Meeting Inbox
+}}{{Transition
+|date=1538448042
+|type=Exited Column
+|project=Platform Engineering
+|column=Inbox
+}}{{Transition
+|date=1538447380
+|type=Removed Project
+|project=Core Platform Team Goals (MCR: Uncategorized)
+}}{{Transition
+|date=1538447380
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538440079
+|type=Removed Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1538440079
+|type=Added Project
+|project=Core Platform Team Goals (MCR: Uncategorized)
+}}{{Transition
+|date=1538436726
+|type=Added Project
+|project=Platform Team Legacy (Later)
+}}{{Transition
+|date=1533156066
+|type=Entered Column
+|project=TechCom-RFC
+|column=Old
+}}{{Transition
+|date=1533156066
+|type=Exited Column
+|project=TechCom-RFC
+|column=P1: Define
+}}{{Transition
+|date=1532986700
+|type=Removed Project
+|project=Proposal
+}}{{Transition
+|date=1532986700
+|type=Added Project
+|project=TechCom-RFC
+}}{{Transition
+|date=1531356908
+|type=Entered Column
+|project=Core-Platform-Team-Old
+|column=Backlog
+}}{{Transition
+|date=1531356908
+|type=Exited Column
+|project=Core-Platform-Team-Old
+|column=Inbox
+}}{{Transition
+|date=1531356543
+|type=Removed Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1531356543
+|type=Added Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1525137903
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Backlog
+}}{{Transition
+|date=1525137903
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Backlog
+}}{{Transition
+|date=1523374938
+|type=Entered Column
+|project=Wikimedia-Rdbms
 |column=Schema changes
-}}{{Phabricator Project
+}}{{Transition
-|name=Epic
+|date=1523374938
+|type=Exited Column
+|project=Wikimedia-Rdbms
+|column=Untriaged
+}}{{Transition
+|date=1522693323
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Backlog
+}}{{Transition
+|date=1522693323
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Inbox
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=Epic
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=Proposal
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=Wikimedia-Rdbms
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=PostgreSQL
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=MSSQL
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=Oracle Database
+}}{{Transition
+|date=1522693291
+|type=Added Project
+|project=SQLite
 }}
 }}