]> wagnertech.de Git - mfinanz.git/blob - sql/Pg-upgrade2/invalid_entries_in_custom_variables_validity.sql
AR/IR/OE - Steuerbeschreibung an Oberfläche / Druck aus tax_id holen
[mfinanz.git] / sql / Pg-upgrade2 / invalid_entries_in_custom_variables_validity.sql
1 -- @tag: invalid_entries_in_custom_variables_validity
2 -- @description: Ungültige Einträge in custom_variables_validity bereinigen
3 -- @depends: release_2_6_1
4 DELETE FROM custom_variables_validity
5 WHERE trans_id NOT IN (
6   SELECT id
7   FROM parts
8 );