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=b989d7cfb4bd8de5c3e290b8df0519ad34d5dd0c;hp=feef5aa24725c0a1a765f222e7e1cacfae063137;hpb=7b6a3af9cc51b982853b572028acc58c8349e2b6;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 '';