X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustom_variables_sub_module_not_null.sql;h=37d249164d3979b0119accd6051c8fd571f5a894;hb=04dccca70c47960cd6ea03a4f0ae05a9cbc42c41;hp=feef5aa24725c0a1a765f222e7e1cacfae063137;hpb=5ee95a8f01b5854ca9d5acf5d80c23dbe564c19f;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 feef5aa24..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,6 +1,5 @@ -- @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 = '' WHERE sub_module IS NULL; ALTER TABLE custom_variables ALTER COLUMN sub_module SET DEFAULT '';