Revision c32b4768
Von Jan Büren vor fast 9 Jahren hinzugefügt
| sql/Pg-upgrade2/inventory_fix_shippingdate_assemblies.sql | ||
|---|---|---|
|
-- @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);
|
||
Auch abrufbar als: Unified diff
fixt#165 shippingdates in inventory nachträglich setzen