[TYPO3-dev] Generate ext_tables.sql from existing tables

[Loek Hilgersom]

Hi Steffen,

Thank you for the quick answer. I needed to make a little detour because the 
tables did not yet belong to an extension, and they did not follow the 
convention that the tablenames should start with tx_ or user_

What I did was
* renaming the tables (adding tx_)
* imported the tables in a temporary installation
* created the empty tables with the kickstarter in a new extension

After that I was able to dump the structure like you said.
Finally, I removed the tx_ from the table names again in ext_tables.sql.

The newly created extension now preserves the tables when doing a database compare.

Thanks!
Loek


On 01/11/2011 03:50 PM, Steffen Kamper wrote:
> Hi,
>
> go to extension manager, click on an installed extension and choose "Dump" from
> menu
>
> vg Steffen