DROP TABLE IF EXISTS `[db_prefix]main`;
DROP TABLE IF EXISTS `[db_prefix]rating`;
DROP TABLE IF EXISTS `[db_prefix]rating_track`;
DROP TABLE IF EXISTS `[db_prefix]cmts`;
DROP TABLE IF EXISTS `[db_prefix]cmts_track`;
DROP TABLE IF EXISTS `[db_prefix]views_track`;

-- top menu
SET @iTMParentId = (SELECT `ID` FROM `sys_menu_top` WHERE `Name` = 'Sites' AND `Parent` = 0 AND `Link` = 'modules/?r=sites/home/|modules/?r=sites/' LIMIT 1);
DELETE FROM `sys_menu_top` WHERE `Parent` = @iTMParentId;
DELETE FROM `sys_menu_top` WHERE `Parent` = 0 AND `Name` = 'Sites' AND `Caption` = '_bx_sites';
DELETE FROM `sys_menu_top` WHERE (`Parent` = 4 OR `Parent` = 9) AND `Name` = 'Sites';

-- member menu
DELETE FROM `sys_menu_member` WHERE `Name` = 'bx_sites';

-- permalinks
DELETE FROM `sys_permalinks` WHERE `check`='bx_sites_permalinks';

-- settings
SET @iCategId = (SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Sites');
DELETE FROM `sys_options` WHERE `kateg` = @iCategId;
DELETE FROM `sys_options_cats` WHERE `ID` = @iCategId;
DELETE FROM `sys_options` WHERE `Name` = 'bx_sites_permalinks';

DELETE FROM `sys_page_compose_pages` WHERE `Name` like 'bx_sites_%';
DELETE FROM `sys_page_compose` WHERE `Page` like '%bx_sites%' OR `Caption` like '%bx_sites%';

DELETE FROM `sys_objects_vote` WHERE `ObjectName` = 'bx_sites';
DELETE FROM `sys_objects_cmts` WHERE `ObjectName` = 'bx_sites';
DELETE FROM `sys_objects_views` WHERE `name` = 'bx_sites';
DELETE FROM `sys_objects_search` WHERE `ObjectName` = 'bx_sites';
DELETE FROM `sys_objects_categories` WHERE `ObjectName` = 'bx_sites';
DELETE FROM `sys_categories` WHERE `Type` = 'bx_sites';
DELETE FROM `sys_categories` WHERE `Type` = 'bx_photos' AND `Category` = 'Sites';
DELETE FROM `sys_objects_tag` WHERE `ObjectName` = 'bx_sites';
DELETE FROM `sys_tags` WHERE `Type` = 'bx_sites';
DELETE FROM `sys_objects_actions` WHERE `Type` like 'bx_sites%';

-- membership levels
DELETE `sys_acl_actions`, `sys_acl_matrix` FROM `sys_acl_actions`, `sys_acl_matrix` WHERE `sys_acl_matrix`.`IDAction` = `sys_acl_actions`.`ID` AND `sys_acl_actions`.`Name` IN('sites view', 'sites browse', 'sites search', 'sites delete', 'sites edit any site', 'sites delete any site', 'sites mark as featured', 'sites approve');
DELETE FROM `sys_acl_actions` WHERE `Name` IN('sites view', 'sites browse', 'sites search', 'sites add', 'sites edit any site', 'sites delete any site', 'sites mark as featured', 'sites approve');

-- site stats
DELETE FROM `sys_stat_site` WHERE `Name` = 'sts';

-- PQ statistics
DELETE FROM `sys_stat_member` WHERE TYPE IN('bx_sites', 'bx_sitesp');
DELETE FROM `sys_account_custom_stat_elements` WHERE `Label` = '_bx_sites';

-- alerts
SET @iHandler := (SELECT `id` FROM `sys_alerts_handlers` WHERE `name` = 'bx_sites' LIMIT 1);
DELETE FROM `sys_alerts` WHERE `handler_id` = @iHandler OR `unit` = 'bx_sites';
DELETE FROM `sys_alerts_handlers` WHERE `id` = @iHandler;

-- admin menu
DELETE FROM `sys_menu_admin` WHERE `name` = 'bx_sites';

-- privacy
DELETE FROM `sys_privacy_actions` WHERE `module_uri`='bx_sites';

-- subscriptions
DELETE FROM `sys_email_templates` WHERE `Name` = 't_sbsSitesComments';
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`='bx_sites';
DELETE FROM `sys_sbs_types` WHERE `unit`='bx_sites';

-- sitemap
DELETE FROM `sys_objects_site_maps` WHERE `object` = 'bx_sites';

-- chart
DELETE FROM `sys_objects_charts` WHERE `object` = 'bx_sites';


-- begin stw integration
-- stw requests
DROP TABLE IF EXISTS `[db_prefix]stw_requests`;

-- stw account info
DROP TABLE IF EXISTS `[db_prefix]stwacc_info`;
-- end stw integration
