ALTER TABLE tblshopping_list_items DROP FOREIGN KEY tblshopping_list_items_ibfk_1;
ALTER TABLE tblshopping_list_items DROP FOREIGN KEY tblshopping_list_items_ibfk_2;

ALTER TABLE devcpapp_mycpapp.tbldetail_estimate_area_task_items DROP FOREIGN KEY tbldeat_items_ibfk_2;
ALTER TABLE devcpapp_mycpapp.tbldetail_estimate_area_task_items DROP FOREIGN KEY tbldeat_items_ibfk_1;

ALTER TABLE `tblshopping_list_items` ADD `image_url` VARCHAR(191) NULL DEFAULT NULL AFTER `image`;
ALTER TABLE `tbldetail_estimate_area_task_items` ADD `image_url` VARCHAR(191) NULL DEFAULT NULL AFTER `image`;

ALTER TABLE `tblsystemwide_supplier` ADD `coming_soon_image` VARCHAR(191) NULL DEFAULT NULL AFTER `upgrade_image`;

ALTER TABLE `tblsystemwide_supplier` CHANGE `is_active` `is_active` TINYINT(1) UNSIGNED NULL DEFAULT '1' COMMENT '0: Inactive, 1: Active, 2: Coming Soon';

INSERT INTO `tblsystemwide_supplier` (`id`, `name`, `image`, `add_store_image`, `upgrade_image`, `img_folder`, `coming_soon_image`, `is_active`, `list_order`, `addedfrom`, `datecreated`) VALUES 
    (NULL, 'Lowes', 'lowes.jpg', 'lowes_unselected.png', 'lowes_upgrade.png', 'lowes', 'lowes_coming_soon.png', '2', '10', NULL, NOW()),
    (NULL, 'Menards', 'menards.jpg', 'menards_unselected.png', 'menards_upgrade.png', 'menards', 'menards_coming_soon.png', '2', '15', NULL, NOW());