[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