Merge branch 'master' of github.com:kivitendo/kivitendo-erp

[mfinanz.git] / sql / Pg-upgrade2 / remove_redundant_customer_vendor_delete_triggers.sql

diff --git a/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql b/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql
new file mode 100644 (file)
index 0000000..39c87dc
--- /dev/null
+++ b/sql/Pg-upgrade2/remove_redundant_customer_vendor_delete_triggers.sql
@@ -0,0 +1,12 @@
+-- @tag: remove_redundant_customer_vendor_delete_triggers
+-- @description: Entfernt doppelte/falsche Trigger zum Aufräumen nach dem Löschen von Kunden/Lieferanten
+-- @depends: release_3_1_0
+-- @encoding: utf-8
+
+-- drop triggers
+DROP TRIGGER IF EXISTS del_customer ON customer;
+DROP TRIGGER IF EXISTS del_vendor   ON vendor;
+
+-- drop functions
+DROP FUNCTION IF EXISTS del_customer();
+DROP FUNCTION IF EXISTS del_vendor();