DbUpgrade Templates für SKR04-3804-addition.pl kompatibel für Lx 2.7 gemacht

[mfinanz.git] / sql / Pg-upgrade2 / invalid_taxkeys.sql

-- @tag: invalid_taxkesy
-- @description: Ungültige Steuerschlüssel in den Kontenrahmendefinitionen und daraus resultierende falsche Einträge in anderen Tabellen werden korrigiert.
-- @depends: tax_primary_key_taxkeys_foreign_keys
UPDATE chart SET taxkey_id = 0 WHERE taxkey_id NOT IN (SELECT DISTINCT taxkey_id FROM taxkeys);
UPDATE taxkeys SET taxkey_id = 0, tax_id = 0 WHERE taxkey_id NOT IN (SELECT DISTINCT taxkey_id FROM taxkeys);