
START TRANSACTION;



ALTER TABLE `services` ADD COLUMN `categories` varchar(255) DEFAULT NULL;

INSERT INTO `plugin_base_fields` VALUES (NULL, 'male_categories_ARRAY_man_short', 'arrays', 'male_categories_ARRAY_man_short', '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', 'Man short', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'male_categories_ARRAY_man_middle', 'arrays', 'male_categories_ARRAY_man_middle', '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', 'Man middle', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'male_categories_ARRAY_man_long', 'arrays', 'male_categories_ARRAY_man_long', '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', 'Man long', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'male_categories_ARRAY_man_beard', 'arrays', 'male_categories_ARRAY_man_beard', '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', 'Man berad', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'female_categories_ARRAY_woman_short', 'arrays', 'female_categories_ARRAY_woman_short', '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', 'Woman short', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'female_categories_ARRAY_woman_middle', 'arrays', 'female_categories_ARRAY_woman_middle', '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', 'Woman middle', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'female_categories_ARRAY_woman_long', 'arrays', 'female_categories_ARRAY_woman_long', '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', 'Woman long', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'child_categories_ARRAY_child', 'arrays', 'child_categories_ARRAY_child', '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', 'Child', 'script');

INSERT INTO `plugin_base_fields` VALUES (NULL, 'lblCategories', 'backend', 'Label / Categories', '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', 'Categories', 'script');

    

COMMIT;