# HG changeset patch
# User Ranjith S R <ranjith@qualiantech.com>
# Date 1536558337 -19800
#      Mon Sep 10 11:15:37 2018 +0530
# Node ID 95337f324531939af556e9cc03f235d63776c5d4
# Parent  6a50f0160b7d10157f594c989af7676a65e12801
Related to issue 39213 : Added Partial Index to Logclient table with loglevel as ERROR

diff -r 6a50f0160b7d -r 95337f324531 src-db/database/model/tables/OBMOBC_LOGCLIENT.xml
--- a/src-db/database/model/tables/OBMOBC_LOGCLIENT.xml	Thu Aug 30 08:33:23 2018 +0200
+++ b/src-db/database/model/tables/OBMOBC_LOGCLIENT.xml	Mon Sep 10 11:15:37 2018 +0530
@@ -59,6 +59,10 @@
       <foreign-key foreignTable="AD_ORG" name="OBMOBC_LOGCLIENT_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBMOBC_LOGCLIENT_LOG_IDX" unique="false">
+        <index-column name="LOGLEVEL"/>
+        <whereClause><![CDATA[LOGLEVEL='ERROR']]></whereClause>
+      </index>
       <check name="OBMOBC_LOGCLIENT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="OBMOBC_LOGCLIENT_ISONLINE_CHK"><![CDATA[ISONLINE IN ('Y', 'N')]]></check>
     </table>