
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "receive_emails_ARRAY_confirm");
UPDATE `multi_lang` SET `content` = 'Booking confirmation email - all calendars' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "receive_emails_ARRAY_payment");
UPDATE `multi_lang` SET `content` = 'Payment confirmation email - all calendars' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "receive_emails_ARRAY_reminder");
UPDATE `multi_lang` SET `content` = 'Booking reminder email - all calendars' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "receive_emails_ARRAY_cancel");
UPDATE `multi_lang` SET `content` = 'Booking cancellation email - all calendars' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

INSERT INTO `fields` VALUES (NULL, 'receive_emails_ARRAY_myconf', 'arrays', 'receive_emails_ARRAY_myconf', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Booking confirmation email - my calendars', 'script');

INSERT INTO `fields` VALUES (NULL, 'receive_emails_ARRAY_mypay', 'arrays', 'receive_emails_ARRAY_mypay', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Payment confirmation email - my calendars', 'script');

INSERT INTO `fields` VALUES (NULL, 'receive_emails_ARRAY_myremind', 'arrays', 'receive_emails_ARRAY_myremind', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Booking reminder email - my calendars', 'script');

INSERT INTO `fields` VALUES (NULL, 'receive_emails_ARRAY_mycan', 'arrays', 'receive_emails_ARRAY_mycan', 'script', '2016-11-28 08:53:03');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Booking cancellation email - my calendars', 'script');

COMMIT;