CREATE DEFINER = 'root'@'localhost' PROCEDURE `proc`(
        IN `nomenclature_id` INTEGER(11),
        IN `discount_type` BIGINT(20),
        IN `item` VARCHAR(40)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT INTO `ukmserver`.`trm_in_disc_std_items_n_plus_m` (`nomenclature_id`, `item`, `discount_type`, `quantity_paid`, `quantity_without_paid`, `modificator`, `version`, `deleted`)
 VALUES ('nomenclature_id', 'item', 'discount_type', '0.0000', '1.0000', '-0%', '0', '0');
END;

SET @nomenclature_id = 1;
SET @discount_type = 121;

SET @item1 = '07889';
SET @item2 = '100974';
SET @item3 = '59538';
SET @item4 = '72761';

INSERT INTO `ukmserver`.`trm_in_disc_std_items_n_plus_m` (`nomenclature_id`, `item`, `discount_type`, `quantity_paid`, `quantity_without_paid`, `modificator`, `version`, `deleted`) VALUES (@nomenclature_id, @item1, @discount_type, '0.0000', '1.0000', '-0%', '0', '0');
INSERT INTO `ukmserver`.`trm_in_disc_std_items_n_plus_m` (`nomenclature_id`, `item`, `discount_type`, `quantity_paid`, `quantity_without_paid`, `modificator`, `version`, `deleted`) VALUES (@nomenclature_id, @item2, @discount_type, '0.0000', '1.0000', '-0%', '0', '0');
INSERT INTO `ukmserver`.`trm_in_disc_std_items_n_plus_m` (`nomenclature_id`, `item`, `discount_type`, `quantity_paid`, `quantity_without_paid`, `modificator`, `version`, `deleted`) VALUES (@nomenclature_id, @item3, @discount_type, '0.0000', '1.0000', '-0%', '0', '0');
INSERT INTO `ukmserver`.`trm_in_disc_std_items_n_plus_m` (`nomenclature_id`, `item`, `discount_type`, `quantity_paid`, `quantity_without_paid`, `modificator`, `version`, `deleted`) VALUES (@nomenclature_id, @item4, @discount_type, '0.0000', '1.0000', '-0%', '0', '0');