Project

General

Profile

Actions
Copy link

Feature #101553

open

Auto-create DB fields from TCA columns

Added by Christian Kuhn 11 months ago. Updated 16 days ago.

Status:
In Progress
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2023-10-13
Due date:
% Done:

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:
On Location Sprint

Description

Goal is to further reduce / get rid of ext_tables.sql by creating DB fields from TCA columns.

  • type=check
  • type=color
  • type=datetime
  • type=email
  • type=flex
  • type=file
  • type=folder
  • type=group
  • type=imageManipulation
  • type=inline
  • type=input
  • type=language
  • type=link
  • type=none - no DB field!
  • type=number
  • type=passthrough
  • type=password
  • type=radio
  • type=select
  • type=text
  • type=user

Related issues 38 (3 open — 35 closed)

Related to TYPO3 Core - Task #101571: Auto-create DB fields from TCA columns for type "file"Closed2023-08-03

Actions
Related to TYPO3 Core - Task #101623: Allow table without columns in ext_tables.sqlClosed2023-08-09

Actions
Related to TYPO3 Core - Task #101641: Modernize FileHandlingUtilityClosed2023-08-09

Actions
Related to TYPO3 Core - Task #101642: Modernize ext:core ext_tables.sql AST classesClosed2023-08-09

Actions
Related to TYPO3 Core - Task #101651: Modernize ext:core ext_tables.sql DataType classesClosed2023-08-10

Actions
Related to TYPO3 Core - Feature #101653: Auto-create DB fields from TCA columns for type "check"Closed2023-08-10

Actions
Related to TYPO3 Core - Feature #101654: Auto-create DB fields from TCA columns for type "email"Closed2023-08-10

Actions
Related to TYPO3 Core - Task #101660: Clean up ext_tables.sql parserClosed2023-08-11

Actions
Related to TYPO3 Core - Task #101793: Remove DataHandler->checkStoredRecord()Closed2023-08-30

Actions
Related to TYPO3 Core - Task #101890: Auto-create DB fields from TCA columns for type "folder"ClosedAnja Leichsenring2023-09-10

Actions
Related to TYPO3 Core - Task #101898: Remove superfluous test from DefaultTcaSchemaTest.phpClosedStefan Bürk2023-09-12

Actions
Related to TYPO3 Core - Feature #101908: Auto-create DB fields from TCA columns for type "group"ClosedAnja Leichsenring2023-09-13

Actions
Related to TYPO3 Core - Feature #101914: Auto-create DB fields from TCA columns for type "imageManipulation"ClosedAnja Leichsenring2023-09-14

Actions
Related to TYPO3 Core - Feature #101915: Auto-create DB fields from TCA columns for type "language"ClosedAnja Leichsenring2023-09-14

Actions
Related to TYPO3 Core - Task #101985: Deal with leftover sql definitions from type=groupNewAnja Leichsenring2023-09-21

Actions
Related to TYPO3 Core - Feature #101986: Auto-create DB fields from TCA columns for type "text"ClosedAnja Leichsenring2023-09-21

Actions
Related to TYPO3 Core - Task #101997: Auto-create DB fields from TCA columns for type "flex"Closed2023-09-21

Actions
Related to TYPO3 Core - Task #102085: Allow to omit tables in ext_tables.sqlClosed2023-10-04

Actions
Related to TYPO3 Core - Task #102106: Auto-create DB fields from TCA columns for type "password"Closed2023-10-06

Actions
Related to TYPO3 Core - Feature #102107: Auto-create DB fields from TCA columns for type "color"Closed2023-10-06

Actions
Related to TYPO3 Core - Feature #102168: Auto-create DB fields from TCA columns for type "link"ClosedAnja Leichsenring2023-10-14

Actions
Related to TYPO3 Core - Feature #102163: Auto-create DB fields from TCA columns for type "radio"ClosedNikita Hovratov2023-10-13

Actions
Related to TYPO3 Core - Feature #102210: Auto-create DB fields from TCA columns for type "inline"ClosedAnja Leichsenring2023-10-20

Actions
Related to TYPO3 Core - Bug #99937: 2038-Bug in TYPO3?Resolved2023-02-13

Actions
Related to TYPO3 Core - Feature #97367: Auto creation of database fields for TCA "datetime"ClosedOliver Bartsch2022-04-12

Actions
Related to TYPO3 Core - Feature #102237: Auto-create DB fields from TCA columns for type "number"ClosedAnja Leichsenring2023-10-24

Actions
Related to TYPO3 Core - Feature #102279: Auto-create DB fields from TCA columns for type "select"ResolvedAnja Leichsenring2023-10-28

Actions
Related to TYPO3 Core - Task #102944: Reduce `ext_tables.sql` for `ext:redirects`ClosedStefan Bürk2024-01-26

