INSERT INTO tblsms_templates_static values ('','business_review', 'Hey {contact_firstname}, when you get a minute, would you mind leaving a review for {companyname}? Google: {google_my_business_link}. Yelp: {yelp_business_link}. Thanks so much!',now(),now());
INSERT INTO tblsms_templates  SELECT '', id,'business_review', 'Hey {contact_firstname}, when you get a minute, would you mind leaving a review for {companyname}? Google: {google_my_business_link}. Yelp: {yelp_business_link}. Thanks so much!',now(),now() FROM tbltenants;
INSERT INTO tblemailtemplates  SELECT id, '','business_review', 'business-review', 'english', 'Business review feedback', 'Mind sharing your feedback?', '<span style=\"font-size: 12pt;\">Hi {client_firstname},</span><br /><br /><span style=\"font-size: 12pt;\">I wanted to ask if you&rsquo;d mind taking a minute to leave a review for {companyname} so other customers can read about your experience. It will only take a minute.</span><br /><br /><b>You can review us at Google here: </b><span style=\"font-size: 12pt;\">{GoogleMyBusinessLink}<br /><br /><b>You can review us at Yelp here:</b><span style=\"font-size: 12pt;\"> {YelpBusinessLink}</span><span style=\"font-size: 12pt;\"><br /></span><span style=\"font-size: 12pt;\">Thanks so much for giving us the opportunity to serve you {client_firstname}.</span><br /><br /><span style=\"font-size: 12pt;\">{authorize_signature}</span>', '{tenant_name}', NULL, '0', '1', '0',0,0 FROM tbltenants;
insert into tblemailtemplates_static values ('','business_review', 'business-review', 'english', 'Business review feedback', 'Mind sharing your feedback?', '<span style="font-size: 12pt;">Hi {contact_firstname},</span><br /><br /><span style="font-size: 12pt;">I wanted to ask if you&rsquo;d mind taking a minute to leave a review for {companyname} so other customers can read about your experience. It will only take a minute.</span><br /><br /><b>You can review us at Google here: </b><span style="font-size: 12pt;">{google_my_business_link}<br /><br /><b>You can review us at Yelp here:</b><span style="font-size: 12pt;"> {yelp_business_link}</span><span style="font-size: 12pt;"><br /></span><span style="font-size: 12pt;">Thanks so much for giving us the opportunity to serve you {contact_firstname}.</span><br /><br /><span style="font-size: 12pt;">{email_signature}</span>', ' {tenant_name}', NULL, '0', '1', '0');
INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('Business Review', 'business_review', 'Business Review', 'restrict', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('9', '75', '0', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('10', '75', '1', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('11', '75', '1', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('12', '75', '1', '2021-08-25 12:20:12');

INSERT INTO `tblplan_features` (`name`, `codename`, `description`, `type`, `added_on`) VALUES ('Send SMS Updates', 'send_sms_updates', 'Send SMS Updates', 'restrict', '2021-09-17 12:20:12');

INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('9', '79', '0', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('10', '79', '0', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('11', '79', '1', '2021-08-25 12:20:12');
INSERT INTO `tblplan_features_value` (`plans_id`, `plans_features_id`, `value`, `added_on`) VALUES ('12', '79', '1', '2021-08-25 12:20:12');
