projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Presenter Code - gl_transaction aus invoice wieder entfernt
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
chart_taxkey_id_from_taxkeys.sql
1
-- @tag: chart_taxkey_id_from_taxkeys
2
-- @description: chart.taxkey_id aus taxkeys aktualisieren
3
-- @depends: release_2_6_2
4
UPDATE chart
5
SET taxkey_id = (
6
SELECT taxkey_id
7
FROM taxkeys
8
WHERE taxkeys.chart_id = chart.id
9
ORDER BY startdate DESC
10
LIMIT 1
11
);