1 -- @tag: ar_ap_gl_delete_triggers_deletion_from_acc_trans
2 -- @description: Beim Löschen aus ar, ap, gl per Trigger auch dazugehörige Einträge aus acc_trans löschen
3 -- @depends: release_3_0_0
4 CREATE OR REPLACE FUNCTION clean_up_acc_trans_after_ar_ap_gl_delete() RETURNS trigger AS $$
6 DELETE FROM acc_trans WHERE trans_id = OLD.id;
11 CREATE TRIGGER after_delete_ar_trigger
12 AFTER DELETE ON ar FOR EACH ROW EXECUTE
13 PROCEDURE clean_up_acc_trans_after_ar_ap_gl_delete();
15 CREATE TRIGGER after_delete_ap_trigger
16 AFTER DELETE ON ap FOR EACH ROW EXECUTE
17 PROCEDURE clean_up_acc_trans_after_ar_ap_gl_delete();
19 CREATE TRIGGER after_delete_gl_trigger
20 AFTER DELETE ON gl FOR EACH ROW EXECUTE
21 PROCEDURE clean_up_acc_trans_after_ar_ap_gl_delete();