Gültigkeit von custom variables nur für Artikelstammdaten speichern

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

diff --git a/sql/Pg-upgrade2/invalid_entries_in_custom_variables_validity.sql b/sql/Pg-upgrade2/invalid_entries_in_custom_variables_validity.sql
new file mode 100644 (file)
index 0000000..62dd944
--- /dev/null
+++ b/sql/Pg-upgrade2/invalid_entries_in_custom_variables_validity.sql
@@ -0,0 +1,9 @@
+-- @tag: invalid_entries_in_custom_variables_validity
+-- @description: Ungültige Einträge in custom_variables_validity bereinigen
+-- @depends: release_2_6_1
+-- @charset: utf-8
+DELETE FROM custom_variables_validity
+WHERE trans_id NOT IN (
+  SELECT id
+  FROM parts
+);