4.0 to 5.0 Admin icon Migration

-- Add/Replace Admin Icons (all)
INSERT INTO BLC_ADMIN_MODULE (ADMIN_MODULE_ID, DISPLAY_ORDER, ICON, MODULE_KEY, NAME) VALUES (-33000, 125, 'blc-icon-search', 'BLCSearch', 'Search');
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-blc-leaf' WHERE ADMIN_MODULE_ID=-999001;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-search' WHERE ADMIN_MODULE_ID=-33000;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-globe' WHERE ADMIN_MODULE_ID=-29000;
UPDATE BLC_ADMIN_MODULE SET ICON='fa fa-sitemap' WHERE ADMIN_MODULE_ID=-20000;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-inventory' WHERE ADMIN_MODULE_ID=-9;
UPDATE BLC_ADMIN_MODULE SET ICON='fa fa-usd' WHERE ADMIN_MODULE_ID=-8;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-site-updates' WHERE ADMIN_MODULE_ID=-7;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-design' WHERE ADMIN_MODULE_ID=-6;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-settings' WHERE ADMIN_MODULE_ID=-5;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-security' WHERE ADMIN_MODULE_ID=-4;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-customer-care' WHERE ADMIN_MODULE_ID=-3;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-content' WHERE ADMIN_MODULE_ID=-2;
UPDATE BLC_ADMIN_MODULE SET ICON='blc-icon-catalog' WHERE ADMIN_MODULE_ID=-1;

-- Remove old Search sections (all)
DELETE FROM BLC_ADMIN_SEC_PERM_XREF WHERE ADMIN_SECTION_ID = -23500;
DELETE FROM BLC_ADMIN_SEC_PERM_XREF WHERE ADMIN_SECTION_ID = -23501;
DELETE FROM BLC_ADMIN_SECTION WHERE ADMIN_SECTION_ID = -23500;
DELETE FROM BLC_ADMIN_SECTION WHERE ADMIN_SECTION_ID = -23501;

-- Add Search Sections (Enterprise with MultiTenant)
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33502, 'org.broadleafcommerce.core.search.domain.IndexField', NULL, 4000, NULL, NULL, 'Fields', 'SearchField', '/search-field', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33501, 'org.broadleafcommerce.core.search.domain.SearchFacet', NULL, 3000, NULL, NULL, 'Facets', 'SearchFacet', '/search-facet', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33500, 'org.broadleafcommerce.core.search.redirect.domain.SearchRedirect', NULL, 1000, NULL, NULL, 'Redirects', 'SearchRedirect', '/search-redirect', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33000, 'com.broadleafcommerce.search.domain.GlobalBoostRule', NULL, 2000, NULL, NULL, 'Relevancy Rules', 'GlobalBoostRule', '/boost-rule', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-32000, 'com.broadleafcommerce.merchandisinggroup.domain.ProductGroup', NULL, 4000, 'VISIBLE', NULL, 'Product Group', 'Product Groups', '/product-group', 1, -1);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID) 
VALUES (-17000, 'com.broadleafcommerce.customersegment.domain.CustomerSegment', NULL, 3000, 'SITE_ONLY', NULL, 'Customer Segment', 'CustomerSegment', '/customer-segment', TRUE, -3);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, TEMPLATE_SITE_VISIBILITY, SITE_DISC, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-31000, 'com.broadleafcommerce.account.domain.Account', NULL, 500, 'SITE_ONLY', NULL, 'Accounts', 'Accounts', '/accounts', NULL, -3);

-- Add Search Sections (Enterprise)
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33502, 'org.broadleafcommerce.core.search.domain.IndexField', NULL, 4000, 'Fields', 'SearchField', '/search-field', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33501, 'org.broadleafcommerce.core.search.domain.SearchFacet', NULL, 3000, 'Facets', 'SearchFacet', '/search-facet', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33500, 'org.broadleafcommerce.core.search.redirect.domain.SearchRedirect', NULL, 1000, 'Redirects', 'SearchRedirect', '/search-redirect', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-33000, 'com.broadleafcommerce.search.domain.GlobalBoostRule', NULL, 2000, 'Relevancy Rules', 'GlobalBoostRule', '/boost-rule', 1, -33000);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-32000, 'com.broadleafcommerce.merchandisinggroup.domain.ProductGroup', NULL, 4000, 'Product Group', 'Product Groups', '/product-group', 1, -1);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID) 
VALUES (-17000, 'com.broadleafcommerce.customersegment.domain.CustomerSegment', NULL, 3000, 'Customer Segment', 'CustomerSegment', '/customer-segment', TRUE, -3);
INSERT INTO BLC_ADMIN_SECTION (ADMIN_SECTION_ID, CEILING_ENTITY, DISPLAY_CONTROLLER, DISPLAY_ORDER, NAME, SECTION_KEY, URL, USE_DEFAULT_HANDLER, ADMIN_MODULE_ID)
VALUES (-31000, 'com.broadleafcommerce.account.domain.Account', NULL, 500, 'Accounts', 'Accounts', '/accounts', NULL, -3);