From 47b9095415d7e0ee26d82946d08aab4a6b6c17b0 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 30 Apr 2015 12:13:05 +0200 Subject: [PATCH] =?utf8?q?obsoleten=20Trigger=20auf=20oe=20fr=C3=BCher=20l?= =?utf8?q?=C3=B6schen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/remove_obsolete_trigger.sql | 2 -- sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql | 2 +- 2 files changed, 1 insertion(+), 3 deletions(-) diff --git a/sql/Pg-upgrade2/remove_obsolete_trigger.sql b/sql/Pg-upgrade2/remove_obsolete_trigger.sql index db802386d..796573065 100644 --- a/sql/Pg-upgrade2/remove_obsolete_trigger.sql +++ b/sql/Pg-upgrade2/remove_obsolete_trigger.sql @@ -1,7 +1,5 @@ -- @tag: remove_obsolete_trigger -- @description: Entfernt veraltete Trigger check_inventory --- @depends: release_3_2_0 --- @encoding: utf-8 -- drop triggers DROP TRIGGER IF EXISTS check_inventory ON oe; 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); -- 2.20.1