
START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'front_booking_status_ARRAY_4', 'arrays', 'front_booking_status_ARRAY_4', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Booking not found.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_booking_status_ARRAY_3', 'arrays', 'front_booking_status_ARRAY_3', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'The booking was already paid.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_booking_status_ARRAY_5', 'arrays', 'front_booking_status_ARRAY_5', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Invoice not found.', 'script');

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_booking_status_ARRAY_1");
UPDATE `multi_lang` SET `content` = 'Booking has been made.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;