Page MenuHomePhabricator

Migrate tables.sql to abstract schema
Open, Needs TriagePublic

Description

This needs to be done gradually, a hybrid situation would be great.

Status: 55 out of 57 are done (96%):

Details

ProjectBranchLines +/-Subject
mediawiki/coreREL1_36+6 -6
mediawiki/coremaster+6 -6
mediawiki/coremaster+226 -81
mediawiki/coremaster+280 -141
mediawiki/coremaster+252 -4
mediawiki/coremaster+7 -3
mediawiki/coremaster+247 -106
mediawiki/coremaster+6 -1
mediawiki/coremaster+282 -86
mediawiki/coremaster+510 -140
mediawiki/coremaster+3 -0
mediawiki/coremaster+22 -9
mediawiki/coremaster+16 -6
mediawiki/coremaster+335 -81
mediawiki/coremaster+393 -119
mediawiki/coremaster+80 -20
mediawiki/coremaster+5 -1
mediawiki/coremaster+308 -60
mediawiki/coremaster+85 -75
mediawiki/coremaster+4 -0
mediawiki/coremaster+8 -1
mediawiki/coremaster+417 -95
mediawiki/coremaster+299 -84
mediawiki/coremaster+266 -83
mediawiki/coremaster+189 -74
mediawiki/coremaster+73 -2
mediawiki/coremaster+142 -41
mediawiki/coremaster+3 -0
mediawiki/coremaster+192 -66
mediawiki/coremaster+4 -4
mediawiki/coremaster+124 -42
mediawiki/coremaster+66 -29
mediawiki/coremaster+93 -30
mediawiki/coremaster+54 -8
mediawiki/coremaster+114 -35
mediawiki/coremaster+55 -24
mediawiki/coremaster+8 -1
mediawiki/coremaster+1 -1
mediawiki/coremaster+86 -35
mediawiki/coremaster+110 -61
mediawiki/coremaster+2 -2
mediawiki/coremaster+138 -29
mediawiki/coremaster+79 -42
mediawiki/coremaster+179 -76
mediawiki/coremaster+49 -16
mediawiki/coremaster+74 -39
mediawiki/coremaster+159 -39
mediawiki/coremaster+131 -34
mediawiki/coremaster+80 -27
mediawiki/coremaster+63 -29
mediawiki/coremaster+79 -29
mediawiki/coremaster+53 -17
mediawiki/coremaster+35 -0
mediawiki/coremaster+105 -41
mediawiki/coremaster+101 -29
mediawiki/coremaster+90 -26
mediawiki/coremaster+106 -33
mediawiki/coremaster+120 -36
mediawiki/coremaster+112 -43
mediawiki/coremaster+91 -31
mediawiki/coremaster+100 -38
mediawiki/coremaster+57 -33
mediawiki/coreREL1_35+3 -1
mediawiki/coremaster+2 -0
mediawiki/coremaster+99 -42
mediawiki/coremaster+77 -36
mediawiki/coremaster+52 -22
mediawiki/coremaster+87 -40
mediawiki/coremaster+75 -42
mediawiki/coremaster+60 -49
mediawiki/coremaster+73 -36
mediawiki/coremaster+122 -58
mediawiki/coremaster+56 -27
mediawiki/coremaster+6 -0
mediawiki/coremaster+37 -13
mediawiki/coremaster+20 -6
mediawiki/coremaster+61 -10
mediawiki/coremaster+18 -0
mediawiki/coremaster+45 -40
Show related patches Customize query in gerrit

Related Objects

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Change 619155 merged by jenkins-bot:
[mediawiki/core@master] Migrate slot_roles and content_models to abstract schema

https://gerrit.wikimedia.org/r/619155

Change 643435 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] Migrate page to abstract schema

https://gerrit.wikimedia.org/r/643435

Change 644004 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate categorylinks to abstract schema

https://gerrit.wikimedia.org/r/644004

Change 644171 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] DBAL ENUM datatype: Complete Postgres support

https://gerrit.wikimedia.org/r/644171

Change 644171 merged by jenkins-bot:
[mediawiki/core@master] DBAL ENUM datatype: Complete Postgres support

https://gerrit.wikimedia.org/r/644171

Change 644004 merged by jenkins-bot:
[mediawiki/core@master] Migrate categorylinks to abstract schema

https://gerrit.wikimedia.org/r/644004

Change 646197 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] Migrate logging to abstract schema

https://gerrit.wikimedia.org/r/646197

Change 646197 merged by jenkins-bot:
[mediawiki/core@master] Migrate logging to abstract schema

https://gerrit.wikimedia.org/r/646197

I noticed that the type of cl_timestamp in categorylinks was changed.
mw:Manual:Categorylinks_table#Schema_summary

Does it need an alter table?

Yes, It's on my radar T269463: Drop cl_timestamp. I'm trying to find a solution for it.

Change 649102 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate uploadstash to abstract schema

https://gerrit.wikimedia.org/r/649102

Change 649102 merged by jenkins-bot:
[mediawiki/core@master] Migrate uploadstash to abstract schema

https://gerrit.wikimedia.org/r/649102

Change 651001 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] [WIP] Migrate filearchive to abstract schema

https://gerrit.wikimedia.org/r/651001

Change 651001 merged by jenkins-bot:
[mediawiki/core@master] Migrate filearchive to abstract schema

https://gerrit.wikimedia.org/r/651001

Change 651680 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate text table to abstract schema

https://gerrit.wikimedia.org/r/651680

Change 653625 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] Use TIMESTAMPTZ consistenly in Postgres SQL schema

https://gerrit.wikimedia.org/r/653625

