Benutzerdefinierte Variablen: Indizes für Tabelle custom_variables_validity

[mfinanz.git] / 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 (file)
index 0000000..1fb3725
--- /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);