DELIMITER &&
CREATE TRIGGER aging BEFORE INSERT ON zapornik_kazen
FOR EACH ROW
BEGIN
    IF ((YEAR(CURDATE()) - YEAR(zacetek))>110) THEN
       SET NEW.ziveci = "NE";

    END IF;
    END;
&&



DELIMITER //
 CREATE PROCEDURE zapornik_kazen (stevilo INT)
 BEGIN
 DECLARE stevec INT;
 DECLARE zacetek DATETIME;
 DECLARE konec_kazni DATETIME;
 DECLARE zapornik_ID_zapornik INT;
 DECLARE ziveci VARCHAR(10);
 DECLARE zapornik_zapo_oddelek_ID_ZAPO_ODDELEK INT;
 DECLARE zapornik_soba_ID_SOBA INT;
 DECLARE kazen_ID_KAZEN INT;
 DECLARE konec_kurz INT DEFAULT 0;
 DECLARE zacetek_kurz CURSOR FOR SELECT ID_ZAPORNIK from zapornik ORDER BY RAND() LIMIT 100;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET konec_kurz=1;

 OPEN zacetek_kurz;

 zacni_loop: LOOP
 FETCH zacetek_kurz INTO zapornik_ID_zapornik;
 IF konec_kurz = 1 THEN LEAVE zacni_loop;
 END IF;
SET stevec=1;
 WHILE stevec<=FLOOR(stevilo/100) DO
  SET zacetek= NOW() - INTERVAL FLOOR(RAND() * (1000-1+1))+1 MONTH;
  SET konec_kazni= zacetek + INTERVAL FLOOR(RAND() * 1000) DAY;
  SET zapornik_zapo_oddelek_ID_ZAPO_ODDELEK=FLOOR(RAND() (SELECT COUNT() FROM zapo_oddelek)) + 1;
  SET zapornik_soba_ID_SOBA=FLOOR(RAND() (SELECT COUNT() FROM soba)) + 1;
  SET kazen_ID_KAZEN=FLOOR(RAND() (SELECT COUNT() FROM kazen)) + 1;
  SET ziveci="DA";


 INSERT INTO zapornik_kazen(zapornik_ID_zapornik ,  zapornik_zapo_oddelek_ID_ZAPO_ODDELEK  ,  zapornik_soba_ID_SOBA,`kazen_ID_KAZEN`,`konec_kazni`,`zacetek`,`ziveci`) VALUE (zapornik_ID_zapornik,zapornik_zapo_oddelek_ID_ZAPO_ODDELEK,zapornik_soba_ID_SOBA,kazen_ID_KAZEN, konec_kazni  ,  zacetek , ziveci);
 SET stevec=stevec+1;
 END WHILE;
 END LOOP;
 CLOSE zacetek_kurz;
 END //

ko tole zazenem pa dobim da je unknown column zacetek in field list