TRIGGER EXO 7

--DELIMITER $$
CREATE TRIGGER Trig_After_DI_Install8
after INSERT OR DELETE ON Install
FOR each ROW BEGIN

    -- Insert action
    IF INSERTING THEN

        UPDATE Workstation SET nbsoft = nbsoft+1
        WHERE NWStation = :NEW.NWStation;

        UPDATE Software SET nbinstall = nbinstall+1
        WHERE NSoft = :NEW.NSoft;

    --DELETE action
    ELSE IF DELETING THEN
        UPDATE Workstation SET nbsoft = nbsoft-1
        WHERE NWStation = :OLD.NWStation;

        UPDATE Software SET nbinstall = nbinstall-1
        WHERE NSoft = :OLD.NSoft;
    END IF;
    END IF;


END;
--DELIMITER ;