INSERT INTO `email_template_global` (`code`, `name`, `subject`, `template`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`) VALUES ('PMF01', 'PM to Feedback conversion', 'Your Private Message to Management Office has been Converted to a Feedback', '

Dear {name},

Thank you for your Private Message. Your Private Message has been converted to a Feedback by Management Office as below:-

{message}

To avoid future emails from being automatically sent to your junk mail folder, we suggest that you add our email address [admin@iresidenzmail.com] to your Address Book and/or the “Approved Sender” list.

This is a computer generated email. Please do not reply to this email.

', '2018-06-06 10:35:16', '2018-06-06 10:35:16', 1, 1); ALTER TABLE `feedback` ADD `conversation_id` INT NULL AFTER `on_behalf_of`; ALTER TABLE `email_template_global` CHANGE `subject` `subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;