Standardise type for change_time column in Wikibase repo
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Jun 12 2022, 9:23 PM

Description

According to T42626 the timestamp should be adjust from varbinary(14) to binary(14) because there is no need to hold infinite.

This should be reached by changing the abstract schema type for this column to mwtimestamp

	Subject	Repo	Branch	Lines +/-
	schema: Use mwtimestamp type for change_time column	mediawiki/extensions/Wikibase	master	+148 -16

Mentioned In: T313070: Adjust the field type of wb_changes.change_time to fixed binary on wmf wikis
Mentioned Here: T42626: Standardise type of timestamp database fields (MySQL)

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

[mediawiki/extensions/Wikibase@master] schema: Use mwtimestamp type for change_time column

Umherirrender triaged this task as Low priority.Jun 12 2022, 9:25 PM

Change 804781 merged by jenkins-bot:

[mediawiki/extensions/Wikibase@master] schema: Use mwtimestamp type for change_time column