Nothing Special   »   [go: up one dir, main page]
Page MenuHomePhabricator
Create Task
Maniphest T230428

Migrate tables.sql to abstract schema
Closed, ResolvedPublic
Actions

Description

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

Status: 57 out of 57 are done (100%):

Details

Other Assignee
Ammarpad
SubjectRepoBranchLines +/-
Migrate searchindex to abstract schemamediawiki/coremaster+104 -65
Migrate revision table to abstract schemamediawiki/coremaster+223 -81
Make page_is_redirect and page_is_new unsignedmediawiki/coreREL1_36+6 -6
Make page_is_redirect and page_is_new unsignedmediawiki/coremaster+6 -6
Migrate user table to abstract schemamediawiki/coremaster+280 -141
Prepare for migrating `user` to abstract schemamediawiki/coremaster+252 -4
Postgres: Fix revision table indexes drifts with MySQLmediawiki/coremaster+7 -3
Migrate page to abstract schemamediawiki/coremaster+247 -106
postgres: Fix drifts of indexes in user table compared to mysqlmediawiki/coremaster+6 -1
Migrate archive table to abstract schemamediawiki/coremaster+282 -86
Migrate recentchanges table to abstract schemamediawiki/coremaster+510 -140
Add schema change for img_timestamp varbinary(14) to binary(14)mediawiki/coremaster+3 -0
Fix drifts in columns of recentchanges in PGmediawiki/coremaster+22 -9
Standardize archive indexesmediawiki/coremaster+16 -6
Migrate image table to abstract schemamediawiki/coremaster+335 -81
Migrate ipblocks to abstract schemamediawiki/coremaster+393 -119
Migrate objectcache to abstract schemamediawiki/coremaster+80 -20
Fix Postgres index drifts on recentchanges tablemediawiki/coremaster+5 -1
Migrate oldimage to abstract schemamediawiki/coremaster+308 -60
Migrate text table to abstract schemamediawiki/coremaster+85 -75
Add missing PG indexes of ipblocksmediawiki/coremaster+4 -0
Use TIMESTAMPTZ consistenly in Postgres SQL schemamediawiki/coremaster+8 -1
Migrate filearchive to abstract schemamediawiki/coremaster+417 -95
Migrate uploadstash to abstract schemamediawiki/coremaster+299 -84
Migrate logging to abstract schemamediawiki/coremaster+266 -83
Migrate categorylinks to abstract schemamediawiki/coremaster+189 -74
DBAL ENUM datatype: Complete Postgres supportmediawiki/coremaster+73 -2
Migrate slot_roles and content_models to abstract schemamediawiki/coremaster+142 -41
Add patch to set wl_notificationtimestamp BINARY(14)mediawiki/coremaster+3 -0
Migrate job to abstract schemamediawiki/coremaster+192 -66
Fix un_user_ip index columnmediawiki/coremaster+4 -4
Migrate watchlist table to Abstract schemamediawiki/coremaster+124 -42
Migrate new_talk to abstract schemamediawiki/coremaster+66 -29
Migrate page_props to abstract schemamediawiki/coremaster+93 -30
Add custom ENUM datatype for doctrine DBALmediawiki/coremaster+54 -8
Migrate revision_actor_temp to abstract schemamediawiki/coremaster+114 -35
Migrate revision_comment_temp to abstract schemamediawiki/coremaster+55 -24
DoctrineSchemaBuilder: Allow specifying custom table optionsmediawiki/coremaster+8 -1
DoctrineSchemaBuilder: Pass all args to Schema index methodmediawiki/coremaster+1 -1
Migrate ip_changes to abstract schemamediawiki/coremaster+86 -35
Migrate externallinks to abstract schemamediawiki/coremaster+110 -61
DoctrineSchemaBuilder: Pass down extra options for Schema index creationmediawiki/coremaster+2 -2
Migrate protected_titles to abstract schemamediawiki/coremaster+138 -29
Migrate interwiki table to abstract schemamediawiki/coremaster+79 -42
Migrate sites table to abstract schemamediawiki/coremaster+179 -76
Migrate querycache_info to abstract schemamediawiki/coremaster+49 -16
Migrate user_groups to abstract schemamediawiki/coremaster+74 -39
Migrate page_restrictions to abstract schemamediawiki/coremaster+159 -39
Migrate querycachetwo table to abstract schemamediawiki/coremaster+131 -34
Migrate querycache to abstract schemamediawiki/coremaster+80 -27
Migrate ipblocks_restrictions to abstract schemamediawiki/coremaster+63 -29
Migrate change_tag_def table to abstract schemamediawiki/coremaster+79 -29
Migrate watchlist_expiry to abstract schemamediawiki/coremaster+53 -17
Introduce TinyInt db datatype for doctrine DBALmediawiki/coremaster+35 -0
Migrate category to abstract schemamediawiki/coremaster+105 -41
Migrate iwlinks to abstract schemamediawiki/coremaster+101 -29
Migrate langlinks to abstract schemamediawiki/coremaster+90 -26
Migrate imagelinks table to abstract schemamediawiki/coremaster+106 -33
Migrate templatelinks table to abstract schemamediawiki/coremaster+120 -36
Migrate pagelinks table to abstract schemamediawiki/coremaster+112 -43
Migrate redirect table to abstract schemamediawiki/coremaster+91 -31
Migrate l10n_cache and module_deps to abstract schemamediawiki/coremaster+100 -38
Migrate user_properties to abstract schemamediawiki/coremaster+57 -33
Make ct_rc_id unsignedmediawiki/coreREL1_35+3 -1
Make ct_rc_id unsignedmediawiki/coremaster+2 -0
Migrate change_tag to abstract schemamediawiki/coremaster+99 -42
Migrate content table to abstract schemamediawiki/coremaster+77 -36
Migrate log_search table to abstract schemamediawiki/coremaster+52 -22
Migrate site_stats table to abstract schemamediawiki/coremaster+87 -40
Migrate slots table to abstract schemamediawiki/coremaster+75 -42
Migrate comment table to abstract schemamediawiki/coremaster+60 -49
Migrate bot_passwords table to abstract schemamediawiki/coremaster+73 -36
Migrate actor and user_former_groups tables to abstract schemamediawiki/coremaster+122 -58
Migrate site_identifiers to abstract schemamediawiki/coremaster+56 -27
Make schema builder remove table prefixes from Postgresmediawiki/coremaster+6 -0
Migrate updatelog to abstract schemamediawiki/coremaster+37 -13
Small improvements to DoctrineSchemaBuilder and generateSchemaSqlmediawiki/coremaster+20 -6
Wire empty abstract schema into installermediawiki/coremaster+61 -10
More work on formatting generated sqlmediawiki/coremaster+18 -0
Improve tests in DoctrineSchemaBuildermediawiki/coremaster+45 -40
Show related patches Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Ladsgroup added a comment.Dec 13 2020, 2:11 PM

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

