From 9d3ce6e8de57241dbba95498f8db127410e11752 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 25 Jul 2008 16:21:19 +0000 Subject: [PATCH] =?utf8?q?Das=20Feld=20"transaction=5Fdescription"=20sollt?= =?utf8?q?e=20keine=20NULL-Werte=20enthalten,=20weil=20das=20das=20Sortier?= =?utf8?q?en=20unn=C3=B6tig=20erschwert.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/transaction_description_not_null.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/transaction_description_not_null.sql diff --git a/sql/Pg-upgrade2/transaction_description_not_null.sql b/sql/Pg-upgrade2/transaction_description_not_null.sql new file mode 100644 index 000000000..2758d6865 --- /dev/null +++ b/sql/Pg-upgrade2/transaction_description_not_null.sql @@ -0,0 +1,6 @@ +-- @tag: transaction_description_not_null +-- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten. +-- @depends: transaction_description +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; -- 2.20.1