ALTER TABLE tblshopping_list_items ADD source_product_sku varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL AFTER name;
ALTER TABLE tblshopping_list_items ADD product_url varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL AFTER image_url;
ALTER TABLE tblshopping_list_items ADD category_id bigint(20) unsigned NULL AFTER product_url;
ALTER TABLE tblshopping_list_items ADD supplier_id bigint(20) unsigned NULL AFTER category_name;
ALTER TABLE tblshopping_list_items ADD supplier_image varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL AFTER supplier_name;


ALTER TABLE tbldetail_estimate_area_task_items ADD source_product_sku varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL AFTER name;
ALTER TABLE tbldetail_estimate_area_task_items ADD product_url varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL AFTER image_url;
ALTER TABLE tbldetail_estimate_area_task_items ADD category_id bigint(20) unsigned NULL AFTER product_url;
ALTER TABLE tbldetail_estimate_area_task_items ADD supplier_id bigint(20) unsigned NULL AFTER category_name;
ALTER TABLE tbldetail_estimate_area_task_items ADD supplier_image varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL AFTER supplier_name;

ALTER TABLE tblshopping_list ADD job_id  bigint(20) unsigned DEFAULT NULL AFTER client_id;