[Typo3] Clean up unused data in database
Dirk
typo3user at gmx.net
Sat Nov 19 00:29:30 CET 2005
>> There are quite some tables I'm hesitant to delete; for example these:
>>
>> Removing tables (rename with prefix)
>> ALTER TABLE static_taxes RENAME zzz_deleted_static_taxes;
>> Records in table: 35
>> ALTER TABLE sys_todos RENAME zzz_deleted_sys_todos;
>> Records in table: 1
>> ALTER TABLE sys_todos_users_mm RENAME zzz_deleted_sys_todos_users_mm;
>> Records in table: 1
>> ALTER TABLE sys_workflows RENAME zzz_deleted_sys_workflows;
>> Records in table: 1
>> ALTER TABLE sys_workflows_algr_mm RENAME zzz_deleted_sys_workflows_algr_mm;
>> ALTER TABLE sys_workflows_pubuser_mm RENAME zzz_deleted_sys_workflows_pubuser_mm;
>> ALTER TABLE sys_workflows_rvuser_mm RENAME zzz_deleted_sys_workflows_rvuser_mm;
>> ALTER TABLE tt_news RENAME zzz_deleted_tt_news;
>> ALTER TABLE tt_news_cat RENAME zzz_deleted_tt_news_cat;
>> ALTER TABLE tt_news_cat_mm RENAME zzz_deleted_tt_news_cat_mm;
>> ALTER TABLE tt_news_related_mm RENAME zzz_deleted_tt_news_related_mm;
>>
>> And it's really safe to rename them?!!?
>
>If typo needs tables, it creates thems if they don't exist when you use
>the comparing tool. If you uninstall any default plugin typo suggest
>first to rename table and then to delete renamed tables.
>The purpose is that the database match *exactly* with the installed plugins.
>Have you uninstalled 'User>Task Center, Tasks' etc. and 'tt_news'?
yes, they were inactive, so that's okay
(what's not okay see my other mail...)
More information about the TYPO3-english
mailing list