From c32b4768eeda94d906abf14b40cd8252f9dab8d7 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Wed, 18 May 2016 12:27:38 +0200 Subject: [PATCH] =?utf8?q?fixt#165=20shippingdates=20in=20inventory=20nach?= =?utf8?q?tr=C3=A4glich=20setzen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql diff --git a/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql b/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql new file mode 100644 index 000000000..64fbc7571 --- /dev/null +++ b/sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql @@ -0,0 +1,6 @@ +-- @tag: inventory_fix_shippingdate_assemblies +-- @description: Shippingdate für assemblies und assembly_items nachträglich wie itime setzen. +-- @depends: release_3_4_0 warehouse transfer_type_assembled +-- @encoding: utf-8 +update inventory set shippingdate = itime where comment ilike 'Verbraucht %' and shippingdate is null; +update inventory set shippingdate = itime where shippingdate is null and parts_id in (select id from parts where assembly); -- 2.20.1