X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fchart_names.sql;h=4f3780e513da0e8a56e7517eb60dbe5716490097;hb=1d99e3e9537f75342a9f20f1e89a3e8cb4bb5444;hp=55a2e31444657fc1a8758ddcafd39648d0bd4b7f;hpb=72df4319989c030a3beb476528114ea8784e16aa;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/chart_names.sql b/sql/Pg-upgrade2/chart_names.sql index 55a2e3144..4f3780e51 100644 --- a/sql/Pg-upgrade2/chart_names.sql +++ b/sql/Pg-upgrade2/chart_names.sql @@ -2,10 +2,10 @@ -- @description: Behebt ein paar Schreibfehler in Kontennamen in den Kontenramen SKR03 und SKR04. -- @depends: UPDATE chart - SET description = replace(description, 'Saldenverträge', 'Saldenvorträge') + SET description = replace(description, 'Saldenverträge', 'Saldenvorträge') WHERE ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND - (description LIKE 'Saldenverträge%'); + (description LIKE 'Saldenverträge%'); UPDATE chart SET description = replace(description, 'Abziebare', 'Abziehbare') WHERE