Make ipblocks.ipb_id unsigned in mysql
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Dec 7 2021, 2:29 PM

Project Tags

Referenced Files

None

Subscribers

Description

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

This also affect ipblocks.ipb_parent_block_id and ipblocks_restrictions.ir_ipb_id, because the value is stored there

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	schema: Make ipblocks.ipb_id unsigned	mediawiki/core	master	+612 -7

Mentioned In: T306270: Make primary key ipblocks_restrictions.ir_ipb_id unsigned on wmf wikis
T306269: Make primary key ipblocks.ipb_id unsigned on wmf wikis

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

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

[mediawiki/core@master] schema: Make ipblocks.ipb_id unsigned

Change 742800 merged by jenkins-bot:

[mediawiki/core@master] schema: Make ipblocks.ipb_id unsigned

Umherirrender claimed this task.