START TRANSACTION;

ALTER TABLE `requests` ADD COLUMN `type_on_request` smallint(5) DEFAULT '1';

INSERT INTO `plugin_base_fields` VALUES (NULL, 'lblRequestsTypeOnRequest', 'backend', 'Label / Type of on request', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Type of on request', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'type_of_on_request_ARRAY_1', 'arrays', 'type_of_on_request_ARRAY_1', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'ON REQUEST CLASSIC', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'type_of_on_request_ARRAY_2', 'arrays', 'type_of_on_request_ARRAY_2', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'SOLD OUT', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'front_sold_out', 'frontend', 'Label / Sold-out', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Sold-out', 'script');


COMMIT;