Change 653625 merged by jenkins-bot:
[mediawiki/core@master] Use TIMESTAMPTZ consistenly in Postgres SQL schema

https://gerrit.wikimedia.org/r/653625

Change 655198 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Add missing PG indexes of ipblocks

https://gerrit.wikimedia.org/r/655198

Change 655198 merged by jenkins-bot:
[mediawiki/core@master] Add missing PG indexes of ipblocks

https://gerrit.wikimedia.org/r/655198

Change 651680 merged by jenkins-bot:
[mediawiki/core@master] Migrate text table to abstract schema

https://gerrit.wikimedia.org/r/651680

Change 656586 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate oldimage to abstract schema

https://gerrit.wikimedia.org/r/656586

Change 656586 merged by jenkins-bot:
[mediawiki/core@master] Migrate oldimage to abstract schema

https://gerrit.wikimedia.org/r/656586

Change 656587 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Fix Postgres index drifts on recentchanges table

https://gerrit.wikimedia.org/r/656587

Change 656587 merged by jenkins-bot:
[mediawiki/core@master] Fix Postgres index drifts on recentchanges table

https://gerrit.wikimedia.org/r/656587

Change 636049 merged by jenkins-bot:
[mediawiki/core@master] Migrate objectcache to abstract schema

https://gerrit.wikimedia.org/r/636049

Change 657949 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate ipblocks to abstract schema

https://gerrit.wikimedia.org/r/657949

Change 657957 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Standardize archive indexes

https://gerrit.wikimedia.org/r/657957

Change 657949 merged by jenkins-bot:
[mediawiki/core@master] Migrate ipblocks to abstract schema

https://gerrit.wikimedia.org/r/657949

Change 659385 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate image table to abstract schema

https://gerrit.wikimedia.org/r/659385

Change 657957 merged by jenkins-bot:
[mediawiki/core@master] Standardize archive indexes

https://gerrit.wikimedia.org/r/657957

Change 659385 merged by jenkins-bot:
[mediawiki/core@master] Migrate image table to abstract schema

https://gerrit.wikimedia.org/r/659385

Change 662027 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Fix drifts in columns of recentchanges in PG

https://gerrit.wikimedia.org/r/662027

Change 662027 merged by jenkins-bot:
[mediawiki/core@master] Fix drifts in columns of recentchanges in PG

https://gerrit.wikimedia.org/r/662027

Change 667158 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate recentchanges table to abstract schema

https://gerrit.wikimedia.org/r/667158

Change 667158 merged by jenkins-bot:
[mediawiki/core@master] Migrate recentchanges table to abstract schema

https://gerrit.wikimedia.org/r/667158

Change 668548 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Add schema change for img_timestamp varbinary(14) to binary(14)

https://gerrit.wikimedia.org/r/668548

Change 668548 merged by jenkins-bot:
[mediawiki/core@master] Add schema change for img_timestamp varbinary(14) to binary(14)

https://gerrit.wikimedia.org/r/668548

Change 671679 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Migrate archive table to abstract schema

https://gerrit.wikimedia.org/r/671679

Change 671679 merged by jenkins-bot:
[mediawiki/core@master] Migrate archive table to abstract schema

https://gerrit.wikimedia.org/r/671679

Change 673508 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Fix drifts of indexes in postgres and mysql in user table

https://gerrit.wikimedia.org/r/673508

Change 673508 merged by jenkins-bot:
[mediawiki/core@master] postgres: Fix drifts of indexes in user table compared to mysql

https://gerrit.wikimedia.org/r/673508

Change 643435 merged by jenkins-bot:
[mediawiki/core@master] Migrate page to abstract schema

https://gerrit.wikimedia.org/r/643435

Change 673784 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] Postgres: Fix revision table indexes drifts with MySQL

https://gerrit.wikimedia.org/r/673784

Change 673784 merged by jenkins-bot:
[mediawiki/core@master] Postgres: Fix revision table indexes drifts with MySQL

https://gerrit.wikimedia.org/r/673784

Change 674139 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] Migrate revision table to abstract schema

https://gerrit.wikimedia.org/r/674139

Change 675281 had a related patch set uploaded (by Ammarpad; author: Ammarpad):
[mediawiki/core@master] Prepare for migrating user to abstract schema

https://gerrit.wikimedia.org/r/675281

Change 675281 merged by jenkins-bot:
[mediawiki/core@master] Prepare for migrating user to abstract schema

https://gerrit.wikimedia.org/r/675281

Change 675332 had a related patch set uploaded (by Ammarpad; author: Ammarpad):

[mediawiki/core@master] WIP: Migrate user table to abstract schema

https://gerrit.wikimedia.org/r/675332

Change 675332 merged by jenkins-bot:

[mediawiki/core@master] Migrate user table to abstract schema

https://gerrit.wikimedia.org/r/675332

Change 689695 had a related patch set uploaded (by Ladsgroup; author: Ladsgroup):

[mediawiki/core@master] Make page_is_redirect unsigned

https://gerrit.wikimedia.org/r/689695

Change 689695 merged by jenkins-bot:

[mediawiki/core@master] Make page_is_redirect and page_is_new unsigned

https://gerrit.wikimedia.org/r/689695

Change 690067 had a related patch set uploaded (by Ladsgroup; author: Ladsgroup):

[mediawiki/core@REL1_36] Make page_is_redirect and page_is_new unsigned

https://gerrit.wikimedia.org/r/690067

Change 690067 merged by jenkins-bot:

[mediawiki/core@REL1_36] Make page_is_redirect and page_is_new unsigned

https://gerrit.wikimedia.org/r/690067