Actions
Related to TYPO3 Core - Task #104063: Make slug fields TEXT by defaultResolved2024-06-11

Actions
Related to TYPO3 Core - Task #104068: Make type=link fields TEXT by defaultResolved2024-06-12

Actions
Related to TYPO3 Core - Task #104098: Auto-create DB fields from TCA columns for type "input"Resolved2024-06-13

Actions
Related to TYPO3 Core - Task #104110: Streamline DefaultTcaSchemaResolved2024-06-14

Actions
Related to TYPO3 Core - Task #104138: Avoid long varchar() in pages tableResolved2024-06-18

Actions
Related to TYPO3 Core - Bug #93534: Insufficient database type for (several) title propertiesUnder Review2021-02-17

Actions
Related to TYPO3 Core - Task #104143: Make pages.author VARCHAR(255)Resolved2024-06-18

Actions
Related to TYPO3 Core - Task #103028: Refactoring DefaultTcaSchema to reduce redundant codeNew2024-02-03

Actions
Related to TYPO3 Core - Task #104146: TEXT for type=input length > 255Resolved2024-06-18

Actions
Related to TYPO3 Core - Task #104153: About "row size too large"Resolved2024-06-19

Actions
Actions
Copy link
 #1

Updated by Oliver Wand 11 months ago

  • Related to Task #101571: Auto-create DB fields from TCA columns for type "file" added
Actions
Copy link
 #2

Updated by Christian Kuhn 11 months ago

  • Related to Task #101623: Allow table without columns in ext_tables.sql added
Actions
Copy link
 #3

Updated by Christian Kuhn 11 months ago

  • Related to Task #101641: Modernize FileHandlingUtility added
Actions
Copy link
 #4

Updated by Christian Kuhn 11 months ago

  • Related to Task #101642: Modernize ext:core ext_tables.sql AST classes added
Actions
Copy link
 #5

Updated by Christian Kuhn 11 months ago

  • Related to Task #101651: Modernize ext:core ext_tables.sql DataType classes added
Actions
Copy link
 #6

Updated by Oliver Wand 11 months ago

  • Related to Feature #101653: Auto-create DB fields from TCA columns for type "check" added
Actions
Copy link
 #7

Updated by Oliver Wand 11 months ago

  • Related to Feature #101654: Auto-create DB fields from TCA columns for type "email" added
Actions
Copy link
 #8

Updated by Christian Kuhn 11 months ago

  • Related to Task #101660: Clean up ext_tables.sql parser added
Actions
Copy link
 #9

Updated by Christian Kuhn 10 months ago

  • Related to Task #101793: Remove DataHandler->checkStoredRecord() added
Actions
Copy link
 #10

Updated by Anja Leichsenring 10 months ago

  • Description updated (diff)
Actions
Copy link
 #11

Updated by Anja Leichsenring 10 months ago

  • Related to Task #101890: Auto-create DB fields from TCA columns for type "folder" added
Actions
Copy link
 #12

Updated by Stefan Bürk 10 months ago

  • Related to Task #101898: Remove superfluous test from DefaultTcaSchemaTest.php added
Actions
Copy link
 #13

Updated by Anja Leichsenring 10 months ago

  • Description updated (diff)
Actions
Copy link
 #14

Updated by Anja Leichsenring 10 months ago

  • Subtask #101908 added
Actions
Copy link
 #15

