
START TRANSACTION;

UPDATE `options` SET `label`='Automatically|Email confirmation|Not confirmed' WHERE `key`='o_employee_confirmed';
UPDATE `options` SET `label`='Automatically|Email confirmation|Not confirmed' WHERE `key`='o_employer_confirmed';

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "notify_bodies_ARRAY_5");
UPDATE `multi_lang` SET `content` = '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 "Email confirmation". ' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "notify_bodies_ARRAY_6");
UPDATE `multi_lang` SET `content` = '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 "Email confirmation". ' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;