[otrs-cvs] UnitTestServer UnitTestServer.sopm,1.8,1.9

Comments:
Update of /home/cvs/UnitTestServer
In directory lancelot:/tmp/cvs-serv7641

Modified Files:
	UnitTestServer.sopm 
Log Message:
Added indizes to improve the performance.

Author: mh

Index: UnitTestServer.sopm
===================================================================
RCS file: /home/cvs/UnitTestServer/UnitTestServer.sopm,v
retrieving revision 1.8
retrieving revision 1.9
diff -2 -u -d -r1.8 -r1.9
--- UnitTestServer.sopm	20 Mar 2013 13:58:58 -0000	1.8
+++ UnitTestServer.sopm	5 Apr 2013 14:57:37 -0000	1.9
@@ -32,4 +32,14 @@
             <Column Name="xml_key" Required="true" Size="250" Type="VARCHAR"/>
             <Column Name="create_time" Required="true" Type="DATE"/>
+            <Index Name="unit_test_product_tests_not_ok">
+                <IndexColumn Name="product"/>
+                <IndexColumn Name="tests_not_ok"/>
+            </Index>
+            <Index Name="unit_test_product">
+                <IndexColumn Name="product"/>
+            </Index>
+            <Index Name="unit_test_xml_key">
+                <IndexColumn Name="xml_key"/>
+            </Index>
         </TableCreate>
     </DatabaseInstall>
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log