-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE: td_sga_comisiones
-- Tabla: sga_comisiones
-- Version: 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP FUNCTION ftdb_sga_comisiones ();
CREATE OR REPLACE FUNCTION ftdb_sga_comisiones () RETURNS trigger AS 
$BODY$
   
BEGIN
   -- Borro la evaluacion automática de la comision.
   DELETE FROM sga_evaluaciones 
      WHERE entidad = OLD.entidad
        AND evaluacion_tipo IN (SELECT evaluacion_tipo 
                               FROM sga_evaluaciones_tipos 
                              WHERE aplica_a = 'C' 
                                AND automatica = 'S');

   -- Borro tabla de cupos de la comision
   DELETE FROM sga_comisiones_cupo 
         WHERE comision = OLD.comision;

   -- Borro tabla de excepciones de asistencia por alumno.
   DELETE FROM sga_alumnos_excep_asistencia
         WHERE comision = OLD.comision;

   RETURN OLD;
END;
$BODY$
LANGUAGE 'plpgsql';


-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE sobre sga_comisiones
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tdb_sga_comisiones ON sga_comisiones RESTRICT;
CREATE TRIGGER tdb_sga_comisiones
       BEFORE DELETE ON sga_comisiones 
       FOR EACH ROW EXECUTE PROCEDURE ftdb_sga_comisiones();