1UPDATE `tiki_preferences` SET `name` = 'theme' WHERE `name` = 'theme_active';
2UPDATE `tiki_preferences` SET `name` = 'theme_option', `value` = REPLACE(`value`, '.css', '') WHERE `name` = 'style_option';
3UPDATE `tiki_user_preferences` SET `value` = REPLACE(`value`, '.css', '') WHERE `prefName` = 'theme';
4UPDATE `tiki_user_preferences` SET `prefName` = 'theme_option', `value` = REPLACE(`value`, '.css', '') WHERE `prefName` = 'theme-option';
5UPDATE `tiki_theme_control_categs` SET `theme` = REPLACE(`theme`, '.css', '');
6UPDATE `tiki_theme_control_objects` SET `theme` = REPLACE(`theme`, '.css', '');
7UPDATE `tiki_theme_control_sections` SET `theme` = REPLACE(`theme`, '.css', '');
8UPDATE `users_groups` SET `groupTheme` = REPLACE(`groupTheme`, '.css', '');
9