From fbb89b3bd85135f9c95369b3995665607116d2d0 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 25 Jul 2008 16:23:15 +0000 Subject: [PATCH] Das Feld "transaction_description" gibt es auch in der Tabelle "delivery_orders". --- sql/Pg-upgrade2/transaction_description_not_null.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/Pg-upgrade2/transaction_description_not_null.sql b/sql/Pg-upgrade2/transaction_description_not_null.sql index 2758d6865..54530e818 100644 --- a/sql/Pg-upgrade2/transaction_description_not_null.sql +++ b/sql/Pg-upgrade2/transaction_description_not_null.sql @@ -1,6 +1,7 @@ -- @tag: transaction_description_not_null -- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten. --- @depends: transaction_description +-- @depends: transaction_description delivery_orders UPDATE ap SET transaction_description = '' WHERE transaction_description IS NULL; UPDATE ar SET transaction_description = '' WHERE transaction_description IS NULL; UPDATE oe SET transaction_description = '' WHERE transaction_description IS NULL; +UPDATE delivery_orders SET transaction_description = '' WHERE transaction_description IS NULL; -- 2.20.1