X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftax_primary_key_taxkeys_foreign_keys.sql;h=8a41f7b2364b29fb4e5d09de0aa4cce4a4d6028a;hb=94f5cb152afa9210162295b6727801c296af0631;hp=cc4b7cf0ae708f9c3c993a58640310e8bbdb762f;hpb=f9504bdd4a868b62b545e42dc3ca374c988dc647;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/tax_primary_key_taxkeys_foreign_keys.sql b/sql/Pg-upgrade2/tax_primary_key_taxkeys_foreign_keys.sql
index cc4b7cf0a..8a41f7b23 100644
--- a/sql/Pg-upgrade2/tax_primary_key_taxkeys_foreign_keys.sql
+++ b/sql/Pg-upgrade2/tax_primary_key_taxkeys_foreign_keys.sql
@@ -1,5 +1,6 @@
 -- @tag: tax_primary_key_taxkeys_foreign_keys
 -- @description: Legt in tax einen neuen Primärschlüssel und in taxkeys einen neuen Fremdschlüssel auf tax an.
 -- @depends: tax_id_if_taxkey_is_0
+UPDATE taxkeys SET tax_id = 0 WHERE taxkey_id = 0;
 ALTER TABLE tax ADD PRIMARY KEY (id);
 ALTER TABLE taxkeys ADD FOREIGN KEY (tax_id) REFERENCES tax (id);