Pasted

-- 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 ;