From 958591cfb07d59b53d31d98a4bce28358798d17d Mon Sep 17 00:00:00 2001
From: =?utf8?q?Sven=20Sch=C3=B6ling?= <s.schoeling@linet-services.de>
Date: Tue, 19 Apr 2011 16:06:27 +0200
Subject: [PATCH] Zwei Indices in cvar Tabellen um komplexe Suchen zu
 beschleunigen.

---
 sql/Pg-upgrade2/custom_variables_indices.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/Pg-upgrade2/custom_variables_indices.sql

diff --git a/sql/Pg-upgrade2/custom_variables_indices.sql b/sql/Pg-upgrade2/custom_variables_indices.sql
new file mode 100644
index 000000000..77d494a4d
--- /dev/null
+++ b/sql/Pg-upgrade2/custom_variables_indices.sql
@@ -0,0 +1,8 @@
+-- @tag: custom_variables_indices
+-- @description: Indices für benutzerdefinierte Variablen
+-- @depends: release_2_6_2
+-- @charset: utf-8
+
+CREATE INDEX custom_variables_sub_module_idx ON custom_variables (sub_module);
+CREATE INDEX custom_variables_config_id_idx ON custom_variables (config_id);
+
-- 
2.20.1