ALTER TABLE `tbltenants` ADD `freshdesk_contact_id` BIGINT NULL DEFAULT NULL AFTER `id`;
UPDATE `tblemailtemplates_static` SET subject = '{first_name}, your {plan_name} membership has expired', message = '<span style="font-size: 12pt;">Hi {first_name},</span><br/><br/><span style="font-size: 12pt;">This email is letting you know that your {plan_name} membership has expired at Contractor+.</span><br/><br/><span style="font-size: 12pt;">If you wish to continue using and getting the benefits from Contractor+, please login to the app and renew your membership today.</span><br/><br/><span style="font-size: 12pt;">If you have any questions, you can reply to this email and our billing team will get back to you ASAP.</span><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><br/><span style="font-size: 12pt;">Billing Team</span><br/><span style="font-size: 12pt;">Contractor+ App</span><br/><span style="font-size: 12pt;">www.contractorplus.app</span>' WHERE slug = 'plan-expiry-mail';
UPDATE `tblemailtemplates` SET subject = '{first_name}, your {plan_name} membership has expired', message = '<span style="font-size: 12pt;">Hi {first_name},</span><br/><br/><span style="font-size: 12pt;">This email is letting you know that your {plan_name} membership has expired at Contractor+.</span><br/><br/><span style="font-size: 12pt;">If you wish to continue using and getting the benefits from Contractor+, please login to the app and renew your membership today.</span><br/><br/><span style="font-size: 12pt;">If you have any questions, you can reply to this email and our billing team will get back to you ASAP.</span><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><br/><span style="font-size: 12pt;">Billing Team</span><br/><span style="font-size: 12pt;">Contractor+ App</span><br/><span style="font-size: 12pt;">www.contractorplus.app</span>' WHERE slug = 'plan-expiry-mail';
UPDATE tblplans SET description = '<div class="plan-feature"><span>+ 2GB Bandwidth</span><span>+ 150GB Storage</span><span>+ 12 Accounts</span><span>+ 7 Host Domain</span><span>+ 24/7 Support</span></div>' WHERE id IN (9, 10, 11, 12);
