#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"