Page MenuHomePhabricator

Convert UNIQUE indexes to Primary Keys in MW Core Tables
Closed, ResolvedPublic

Description

Forked from https://discourse-mediawiki.wmflabs.org/t/database-structure-change-for-use-in-mysql-cluster/595 as a follow on from T17441 and T164399

Although these tables do have UNIQUE indexes, they don't have primary keys.

  • interwiki
  • page_props
  • protected_titles
  • site_identifiers

Details

Related Gerrit Patches:

Event Timeline

Reedy created this task.Jul 4 2018, 6:56 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 4 2018, 6:56 PM
Reedy updated the task description. (Show Details)Jul 4 2018, 7:03 PM

Change 443858 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/core@master] [WIP] Convert UNIQUE INDEX to PRIMARY KEY

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

Change 443858 merged by jenkins-bot:
[mediawiki/core@master] Convert numerous UNIQUE INDEX to PRIMARY KEY

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

Reedy closed this task as Resolved.Jul 11 2018, 7:58 PM
Reedy claimed this task.
Reedy removed a project: Patch-For-Review.