From dc1dd39444b4b2c4b194ca6a4f52017c8aee614e Mon Sep 17 00:00:00 2001 From: Thomas Heck Date: Mon, 6 Aug 2012 16:51:28 +0200 Subject: [PATCH] =?utf8?q?CSV-Import=20f=C3=BCr=20benutzerdefinierte=20Var?= =?utf8?q?iablen=20gefixt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit behebt #1924 --- sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql diff --git a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql new file mode 100644 index 000000000..3382a58b3 --- /dev/null +++ b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql @@ -0,0 +1,8 @@ +-- @tag: custom_variables_sub_module_not_null +-- @description: sub_module in custom_variables auf NOT NULL ändern. +-- @encoding: utf-8 +-- @depends: release_2_7_0 +UPDATE custom_variables SET sub_module = ''; +ALTER TABLE custom_variables ALTER COLUMN sub_module SET DEFAULT ''; +ALTER TABLE custom_variables ALTER COLUMN sub_module SET NOT NULL; + -- 2.20.1