X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustom_variables_parts_services_assemblies.sql;h=c785912c61b62b39e9d7987fe3c7bbf1ac1b06bc;hb=142ea3bff784ba29bd87de5615bb4f2aec8c977f;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..c785912c6 100644 --- a/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql +++ b/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql @@ -1,4 +1,6 @@ -- @tag: custom_variables_parts_services_assemblies --- @description: Benutzerdefinierte Variablen für Waren, Dienstleistungen, Erzeugnisse. +-- @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 = '';