START TRANSACTION;

  ALTER TABLE `modify_prices` ADD `apply_to` ENUM('default','custom','both') NOT NULL DEFAULT 'both' AFTER `type`;

  INSERT INTO `plugin_base_fields` VALUES (NULL, 'lblModifyPricesApplyTo', 'backend', 'Label / Modify Prices Apply To', 'script', NULL);
  SET @id := (SELECT LAST_INSERT_ID());
  INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Apply to', 'script');

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

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

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

  INSERT INTO `plugin_base_fields` VALUES (NULL, 'front_2_sort_name_asc', 'backend', 'Label / Sort by name', 'script', NULL);
  SET @id := (SELECT LAST_INSERT_ID());
  INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Name (Low to High)', 'script');

COMMIT;