gerritbot added a comment.Dec 13 2020, 5:48 PM

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

Ladsgroup updated the task description. (Show Details)Dec 13 2020, 6:09 PM
Ladsgroup updated the task description. (Show Details)Dec 13 2020, 7:23 PM
Ladsgroup mentioned this in T270053: Increase size of content_models.model_id.Dec 13 2020, 7:27 PM
Ladsgroup mentioned this in T270054: Increase size of slot_roles.role_id.
Ladsgroup mentioned this in T270055: Schema change for timestamp field of uploadstash.Dec 13 2020, 7:30 PM
gerritbot added a comment.Dec 13 2020, 7:37 PM

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

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

gerritbot added a comment.Dec 20 2020, 10:22 PM

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

Ladsgroup updated the task description. (Show Details)Dec 23 2020, 3:19 AM
Jdforrester-WMF updated the task description. (Show Details)Dec 23 2020, 3:37 AM
gerritbot added a comment.Dec 23 2020, 4:04 AM

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

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

gerritbot added a comment.Dec 23 2020, 4:06 AM

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

Ladsgroup updated the task description. (Show Details)Dec 23 2020, 4:07 AM
gerritbot added a comment.Jan 3 2021, 1:11 AM

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

gerritbot added a comment.Jan 3 2021, 12:42 PM

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

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

