Review main Merged Breaking

80668[!!!][FEATURE] Finetune SQL autocreation of TCA fields type "datetime"

Garvin Hicking CR +2 V +2 Hard +258 −15 updated 11/20/23, 14:45

Commit message

This patch tries to address the issue of several core DB fields
being set to 'integer signed' (1901 to 2038), specifically:

* `be_users.lastlogin`
* `fe_users.lastlogin`
* `pages.lastUpdated`
* `pages.newUntil`
* `sys_redirect.lasthiton`
* `index_config.timer_next_indexing`
* `tx_extensionmanager_domain_model_extension.last_updated`
* `sys_workspace.publish_time`

These fields currently have a cut-off for 2038. Those are now
changed to 'bigint unsigned' and can survive until 2106.

Additionally, these fields:

* `sys_file_metadata.content_creation_date`
* `tt_content.date`

did not allow any dates before 1901, however certain systems might
want to use FAL metadata of i.e. 1799 (historical paintings),
or content elements of historic sites.

Review

  • Code review CR +2

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V +2

    Imported before Forger kept the single votes, the next import adds them.

Issues 2

Files 17