X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustom_variables_parts_services_assemblies.sql;h=5ca6792843d99d369196e3405242988e8a8aeef7;hb=c781fb44ddffd751ae494781cbd239c44c844e15;hp=c4457930c6950c64a092203711dcc00e42f91ece;hpb=40ad4ed60117136ba3e181e3e4001255e082ff17;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql b/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql index c4457930c..5ca679284 100644 --- a/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql +++ b/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql @@ -2,3 +2,5 @@ -- @description: Benutzerdefinierte Variablen für Waren, Dienstleistungen, Erzeugnisse. -- @depends: release_2_6_0 ALTER TABLE custom_variable_configs ADD COLUMN flags text; +ALTER TABLE custom_variables ADD COLUMN sub_module text; +UPDATE custom_variables SET sub_module = '';