Kosmetikmerge aus Revisionen 5187, 5191, 5193, 5194, 5218, 5219, 5222, 5228, 5229

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

-- @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);