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 data from bash (being in the extension directory):
mysqldump --add-drop-table \
--password=[password] [database name] \
[tablename] > ./ext_tables_static+adt.sql
--add-drop-table
will make sure to include a DROP TABLE
statement so any data is inserted in a fresh table.
You can also drop the table content using the Extension Manager in the backend.
Note
The table structure of static tables needs to be in the
ext_tables.sql
file as well - otherwise an installed static
table will be reported as being in excess in the Install Tool.
Warning
Static data is not meant to be extended by other extensions. On
re-import all extended fields and data is lost due to DROP TABLE
statements.