Page MenuHomePhabricator

CloseWikis table `closedwikis` lacks a primary key
Open, Needs TriagePublic

Description

Current table
CREATE TABLE /*$wgDBprefix*/closedwikis (
	cw_wiki varchar(255) NOT NULL,
	cw_reason mediumblob NOT NULL,
	cw_timestamp binary(14) NOT NULL,
	cw_by tinyblob NOT NULL
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX cw_wiki ON closedwikis (cw_wiki);

The unique index should be converted to a primary key.
There appear to be no direct references to the index itself: https://codesearch.wmflabs.org/search/?q=cw_wiki%5B%5Es%5D&i=nope&files=&repos=

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

Restricted Application added a project: User-DannyS712. · View Herald TranscriptJan 31 2020, 5:48 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
DannyS712 moved this task from Unsorted to Next on the User-DannyS712 board.Jan 31 2020, 5:53 AM
Reedy moved this task from Unsorted to Cleanup on the Schema-change board.Feb 23 2020, 3:06 PM

Change 600519 had a related patch set uploaded (by DannyS712; owner: DannyS712):
[mediawiki/extensions/CloseWikis@master] Convert closedwikis.cw_wiki from unique index to primary key

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