projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Verknüpfte Belege: Implementation "Verknüpfungen löschen"
[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
-- @charset: utf-8
5
UPDATE chart
6
SET taxkey_id = (
7
SELECT taxkey_id
8
FROM taxkeys
9
WHERE taxkeys.chart_id = chart.id
10
ORDER BY startdate DESC
11
LIMIT 1
12
);