START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_enter_err', 'frontend', 'Front Label / Please enter a voucher code.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Please enter a voucher code.', 'script');
				
INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_code_require', 'frontend', 'Front Label / Voucher code is required.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher code is required.', 'script');
				

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_already_invalid', 'frontend', 'Front Label / Voucher already used or invalid.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher already used or invalid.', 'script');
				

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_not_active', 'frontend', 'Front Label / Voucher not active yet.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher not active yet.', 'script');
				

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_expired', 'frontend', 'Front Label / Voucher expired.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher expired.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher_applied', 'frontend', 'Front Label / Voucher applied successfully.', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher applied successfully.', 'script');
				

INSERT INTO `fields` VALUES (NULL, 'front_3_voucher', 'frontend', 'Front Label / Voucher -Prepagato', 'script', '2018-05-31 06:44:09');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Voucher -Prepagato', 'script');
				
ALTER TABLE `bookings`
ADD `voucher_code` VARCHAR(255) NULL,
ADD `voucher_discount` DECIMAL(10,2) NULL,
ADD `voucher_used_on` DATETIME NULL;

COMMIT;
