X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftax_id_if_taxkey_is_0.sql;h=a3eaf4d75e2e7d7bcbbc7823034067c07d825a05;hb=2ae70bd488265cab4a7cef8243b3660f7d35e83e;hp=3df341430f13eb1649b0790b8cd6dde3ac8fda0b;hpb=4fd8bdbfb46b8b63a7d05457959b98c4956d1dbd;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql b/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql
index 3df341430..a3eaf4d75 100644
--- a/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql
+++ b/sql/Pg-upgrade2/tax_id_if_taxkey_is_0.sql
@@ -2,3 +2,4 @@
 -- @description: Aktualisierung der Spalte tax.id, wenn tax.taxkey = 0 ist.
 -- @depends:
 UPDATE tax SET id = 0 WHERE taxkey = 0;
+UPDATE taxkeys SET tax_id = 0 WHERE taxkey_id = 0;