UPDATE `tblemailtemplates` SET subject = 'New Shopping List for {shopping_list_address}', message = '<span style="font-size: 12pt;">Hi {shopping_list_for},</span><br/><br/><span style="font-size: 12pt;">Attached is the shopping list titled: {shopping_list_title}</span><br/><br/><span style="font-size: 12pt;">This list is related to {shopping_list_address}.</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'shopping-list-send';
UPDATE `tblemailtemplates_static` SET subject = 'New Shopping List for {shopping_list_address}', message = '<span style="font-size: 12pt;">Hi {shopping_list_for},</span><br/><br/><span style="font-size: 12pt;">Attached is the shopping list titled: {shopping_list_title}</span><br/><br/><span style="font-size: 12pt;">This list is related to {shopping_list_address}.</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'shopping-list-send';
ALTER TABLE `tblstaff` ADD `enjoying_cp` TINYINT(1) NOT NULL DEFAULT '1' AFTER `profile_image`, ADD `is_review_added` TINYINT(1) NOT NULL DEFAULT '0' AFTER `enjoying_cp`, ADD `review_updated_at` DATETIME NULL AFTER `is_review_added`;
-- New Mail for Plan Expiry
INSERT INTO `tblemailtemplates_static` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES ('2009', 'staff', 'plan-expiry-mail', 'english', 'Plan Expiry Mail', 'Renew Your Plan - Contractor+', '<span style=\"font-size: 12pt;\">Hi {name},</span><br/><br/><span style=\"font-size: 12pt;\">Your package has expired today. Renew your plan to continue enjoying the benefits of Contractor+</span><br/><br/><span style=\"font-size: 12pt;\">{email_signature}</span>', ' ', NULL, '0', '1', '0');
INSERT INTO `tblemailtemplates` (`tenant_id`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) SELECT id, 'staff', 'plan-expiry-mail', 'english', 'Plan Expiry Mail', 'Renew Your Plan - Contractor+', '<span style=\"font-size: 12pt;\">Hi {name},</span><br/><br/><span style=\"font-size: 12pt;\">Your package has expired today. Renew your plan to continue enjoying the benefits of Contractor+</span><br/><br/><span style=\"font-size: 12pt;\">{email_signature}</span>', ' ', NULL, '0', '1', '0' FROM tbltenants;