
START TRANSACTION;

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

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

INSERT INTO `fields` VALUES (NULL, 'receive_sms_ARRAY_myconf', 'arrays', 'receive_sms_ARRAY_myconf', 'script', '2016-05-18 07:07:22');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Booking confirmation SMS - my calendars', 'script');

INSERT INTO `fields` VALUES (NULL, 'receive_sms_ARRAY_mypay', 'arrays', 'receive_sms_ARRAY_mypay', 'script', '2016-05-18 07:08:06');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Payment confirmation SMS - my calendars', 'script');

COMMIT;