X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade%2FPg-upgrade-2.2.0.25-2.2.0.26.pl;h=eec34d0c50a2fffd91d5df42ac9dc8a96e70a673;hb=7ec334735373f140fb8ab48d9cdbe8dedecd99d0;hp=ef057d9b08ac0c91876e05b4ee9fa915be06e23b;hpb=6ec6983b3e72953c1e0a50d31a7e93c0c8b13a33;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.25-2.2.0.26.pl b/sql/Pg-upgrade/Pg-upgrade-2.2.0.25-2.2.0.26.pl index ef057d9b0..eec34d0c5 100644 --- a/sql/Pg-upgrade/Pg-upgrade-2.2.0.25-2.2.0.26.pl +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0.25-2.2.0.26.pl @@ -123,7 +123,7 @@ sub update_units_steps_1_2 { " unit IN (SELECT name FROM units))"; } else { - $query = "SELECT t.unit, p.inventory_accno_id " . + $query = "SELECT t.unit, p.inventory_accno_id, p.assembly " . "FROM $table t " . "LEFT JOIN parts p ON p.id = t.parts_id " . "WHERE NOT ((t.unit = '') OR t.unit ISNULL OR " .