Langtext-Dialog: Größe prozentual zum Hauptfenster einstellbar pro Benutzer

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

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 cc4b7cf..8a41f7b 100644 (file)
--- 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);