kivitendo/sql/Pg-upgrade2/invalid_taxkeys.sql @ 7b1da9c3
| 980877a3 | Moritz Bunkus | -- @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);
|