From 7ec334735373f140fb8ab48d9cdbe8dedecd99d0 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 13 Dec 2006 15:27:31 +0000 Subject: [PATCH] Da fehlte noch eine Spalte. --- sql/Pg-upgrade/Pg-upgrade-2.2.0.25-2.2.0.26.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 " . -- 2.20.1