DELIMITER //
CREATE PROCEDURE kazen (stevilo INT)
    BEGIN
        DECLARE ime VARCHAR(45);

        DECLARE vrsta_kaznivega_dejanja_ID_VRSTA_KAZNIVEGA_DEJANJA INT;
        DECLARE soba_ID_SOBA INT;
        DECLARE stevec INT;
        DECLARE maxStevilo INT;

        DECLARE stevec_2 INT;
        DECLARE stevec3 INT;
        DECLARE st_vrstic INT;


        DECLARE konec INT DEFAULT FALSE;
        DECLARE kurzor_1 CURSOR FOR SELECT v.ID_VRSTA_KAZNIVEGA_DEJANJA FROM `zapori`.`vrsta_kaznivega_dejanja` v;
        DECLARE CONTINUE HANDLER FOR NOT FOUND SET konec = TRUE;

        SET stevec = 0;
        SET stevec_2 = 0;
        SET maxStevilo = stevilo;
        SET st_vrstic = (SELECT COUNT(*) FROM `zapori`.`vrsta_kaznivega_dejanja`);


        WHILE stevec_2 <= st_vrstic DO
            OPEN kurzor_1;
            FETCH kurzor_1 INTO vrsta_kaznivega_dejanja_ID_VRSTA_KAZNIVEGA_DEJANJA;

            WHILE (stevec < maxStevilo) DO
                SET ime = "Ime dejanja";
				SET stevec3 =FLOOR((RAND() * (1000-1+1))+1);
                SET soba_ID_SOBA = FLOOR(RAND() * (SELECT COUNT(*) FROM `zapori`.`soba`)) + 1;

                INSERT INTO `zapori`.`kazen` (`vrsta_kaznivega_dejanja_ID_VRSTA_KAZNIVEGA_DEJANJA`, `soba_ID_SOBA`, `ime`) VALUES (vrsta_kaznivega_dejanja_ID_VRSTA_KAZNIVEGA_DEJANJA, soba_ID_SOBA, CONCAT(ime, stevec3));

                SET stevec = stevec + 1;
            END WHILE;

            CLOSE kurzor_1;

        SET stevec_2 = FLOOR((RAND() * (1000-1+1))+1);
        END WHILE;

    END //

DELIMITER ;