sql/Pg-upgrade2/cleanup_after_customer_vendor_deletion.sql

   1 -- @tag: cleanup_after_customer_vendor_deletion
   2 -- @description: Nach Löschen von Kunden/Lieferanten via Trigger auch Ansprechpersonen/Lieferadressen löschen
   3 -- @depends: release_3_0_0
   4 CREATE OR REPLACE FUNCTION clean_up_after_customer_vendor_delete() RETURNS trigger AS $$
   5   BEGIN
   6     DELETE FROM contacts
   7     WHERE cp_cv_id = OLD.id;
   8
   9     DELETE FROM shipto
  10     WHERE (trans_id = OLD.id)
  11       AND (module   = 'CT');
  12
  13     RETURN OLD;
  14   END;
  15 $$ LANGUAGE plpgsql;
  16
  17 CREATE TRIGGER after_delete_customer_trigger
  18 AFTER DELETE ON customer FOR EACH ROW EXECUTE
  19 PROCEDURE clean_up_after_customer_vendor_delete();
  20
  21 CREATE TRIGGER after_delete_vendor_trigger
  22 AFTER DELETE ON vendor FOR EACH ROW EXECUTE
  23 PROCEDURE clean_up_after_customer_vendor_delete();