ReleaseTaggerBot edited projects, added MW-1.36-notes (1.36.0-wmf.25; 2021-01-05); removed MW-1.36-notes (1.36.0-wmf.21; 2020-12-08).Jan 3 2021, 1:01 PM
gerritbot added a comment.Jan 9 2021, 2:03 PM

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

gerritbot added a comment.Jan 9 2021, 7:01 PM

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

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

gerritbot added a comment.Jan 9 2021, 7:06 PM

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

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

Jdforrester-WMF updated the task description. (Show Details)Jan 9 2021, 7:08 PM
gerritbot added a comment.Jan 16 2021, 7:51 PM

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

gerritbot added a comment.Jan 16 2021, 10:00 PM

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

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

Ladsgroup updated the task description. (Show Details)Jan 16 2021, 10:02 PM
gerritbot added a comment.Jan 16 2021, 10:25 PM

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

gerritbot added a comment.Jan 19 2021, 5:19 PM

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

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

Ladsgroup updated the task description. (Show Details)Jan 20 2021, 4:51 PM
Ladsgroup mentioned this in T272511: Drop default of oldimage.oi_timestamp.Jan 20 2021, 5:08 PM
gerritbot added a comment.Jan 20 2021, 5:09 PM

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

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

Ladsgroup mentioned this in T272512: Apply outstanding schema changes for "objectcache" tables in production (exptime, flags, modtoken).Jan 20 2021, 5:15 PM
gerritbot added a comment.Jan 23 2021, 5:06 AM

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

Ladsgroup updated the task description. (Show Details)Jan 23 2021, 5:12 AM
gerritbot added a comment.Jan 23 2021, 9:03 AM

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

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

gerritbot added a comment.Jan 23 2021, 7:14 PM

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

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

Ladsgroup updated the task description. (Show Details)Jan 24 2021, 12:50 AM
Ladsgroup updated the task description. (Show Details)
gerritbot added a comment.Jan 28 2021, 7:18 PM

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

Ladsgroup updated the task description. (Show Details)Jan 28 2021, 8:09 PM
gerritbot added a comment.Jan 28 2021, 9:23 PM

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

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

gerritbot added a comment.Jan 28 2021, 9:23 PM

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

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

Ladsgroup mentioned this in T273358: Schema change for dropping defaults of ipb_timestamp and ipb_expiry.Jan 30 2021, 12:31 PM
Ladsgroup mentioned this in T273359: Schema change for renaming name_title_timestamp on archive table.Jan 30 2021, 12:38 PM
Ladsgroup mentioned this in T273360: Schema change for dropping default of img_timestamp and making it binary(14).Jan 30 2021, 12:47 PM
Ladsgroup mentioned this in T273361: Schema change for renaming two indexes of site_identifiers.Jan 30 2021, 12:51 PM
gerritbot added a comment.Feb 6 2021, 12:22 AM

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

gerritbot added a comment.Feb 6 2021, 3:20 PM

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

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

gerritbot added a comment.Feb 26 2021, 12:54 PM

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

gerritbot added a comment.Feb 27 2021, 5:49 PM

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

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

Jdforrester-WMF updated the task description. (Show Details)Feb 27 2021, 5:55 PM
Jdforrester-WMF updated the task description. (Show Details)
Ladsgroup mentioned this in T276156: Drop default of rc_timestamp.Mar 1 2021, 7:53 PM
gerritbot added a comment.Mar 4 2021, 8:21 PM

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

gerritbot added a comment.Mar 4 2021, 9:16 PM

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

ReleaseTaggerBot edited projects, added MW-1.36-notes (1.36.0-wmf.34; 2021-03-09); removed MW-1.36-notes (1.36.0-wmf.25; 2021-01-05).Mar 4 2021, 10:00 PM
DannyS712 mentioned this in T276734: ORES tests failing: Field 'rc_timestamp' doesn't have a default value.Mar 7 2021, 11:50 PM
Ladsgroup mentioned this in T277116: fa_deleted_timestamp and fa_timestamp are binary(14) in code but varbinary(14) in production.Mar 10 2021, 11:49 PM
gerritbot added a comment.Mar 13 2021, 7:53 PM

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

