X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcleanup_after_customer_vendor_deletion.sql;h=a1a08be71b50e1fdb54e58aa96e6e09da2509750;hb=30b4a78c4100ebdcd6e6917fbcbf1d12f4f7b4d6;hp=76d68b7a732df5beec5761a2b2e1f6346cc21b13;hpb=7691e04ba5188a2b77761ffff8364728ff6cce52;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/cleanup_after_customer_vendor_deletion.sql b/sql/Pg-upgrade2/cleanup_after_customer_vendor_deletion.sql index 76d68b7a7..a1a08be71 100644 --- a/sql/Pg-upgrade2/cleanup_after_customer_vendor_deletion.sql +++ b/sql/Pg-upgrade2/cleanup_after_customer_vendor_deletion.sql @@ -1,7 +1,6 @@ -- @tag: cleanup_after_customer_vendor_deletion -- @description: Nach Löschen von Kunden/Lieferanten via Trigger auch Ansprechpersonen/Lieferadressen löschen -- @depends: release_3_0_0 --- @charset: utf-8 CREATE OR REPLACE FUNCTION clean_up_after_customer_vendor_delete() RETURNS trigger AS $$ BEGIN DELETE FROM contacts