projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Kosmetik: Ausrichtung
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
tax_id_if_taxkey_is_0.sql
1
-- @tag: tax_id_if_taxkey_is_0
2
-- @description: Aktualisierung der Spalte tax.id, wenn tax.taxkey = 0 ist.
3
-- @depends:
4
UPDATE tax SET id = 0 WHERE taxkey = 0;
5
UPDATE taxkeys SET tax_id = 0 WHERE taxkey_id = 0;