
START TRANSACTION;

UPDATE `options` SET `value`='1|0::1' WHERE `key`='o_seo_url';

ALTER TABLE `services` ADD COLUMN `order` int(10) DEFAULT NULL;

INSERT INTO `plugin_base_fields` VALUES (NULL, 'service_order', 'backend', 'Label / Order', 'script', '2015-03-20 11:37:44');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Order', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'front_time_slots', 'frontend', 'Label / Time slots', 'script', '2015-03-20 11:37:44');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Time slots', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'front_no_timeslots_available', 'frontend', 'Label / No time slots available', 'script', '2015-03-20 11:37:44');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Sorry, we cannot provide any time slots. Please reduce the selection of the services or call us on tel 123-456-789', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'front_accept_booking_days_ahead_msg', 'frontend', 'Label / Accept bookings X day(s) ahead', 'script', '2015-03-20 11:37:44');
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Accept bookings %d day(s) ahead', 'script');

    

COMMIT;