TYPO3 Core

The field is in TCA defined as type=check, which implies the DB representation is a positive number.
This is not the case, data range is -2 to 2, representing different states for the extension.

With #101653 fields of TCA type 'check' must not be defined in ext_tables.sql anymore and become auto created as a smallint unsigned. This leads to errors for the users either while trying to migrate to the current DB schema of the core or later on while reviewing extensions in the extension manager, because the negative numbers will not be handled correctly. Also, updating extension list will fail due to incompatible DB field format.

To get rid of the problem, the TCA type will be redefined as a number, which reflects the reality of this field.