
START TRANSACTION;

UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>Your job application for job: {refid} is received.<br/> <br/>Thank you' WHERE `field` = 'message1' AND `model`='pjNotification' AND `foreign_id` = 1;
UPDATE `multi_lang` SET `content` = 'You received a new application for job : {refid}<br/><br/>First Name: {fname}<br/>Last Name: {lname}<br/>E-Mail: {email}<br/><br/>This email was automatically generated, please do not reply.' WHERE `field` = 'message2' AND `model`='pjNotification' AND `foreign_id` = 1;
UPDATE `multi_lang` SET `content` = 'A new job has been posted. <br/><br/>Reference ID: {refid}<br/><br/>Edit the job ad here: {editjoburl}<br/><br/>Thank you!' WHERE `field` = 'message3' AND `model`='pjNotification' AND `foreign_id` = 1;
UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>your password is: {password}<br/> <br/>Thank you' WHERE `field` = 'message4' AND `model`='pjNotification' AND `foreign_id` = 1;

UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>Your job application for job: {refid} is received.<br/> <br/>Thank you' WHERE `field` = 'message1' AND `model`='pjNotification' AND `foreign_id` = 2;
UPDATE `multi_lang` SET `content` = 'You received a new application for job : {refid}<br/><br/>First Name: {fname}<br/>Last Name: {lname}<br/>E-Mail: {email}<br/><br/>This email was automatically generated, please do not reply.' WHERE `field` = 'message2' AND `model`='pjNotification' AND `foreign_id` = 2;
UPDATE `multi_lang` SET `content` = 'A new job has been posted. <br/><br/>Reference ID: {refid}<br/><br/>Edit the job ad here: {editjoburl}<br/><br/>Thank you!' WHERE `field` = 'message3' AND `model`='pjNotification' AND `foreign_id` = 2;
UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>your password is: {password}<br/> <br/>Thank you' WHERE `field` = 'message4' AND `model`='pjNotification' AND `foreign_id` = 2;

UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>Your job application for job: {refid} is received.<br/> <br/>Thank you' WHERE `field` = 'message1' AND `model`='pjNotification' AND `foreign_id` = 3;
UPDATE `multi_lang` SET `content` = 'You received a new application for job : {refid}<br/><br/>First Name: {fname}<br/>Last Name: {lname}<br/>E-Mail: {email}<br/><br/>This email was automatically generated, please do not reply.' WHERE `field` = 'message2' AND `model`='pjNotification' AND `foreign_id` = 3;
UPDATE `multi_lang` SET `content` = 'A new job has been posted. <br/><br/>Reference ID: {refid}<br/><br/>Edit the job ad here: {editjoburl}<br/><br/>Thank you!' WHERE `field` = 'message3' AND `model`='pjNotification' AND `foreign_id` = 3;
UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>your password is: {password}<br/> <br/>Thank you' WHERE `field` = 'message4' AND `model`='pjNotification' AND `foreign_id` = 3;

UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>Your job application for job: {refid} is received.<br/> <br/>Thank you' WHERE `field` = 'message1' AND `model`='pjNotification' AND `foreign_id` = 4;
UPDATE `multi_lang` SET `content` = 'You received a new application for job : {refid}<br/><br/>First Name: {fname}<br/>Last Name: {lname}<br/>E-Mail: {email}<br/><br/>This email was automatically generated, please do not reply.' WHERE `field` = 'message2' AND `model`='pjNotification' AND `foreign_id` = 4;
UPDATE `multi_lang` SET `content` = 'A new job has been posted. <br/><br/>Reference ID: {refid}<br/><br/>Edit the job ad here: {editjoburl}<br/><br/>Thank you!' WHERE `field` = 'message3' AND `model`='pjNotification' AND `foreign_id` = 4;
UPDATE `multi_lang` SET `content` = 'Dear {fname},<br/><br/>your password is: {password}<br/> <br/>Thank you' WHERE `field` = 'message4' AND `model`='pjNotification' AND `foreign_id` = 4;

COMMIT;