Make filearchive.fa_id unsigned in mysql
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Dec 7 2021, 2:25 PM

Description

autoincrement table columns could be unsigned to allow storing more values before the value is overflowed

This may not needed if image tables are refactored - T28741

	Subject	Repo	Branch	Lines +/-
	schema: Make filearchive.fa_id unsigned	mediawiki/core	master	+497 -1

Mentioned In: T298294: Make primary key filearchive.fa_id unsigned on wmf wikis
Mentioned Here: T28741: Migrate file tables to a modern layout (image/oldimage; file/file_revision; add primary keys)

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 7 2021, 2:25 PM

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

[mediawiki/core@master] schema: Make filearchive.fa_id unsigned

Change 742799 merged by jenkins-bot:

[mediawiki/core@master] schema: Make filearchive.fa_id unsigned

Umherirrender claimed this task.

Umherirrender triaged this task as Medium priority.