Attention

TYPO3 v12 has reached end-of-life as of April 30th 2026 and is no longer being maintained. Use the version switcher on the top left of this page to select documentation for a supported version of TYPO3.

Need more time before upgrading? You can purchase Extended Long Term Support (ELTS) for TYPO3 v12 here: TYPO3 ELTS.

Creating a new database model

Create SQL database schema

Add example-extension/ext_tables.sql
Model the database scheme from the TCA or PHP model perspective, then check which fields still have to be added to the ext_tables regarding your TYPO3 version by comparing database model with configuration, read more here
Insert your SQL database schema definition into that file
- Each entity is represented by one database table
  - Table name has the following structure: tx_{extension key without underscores}_domain_model_{entity name}
  - Each entity property is represented by one database column

CREATE TABLE tx_exampleextension_domain_model_example (
    title       varchar(255)     DEFAULT ''  NOT NULL,
    description text             DEFAULT '',
    foo_foo     tinyint(1)       DEFAULT '1'
);

Create TCA configuration

Add example-extension/Configuration/TCA/{table name}.php * In the example: example-extension/Configuration/TCA/tx_exampleextension_domain_model_example.php
The TCA defines types, validation and backend-UI-related parameters for each entity property * See TCA Reference for further information
Add localization files according to Language
- example-extension/Resources/Private/Language/locallang_db.xlf
- example-extension/Resources/Private/Language/de.locallang_db.xlf
Add table icon
- example-extension/Resources/Public/Icons/{entity name}.svg