
START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'front_login_employers', 'frontend', 'Label / Login employers', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Login employers', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_login_candidates', 'frontend', 'Label / Login candidates', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Login candidates', 'script');

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_employer_login_intro");
UPDATE `multi_lang` SET `content` = 'Login your employer account to manage jobs and view CVs.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_candidate_login_intro");
UPDATE `multi_lang` SET `content` = 'Login your employee account to edit your profile and easily apply to job offers.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_forgot_password_intro");
UPDATE `multi_lang` SET `content` = 'Enter your email address and password will be sent.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_employer_register_intro");
UPDATE `multi_lang` SET `content` = 'Register for new employer account to manage your job and view CVs.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_candidate_register_intro");
UPDATE `multi_lang` SET `content` = 'Register for new candidate account to manage your profile and easily apply to job offers.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;