Merge branch 'master' of github.com:kivitendo/kivitendo-erp

[kivitendo-erp.git] / 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
index 3382a58b3596d5734990e05548832dfeb6675d50..feef5aa24725c0a1a765f222e7e1cacfae063137 100644 (file)
--- a/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql
+++ b/sql/Pg-upgrade2/custom_variables_sub_module_not_null.sql
@@ -2,7 +2,7 @@
 -- @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;