Updated by Anja Leichsenring 10 months ago

  • Subtask deleted (#101908)
Actions
Copy link
 #16

Updated by Anja Leichsenring 10 months ago

  • Related to Feature #101908: Auto-create DB fields from TCA columns for type "group" added
Actions
Copy link
 #17

Updated by Anja Leichsenring 10 months ago

  • Description updated (diff)
Actions
Copy link
 #18

Updated by Anja Leichsenring 10 months ago

  • Related to Feature #101914: Auto-create DB fields from TCA columns for type "imageManipulation" added
Actions
Copy link
 #19

Updated by Anja Leichsenring 10 months ago

  • Related to Feature #101915: Auto-create DB fields from TCA columns for type "language" added
Actions
Copy link
 #20

Updated by Anja Leichsenring 10 months ago

  • Description updated (diff)
Actions
Copy link
 #21

Updated by Anja Leichsenring 9 months ago

  • Related to Task #101985: Deal with leftover sql definitions from type=group added
Actions
Copy link
 #22

Updated by Anja Leichsenring 9 months ago

  • Related to Feature #101986: Auto-create DB fields from TCA columns for type "text" added
Actions
Copy link
 #23

Updated by Anja Leichsenring 9 months ago

  • Description updated (diff)
Actions
Copy link
 #24

Updated by Christian Kuhn 9 months ago

  • Related to Task #101997: Auto-create DB fields from TCA columns for type "flex" added
Actions
Copy link
 #25

Updated by Christian Kuhn 9 months ago

  • Description updated (diff)
Actions
Copy link
 #26

Updated by Christian Kuhn 9 months ago

  • Related to Task #102085: Allow to omit tables in ext_tables.sql added
Actions
Copy link
 #27

Updated by Christian Kuhn 9 months ago

  • Related to Task #102106: Auto-create DB fields from TCA columns for type "password" added
Actions
Copy link
 #28

Updated by Christian Kuhn 9 months ago

  • Description updated (diff)
Actions
Copy link
 #29

Updated by Christian Kuhn 9 months ago

  • Related to Feature #102107: Auto-create DB fields from TCA columns for type "color" added
Actions
Copy link
 #30

Updated by Christian Kuhn 9 months ago

  • Description updated (diff)
Actions
Copy link
 #31

Updated by Nikita Hovratov 9 months ago

  • Subtask #102163 added
Actions
Copy link
 #32

Updated by Anja Leichsenring 9 months ago

  • Related to Feature #102168: Auto-create DB fields from TCA columns for type "link" added
Actions
Copy link
 #33

Updated by Anja Leichsenring 9 months ago

  • Description updated (diff)
Actions
Copy link
 #34

Updated by Nikita Hovratov 9 months ago

  • Subtask deleted (#102163)
Actions
Copy link
 #35

Updated by Nikita Hovratov 9 months ago

  • Related to Feature #102163: Auto-create DB fields from TCA columns for type "radio" added
Actions
Copy link
 #36

Updated by Anja Leichsenring 8 months ago

  • Description updated (diff)
Actions
Copy link
 #37

Updated by Anja Leichsenring 8 months ago

  • Related to Feature #102210: Auto-create DB fields from TCA columns for type "inline" added
Actions
Copy link
 #38

Updated by Garvin Hicking 8 months ago

Actions
Copy link
 #39

Updated by Anja Leichsenring 8 months ago

  • Related to Feature #97367: Auto creation of database fields for TCA "datetime" added
Actions
Copy link
 #40

Updated by Anja Leichsenring 8 months ago

  • Description updated (diff)
Actions
Copy link
 #41

Updated by Anja Leichsenring 8 months ago

  • Related to Feature #102237: Auto-create DB fields from TCA columns for type "number" added
Actions
Copy link
 #42

Updated by Anja Leichsenring 8 months ago

  • Description updated (diff)
Actions
Copy link
 #43

Updated by Anja Leichsenring 8 months ago

  • Related to Feature #102279: Auto-create DB fields from TCA columns for type "select" added
Actions
Copy link
 #44

Updated by Anja Leichsenring 8 months ago

  • Description updated (diff)
Actions
Copy link
 #45

Updated by Stefan Bürk 5 months ago

  • Related to Task #102944: Reduce `ext_tables.sql` for `ext:redirects` added
Actions
Copy link
 #46

Updated by Georg Ringer 19 days ago

  • Status changed from New to In Progress
Actions
Copy link
 #47

Updated by Christian Kuhn 18 days ago

  • Related to Task #104063: Make slug fields TEXT by default added
Actions
Copy link
 #48

Updated by Christian Kuhn 18 days ago

  • Related to Task #104068: Make type=link fields TEXT by default added
Actions
Copy link
 #49

Updated by Christian Kuhn 17 days ago

  • Related to Task #104098: Auto-create DB fields from TCA columns for type "input" added
Actions
Copy link
 #50

Updated by Christian Kuhn 16 days ago

  • Description updated (diff)
Actions
Copy link
 #51

Updated by Christian Kuhn 16 days ago

  • Related to Task #104110: Streamline DefaultTcaSchema added
Actions
Copy link
 #52

Updated by Christian Kuhn 12 days ago

  • Related to Task #104138: Avoid long varchar() in pages table added
Actions
Copy link
 #53

Updated by Christian Kuhn 12 days ago

  • Related to Bug #93534: Insufficient database type for (several) title properties added
Actions
Copy link
 #54

Updated by Christian Kuhn 12 days ago

  • Related to Task #104143: Make pages.author VARCHAR(255) added
Actions
Copy link
 #55

Updated by Christian Kuhn 12 days ago

  • Related to Task #103028: Refactoring DefaultTcaSchema to reduce redundant code added
Actions
Copy link
 #56

Updated by Christian Kuhn 12 days ago

  • Related to Task #104146: TEXT for type=input length > 255 added
Actions
Copy link
 #57

Updated by Christian Kuhn 11 days ago

Actions
Copy link

Also available in: Atom PDF