From 627503c1d8443acdb4c50362c3981e68564a12d4 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 4 Feb 2014 10:35:56 +0100 Subject: [PATCH] =?utf8?q?Benutzerdefinierte=20Variablen:=20Indizes=20f?= =?utf8?q?=C3=BCr=20Tabelle=20custom=5Fvariables=5Fvalidity?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/custom_variables_validity_index.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 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); -- 2.20.1