---
title: "ext_tables_static+adt.sql"
manual: "TYPO3 Explained"
version: "12.4"
permalink: "https://docs.typo3.org/permalink/t3coreapi:ext-tables-static-adt-sql@12.4"
source: "ExtensionArchitecture/FileStructure/ExtTablesStaticAdtSql.rst"
rendered: "2026-10-21T15:29:37+00:00"
---

> [!WARNING]
> **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](https://typo3.com/services/extended-support-elts).

# `ext_tables_static+adt.sql` {#ext-tables-static-adt-sql}

-   **ext_tables_static+adt.sql**

    -   *Scope:* extension
    -   *Path (Composer):* packages/my_extension/ext_tables_static+adt.sql
    -   *Path (Classic):* typo3conf/ext/my_extension/ext_tables_static+adt.sql

    Holds static SQL tables and their data.

    If the extension requires static data you can dump it into an SQL file
    by this name. Example for dumping MySQL/MariaDB data from shell (executed in the
    extension's root directory):

```shell
mysqldump --user=[user] --password [database name] \
          [tablename] > ./ext_tables_static+adt.sql
```

Note that only `INSERT INTO` statements are allowed. The file is
interpreted whenever the corresponding extension's setup routines get called:
Upon first time installation, command task execution of
`bin/typo3 extension:setup` or via the **Admin Tools > Extensions**
interface and the **Reload extension data** action. The static data is
then only re-evaluated, if the file has different contents than on the last
execution. In that case, the table is truncated and the new data imported.

The table structure of static tables must be declared in the
[`ext_tables.sql`](ExtTablesSql.md#file-extension-ext-tables-sql) file, otherwise data cannot be added to a static table.

> [!WARNING]
> Static data is not meant to be extended by other extensions. On
> re-import all extended fields and data is lost.