X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/40ad4ed60117136ba3e181e3e4001255e082ff17..66fcb1c6c46c36bd30cb6fdcca4a43e7c57c1ac6:/sql/Pg-upgrade2/custom_variables_parts_services_assemblies.sql 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 = '';