INSERT INTO tbloptions SELECT id, null, 'estimate_show_supplies_to_client','0',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'estimate_show_supplies_to_client','0',1);

UPDATE tbloptions SET value = "top" WHERE name = "show_cp_branding";
UPDATE tbloptions_static SET value = "top" WHERE name = "show_cp_branding";

UPDATE tbloptions SET value = "" WHERE name = "invoice_display_team_members_info";
UPDATE tbloptions_static SET value = "" WHERE name = "invoice_display_team_members_info";

UPDATE tbloptions SET value = "" WHERE name = "estimate_display_team_members_info";
UPDATE tbloptions_static SET value = "" WHERE name = "estimate_display_team_members_info";

UPDATE tbloptions SET value = "" WHERE name = "pi_display_team_members_info";
UPDATE tbloptions_static SET value = "" WHERE name = "pi_display_team_members_info";

UPDATE tbloptions SET value = "" WHERE name = "invoice_show_paid_date";
UPDATE tbloptions_static SET value = "" WHERE name = "invoice_show_paid_date";

INSERT INTO tbloptions SELECT id, null, 'shop_list_show_phone_number_in_header','',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'shop_list_show_phone_number_in_header','',1);
INSERT INTO tbloptions SELECT id, null, 'shop_list_show_email_in_header','',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'shop_list_show_email_in_header','',1);
INSERT INTO tbloptions SELECT id, null, 'shop_list_show_website_in_header','0',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'shop_list_show_website_in_header','0',1);
INSERT INTO tbloptions SELECT id, null, 'shop_list_show_client_phone_number','0',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'shop_list_show_client_phone_number','0',1);

INSERT INTO tbloptions SELECT id, null, 'shop_list_display_team_members_info','',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'shop_list_display_team_members_info','',1);

INSERT INTO tbloptions SELECT id, null, 'invoice_show_address_on_invoice','billing',1 FROM tbltenants;
INSERT INTO tbloptions_static VALUES (null,'invoice_show_address_on_invoice','billing',1);


UPDATE tblplan_features SET name = "Remove CP Branding", codename = "remove_cp_branding", description = "Remove CP Branding" WHERE codename = "update_cp_branding_preference";

INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('Move Bottom CP Branding', 'move_bottom_cp_branding', 'Move Bottom CP Branding', 'restrict', NOW());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('9', '92', '0', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('10', '92', '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('11', '92', '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('12', '92', '1', UTC_TIMESTAMP());

INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('Show Both Property and Billing Address On Invoice', 'show_both_address_on_invoice', 'Show Both Property and Billing Address On Invoice', 'restrict', NOW());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('9', '93', '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('10', '93', '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('11', '93', '1', UTC_TIMESTAMP());
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('12', '93', '1', UTC_TIMESTAMP());