manueller Rechnungsversand per E-Mail. Vorbelegung mandantenweit konfigurierbar

[kivitendo-erp.git] / sql / Pg-upgrade2 / tax_id_if_taxkey_is_0.sql

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 3df341430f13eb1649b0790b8cd6dde3ac8fda0b..a3eaf4d75e2e7d7bcbbc7823034067c07d825a05 100644 (file)
--- 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;