
START TRANSACTION;

INSERT INTO `notifications` (`id`) VALUES
(5),
(6);

INSERT INTO `options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_employee_confirmed', 1, 'auto|manual|no::auto', 'Automatically|Manually|Not confirmed', 'enum', 8, 1, NULL),
(1, 'o_employer_confirmed', 2, 'auto|manual|no::auto', 'Automatically|Manually|Not confirmed', 'enum', 2, 1, NULL);

UPDATE `options` SET `is_visible` = '0' WHERE `key` = "o_is_employee_confirmed";
UPDATE `options` SET `is_visible` = '0' WHERE `key` = "o_is_employer_confirmed";

INSERT INTO `fields` VALUES (NULL, 'opt_o_employee_confirmed', 'backend', 'Options / Employee account is confirmed', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employee account is confirmed', 'script');

INSERT INTO `fields` VALUES (NULL, 'opt_o_employer_confirmed', 'backend', 'Options / Employer account is confirmed', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employer account is confirmed', 'script');


INSERT INTO `fields` VALUES (NULL, 'notifications_ARRAY_5', 'arrays', 'notifications_ARRAY_5', 'script', '2017-03-08 06:51:47');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employee account confirmation', 'script');

INSERT INTO `fields` VALUES (NULL, 'notifications_ARRAY_6', 'arrays', 'notifications_ARRAY_6', 'script', '2017-03-08 06:52:07');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employer account confirmation', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_tokens_ARRAY_5', 'arrays', 'notify_tokens_ARRAY_5', 'script', '2017-03-08 06:52:51');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'available tokens:\r\n<br/>\r\n{fname}\r\n<br/>\r\n{lname}\r\n<br/>\r\n{email}\r\n<br/>\r\n{password}', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_tokens_ARRAY_6', 'arrays', 'notify_tokens_ARRAY_6', 'script', '2017-03-08 06:56:07');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'available tokens:\r\n<br/>\r\n{companyname}\r\n<br/>\r\n{contactname}\r\n<br/>\r\n{email}\r\n<br/>\r\n{password}', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_titles_ARRAY_5', 'arrays', 'notify_titles_ARRAY_5', 'script', '2017-03-08 06:57:48');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employee account confirmation', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_titles_ARRAY_6', 'arrays', 'notify_titles_ARRAY_6', 'script', '2017-03-08 06:58:06');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Employer account confirmation', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_bodies_ARRAY_5', 'arrays', 'notify_bodies_ARRAY_5', 'script', '2017-03-08 07:00:18');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'This email will be sent to employees after their accounts created. However, this email only work in condition the option "Employee account is confirmed" set to "Manually". ', 'script');

INSERT INTO `fields` VALUES (NULL, 'notify_bodies_ARRAY_6', 'arrays', 'notify_bodies_ARRAY_6', 'script', '2017-03-08 07:00:51');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'This email will be sent to employers after their accounts created. However, this email only work in condition the option "Employer account is confirmed" set to "Manually". ', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_candidate_reg_ARRAY_3', 'arrays', 'front_candidate_reg_ARRAY_3', 'script', '2017-03-08 07:07:16');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Your account has been created, you need to check your mail box and follow the link to activate your account.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_employer_reg_ARRAY_4', 'arrays', 'front_employer_reg_ARRAY_4', 'script', '2017-03-08 07:09:29');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Your account has been created. You need to check your mail box and follow the link to activate your account.', 'script');

COMMIT;