X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=sql%2FPg-upgrade2%2Fcustom_variables_sub_module_not_null.sql;h=37d249164d3979b0119accd6051c8fd571f5a894;hb=321bd6025faf943442b6a125faa30cfaee34fdda;hp=3382a58b3596d5734990e05548832dfeb6675d50;hpb=dc1dd39444b4b2c4b194ca6a4f52017c8aee614e;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql
index 3382a58b3..37d249164 100644
--- a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql
+++ b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql
@@ -1,8 +1,7 @@
 -- @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 = '';
+UPDATE custom_variables SET sub_module = '' WHERE sub_module IS NULL;
 ALTER TABLE custom_variables ALTER COLUMN sub_module SET DEFAULT '';
 ALTER TABLE custom_variables ALTER COLUMN sub_module SET NOT NULL;