#101553Auto-create DB fields from TCA columns
Description
Goal is to further reduce / get rid of ext_tables.sql by creating DB fields from TCA columns.
type=checktype=colortype=datetimetype=emailtype=flextype=filetype=foldertype=grouptype=imageManipulationtype=inlinetype=inputtype=languagetype=linktype=none– no DB field!type=number- type=passthrough
type=passwordtype=radiotype=selecttype=text- type=user
Reviews 38
- main 96120[BUGFIX] Use TCA default for columns created from TCA
- main 84751[TASK] Use VARCHAR(255) over TINYTEXT
- 13.4 86870[BUGFIX] Add update wizard to prevent truncation error in DB upgrade
- main 86831[BUGFIX] Add update wizard to prevent truncation error in DB upgrade
- main 81016[FEATURE] Auto DB fields from TCA for type "imageManipulation"
- main 84630[TASK] Make slug fields TEXT by default
- main 84784[TASK] Add docs for database error "row size too large"
- main 84774[TASK] Have TEXT for type=input length > 255
- main 84772[TASK] Make pages.author VARCHAR(255)
- main 84748[TASK] Avoid long varchar() in pages table
- main 84714[TASK] Streamline DefaultTcaSchema
- main 83183[FEATURE] Auto create DB fields from TCA for type "input"
- main 84658[TASK] Make type=link fields TEXT by default
- main 82661[TASK] Reduce `ext_tables.sql` for `ext:redirects`
- main 82260[BUGFIX] Add missing TCA default values for select-mm fields
- main 81604[FEATURE] Auto create DB fields from TCA for type "select"
- main 80668[!!!][FEATURE] Finetune SQL autocreation of TCA fields type "datetime"
- main 81532[FEATURE] Auto create DB fields from TCA for type "number"
- main 81488[FEATURE] Auto create DB fields from TCA for type "inline"
- main 81427[FEATURE] Auto create DB fields from TCA for type "link"
- main 81426[FEATURE] Auto DB fields from TCA for type "radio"
- main 81366[FEATURE] Auto DB fields from TCA for type "color"
- main 81362[FEATURE] Auto DB fields from TCA for type "password"
- main 81127[FEATURE] Auto DB fields from TCA for type "text"
- main 81181[TASK] Allow to omit tables in ext_tables.sql
- main 81158[FEATURE] Auto DB fields from TCA for type "flex"
- main 80990[FEATURE] Auto DB fields from TCA for type "group"
- main 81017[FEATURE] Auto DB fields from TCA for type "language"
- main 80972[TASK] Remove superfluous test from DefaultTcaSchemaTest.php
- main 80938[FEATURE] Auto-create DB fields from TCA columns for type "folder"
- main 80513[FEATURE] Auto-create DB fields from TCA columns for type "check"
- main 80515[FEATURE] Auto-create DB fields from TCA for type "email"
- main 80752[TASK] Remove DataHandler->checkStoredRecord()
- main 80519[TASK] Clean up ext_tables.sql parser
- main 80510[TASK] Modernize ext:core ext_tables.sql DataType classes
- main 80498[TASK] Modernize ext:core ext_tables.sql AST classes
- main 80465[TASK] Allow table without columns in ext_tables.sql
- main 80374[FEATURE] Auto DB fields from TCA for type "file"
Related issues 39
- Bug #93534Insufficient database type for (several) title properties
- Feature #97367Auto creation of database fields for TCA "datetime"
- Bug #999372038-Bug in TYPO3?
- Task #101571Auto-create DB fields from TCA columns for type "file"
- Task #101623Allow table without columns in ext_tables.sql
- Task #101641Modernize FileHandlingUtility
- Task #101642Modernize ext:core ext_tables.sql AST classes
- Task #101651Modernize ext:core ext_tables.sql DataType classes
- Feature #101653Auto-create DB fields from TCA columns for type "check"
- Feature #101654Auto-create DB fields from TCA columns for type "email"
- Task #101660Clean up ext_tables.sql parser
- Task #101793Remove DataHandler->checkStoredRecord()
- Task #101890Auto-create DB fields from TCA columns for type "folder"
- Task #101898Remove superfluous test from DefaultTcaSchemaTest.php
- Feature #101908Auto-create DB fields from TCA columns for type "group"
- Feature #101914Auto-create DB fields from TCA columns for type "imageManipulation"
- Feature #101915Auto-create DB fields from TCA columns for type "language"
- Task #101985Deal with leftover sql definitions from type=group
- Feature #101986Auto-create DB fields from TCA columns for type "text"
- Task #101997Auto-create DB fields from TCA columns for type "flex"
- Task #102085Allow to omit tables in ext_tables.sql
- Task #102106Auto-create DB fields from TCA columns for type "password"
- Feature #102107Auto-create DB fields from TCA columns for type "color"
- Feature #102163Auto-create DB fields from TCA columns for type "radio"
- Feature #102168Auto-create DB fields from TCA columns for type "link"
- Feature #102210Auto-create DB fields from TCA columns for type "inline"
- Feature #102237Auto-create DB fields from TCA columns for type "number"
- Feature #102279Auto-create DB fields from TCA columns for type "select"
- Task #102944Reduce `ext_tables.sql` for `ext:redirects`
- Task #103028Refactoring DefaultTcaSchema to reduce redundant code
- Task #104063Make slug fields TEXT by default
- Task #104068Make type=link fields TEXT by default
- Task #104098Auto-create DB fields from TCA columns for type "input"
- Task #104110Streamline DefaultTcaSchema
- Task #104138Avoid long varchar() in pages table
- Task #104143Make pages.author VARCHAR(255)
- Task #104146TEXT for type=input length > 255
- Task #104153About "row size too large"
- Bug #110508Default TCA schema ignores "default"
History 62
Show 37 earlier messages
-
Oliver Wand changed Related to #101571 <span data-processor="relativetime" data-value="2023-08-03T21:16:19+00:00" > 08/03/23, 21:16 </span>
-
Christian Kuhn changed Related to #101623 <span data-processor="relativetime" data-value="2023-08-09T05:09:43+00:00" > 08/09/23, 05:09 </span>
-
Christian Kuhn changed Related to #101641 <span data-processor="relativetime" data-value="2023-08-09T21:39:44+00:00" > 08/09/23, 21:39 </span>
-
Christian Kuhn changed Related to #101642 <span data-processor="relativetime" data-value="2023-08-09T21:40:26+00:00" > 08/09/23, 21:40 </span>
-
Christian Kuhn changed Related to #101651 <span data-processor="relativetime" data-value="2023-08-10T14:49:11+00:00" > 08/10/23, 14:49 </span>
-
Oliver Wand changed Related to #101653 <span data-processor="relativetime" data-value="2023-08-10T17:00:47+00:00" > 08/10/23, 17:00 </span>
-
Oliver Wand changed Related to #101654 <span data-processor="relativetime" data-value="2023-08-10T19:21:31+00:00" > 08/10/23, 19:21 </span>
-
Christian Kuhn changed Related to #101660 <span data-processor="relativetime" data-value="2023-08-11T10:39:38+00:00" > 08/11/23, 10:39 </span>
-
Christian Kuhn changed Related to #101793 <span data-processor="relativetime" data-value="2023-08-30T01:27:04+00:00" > 08/30/23, 01:27 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-09-10T07:56:47+00:00" > 09/10/23, 07:56 </span>
-
Anja Leichsenring changed Related to #101890 <span data-processor="relativetime" data-value="2023-09-10T08:06:42+00:00" > 09/10/23, 08:06 </span>
-
Stefan Bürk changed Related to #101898 <span data-processor="relativetime" data-value="2023-09-12T04:33:06+00:00" > 09/12/23, 04:33 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-09-12T04:53:02+00:00" > 09/12/23, 04:53 </span>
-
Anja Leichsenring changed subtask #101908 <span data-processor="relativetime" data-value="2023-09-13T08:50:51+00:00" > 09/13/23, 08:50 </span>
-
Anja Leichsenring changed
subtask #101908<span data-processor="relativetime" data-value="2023-09-13T10:17:04+00:00" > 09/13/23, 10:17 </span> -
Anja Leichsenring changed Related to #101908 <span data-processor="relativetime" data-value="2023-09-13T10:17:14+00:00" > 09/13/23, 10:17 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-09-14T03:28:09+00:00" > 09/14/23, 03:28 </span>
-
Anja Leichsenring changed Related to #101914 <span data-processor="relativetime" data-value="2023-09-14T03:28:58+00:00" > 09/14/23, 03:28 </span>
-
Anja Leichsenring changed Related to #101915 <span data-processor="relativetime" data-value="2023-09-14T03:48:45+00:00" > 09/14/23, 03:48 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-09-14T04:23:51+00:00" > 09/14/23, 04:23 </span>
-
Anja Leichsenring changed Related to #101985 <span data-processor="relativetime" data-value="2023-09-21T04:29:26+00:00" > 09/21/23, 04:29 </span>
-
Anja Leichsenring changed Related to #101986 <span data-processor="relativetime" data-value="2023-09-21T04:30:24+00:00" > 09/21/23, 04:30 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-09-21T04:30:47+00:00" > 09/21/23, 04:30 </span>
-
Christian Kuhn changed Related to #101997 <span data-processor="relativetime" data-value="2023-09-21T14:50:09+00:00" > 09/21/23, 14:50 </span>
-
Christian Kuhn changed description <span data-processor="relativetime" data-value="2023-09-21T14:50:36+00:00" > 09/21/23, 14:50 </span>
-
Christian Kuhn changed Related to #102085 <span data-processor="relativetime" data-value="2023-10-04T13:21:22+00:00" > 10/04/23, 13:21 </span>
-
Christian Kuhn changed Related to #102106 <span data-processor="relativetime" data-value="2023-10-06T15:12:32+00:00" > 10/06/23, 15:12 </span>
-
Christian Kuhn changed description <span data-processor="relativetime" data-value="2023-10-06T15:12:56+00:00" > 10/06/23, 15:12 </span>
-
Christian Kuhn changed Related to #102107 <span data-processor="relativetime" data-value="2023-10-06T17:39:07+00:00" > 10/06/23, 17:39 </span>
-
Christian Kuhn changed description <span data-processor="relativetime" data-value="2023-10-06T17:58:11+00:00" > 10/06/23, 17:58 </span>
-
Nikita Hovratov changed subtask #102163 <span data-processor="relativetime" data-value="2023-10-13T14:09:00+00:00" > 10/13/23, 14:09 </span>
-
Anja Leichsenring changed Related to #102168 <span data-processor="relativetime" data-value="2023-10-14T07:13:50+00:00" > 10/14/23, 07:13 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-10-14T07:14:50+00:00" > 10/14/23, 07:14 </span>
-
Nikita Hovratov changed
subtask #102163<span data-processor="relativetime" data-value="2023-10-16T09:13:12+00:00" > 10/16/23, 09:13 </span> -
Nikita Hovratov changed Related to #102163 <span data-processor="relativetime" data-value="2023-10-16T09:13:19+00:00" > 10/16/23, 09:13 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-10-20T08:10:58+00:00" > 10/20/23, 08:10 </span>
-
Anja Leichsenring changed Related to #102210 <span data-processor="relativetime" data-value="2023-10-20T08:11:56+00:00" > 10/20/23, 08:11 </span>
-
Garvin Hicking changed Related to #99937 <span data-processor="relativetime" data-value="2023-10-20T08:51:21+00:00" > 10/20/23, 08:51 </span>
-
Anja Leichsenring changed Related to #97367 <span data-processor="relativetime" data-value="2023-10-22T11:28:13+00:00" > 10/22/23, 11:28 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-10-22T11:28:57+00:00" > 10/22/23, 11:28 </span>
-
Anja Leichsenring changed Related to #102237 <span data-processor="relativetime" data-value="2023-10-24T03:32:07+00:00" > 10/24/23, 03:32 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-10-24T03:32:28+00:00" > 10/24/23, 03:32 </span>
-
Anja Leichsenring changed Related to #102279 <span data-processor="relativetime" data-value="2023-10-28T07:01:59+00:00" > 10/28/23, 07:01 </span>
-
Anja Leichsenring changed description <span data-processor="relativetime" data-value="2023-10-28T07:02:23+00:00" > 10/28/23, 07:02 </span>
-
Stefan Bürk changed Related to #102944 <span data-processor="relativetime" data-value="2024-01-26T12:49:26+00:00" > 01/26/24, 12:49 </span>
-
Georg Ringer changed status
NewIn Progress <span data-processor="relativetime" data-value="2024-06-11T21:03:20+00:00" > 06/11/24, 21:03 </span> -
Christian Kuhn changed Related to #104063 <span data-processor="relativetime" data-value="2024-06-12T11:40:12+00:00" > 06/12/24, 11:40 </span>
-
Christian Kuhn changed Related to #104068 <span data-processor="relativetime" data-value="2024-06-12T11:40:36+00:00" > 06/12/24, 11:40 </span>
-
Christian Kuhn changed Related to #104098 <span data-processor="relativetime" data-value="2024-06-13T15:53:00+00:00" > 06/13/24, 15:53 </span>
-
Christian Kuhn changed description <span data-processor="relativetime" data-value="2024-06-14T11:00:11+00:00" > 06/14/24, 11:00 </span>
-
Christian Kuhn changed Related to #104110 <span data-processor="relativetime" data-value="2024-06-14T11:01:21+00:00" > 06/14/24, 11:01 </span>
-
Christian Kuhn changed Related to #104138 <span data-processor="relativetime" data-value="2024-06-18T07:41:46+00:00" > 06/18/24, 07:41 </span>
-
Christian Kuhn changed Related to #93534 <span data-processor="relativetime" data-value="2024-06-18T09:29:20+00:00" > 06/18/24, 09:29 </span>
-
Christian Kuhn changed Related to #104143 <span data-processor="relativetime" data-value="2024-06-18T09:36:18+00:00" > 06/18/24, 09:36 </span>
-
Christian Kuhn changed Related to #103028 <span data-processor="relativetime" data-value="2024-06-18T12:38:23+00:00" > 06/18/24, 12:38 </span>
-
Christian Kuhn changed Related to #104146 <span data-processor="relativetime" data-value="2024-06-18T12:40:26+00:00" > 06/18/24, 12:40 </span>
-
Christian Kuhn changed Related to #104153 <span data-processor="relativetime" data-value="2024-06-19T09:39:52+00:00" > 06/19/24, 09:39 </span>
-
Benni Mack changed Sprint Focus
On Location Sprint<span data-processor="relativetime" data-value="2024-07-11T12:16:46+00:00" > 07/11/24, 12:16 </span> -
Garvin Hicking changed category <span data-processor="relativetime" data-value="2024-07-31T10:43:26+00:00" > 07/31/24, 10:43 </span>
-
Christian Kuhn commented and changed status
In ProgressResolved <span data-processor="relativetime" data-value="2025-04-24T11:08:31+00:00" > 04/24/25, 11:08 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:36:47+00:00" > 12/02/25, 14:36 </span> -
Mathias Brodala changed Related to #110508 <span data-processor="relativetime" data-value="2026-08-21T09:43:37+00:00" > 08/21/26, 09:43 </span>
i think we could close here for the time being: most fields are covered by now, leaving only special cases like ‘none’, ‘user’ and some inline parent fields. the current set is what we established with v13, v14 could continue with the special cases in fresh issues, possibly linked here.