Convert Unique Index to Primary Key on table cn_notice_regions
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Jul 6 2022, 6:12 PM

Description

According to T172514 a primary key is prefered over unique index.

The table cn_notice_regions should be converted.

	Subject	Repo	Branch	Lines +/-
	schema: Convert Unique Index to Primary Key on cn_notice_regions	mediawiki/extensions/CentralNotice	master	+82 -15

Mentioned In: T326228: Add primary key and drop unique index on cn_notice_regions on wmf wikis
Mentioned Here: T172514: Add new PKs to tables.sql (mysql and sqlite)

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 6 2022, 6:12 PM

Change 817882 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/extensions/CentralNotice@master] schema: Convert Unique Index to Primary Key on cn_notice_regions

Umherirrender triaged this task as Lowest priority.Jul 28 2022, 8:00 PM

Change 817882 merged by jenkins-bot:

[mediawiki/extensions/CentralNotice@master] schema: Convert Unique Index to Primary Key on cn_notice_regions