[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

WMDE-leszek added a comment. In T205094#6526147 , @Ladsgroup wrote: > > I don't know if I understood you correctly but the abstract schema is going to help with finding drifts between production and dev code (T104459:

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup added a comment. In T205094#6525519 , @WMDE-leszek wrote: > This seems to be finished. There is still a bunch questions I would have that this task does not seem to be explaining, e.g. how this "abstract schema" approach is

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

WMDE-leszek updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, WMDE-leszek Cc: WMDE-leszek, Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Lucas_Werkmeister_WMDE added a comment. We use abstract schemas for the initial table definitions, but not (as far as I’m aware) for generating schema changes… Amir, did you have any plans for that? TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

WMDE-leszek closed this task as "Resolved". WMDE-leszek moved this task from Test (Verification) to Done on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. WMDE-leszek added a comment. This seems to be finished. There is still a bunch questions I would have that this task does

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Michael removed a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Michael Cc: WMDE-leszek, Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup moved this task from Peer Review to Test (Verification) on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment. The only thing left is wb_terms and I assume this will be handled on the wb_terms clean up hike. TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628471 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Rename changes_dispatch to wb_changes_dispatch https://gerrit.wikimedia.org/r/628471 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628470 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_changes_dispatch to abstract schema https://gerrit.wikimedia.org/r/628470 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

ReleaseTaggerBot edited projects, added MW-1.36-notes (1.36.0-wmf.11; 2020-09-29); removed MW-1.36-notes (1.36.0-wmf.10; 2020-09-22). TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628469 **merged** by jenkins-bot: [mediawiki/core@master] Improve TinyIntType https://gerrit.wikimedia.org/r/628469 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628471 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Rename changes_dispatch to wb_changes_dispatch https://gerrit.wikimedia.org/r/628471 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628470 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_changes_dispatch to abstract schema https://gerrit.wikimedia.org/r/628470 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 628469 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/core@master] Improve TinyIntType https://gerrit.wikimedia.org/r/628469 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup moved this task from Stalled/Waiting to Doing on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment. In T205094#6466818 , @Michael wrote: > Added (default?) 2 week due date to see if

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Michael added a comment. Added (default?) 2 week due date to see if https://gerrit.wikimedia.org/r/c/mediawiki/core/+/626854 is merged, then we can proceed as described above (T205094#6460185 ). TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Michael set Due Date to Wed, Sep 30, 12:00 AM. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Michael Cc: WMDE-leszek, Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup moved this task from Peer Review to Stalled/Waiting on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment. Now waiting on the core patch getting merged so we can pick up wb_changes_dispatch and dropping wb_terms. TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627836 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Rename changes_* schema files https://gerrit.wikimedia.org/r/627836 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627836 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Rename changes_* schema files https://gerrit.wikimedia.org/r/627836 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627347 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_changes table to abstract schema https://gerrit.wikimedia.org/r/627347 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627285 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_changes_subscription to abstract schema https://gerrit.wikimedia.org/r/627285 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627281 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_items_per_site to abstract schema https://gerrit.wikimedia.org/r/627281 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

ReleaseTaggerBot edited projects, added MW-1.36-notes (1.36.0-wmf.10; 2020-09-22); removed MW-1.36-notes (1.36.0-wmf.9; 2020-09-15). TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627277 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_id_counters to abstract schema https://gerrit.wikimedia.org/r/627277 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup moved this task from Doing to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment. This is mostly done, All tables are migrated except two: - wb_terms, it has some complexities (float data type) that is not yet doable in

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627347 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_changes table to abstract schema https://gerrit.wikimedia.org/r/627347 TASK DETAIL https://phabricator.wikimedia.org/T205094

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627285 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_changes_subscription to abstract schema https://gerrit.wikimedia.org/r/627285 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627281 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_items_per_site to abstract schema https://gerrit.wikimedia.org/r/627281 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 627277 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_id_counters to abstract schema https://gerrit.wikimedia.org/r/627277 TASK DETAIL https://phabricator.wikimedia.org/T205094

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

ReleaseTaggerBot edited projects, added MW-1.36-notes (1.36.0-wmf.9; 2020-09-15); removed MW-1.36-notes (1.36.0-wmf.6; 2020-08-25). TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 622659 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Move changes_* files out of sql archives https://gerrit.wikimedia.org/r/622659 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup merged a task: T259411: Migrate Wikibase to the abstract schema. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: WMDE-leszek, Lucas_Werkmeister_WMDE, Izno, Michael,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup moved this task from To Do to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup claimed this task. Ladsgroup added a comment. This patch needs review ^ :D TASK DETAIL https://phabricator.wikimedia.org/T205094 WORKBOARD

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 622659 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Move changes_* files out of sql archives https://gerrit.wikimedia.org/r/622659 TASK DETAIL https://phabricator.wikimedia.org/T205094

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore removed Ladsgroup as the assignee of this task. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Addshore Cc: Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Addshore Cc: Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Addshore Cc: Lucas_Werkmeister_WMDE, Izno, Michael, Ladsgroup, daniel, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Lucas_Werkmeister_WMDE moved this task from Peer Review to To Do on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Lucas_Werkmeister_WMDE added a comment. Goes back to TODO, I guess, for futher schema migrations. TASK DETAIL https://phabricator.wikimedia.org/T205094

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621921 **merged** by jenkins-bot: [mediawiki/extensions/WikimediaMaintenance@master] Fix createExtensionTables.php for moved sql files in Wikibase https://gerrit.wikimedia.org/r/621921 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621921 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/WikimediaMaintenance@master] Fix createExtensionTables.php for moved sql files in Wikibase https://gerrit.wikimedia.org/r/621921 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621911 **merged** by jenkins-bot: [mediawiki/extensions/WikimediaMaintenance@master] Fix addWiki.php for moved sql files in Wikibase https://gerrit.wikimedia.org/r/621911 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621911 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/WikimediaMaintenance@master] Fix addWiki.php for moved sql files in Wikibase https://gerrit.wikimedia.org/r/621911 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621717 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Rename AddNormalizedTermsTablesDDL to term_store https://gerrit.wikimedia.org/r/621717 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621717 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Rename AddNormalizedTermsTablesDDL to term_store https://gerrit.wikimedia.org/r/621717 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621559 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate the new term store to abstract schema https://gerrit.wikimedia.org/r/621559 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621554 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate wb_property_info to abstract schema https://gerrit.wikimedia.org/r/621554 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621559 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate the new term store to abstract schema https://gerrit.wikimedia.org/r/621559 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621554 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate wb_property_info to abstract schema https://gerrit.wikimedia.org/r/621554 TASK DETAIL https://phabricator.wikimedia.org/T205094

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621037 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Migrate entity_usage table in client to abstract schema https://gerrit.wikimedia.org/r/621037 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

ReleaseTaggerBot added a project: MW-1.36-notes (1.36.0-wmf.6; 2020-08-25). TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, ReleaseTaggerBot Cc: Lucas_Werkmeister_WMDE, Izno, Michael,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 621037 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Migrate entity_usage table in client to abstract schema https://gerrit.wikimedia.org/r/621037 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup added a comment. Yeah, it's not done now, I'm fine either way, I can start with client which is simpler TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc:

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Lucas_Werkmeister_WMDE moved this task from Peer Review to Test (Verification) on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Lucas_Werkmeister_WMDE added a comment. @Ladsgroup As far as I understand, the “use new MediaWiki abstract schema change features” part of this is

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619850 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Reorganize repo schema scripts https://gerrit.wikimedia.org/r/619850 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619720 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Remove duplicate code in SqlUsageTrackerSchemaUpdater https://gerrit.wikimedia.org/r/619720 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619555 **merged** by jenkins-bot: [mediawiki/extensions/Wikibase@master] Reorganize client schema scripts https://gerrit.wikimedia.org/r/619555 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619850 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Reorganize repo schema scripts https://gerrit.wikimedia.org/r/619850 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619720 had a related patch set uploaded (by Lucas Werkmeister (WMDE); owner: Lucas Werkmeister (WMDE)): [mediawiki/extensions/Wikibase@master] Remove duplicate code in SqlUsageTrackerSchemaUpdater https://gerrit.wikimedia.org/r/619720 TASK DETAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a comment. Change 619555 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup): [mediawiki/extensions/Wikibase@master] Reorganize client schema scripts https://gerrit.wikimedia.org/r/619555 TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

gerritbot added a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, gerritbot Cc: Izno, Michael, Ladsgroup, daniel, Addshore, Aklapper, Matthias_Geisler_WMDE,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup claimed this task. Ladsgroup moved this task from To Do to Doing on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Restricted Application added a project: User-Ladsgroup. TASK DETAIL https://phabricator.wikimedia.org/T205094 WORKBOARD

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

darthmon_wmde raised the priority of this task from "Medium" to "Needs Triage". TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: darthmon_wmde Cc: Izno, Michael, Ladsgroup, daniel, Addshore,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup added a comment. In T205094#6364135 , @Izno wrote: > In T205094#6359681 , @Ladsgroup wrote: > >> Mediawiki core actually supports upgrading from basically any version. A

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup added a comment. Found it: T230317: Error: 1146 Table 'valid_tag' doesn't exist when upgrading from an ancient MediaWiki version TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Izno added a comment. In T205094#6359681 , @Ladsgroup wrote: > Mediawiki core actually supports upgrading from basically any version. A couple of months ago I got a ticket that I broke upgrading from 1.10 (and people are really

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Ladsgroup added a comment. In T205094#6359584 , @Michael wrote: > - Consider naming schema > - consider sorting files into subdirectories by years or tables or MediaWiki versions One important lack of distinction in wikibase sql

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Michael moved this task from To Do to Stalled/Waiting on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Michael added a comment. We still need to confirm whether abstract schema _changes_ is actually already available. The docs indicate that it is not done yet, but they might

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Michael added a comment. - Consider naming schema - consider sorting files into subdirectories by years or tables or MediaWiki versions - investigate which parts of DatabaseSchemaUpdater can maybe be deleted because they are very old - we probably can mark everything for deletion older

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore moved this task from Prioritized Tech to Wikidata-Campsite-Iteration-∞ on the Wikidata-Campsite board. Addshore edited projects, added Wikidata-Campsite (Wikidata-Campsite-Iteration-∞); removed Wikidata-Campsite. TASK DETAIL https://phabricator.wikimedia.org/T205094 WORKBOARD

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Ladsgroup, daniel, Addshore, Aklapper, Matthias_Geisler_WMDE, Jonas, Akuckartz, darthmon_wmde,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore raised the priority of this task from "Low" to "Medium". TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Ladsgroup, daniel, Addshore, Aklapper, Matthias_Geisler_WMDE, Jonas,

[Wikidata-bugs] [Maniphest] T205094: Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features

Addshore renamed this task from "Investigate and restructure SQL directory using new MediaWiki abstract schema change features" to "Investigate and restructure SQL directory, and use new MediaWiki abstract schema change features". TASK DETAIL https://phabricator.wikimedia.org/T205094 EMAIL