
START TRANSACTION;


INSERT INTO `options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_allow_redsys', 7, '1|0::1', NULL, 'bool', 30, 1, NULL),
(1, 'o_redsys_key', 7, '', NULL, 'string', 31, 1, NULL),
(1, 'o_redsys_code', 7, '', NULL, 'string', 32, 1, NULL),
(1, 'o_redsys_terminal', 7, '', NULL, 'string', 33, 1, NULL);

ALTER TABLE `bookings` CHANGE `payment_method` `payment_method` enum('paypal','authorize','creditcard','bank','three_step_redirect','redsys') DEFAULT NULL;


INSERT INTO `fields` VALUES (NULL, 'payment_methods_ARRAY_redsys', 'arrays', 'payment_methods_ARRAY_redsys', 'script', '2016-12-16 04:31:40');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Redsys payment', 'script');

INSERT INTO `fields` VALUES (NULL, 'opt_o_allow_redsys', 'backend', 'Options / Allow Redsys payment', 'script', '2016-12-16 04:36:23');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Allow Redsys payment', 'script');

INSERT INTO `fields` VALUES (NULL, 'opt_o_redsys_key', 'backend', 'Options / Redsys key', 'script', '2016-12-16 04:37:00');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Redsys key', 'script');

INSERT INTO `fields` VALUES (NULL, 'opt_o_redsys_code', 'backend', 'Options / Redsys key', 'script', '2016-12-16 04:52:28');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'FUC Code assigned to the merchant', 'script');

INSERT INTO `fields` VALUES (NULL, 'opt_o_redsys_terminal', 'backend', 'Options / Redsys key', 'script', '2016-12-16 04:54:18');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Terminal number which is assigned\r\nby the bank.', 'script');

INSERT INTO `fields` VALUES (NULL, 'front_booking_statuses_ARRAY_12', 'arrays', 'front_booking_statuses_ARRAY_12', 'script', '2016-12-16 04:54:18');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Please wait while redirect to secure payment processor webpage complete...', 'script');



COMMIT;