projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Handle zur LXDebug-Logdatei auch UTF-8 encoden
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
chart_names.sql
diff --git
a/sql/Pg-upgrade2/chart_names.sql
b/sql/Pg-upgrade2/chart_names.sql
index
55a2e31
..
4f3780e
100644
(file)
--- 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
-- @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
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
UPDATE chart
SET description = replace(description, 'Abziebare', 'Abziehbare')
WHERE