X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/5609a646164465de4a4217a2757c27d4c0b6bcee..2bfb8a5019d8b97fbbe2efb83da959eb66f458f1:/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
index 000000000..62dd9447e
--- /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
+);