before_insert_descrEvent.sql

-- Trigger `before_insert_descrEvent` para manejar previo a la insercion de fila
DELIMITER $$

DROP TRIGGER `before_insert_descrEvent`;$$
CREATE
    TRIGGER `before_insert_descrEvent` BEFORE INSERT
    ON `descrEvent`
    FOR EACH ROW BEGIN
        -- DECLARE idBul INT(2);
        -- DECLARE yearEv INT(4);
        -- SELECT YEAR(NEW.fechbull) INTO yearEv;
        SELECT IFNULL(MAX(idbul),0) + 1 FROM descrEvent WHERE evntid = NEW.evntid INTO @idBul;
        SET NEW.idbul = @idBul;
    END$$

DELIMITER ;