
START TRANSACTION;

ALTER TABLE `bookings` ADD COLUMN `vacct_no` varchar(255) DEFAULT NULL AFTER `bankCd`;

INSERT INTO `fields` VALUES (NULL, 'front_messages_ARRAY_9', 'arrays', 'front_messages_ARRAY_9', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Your booking is saved and your payment was successfull.', 'script');

COMMIT;