Convert Unique Index to Primary Key on table cn_notice_countries
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_countries should be converted.

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

Mentioned In: T326227: Add primary key and drop unique index on cn_notice_countries 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 817881 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

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

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

Change 817881 merged by jenkins-bot:

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