X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/873a9a839d7c51f1dfbfb3a36bd4d7b152a1e818..627503c1d8443acdb4c50362c3981e68564a12d4:/sql/Pg-upgrade2/custom_variables_validity_index.sql

diff --git a/sql/Pg-upgrade2/custom_variables_validity_index.sql b/sql/Pg-upgrade2/custom_variables_validity_index.sql
new file mode 100644
index 000000000..1fb3725da
--- /dev/null
+++ b/sql/Pg-upgrade2/custom_variables_validity_index.sql
@@ -0,0 +1,8 @@
+-- @tag: custom_variables_validity_index
+-- @description: Indizes für Tabelle custom_variables_validity
+-- @depends: release_3_0_0
+CREATE INDEX idx_custom_variables_validity_config_id_trans_id
+ON custom_variables_validity (config_id, trans_id);
+
+CREATE INDEX idx_custom_variables_validity_trans_id
+ON custom_variables_validity (trans_id);