Ladsgroup updated the task description. (Show Details)Mar 14 2021, 3:00 AM
gerritbot added a comment.Mar 14 2021, 5:53 AM

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

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

Jdforrester-WMF updated the task description. (Show Details)Mar 14 2021, 4:47 PM
Jdforrester-WMF updated the task description. (Show Details)
gerritbot added a comment.Mar 19 2021, 2:57 PM

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

gerritbot added a comment.Mar 19 2021, 7:42 PM

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

Ladsgroup updated the task description. (Show Details)Mar 21 2021, 11:49 AM
gerritbot added a comment.Mar 21 2021, 12:15 PM

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

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

gerritbot added a comment.Mar 21 2021, 6:25 PM

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

gerritbot added a comment.Mar 22 2021, 5:25 AM

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

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

gerritbot added a comment.Mar 22 2021, 8:24 PM

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

gerritbot added a comment.Mar 27 2021, 10:22 AM

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

gerritbot added a comment.Mar 28 2021, 10:31 AM

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

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

gerritbot added a comment.Apr 4 2021, 7:34 PM

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

Ammarpad updated the task description. (Show Details)Apr 4 2021, 7:35 PM
Ladsgroup updated the task description. (Show Details)Apr 25 2021, 9:51 AM
gerritbot added a comment.Apr 25 2021, 10:15 AM

Change 675332 merged by jenkins-bot:

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

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

ReleaseTaggerBot added a project: MW-1.37-notes (1.37.0-wmf.3; 2021-04-27).Apr 25 2021, 11:00 AM
Ladsgroup mentioned this in T282371: Schema change for dropping default of ar_timestamp.May 9 2021, 11:49 AM
Ladsgroup mentioned this in T282372: Schema change for dropping default of page_touched.
Ladsgroup mentioned this in T282373: Schema change for dropping default of user_touched.May 9 2021, 11:52 AM
gerritbot added a comment.May 12 2021, 8:49 AM

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

gerritbot added a comment.May 13 2021, 1:23 AM

Change 689695 merged by jenkins-bot:

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

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

ReleaseTaggerBot edited projects, added MW-1.37-notes (1.37.0-wmf.6; 2021-05-18); removed MW-1.37-notes (1.37.0-wmf.3; 2021-04-27).May 13 2021, 2:00 AM
gerritbot added a comment.May 13 2021, 2:06 AM

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

gerritbot added a comment.May 13 2021, 2:18 AM

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

ReleaseTaggerBot edited projects, added MW-1.36-notes; removed MW-1.36-notes (1.36.0-wmf.34; 2021-03-09).May 13 2021, 3:00 AM
Umherirrender mentioned this in T174471: Add new PKs to Postgres tables.May 16 2021, 8:39 PM
gerritbot added a comment.May 22 2021, 11:56 PM

Change 674139 merged by jenkins-bot:

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

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

Ladsgroup updated the task description. (Show Details)May 23 2021, 12:05 AM
Ladsgroup updated the task description. (Show Details)May 23 2021, 12:12 AM
Ladsgroup mentioned this in T283499: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp.May 24 2021, 12:36 PM
gerritbot added a comment.May 27 2021, 1:02 PM

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

[mediawiki/core@master] Migrate searchindex to abstract schema

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

gerritbot added a comment.May 27 2021, 6:08 PM

Change 696411 merged by jenkins-bot:

[mediawiki/core@master] Migrate searchindex to abstract schema

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

Ladsgroup closed this task as Resolved.May 27 2021, 6:19 PM
Ladsgroup removed Ladsgroup as the assignee of this task.
Ladsgroup updated the task description. (Show Details)

This is done. It was sorta half half between me and Ammarpad. \o/

Jdforrester-WMF updated Other Assignee, added: Ammarpad.May 27 2021, 7:37 PM
Jdforrester-WMF updated the task description. (Show Details)
Jdforrester-WMF subscribed.

Congratulations, both. Brilliant work.

Jdforrester-WMF mentioned this in T230430: Migrate most recent schema changes to use the abstract system.May 27 2021, 7:38 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits