text: DROP TABLE IF EXISTS `[db_prefix]entries`;
  DROP TABLE IF EXISTS `[db_prefix]comments`;
  DROP TABLE IF EXISTS `[db_prefix]comments_track`;
  DROP TABLE IF EXISTS `[db_prefix]voting`;
  DROP TABLE IF EXISTS `[db_prefix]voting_track`;
  DROP TABLE IF EXISTS `[db_prefix]views_track`;
  
  SET @iTMParentId = (SELECT `ID` FROM `sys_menu_top` WHERE `Name`='News' LIMIT 1);
  DELETE FROM `sys_menu_top` WHERE `Name` IN ('News', 'NewsView') OR `Parent`=@iTMParentId;
  DELETE FROM `sys_menu_admin` WHERE `name`='ch_news';
  
  DELETE FROM `sys_permalinks` WHERE `check`='permalinks_module_news';
  
  SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`='News' LIMIT 1);
  DELETE FROM `sys_options_cats` WHERE `name`='News' LIMIT 1;
  DELETE FROM `sys_options` WHERE `kateg`=@iCategoryId OR `Name` IN ('permalinks_module_news', 'category_auto_app_ch_news');
  
  DELETE FROM `sys_objects_cmts` WHERE `ObjectName`='ch_news' LIMIT 1;
  DELETE FROM `sys_objects_vote` WHERE `ObjectName`='ch_news' LIMIT 1;
  DELETE FROM `sys_objects_tag` WHERE `ObjectName`='ch_news' LIMIT 1;
  DELETE FROM `sys_objects_categories` WHERE `ObjectName`='ch_news' LIMIT 1;
  DELETE FROM `sys_categories` WHERE `Type` = 'ch_news';
  DELETE FROM `sys_objects_search` WHERE `ObjectName`='ch_news' LIMIT 1;
  DELETE FROM `sys_objects_views` WHERE `name`='ch_news' LIMIT 1;
  
  DELETE FROM `sys_page_compose_pages` WHERE `Name` IN ('news_single', 'news_home');
  DELETE FROM `sys_page_compose` WHERE `Page` IN ('news_single', 'news_home') OR `Caption` IN ('_news_bcaption_featured', '_news_bcaption_latest', '_news_bcaption_member');
  
  DELETE FROM `sys_objects_actions` WHERE `Type`='ch_news';
  
  DELETE FROM `sys_sbs_entries` USING `sys_sbs_types`, `sys_sbs_entries` WHERE `sys_sbs_types`.`id`=`sys_sbs_entries`.`subscription_id` AND `sys_sbs_types`.`unit`='ch_news';
  DELETE FROM `sys_sbs_types` WHERE `unit`='ch_news';
  
  DELETE FROM `sys_email_templates` WHERE `Name` IN ('t_sbsNewsComments');
  
  DELETE FROM `sys_acl_actions` WHERE `Name` IN ('News Delete');
  
  DELETE FROM `sys_cron_jobs` WHERE `name`='ch_news';
  
  -- mobile
  DELETE FROM `sys_menu_mobile` WHERE `type` = 'ch_news';
  
  -- site stats
  DELETE FROM `sys_stat_site` WHERE `Name`='news';
  
  -- sitemap
  DELETE FROM `sys_objects_site_maps` WHERE `object` = 'ch_news';
  
  -- chart
  DELETE FROM `sys_objects_charts` WHERE `object` = 'ch_news';
  
  -- export
  DELETE FROM `sys_objects_exports` WHERE `object` = 'ch_news';
  