
START TRANSACTION;

ALTER TABLE `applications` CHANGE `status` `status` enum('N','T','F') NOT NULL DEFAULT 'N';

INSERT IGNORE INTO `multi_lang` (`id`, `foreign_id`, `model`, `locale`, `field`, `content`, `source`) VALUES
(NULL, 5, 'pjNotification', '::LOCALE::', 'subject5', 'Employee account', 'script'),
(NULL, 5, 'pjNotification', '::LOCALE::', 'message5', '<p>Dear {fname}, <br /><br /> Your account has been created: <br /> First name: {fname}<br /> Last name: {lname}<br /> Email: {email}<br /> Password: {password}<br /><br /> Thank you!</p>', 'script'),
(NULL, 6, 'pjNotification', '::LOCALE::', 'subject6', 'Employer account', 'script'),
(NULL, 6, 'pjNotification', '::LOCALE::', 'message6', '<p>Dear {contactname}<br /><br /> Your employer account has been created:<br />Company name: {companyname}<br /> Contact name: {contactname}<br /> Email address: {email}<br /> Password: {password}<br /><br /> Thank you!</p>', 'script');

COMMIT;