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

> [!WARNING]
> **Attention**
>
> TYPO3 v11 has reached end-of-life as of October 31th 2024 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 v11 here:
> [TYPO3 ELTS](https://typo3.com/services/extended-support-elts).

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

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` 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.