Review main Merged

96023[TASK] Derive more table columns from TCA in ext_tables.sql

Benni Mack CR +2 V +2 Normal +56 −71 updated 09/24/26, 20:23

Commit message

DefaultTcaSchema has gained enough support for select defaults,
nullable inputs and text length handling that a number of manual
column definitions in ext_tables.sql are now redundant. They are
removed, and the remaining differences are expressed in TCA.

Removed from ext_tables.sql: frame_class, table_caption,
tx_extbase_type, sys_category.items, and the name, sha1, title,
alternative, type and processingfolder columns of the sys_file*
tables. EXT:extbase no longer ships an ext_tables.sql file.

TCA is adjusted where the generated column would otherwise
differ: "max" and "nullable" for title and alternative fields,
"default" for sys_file_collection.type and "dbFieldLength" for
tt_content.frame_class.

Several columns change from TINYTEXT to VARCHAR(255). TINYTEXT
is limited to 255 bytes, not characters, so multibyte characters
such as umlauts, CJK or emoji reduce the usable length below 255
characters. VARCHAR(255) holds 255 characters regardless of their
byte size, and is the better fit for short single-line values.

Empty values of the now nullable fields are stored as NULL.

Review

  • Code review CR +2 Done
    • Georg Ringer +2
    • Jochen Roth +1
    • Wouter Wolters +1
  • Verified V +2 Done
    • Georg Ringer +2
    • Jochen Roth +1
    • Wouter Wolters +1
    • core-ci +1 CI

Issues 1

Files 21

Show 1 more file

Review log 68

  1. Benni Mack uploaded patch set 1 09/23/26, 22:13

  2. core-ci voted on patch set 1 V -1 09/23/26, 22:28 Core CI is not happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/109117

  3. Benni Mack uploaded patch set 2 V -1 09/24/26, 00:03

  4. core-ci voted on patch set 2 V +1 09/24/26, 00:13 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/109121

  5. Jochen Roth voted on patch set 2 CR +1 V +1 09/24/26, 15:10

  6. Wouter Wolters commented on patch set 2 CR +1 V +1 09/24/26, 18:15

    Checked database changes and all succeed.
  7. Georg Ringer voted on patch set 2 CR +2 V +2 09/24/26, 20:23

  8. Georg Ringer merged patch set 3 09/24/26, 20:23