projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
a3eaf4d75e2e7d7bcbbc7823034067c07d825a05
[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;