X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftaxzone_id_in_oe_delivery_orders.sql;h=5c22135becf8663715f76fc76efcdfe9b97931f1;hb=ddec2dcd58e019a3386dce322985da9bec0c9501;hp=00a654e5ab3404c427392f8fc323c923169042ab;hpb=89360aadb2c3e0854a2815e5d0ed8a9efd1c5889;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql b/sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql
index 00a654e5a..5c22135be 100644
--- a/sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql
+++ b/sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql
@@ -1,6 +1,6 @@
 -- @tag: taxzone_id_in_oe_delivery_orders
 -- @description: Werte für Inland in Spalte taxzone_id in Tabellen oe und delivery_orders in Foreign Key zu tax_zones konvertieren; NULL-Werte in ap/ar verhindern; Spalten NOT NULL setzen
--- @depends: change_taxzone_id_0
+-- @depends: change_taxzone_id_0 remove_obsolete_trigger
 
 UPDATE oe              SET taxzone_id = (SELECT id FROM tax_zones WHERE description = 'Inland') WHERE (taxzone_id = 0) OR (taxzone_id IS NULL);
 UPDATE delivery_orders SET taxzone_id = (SELECT id FROM tax_zones WHERE description = 'Inland') WHERE (taxzone_id = 0) OR (taxzone_id IS NULL);