X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/1cd8764aa91e783e0884f9caf5d9b72ffff37a34..72df4319989c030a3beb476528114ea8784e16aa:/sql/Pg-upgrade2/chart_names.sql

diff --git a/sql/Pg-upgrade2/chart_names.sql b/sql/Pg-upgrade2/chart_names.sql
new file mode 100644
index 000000000..55a2e3144
--- /dev/null
+++ b/sql/Pg-upgrade2/chart_names.sql
@@ -0,0 +1,13 @@
+-- @tag: chart_names
+-- @description: Behebt ein paar Schreibfehler in Kontennamen in den Kontenramen SKR03 und SKR04.
+-- @depends:
+UPDATE chart
+  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%');
+UPDATE chart
+  SET description = replace(description, 'Abziebare', 'Abziehbare')
+  WHERE
+    ((SELECT coa FROM defaults) IN ('Germany-DATEV-SKR03EU', 'Germany-DATEV-SKR04EU')) AND
+    (description LIKE 'Abziehbare%');
