UPDATE tblplan_features_value SET VALUE = 0, other_data = '{"outside_message":"You have limit of 0 Credits on your plan. If you want to add more credits please upgrade.",
  "inside_message":"You have limit of 0 Credits on your plan, we have used {!current_count!} credits. If you want to add more credits please upgrade.",
  "tag_color":"#eb0e0e","tag_title":"UPGRADE","link":"https://my.contractorplus.app/","count":"0"}' WHERE plans_id IN (9,13) AND plans_features_id = 136;

UPDATE `tblestimate_supplies` SET supplier_image = 'localsupply.jpg' WHERE supplier_id = 4;
UPDATE `tblinvoice_supplies` SET supplier_image = 'localsupply.jpg' WHERE supplier_id = 4;
UPDATE `tblchange_order_supplies` SET supplier_image = 'localsupply.jpg' WHERE supplier_id = 4;
UPDATE `tblitems_supplies` SET supplier_image = 'localsupply.jpg' WHERE supplier_id = 4;
UPDATE `tblshopping_list_items` SET supplier_image = 'localsupply.jpg' WHERE supplier_id = 4;

UPDATE tbloptions_static SET VALUE = '0' WHERE NAME = 'local_pricing_credits_left'; 

UPDATE `tblestimate_supplies` SET supplier_image = 'localsupply.jpg',type = 'local_pricing', supplier_id = 4  WHERE supplier_id = 0 AND supplier_name = 'Local Store Pricing';

UPDATE `tblinvoice_supplies` SET supplier_image = 'localsupply.jpg',type = 'local_pricing', supplier_id = 4  WHERE supplier_id = 0 AND supplier_name = 'Local Store Pricing';

UPDATE `tblchange_order_supplies` SET supplier_image = 'localsupply.jpg',type = 'local_pricing', supplier_id = 4  WHERE supplier_id = 0 AND supplier_name = 'Local Store Pricing';

UPDATE `tblitems_supplies` SET supplier_image = 'localsupply.jpg',type = 'local_pricing', supplier_id = 4  WHERE supplier_id = 0 AND supplier_name = 'Local Store Pricing';

UPDATE `tblshopping_list_items` SET supplier_image = 'localsupply.jpg',type = 'local_pricing', supplier_id = 4  WHERE supplier_id = 0 AND supplier_name = 'Local Store Pricing';


UPDATE `tblestimate_supplies` SET type = 'local_pricing' WHERE type= '' AND supplier_name = '1Build';
UPDATE `tblinvoice_supplies` SET type = 'local_pricing' WHERE type= '' AND supplier_name = '1Build';

UPDATE `tblchange_order_supplies` SET type = 'local_pricing' WHERE type= '' AND supplier_name = '1Build';
UPDATE `tblitems_supplies` SET type = 'local_pricing' WHERE type= '' AND supplier_name = '1Build';
UPDATE `tblshopping_list_items` SET type = 'local_pricing' WHERE type= '' AND supplier_name = '1Build';

UPDATE tblstaff SET refresh_permissions = 1;
-- Supplier DB 
UPDATE `tblsystemwide_supplier` SET image = 'localsupply.jpg' WHERE id = 4;




