From 001ff85869942b7b69b27438afc4a4d49b9e464a Mon Sep 17 00:00:00 2001
From: Niclas Zimmermann <niclas@kivitendo-premium.de>
Date: Tue, 12 Mar 2013 11:41:05 +0100
Subject: [PATCH] Alte Trigger anpassen

Die Tabellen vendortax und customertax wurden in Commit 9f07753b
entfernt. Allerdings mussten die Trigger del_vendor() und
del_customer() noch angepasst werden.

Behebt Bug #2201.
---
 sql/Pg-upgrade2/delete_cust_vend_tax.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 sql/Pg-upgrade2/delete_cust_vend_tax.sql

diff --git a/sql/Pg-upgrade2/delete_cust_vend_tax.sql b/sql/Pg-upgrade2/delete_cust_vend_tax.sql
new file mode 100644
index 000000000..386e84c43
--- /dev/null
+++ b/sql/Pg-upgrade2/delete_cust_vend_tax.sql
@@ -0,0 +1,17 @@
+-- @tag: delete_cust_vend_tax
+-- @description: Alte Tabellen löschen
+-- @depends: delete_customertax_vendortax_partstax
+-- @charset: utf-8
+
+CREATE OR REPLACE FUNCTION del_customer() RETURNS "trigger" AS
+  'BEGIN
+     DELETE FROM shipto WHERE trans_id = old.id;
+     RETURN NULL;
+   END;' LANGUAGE plpgsql;
+
+CREATE OR REPLACE FUNCTION del_vendor() RETURNS "trigger" AS
+  'BEGIN
+    DELETE FROM shipto WHERE trans_id = old.id;
+    RETURN NULL;
+  END;' LANGUAGE plpgsql;
+
-- 
2.20.1