ALTER TABLE em_Sponsor
    ADD `url` VARCHAR(255) NULL AFTER `logo`;

UPDATE `em_Settings`
SET `value` = '', `system` = 'y'
WHERE `name` = 'headerphone';

UPDATE `em_DPageOption` SET `show` = 'n' WHERE `name` = 'showInFooter';
UPDATE `em_PageOption` SET `show` = 'n' WHERE `name` = 'showInFooter';
UPDATE `em_DraftPageOption` SET `show` = 'n' WHERE `name` = 'showInFooter';


DELETE FROM em_DPageItemType
WHERE `type` IN (
  'People_'
  'Testimonial_',
  'Partner_',
  'Blog\\',
  'ECommerce_Product_Category_',
  'User\\Login\\',
  'User\\Logout\\',
  'User\\',
  'User\\ForgotPassword\\',
  'User\\Register\\',
  'ECommerce_Product_',
  'ECommerce_Cart_',
  'ECommerce_Checkout_',
  'ECommerce_Checkout_LoginBlock_',
  'ECommerce_Order_',
  'ECommerce_Order_GuestView_',
  'Event\\',
  'User\\MemberDirectory\\',
  'Committee\\',
  'Event\\History\\'
);