related to issue 20421: Review needed indexes
authorAsier Lostalé <asier.lostale@openbravo.com>
Mon, 12 Aug 2013 09:31:25 +0200
changeset 20971 3993ddeadfe3
parent 20970 d4d102140b5c
child 20972 a7c526a32254
related to issue 20421: Review needed indexes

Added indexes for parent-child tab relationships for all columns that don't
participate in any other index/unique constraint
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml
modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml
modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml
modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml
modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml
modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml
modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml
modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml
modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml
modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml
src-db/database/model/tables/AD_ALERTRECIPIENT.xml
src-db/database/model/tables/AD_COLUMN.xml
src-db/database/model/tables/AD_DATASET_COLUMN.xml
src-db/database/model/tables/AD_DATASET_TABLE.xml
src-db/database/model/tables/AD_EP_PROCEDURES.xml
src-db/database/model/tables/AD_EXCEPTIONS.xml
src-db/database/model/tables/AD_MODEL_OBJECT.xml
src-db/database/model/tables/AD_MODEL_OBJECT_MAPPING.xml
src-db/database/model/tables/AD_MODEL_OBJECT_PARA.xml
src-db/database/model/tables/AD_MODULE_DBPREFIX.xml
src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml
src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml
src-db/database/model/tables/AD_ORG_WAREHOUSE.xml
src-db/database/model/tables/AD_PACKAGE.xml
src-db/database/model/tables/AD_REF_SEARCH.xml
src-db/database/model/tables/AD_REF_SEARCH_COLUMN.xml
src-db/database/model/tables/A_AMORTIZATIONLINE.xml
src-db/database/model/tables/A_ASSET.xml
src-db/database/model/tables/C_ACCTSCHEMA_GL.xml
src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml
src-db/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml
src-db/database/model/tables/C_ACCT_RPT_GROUP.xml
src-db/database/model/tables/C_ACCT_RPT_NODE.xml
src-db/database/model/tables/C_BPARTNER_DISCOUNT.xml
src-db/database/model/tables/C_BUDGETLINE.xml
src-db/database/model/tables/C_CITY.xml
src-db/database/model/tables/C_COMMISSIONDETAIL.xml
src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml
src-db/database/model/tables/C_DEBT_PAYMENT.xml
src-db/database/model/tables/C_DP_MANAGEMENTLINE.xml
src-db/database/model/tables/C_ELEMENTVALUE_OPERAND.xml
src-db/database/model/tables/C_INVOICE_DISCOUNT.xml
src-db/database/model/tables/C_INVOICE_REVERSE.xml
src-db/database/model/tables/C_NONBUSINESSDAY.xml
src-db/database/model/tables/C_ORDER_DISCOUNT.xml
src-db/database/model/tables/C_PAYMENTTERMLINE.xml
src-db/database/model/tables/C_PHASE.xml
src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
src-db/database/model/tables/C_PROJECTLINE.xml
src-db/database/model/tables/C_PROJECTPHASE.xml
src-db/database/model/tables/C_PROJECTPROPOSAL.xml
src-db/database/model/tables/C_PROJECTPROPOSALLINE.xml
src-db/database/model/tables/C_PROJECTPROPOSALTASK.xml
src-db/database/model/tables/C_PROJECTTASK.xml
src-db/database/model/tables/C_PROJECT_VENDOR.xml
src-db/database/model/tables/C_REMITTANCELINE.xml
src-db/database/model/tables/C_REMITTANCE_PARAMETER.xml
src-db/database/model/tables/C_SALARY_CATEGORY_COST.xml
src-db/database/model/tables/C_TASK.xml
src-db/database/model/tables/C_TAXREGISTER.xml
src-db/database/model/tables/C_TAXREGISTERLINE.xml
src-db/database/model/tables/C_TAXREGISTER_TYPE_LINES.xml
src-db/database/model/tables/C_TAX_ZONE.xml
src-db/database/model/tables/C_UOM_CONVERSION.xml
src-db/database/model/tables/FIN_BANKFILE_EXCEPTION.xml
src-db/database/model/tables/FIN_BANKSTATEMENT.xml
src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml
src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml
src-db/database/model/tables/FIN_PAYMENT_CREDIT.xml
src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml
src-db/database/model/tables/FIN_PAYMENT_RUN_PAYMENT.xml
src-db/database/model/tables/FIN_PAY_EXEC_PROCESS_PARA.xml
src-db/database/model/tables/GL_JOURNAL.xml
src-db/database/model/tables/GL_JOURNALLINE.xml
src-db/database/model/tables/MA_CCP.xml
src-db/database/model/tables/MA_CCP_SHIFT.xml
src-db/database/model/tables/MA_COSTCENTER_EMPLOYEE.xml
src-db/database/model/tables/MA_COSTCENTER_IC.xml
src-db/database/model/tables/MA_COSTCENTER_MACHINE.xml
src-db/database/model/tables/MA_COSTCENTER_VERSION.xml
src-db/database/model/tables/MA_GLOBALUSE.xml
src-db/database/model/tables/MA_INDIRECT_COST_VALUE.xml
src-db/database/model/tables/MA_MACHINESTATION.xml
src-db/database/model/tables/MA_MACHINE_COST.xml
src-db/database/model/tables/MA_MAINTENANCE.xml
src-db/database/model/tables/MA_MAINT_PERIODICITY.xml
src-db/database/model/tables/MA_MAINT_SCHEDULED.xml
src-db/database/model/tables/MA_MAINT_WORKER.xml
src-db/database/model/tables/MA_MEASURE_GROUP.xml
src-db/database/model/tables/MA_MEASURE_TIME.xml
src-db/database/model/tables/MA_MEASURE_VALUES.xml
src-db/database/model/tables/MA_PC_TEST.xml
src-db/database/model/tables/MA_PC_VALUE.xml
src-db/database/model/tables/MA_PL_EMPLOYEE.xml
src-db/database/model/tables/MA_PL_IC.xml
src-db/database/model/tables/MA_PL_INVOICELINE.xml
src-db/database/model/tables/MA_PL_MACHINE.xml
src-db/database/model/tables/MA_PROCESS.xml
src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml
src-db/database/model/tables/MA_SEQUENCE_IC.xml
src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml
src-db/database/model/tables/MA_TOOLSET.xml
src-db/database/model/tables/MA_TOOLSETPROCESS.xml
src-db/database/model/tables/MA_TOOLSETUSED.xml
src-db/database/model/tables/MA_WEEMPLOYEE.xml
src-db/database/model/tables/MA_WEINCIDENCE.xml
src-db/database/model/tables/MRP_PLANNINGMETHODLINE.xml
src-db/database/model/tables/MRP_SALESFORECASTLINE.xml
src-db/database/model/tables/M_ATTRIBUTEVALUE.xml
src-db/database/model/tables/M_DISCOUNTSCHEMALINE.xml
src-db/database/model/tables/M_FREIGHT.xml
src-db/database/model/tables/M_RAPPEL_BPARTNER.xml
src-db/database/model/tables/M_RAPPEL_INVOICE.xml
src-db/database/model/tables/M_RAPPEL_PRODUCT.xml
src-db/database/model/tables/M_RAPPEL_PRODUCTCATEGORY.xml
src-db/database/model/tables/M_RAPPEL_SCALE.xml
src-db/database/model/tables/M_REQUISITIONLINE.xml
src-db/database/model/tables/M_REQUISITIONORDER.xml
src-db/database/model/tables/M_RESERVATION_STOCK.xml
src-db/database/model/tables/M_TRANSACTION.xml
src-db/database/model/tables/M_WAREHOUSE_SHIPPER.xml
src-db/database/model/tables/S_RESOURCEASSIGNMENT.xml
src-db/database/model/tables/S_RESOURCEUNAVAILABLE.xml
src-db/database/model/tables/S_TIMEEXPENSELINE.xml
--- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="OBUIAPP_NAVBAR_COMPONENT" name="OBUIAPP_NVBRA_NAVBACOMPONENT" onDelete="cascade">
         <reference local="OBUIAPP_NAVBAR_COMPONENT_ID" foreign="OBUIAPP_NAVBAR_COMPONENT_ID"/>
       </foreign-key>
+      <index name="OBUIAPP_NAVBARACC_NAVBAR_IDX" unique="false">
+        <index-column name="OBUIAPP_NAVBAR_COMPONENT_ID"/>
+      </index>
       <check name="OBUIAPP_NVBRA_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -60,6 +60,9 @@
       <index name="OBUIAPP_PROCESSACC_PROCESS_IDX" unique="false">
         <index-column name="OBUIAPP_PROCESS_ID"/>
       </index>
+      <index name="OBUIAPP_PROCESSACCESS_ROLE_IDX" unique="false">
+        <index-column name="AD_ROLE_ID"/>
+      </index>
       <check name="OBUIAPP_PROC_ACC_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="OBUIAPP_PROC_ACC_ISREADWR_CHK"><![CDATA[ISREADWRITE IN ('Y', 'N')]]></check>
     </table>
--- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="AD_WINDOW" name="OBUIAPP_REF_W_AD_WINDOW">
         <reference local="AD_WINDOW_ID" foreign="AD_WINDOW_ID"/>
       </foreign-key>
+      <index name="OBUIAPP_REFWINDOW_REF_IDX" unique="false">
+        <index-column name="AD_REFERENCE_ID"/>
+      </index>
       <check name="OBUIAPP_REF_W_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,12 @@
       <foreign-key foreignTable="OBUIAPP_VIEW_IMPL" name="OBUIAPP_VIRA_VIEW" onDelete="cascade">
         <reference local="OBUIAPP_VIEW_IMPL_ID" foreign="OBUIAPP_VIEW_IMPL_ID"/>
       </foreign-key>
+      <index name="OBUIAPP_VIEWRCCESS_VIEWIMP_IDX" unique="false">
+        <index-column name="OBUIAPP_VIEW_IMPL_ID"/>
+      </index>
+      <index name="OBUIAPP_VIEWROLEACC_ROLE_IDX" unique="false">
+        <index-column name="AD_ROLE_ID"/>
+      </index>
       <check name="OBUIAPP_VIRA_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -54,6 +54,9 @@
       <foreign-key foreignTable="AD_ORG" name="OBCLKER_REF_ORG_KEY">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBCLKER_REFMASK_REFERENCE_IDX" unique="false">
+        <index-column name="AD_REFERENCE_ID"/>
+      </index>
       <check name="OBCLKER_REF_MASK_ISCTV_CHCK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="OBCLKER_TEMPLATE" name="OBCLKER_TD_PARENT" onDelete="cascade">
         <reference local="OBCLKER_TEMPLATE_ID" foreign="OBCLKER_TEMPLATE_ID"/>
       </foreign-key>
+      <index name="OBCLKER_TEMPLATEDEP_TEMPL_IDX" unique="false">
+        <index-column name="OBCLKER_TEMPLATE_ID"/>
+      </index>
       <check name="OBCLKER_CTD_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="AD_ORG" name="OBCLKER_VI_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBCLKER_UIDEFINITION_REF_IDX" unique="false">
+        <index-column name="AD_REFERENCE_ID"/>
+      </index>
       <check name="OBCLKER_VUID_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,12 @@
       <foreign-key foreignTable="OBKMO_WIDGET_CLASS" name="OBKMO_WIDCLASSACC_WIDGETCLASS" onDelete="cascade">
         <reference local="OBKMO_WIDGET_CLASS_ID" foreign="OBKMO_WIDGET_CLASS_ID"/>
       </foreign-key>
+      <index name="OBKMO_WDGTCLSACC_WDGTCLASS_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_ID"/>
+      </index>
+      <index name="OBKMO_WGTCLASSACCESS_ROLE_IDX" unique="false">
+        <index-column name="AD_ROLE_ID"/>
+      </index>
       <check name="OBKMO_WIDCLASSACC_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -62,6 +62,9 @@
       <foreign-key foreignTable="OBKMO_WIDGET_CLASS" name="OBKMO_WIDCLASSMENU_WIDGETCLASS" onDelete="cascade">
         <reference local="OBKMO_WIDGET_CLASS_ID" foreign="OBKMO_WIDGET_CLASS_ID"/>
       </foreign-key>
+      <index name="OBKMO_WDGTCLSMENU_WDGTCLS_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_ID"/>
+      </index>
       <check name="OBKMO_WIDCLMENU_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="OBKMO_WIDCLMENU_SEPARATOR_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="OBKMO_WIDGET_CLASS_MENU" name="OBKMO_WCLM_TR_WCLM" onDelete="cascade">
         <reference local="OBKMO_WIDGET_CLASS_MENU_ID" foreign="OBKMO_WIDGET_CLASS_MENU_ID"/>
       </foreign-key>
+      <index name="OBKMO_WDTCMENUTRL_WDTCMENU_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_MENU_ID"/>
+      </index>
       <check name="OBKMO_WCLM_TRL_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="OBKMO_WCLM_TRL_ISTR_CHK"><![CDATA[ISTRANSLATED IN ('Y', 'N')]]></check>
     </table>
--- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -50,6 +50,9 @@
       <foreign-key foreignTable="AD_ORG" name="OBKMO_WIDGET_LIST_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBKMO_WDTLIST_WDTCLS_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_ID"/>
+      </index>
       <check name="OBKMO_WIDGET_LIST_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -50,6 +50,9 @@
       <foreign-key foreignTable="AD_ORG" name="OBKMO_WIDGET_URL_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBKMO_WDTURL_WDCLS_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_ID"/>
+      </index>
       <check name="OBKMO_WIDGET_URL_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -111,6 +111,9 @@
       <foreign-key foreignTable="AD_REFERENCE" name="OBCQL_QUERY_COLUMN_REFERENCE">
         <reference local="AD_REFERENCE_ID" foreign="AD_REFERENCE_ID"/>
       </foreign-key>
+      <index name="OBCQL_QRYCOL_WDGTQRY_IDX" unique="false">
+        <index-column name="OBCQL_WIDGET_QUERY_ID"/>
+      </index>
       <check name="OBCQL_COLUMN_CANBEFILTERED_CHK"><![CDATA[CAN_BE_FILTERED IN ('Y', 'N')]]></check>
       <check name="OBCQL_COLUMN_WHERECLAUSE_CHK"><![CDATA[((CAN_BE_FILTERED = 'Y') AND (WHERECLAUSE_LEFT_PART IS NOT NULL)) OR (CAN_BE_FILTERED = 'N')]]></check>
       <check name="OBCQL_QUERY_COLUMN_ACTIVECHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
--- a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="AD_ORG" name="OBCQL_WIDGET_QUERY_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="OBCQL_WDGTQRY_WDGTCLASS_IDX" unique="false">
+        <index-column name="OBKMO_WIDGET_CLASS_ID"/>
+      </index>
       <index name="OBCQL_WIDGET_QUERY_DS" unique="false">
         <index-column name="OBSERDS_DATASOURCE_ID"/>
       </index>
--- a/modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -50,6 +50,9 @@
       <foreign-key foreignTable="AD_USER" name="OBSOID_USER_OID_AD_USER">
         <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
       </foreign-key>
+      <index name="OBSOID_USERIDENTIFIER_USER_IDX" unique="false">
+        <index-column name="AD_USER_ID"/>
+      </index>
       <unique name="OBSOID_UN_IDENTIFIER">
         <unique-column name="OPENID_IDENTIFIER"/>
       </unique>
--- a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -138,6 +138,9 @@
       <foreign-key foreignTable="OBUISEL_SELECTOR" name="OBUISEL_SF_SELECTOR" onDelete="cascade">
         <reference local="OBUISEL_SELECTOR_ID" foreign="OBUISEL_SELECTOR_ID"/>
       </foreign-key>
+      <index name="OBUISEL_SELECTFLD_SELECTOR_IDX" unique="false">
+        <index-column name="OBUISEL_SELECTOR_ID"/>
+      </index>
       <check name="OBUISEL_SF_CM_CHECK"><![CDATA[ISCENTRALLYMAINTAINED IN ('Y', 'N')]]></check>
       <check name="OBUISEL_SF_FILTER_CHECK"><![CDATA[FILTER IN ('Y', 'N')]]></check>
       <check name="OBUISEL_SF_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_ALERTRECIPIENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_ALERTRECIPIENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -64,5 +64,8 @@
       <foreign-key foreignTable="AD_USER" name="AD_ALERTRECIPIENT_AD_USER">
         <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
       </foreign-key>
+      <index name="AD_ALERTRECIP_ALERTRULE_IDX" unique="false">
+        <index-column name="AD_ALERTRULE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/AD_COLUMN.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_COLUMN.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -235,6 +235,9 @@
       <foreign-key foreignTable="AD_VAL_RULE" name="AD_VALRULE_COLUMN">
         <reference local="AD_VAL_RULE_ID" foreign="AD_VAL_RULE_ID"/>
       </foreign-key>
+      <index name="AD_COLUMN_ELEMENT_IDX" unique="false">
+        <index-column name="AD_ELEMENT_ID"/>
+      </index>
       <index name="AD_COLUMN_TABLE" unique="false">
         <index-column name="AD_TABLE_ID"/>
       </index>
--- a/src-db/database/model/tables/AD_DATASET_COLUMN.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_DATASET_COLUMN.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -64,6 +64,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_DATASET_COLUMN_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_DSCOLUMN_DSTABLE_IDX" unique="false">
+        <index-column name="AD_DATASET_TABLE_ID"/>
+      </index>
       <check name="AD_DATASET_COLUMN_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_DATASET_COLUMN_ISEXCLUD_CHK"><![CDATA[ISEXCLUDED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/AD_DATASET_TABLE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_DATASET_TABLE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -80,6 +80,9 @@
       <foreign-key foreignTable="AD_TABLE" name="AD_DATASET_TABLE_AD_TABLE">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
+      <index name="AD_DATASETTABLE_DATASET_IDX" unique="false">
+        <index-column name="AD_DATASET_ID"/>
+      </index>
       <check name="AD_DATASET_TABLE_INCLUDEAL_CHK"><![CDATA[INCLUDEALLCOLUMNS IN ('Y', 'N')]]></check>
       <check name="AD_DATASET_TABLE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_DATASET_TABLE_ISBUSINES_CHK"><![CDATA[ISBUSINESSOBJECT IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_EP_PROCEDURES.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_EP_PROCEDURES.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_ADEPPROCEDURES">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_EPPROC_EXTENSIONPOINT_IDX" unique="false">
+        <index-column name="AD_EXTENSION_POINTS_ID"/>
+      </index>
       <check name="AD_EP_PROC_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/AD_EXCEPTIONS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_EXCEPTIONS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <index name="AD_EXCEPTIONS_CLIENT_IDX" unique="false">
         <index-column name="AD_CLIENT_ID"/>
       </index>
+      <index name="AD_EXCEPTIONS_MODULE_IDX" unique="false">
+        <index-column name="AD_MODULE_ID"/>
+      </index>
       <index name="AD_EXCEPTIONS_ORG_IDX" unique="false">
         <index-column name="AD_ORG_ID"/>
       </index>
--- a/src-db/database/model/tables/AD_MODEL_OBJECT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_MODEL_OBJECT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -109,6 +109,18 @@
       <foreign-key foreignTable="AD_TAB" name="AD_MODEL_OBJECT_AD_TAB" onDelete="cascade">
         <reference local="AD_TAB_ID" foreign="AD_TAB_ID"/>
       </foreign-key>
+      <index name="AD_MODELOBJECT_CALLOUT_IDX" unique="false">
+        <index-column name="AD_CALLOUT_ID"/>
+      </index>
+      <index name="AD_MODELOBJECT_FORM_IDX" unique="false">
+        <index-column name="AD_FORM_ID"/>
+      </index>
+      <index name="AD_MODELOBJECT_PROCESS_IDX" unique="false">
+        <index-column name="AD_PROCESS_ID"/>
+      </index>
+      <index name="AD_MODELOBJECT_REFERENCE_IDX" unique="false">
+        <index-column name="AD_REFERENCE_ID"/>
+      </index>
       <check name="AD_MODEL_OBJECT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_MODEL_OBJECT_ISDEFAULT_CHK"><![CDATA[ISDEFAULT IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/AD_MODEL_OBJECT_MAPPING.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_MODEL_OBJECT_MAPPING.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -54,6 +54,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_MODEL_OBJECT_MAPPING_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_MODELOBJMAP_MODELOBJ_IDX" unique="false">
+        <index-column name="AD_MODEL_OBJECT_ID"/>
+      </index>
       <check name="AD_MODEL_OBJECT_MAPPING_IS_CH1"><![CDATA[ISDEFAULT IN ('Y', 'N')]]></check>
       <check name="AD_MODEL_OBJECT_MAPPING_IS_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/AD_MODEL_OBJECT_PARA.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_MODEL_OBJECT_PARA.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_MODEL_OBJECT_PARA_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_MODELOJTPARA_MODELOBJ_IDX" unique="false">
+        <index-column name="AD_MODEL_OBJECT_ID"/>
+      </index>
       <check name="AD_MOD_OBJ_PARA_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -50,6 +50,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_MODULE_DBPREFIX_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_MODULEDBPREFIX_MODULE_IDX" unique="false">
+        <index-column name="AD_MODULE_ID"/>
+      </index>
       <unique name="AD_MODULE_DB_PREFIX_UN">
         <unique-column name="NAME"/>
       </unique>
--- a/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -81,6 +81,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_MODULE_DEPENDENCY_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_MODULEDEPENDENCY_MODULE_IDX" unique="false">
+        <index-column name="AD_MODULE_ID"/>
+      </index>
       <check name="AD_MODULE_DEPENDENCY_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_MODULE_ISINCLUDED_CHK"><![CDATA[ISINCLUDED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -76,6 +76,9 @@
       <foreign-key foreignTable="C_ACCTSCHEMA" name="AD_ORG_ACCTSCHEMA_C_ACCTSCHEMA">
         <reference local="C_ACCTSCHEMA_ID" foreign="C_ACCTSCHEMA_ID"/>
       </foreign-key>
+      <index name="AD_ORGACCTSCHEMA_ORG_IDX" unique="false">
+        <index-column name="AD_ORG_ID"/>
+      </index>
       <check name="AD_ORG_ACCTSCHEMA_BPFIELDS_CHK"><![CDATA[(ISBPNEWACCOUNT = 'N') OR ((((ISBPNEWACCOUNT = 'Y') AND (AD_SEQUENCE_BP_ID IS NOT NULL)) AND (ACCT_LENGTH IS NOT NULL)) AND (SUBACCT_LENGTH IS NOT NULL))]]></check>
       <check name="AD_ORG_ACCTSCHEMA_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="AD_ORG_ACCTSCHEMA_ISBPNEWA_CHK"><![CDATA[ISBPNEWACCOUNT IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_ORG_WAREHOUSE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_ORG_WAREHOUSE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -50,6 +50,9 @@
       <foreign-key foreignTable="M_WAREHOUSE" name="AD_ORG_WAREHOUSE_WAREHOUSE">
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
+      <index name="AD_ORGWAREHOUSE_ORG_IDX" unique="false">
+        <index-column name="AD_ORG_ID"/>
+      </index>
       <check name="AD_ORG_WAREHOUSE_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/AD_PACKAGE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_PACKAGE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_PACKAGE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_PACKAGE_MODULE_IDX" unique="false">
+        <index-column name="AD_MODULE_ID"/>
+      </index>
       <unique name="AD_PACKAGE_JAVANAME">
         <unique-column name="JAVAPACKAGE"/>
       </unique>
--- a/src-db/database/model/tables/AD_REF_SEARCH.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_REF_SEARCH.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -60,6 +60,9 @@
       <foreign-key foreignTable="AD_TABLE" name="AD_REF_SEARCH_AD_TABLE">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
+      <index name="AD_REFSEARCH_REFERENCE_IDX" unique="false">
+        <index-column name="AD_REFERENCE_ID"/>
+      </index>
       <check name="AD_REF_SEARCH_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/AD_REF_SEARCH_COLUMN.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/AD_REF_SEARCH_COLUMN.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -62,6 +62,9 @@
       <foreign-key foreignTable="AD_REF_SEARCH" name="AD_REF_SEARCH_COLUMN_AD_REF_SE">
         <reference local="AD_REF_SEARCH_ID" foreign="AD_REF_SEARCH_ID"/>
       </foreign-key>
+      <index name="AD_REFSEARCHCOL_REFSEARCH_IDX" unique="false">
+        <index-column name="AD_REF_SEARCH_ID"/>
+      </index>
       <check name="AD_REF_SEARCH_C_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/A_AMORTIZATIONLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/A_AMORTIZATIONLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -104,6 +104,12 @@
       <foreign-key foreignTable="USER2" name="A_AMORTLINE_USER2">
         <reference local="USER2_ID" foreign="USER2_ID"/>
       </foreign-key>
+      <index name="A_AMORTIZATIONLINE_AMORTIZ_IDX" unique="false">
+        <index-column name="A_AMORTIZATION_ID"/>
+      </index>
+      <index name="A_AMORTIZATIONLINE_ASSET_IDX" unique="false">
+        <index-column name="A_ASSET_ID"/>
+      </index>
       <check name="A_AMORTIZATIONL_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/A_ASSET.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/A_ASSET.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -289,6 +289,9 @@
       <foreign-key foreignTable="M_PRODUCT" name="A_ASSET_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="A_ASSET_BPARTNER_IDX" unique="false">
+        <index-column name="C_BPARTNER_ID"/>
+      </index>
       <check name="A_ASSET_IS30DAYMONTH_CHK"><![CDATA[IS30DAYMONTH IN ('Y', 'N')]]></check>
       <check name="A_ASSET_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="A_ASSET_ISDISPOSED_CHK"><![CDATA[ISDISPOSED IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/C_ACCTSCHEMA_GL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ACCTSCHEMA_GL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -125,6 +125,9 @@
       <foreign-key foreignTable="C_VALIDCOMBINATION" name="C_ACCTSCHM_GL_C_VLDCMBNTN">
         <reference local="CFS_ORDER_ACCT" foreign="C_VALIDCOMBINATION_ID"/>
       </foreign-key>
+      <index name="C_ACCTSCHEMAGL_ACCTSCHEMA_IDX" unique="false">
+        <index-column name="C_ACCTSCHEMA_ID"/>
+      </index>
       <check name="C_ACCTSCHEMA_GL_CREATECL_CHK"><![CDATA[CREATECLOSING IN ('Y', 'N')]]></check>
       <check name="C_ACCTSCHEMA_GL_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_ACCTSCHEMA_GL_USECURRENC_CHK"><![CDATA[USECURRENCYBALANCING IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="C_ACCTSCHEMA" name="C_ACCTSCHEMA_PROCESS_C_ACCTSCH">
         <reference local="C_ACCTSCHEMA_ID" foreign="C_ACCTSCHEMA_ID"/>
       </foreign-key>
+      <index name="C_ACCTSCHEMAPRC_ACCTSCHEMA_IDX" unique="false">
+        <index-column name="C_ACCTSCHEMA_ID"/>
+      </index>
       <check name="C_ACCTSCHEMA_PROCESS_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_ACCTSCHEMA_PROCESS_ISDAT_CHK"><![CDATA[ISDATASET IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="C_ACCTSCHEMA_TABLE" name="C_CCTSCHM_TBL_D_C_CCTSCHM_TBL">
         <reference local="C_ACCTSCHEMA_TABLE_ID" foreign="C_ACCTSCHEMA_TABLE_ID"/>
       </foreign-key>
+      <index name="C_ACCSCHTBLDOCTP_ACCSCHTBL_IDX" unique="false">
+        <index-column name="C_ACCTSCHEMA_TABLE_ID"/>
+      </index>
       <check name="C_ACCTSCH_TA_DO_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_ACCTSCH_TA_DO_NEGATIVE_CHECK"><![CDATA[ALLOWNEGATIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/C_ACCT_RPT_GROUP.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ACCT_RPT_GROUP.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,5 +58,8 @@
       <foreign-key foreignTable="C_ACCT_RPT" name="C_ACCT_RPT_GROUP_C_ACCT_RPT">
         <reference local="C_ACCT_RPT_ID" foreign="C_ACCT_RPT_ID"/>
       </foreign-key>
+      <index name="C_ACCTRPTGROUP_ACCTRPT_IDX" unique="false">
+        <index-column name="C_ACCT_RPT_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_ACCT_RPT_NODE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ACCT_RPT_NODE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,5 +65,8 @@
       <foreign-key foreignTable="C_ELEMENTVALUE" name="C_ACCT_RPT_NODE_C_ELEMENTVALUE">
         <reference local="C_ELEMENTVALUE_ID" foreign="C_ELEMENTVALUE_ID"/>
       </foreign-key>
+      <index name="C_ACCTRPTNODE_ACCTRPTGROUP_IDX" unique="false">
+        <index-column name="C_ACCT_RPT_GROUP_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_BPARTNER_DISCOUNT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_BPARTNER_DISCOUNT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -73,6 +73,9 @@
       <foreign-key foreignTable="C_DISCOUNT" name="C_BPARTNER_DISCOUNT_C_DISCOUNT">
         <reference local="C_DISCOUNT_ID" foreign="C_DISCOUNT_ID"/>
       </foreign-key>
+      <index name="C_BPARTNERDISCOUNT_BP_IDX" unique="false">
+        <index-column name="C_BPARTNER_ID"/>
+      </index>
       <check name="C_BPDISC_APPLYINORDER_CHECK"><![CDATA[APPLYINORDER IN ('N', 'Y')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_BUDGETLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_BUDGETLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -196,6 +196,9 @@
       <foreign-key foreignTable="M_PRODUCT_CATEGORY" name="M_PRODUCT_CATEGORY_CBUDGETLINE">
         <reference local="M_PRODUCT_CATEGORY_ID" foreign="M_PRODUCT_CATEGORY_ID"/>
       </foreign-key>
+      <index name="C_BUDGETLINE_BUDGET_IDX" unique="false">
+        <index-column name="C_BUDGET_ID"/>
+      </index>
       <check name="C_BUDGETLINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_CITY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_CITY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -73,6 +73,9 @@
       <foreign-key foreignTable="AD_ORG" name="C_CITYORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="C_CITY_REGION_IDX" unique="false">
+        <index-column name="C_REGION_ID"/>
+      </index>
       <check name="C_CITY_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_COMMISSIONDETAIL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_COMMISSIONDETAIL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -91,6 +91,9 @@
       <foreign-key foreignTable="C_ORDERLINE" name="C_COMMISSIONDETAIL_C_ORDERLINE">
         <reference local="C_ORDERLINE_ID" foreign="C_ORDERLINE_ID"/>
       </foreign-key>
+      <index name="C_COMMISSIONDET_COMMISSAMT_IDX" unique="false">
+        <index-column name="C_COMMISSIONAMT_ID"/>
+      </index>
       <check name="C_COMMISSIONDET_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_COMMISSIONDET_ISCOSTCALC"><![CDATA[ISCOSTCALCULATED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -89,6 +89,9 @@
       <foreign-key foreignTable="C_CURRENCY" name="C_CURRENCYRATEDOCRATETO">
         <reference local="C_CURRENCY_ID_TO" foreign="C_CURRENCY_ID"/>
       </foreign-key>
+      <index name="C_CONVRATEDOC_FINACCTRX_IDX" unique="false">
+        <index-column name="FIN_FINACC_TRANSACTION_ID"/>
+      </index>
       <unique name="C_CONVERSIONRATEDOC_ONCE">
         <unique-column name="C_CURRENCY_ID"/>
         <unique-column name="C_CURRENCY_ID_TO"/>
--- a/src-db/database/model/tables/C_DEBT_PAYMENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_DEBT_PAYMENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -214,6 +214,9 @@
       <index name="C_DEBT_PAYMENT_SETTGENERAT_IDX" unique="false">
         <index-column name="C_SETTLEMENT_GENERATE_ID"/>
       </index>
+      <index name="C_DEBTPAYMENT_ORDER_IDX" unique="false">
+        <index-column name="C_ORDER_ID"/>
+      </index>
       <check name="C_DEBT_PAYMENT_C_BANKSTATE_CHK"><![CDATA[((C_BANKSTATEMENTLINE_ID IS NULL) AND (C_CASHLINE_ID IS NULL)) OR (ISPAID = 'Y')]]></check>
       <check name="C_DEBT_PAYMENT_C_BPARTNER__CHK"><![CDATA[C_BPARTNER_ID IS NOT NULL]]></check>
       <check name="C_DEBT_PAYMENT_C_CASHLINE__CHK"><![CDATA[(C_CASHLINE_ID IS NULL) OR (C_BANKSTATEMENTLINE_ID IS NULL)]]></check>
--- a/src-db/database/model/tables/C_DP_MANAGEMENTLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_DP_MANAGEMENTLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,5 +65,8 @@
       <foreign-key foreignTable="C_DP_MANAGEMENT" name="C_DP_MANAGEMENTLINE_C_DP_MANAG">
         <reference local="C_DP_MANAGEMENT_ID" foreign="C_DP_MANAGEMENT_ID"/>
       </foreign-key>
+      <index name="C_DPMGTLINE_DPMGT_IDX" unique="false">
+        <index-column name="C_DP_MANAGEMENT_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_ELEMENTVALUE_OPERAND.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ELEMENTVALUE_OPERAND.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="C_ELEMENTVALUE" name="C_ELEMENTVALUE_OPERAND_C_ELEME">
         <reference local="C_ELEMENTVALUE_ID" foreign="C_ELEMENTVALUE_ID"/>
       </foreign-key>
+      <index name="C_ELEMENTVALOPER_ELEMTVAL_IDX" unique="false">
+        <index-column name="C_ELEMENTVALUE_ID"/>
+      </index>
       <check name="C_ELEMENTVALUE_OPERAND_ISA_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_INVOICE_DISCOUNT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_INVOICE_DISCOUNT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,5 +61,8 @@
       <foreign-key foreignTable="C_INVOICE" name="C_INVOICE_DISCOUNT_C_INVOICE">
         <reference local="C_INVOICE_ID" foreign="C_INVOICE_ID"/>
       </foreign-key>
+      <index name="C_INVOICEDISCOUNT_INVOICE_IDX" unique="false">
+        <index-column name="C_INVOICE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_INVOICE_REVERSE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_INVOICE_REVERSE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,5 +53,8 @@
       <foreign-key foreignTable="C_INVOICE" name="C_INVOICE_REVERSE_REVERSED_C_I">
         <reference local="REVERSED_C_INVOICE_ID" foreign="C_INVOICE_ID"/>
       </foreign-key>
+      <index name="C_INVOICEREVERSE_INVOICE_IDX" unique="false">
+        <index-column name="C_INVOICE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_NONBUSINESSDAY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_NONBUSINESSDAY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -54,6 +54,9 @@
       <foreign-key foreignTable="AD_ORG" name="C_NONBUSINESDAYSORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="C_NONBUSINESSDAY_CALENDAR_IDX" unique="false">
+        <index-column name="C_CALENDAR_ID"/>
+      </index>
       <check name="C_NONBUSINESSDA_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_ORDER_DISCOUNT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_ORDER_DISCOUNT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,5 +61,8 @@
       <foreign-key foreignTable="C_ORDER" name="C_ORDER_DISCOUNT_C_ORDER">
         <reference local="C_ORDER_ID" foreign="C_ORDER_ID"/>
       </foreign-key>
+      <index name="C_ORDERDISCOUNT_ORDER_IDX" unique="false">
+        <index-column name="C_ORDER_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PAYMENTTERMLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PAYMENTTERMLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -109,6 +109,9 @@
       <foreign-key foreignTable="FIN_PAYMENTMETHOD" name="C_PAYMENTTERMLINE_FIN_PAY_FK1">
         <reference local="FIN_PAYMENTMETHOD_ID" foreign="FIN_PAYMENTMETHOD_ID"/>
       </foreign-key>
+      <index name="C_PAYMENTTERMLINE_PAYMENTT_IDX" unique="false">
+        <index-column name="C_PAYMENTTERM_ID"/>
+      </index>
       <check name="C_PAYMENTTERMLINE_EXCLUDET_CHK"><![CDATA[EXCLUDETAX IN ('Y', 'N')]]></check>
       <check name="C_PAYMENTTERMLINE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_PAYMENTTERMLINE_ISDUEFIX_CHK"><![CDATA[ISDUEFIXED IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/C_PHASE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PHASE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -77,5 +77,8 @@
       <foreign-key foreignTable="M_PRODUCT" name="C_PHASE_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="C_PHASE_PROJECTTYPE_IDX" unique="false">
+        <index-column name="C_PROJECTTYPE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_POC_EMAILDEFINITION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_POC_EMAILDEFINITION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,5 +65,8 @@
       <foreign-key foreignTable="C_POC_DOCTYPE_TEMPLATE" name="C_POC_EMAILDEFINITION_C_POC_DO">
         <reference local="C_POC_DOCTYPE_TEMPLATE_ID" foreign="C_POC_DOCTYPE_TEMPLATE_ID"/>
       </foreign-key>
+      <index name="C_POCEMAILDEF_DOCTYPETEMPL_IDX" unique="false">
+        <index-column name="C_POC_DOCTYPE_TEMPLATE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -156,6 +156,9 @@
       <foreign-key foreignTable="C_TAX" name="C_TAX_FK_PROJECTLINE">
         <reference local="C_TAX_ID" foreign="C_TAX_ID"/>
       </foreign-key>
+      <index name="C_PROJECTLINE_PROJECT_IDX" unique="false">
+        <index-column name="C_PROJECT_ID"/>
+      </index>
       <check name="C_PROJECTLINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTPHASE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTPHASE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -119,5 +119,8 @@
       <foreign-key foreignTable="M_PRODUCT" name="C_PROJECTPHASE_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="C_PROJECTPHASE_PROJECT_IDX" unique="false">
+        <index-column name="C_PROJECT_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTPROPOSAL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTPROPOSAL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -109,6 +109,9 @@
       <foreign-key foreignTable="FIN_PAYMENTMETHOD" name="C_PROJECTPROPOSAL_FINPAYMETHOD">
         <reference local="FIN_PAYMENTMETHOD_ID" foreign="FIN_PAYMENTMETHOD_ID"/>
       </foreign-key>
+      <index name="C_PROJECTPROPOSAL_PROJECT_IDX" unique="false">
+        <index-column name="C_PROJECT_ID"/>
+      </index>
       <check name="C_PROJECTPROPOS_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTPROPOSALLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTPROPOSALLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -81,6 +81,9 @@
       <foreign-key foreignTable="M_PRODUCT" name="C_PROJECTPROPOSALLINE_M_PRODUC">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="C_PRJPROPOSALLN_PRJPROPOS_IDX" unique="false">
+        <index-column name="C_PROJECTPROPOSAL_ID"/>
+      </index>
       <check name="C_PROJECTPROPOSALLINE_ISAC_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTPROPOSALTASK.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTPROPOSALTASK.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="C_PROJECTPROPOSAL" name="C_PROJECTPROPOSALTASK_C_PROJEC">
         <reference local="C_PROJECTPROPOSAL_ID" foreign="C_PROJECTPROPOSAL_ID"/>
       </foreign-key>
+      <index name="C_PRJPROPOSTASK_PRJPROPOS_IDX" unique="false">
+        <index-column name="C_PROJECTPROPOSAL_ID"/>
+      </index>
       <check name="C_PRPROPTK_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECTTASK.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECTTASK.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -108,5 +108,8 @@
       <foreign-key foreignTable="M_PRODUCT" name="C_PROJECTTASK_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="C_PROJECTTASK_PROJECTPHASE_IDX" unique="false">
+        <index-column name="C_PROJECTPHASE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_PROJECT_VENDOR.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECT_VENDOR.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -86,6 +86,9 @@
       <foreign-key foreignTable="M_PRICELIST_VERSION" name="C_PROJECT_VENDOR_M_PRICELIST_V">
         <reference local="M_PRICELIST_VERSION_ID" foreign="M_PRICELIST_VERSION_ID"/>
       </foreign-key>
+      <index name="C_PROJECTVENDOR_PROJECT_IDX" unique="false">
+        <index-column name="C_PROJECT_ID"/>
+      </index>
       <check name="C_PROJECT_VENDO_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/C_REMITTANCELINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_REMITTANCELINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -68,5 +68,8 @@
       <foreign-key foreignTable="C_DEBT_PAYMENT" name="C_REMITTANCELINE_C_DEBT_PAYMEN">
         <reference local="C_DEBT_PAYMENT_ID" foreign="C_DEBT_PAYMENT_ID"/>
       </foreign-key>
+      <index name="C_REMITLINE_REMIT_IDX" unique="false">
+        <index-column name="C_REMITTANCE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_REMITTANCE_PARAMETER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_REMITTANCE_PARAMETER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -54,5 +54,8 @@
       <foreign-key foreignTable="C_REMITTANCE_TYPE" name="C_REMITTANCE_PARAMETER_C_REMIT">
         <reference local="C_REMITTANCE_TYPE_ID" foreign="C_REMITTANCE_TYPE_ID"/>
       </foreign-key>
+      <index name="C_REMITPARAMETER_REMITTYPE_IDX" unique="false">
+        <index-column name="C_REMITTANCE_TYPE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_SALARY_CATEGORY_COST.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_SALARY_CATEGORY_COST.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -54,5 +54,8 @@
       <foreign-key foreignTable="C_SALARY_CATEGORY" name="C_SALARY_CATEGORY_COST_C_SALAR">
         <reference local="C_SALARY_CATEGORY_ID" foreign="C_SALARY_CATEGORY_ID"/>
       </foreign-key>
+      <index name="C_SALCTGCOST_SALACTG_IDX" unique="false">
+        <index-column name="C_SALARY_CATEGORY_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_TASK.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_TASK.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -77,5 +77,8 @@
       <foreign-key foreignTable="M_PRODUCT" name="C_TASK_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="C_TASK_PHASE_IDX" unique="false">
+        <index-column name="C_PHASE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_TAXREGISTER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_TAXREGISTER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -69,5 +69,8 @@
       <foreign-key foreignTable="C_TAXREGISTER_TYPE" name="C_TAXREGISTER_C_TAXREGISTER_TY">
         <reference local="C_TAXREGISTER_TYPE_ID" foreign="C_TAXREGISTER_TYPE_ID"/>
       </foreign-key>
+      <index name="C_TAXREGISTER_TAXPAYMENT_IDX" unique="false">
+        <index-column name="C_TAXPAYMENT_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_TAXREGISTERLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_TAXREGISTERLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -96,5 +96,8 @@
       <foreign-key foreignTable="C_TAXREGISTER" name="C_TAXREGISTERLINE_C_TAXREGISTE">
         <reference local="C_TAXREGISTER_ID" foreign="C_TAXREGISTER_ID"/>
       </foreign-key>
+      <index name="C_TAXREGISTERLINE_TAXREGIS_IDX" unique="false">
+        <index-column name="C_TAXREGISTER_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_TAXREGISTER_TYPE_LINES.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_TAXREGISTER_TYPE_LINES.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -60,5 +60,8 @@
       <foreign-key foreignTable="C_TAX" name="C_TAXREGISTER_TYPE_LINES_C_TAX">
         <reference local="C_TAX_ID" foreign="C_TAX_ID"/>
       </foreign-key>
+      <index name="C_TAXREGTYPELIN_TAXREGTYPE_IDX" unique="false">
+        <index-column name="C_TAXREGISTER_TYPE_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_TAX_ZONE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_TAX_ZONE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -74,5 +74,8 @@
       <foreign-key foreignTable="C_REGION" name="C_TO_REGION_C_TAX_ZONE">
         <reference local="TO_REGION_ID" foreign="C_REGION_ID"/>
       </foreign-key>
+      <index name="C_TAXZONE_TAX_IDX" unique="false">
+        <index-column name="C_TAX_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/C_UOM_CONVERSION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/C_UOM_CONVERSION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="C_UOM" name="C_UOMCONVERSIONTO">
         <reference local="C_UOM_TO_ID" foreign="C_UOM_ID"/>
       </foreign-key>
+      <index name="C_UOMCONVERSION_UOM_IDX" unique="false">
+        <index-column name="C_UOM_ID"/>
+      </index>
       <check name="C_UOM_CONVERSIO_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/FIN_BANKFILE_EXCEPTION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_BANKFILE_EXCEPTION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="FIN_FINANCIAL_ACCOUNT" name="FIN_BANKFILE_EXCEPTION_FA">
         <reference local="FIN_FINANCIAL_ACCOUNT_ID" foreign="FIN_FINANCIAL_ACCOUNT_ID"/>
       </foreign-key>
+      <index name="FIN_BNKFILEEXC_BNKFILEFRMT_IDX" unique="false">
+        <index-column name="FIN_BANKFILE_FORMAT_ID"/>
+      </index>
       <check name="FIN_BANKFILE_EX_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/FIN_BANKSTATEMENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_BANKSTATEMENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -96,6 +96,9 @@
       <foreign-key foreignTable="FIN_RECONCILIATION" name="FIN_BANKSTAT_FINRECONCILIATION">
         <reference local="FIN_RECONCILIATION_ID" foreign="FIN_RECONCILIATION_ID"/>
       </foreign-key>
+      <index name="FIN_BNKSTMT_FINACCT_IDX" unique="false">
+        <index-column name="FIN_FINANCIAL_ACCOUNT_ID"/>
+      </index>
       <check name="FIN_BANKSTAT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="FIN_BANKSTAT_PROCESSED_CHECK"><![CDATA[PROCESSED IN ('Y', 'N')]]></check>
       <check name="FIN_BANKSTAT_PROCESSING_CHECK"><![CDATA[PROCESSING IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -102,6 +102,9 @@
       <index name="FIN_BANKSTATEMENTLINE_TRX" unique="false">
         <index-column name="FIN_FINACC_TRANSACTION_ID"/>
       </index>
+      <index name="FIN_BNKSTMTLINE_BNKSTMT_IDX" unique="false">
+        <index-column name="FIN_BANKSTATEMENT_ID"/>
+      </index>
       <check name="FIN_BANKSTATLINE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -158,6 +158,9 @@
       <foreign-key foreignTable="USER2" name="FIN_DOUBTFUL_DEBT_USER2">
         <reference local="USER2_ID" foreign="USER2_ID"/>
       </foreign-key>
+      <index name="FIN_DOUBTDBT_DOUBTDBTRUN_IDX" unique="false">
+        <index-column name="FIN_DOUBTFUL_DEBT_RUN_ID"/>
+      </index>
       <check name="FIN_DOUBTDEBT_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="FIN_DOUBTDEBT_PROCESSED"><![CDATA[PROCESSED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/FIN_PAYMENT_CREDIT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT_CREDIT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -64,6 +64,9 @@
       <foreign-key foreignTable="FIN_PAYMENT" name="FIN_CR_FIN_PAYMENT_USED">
         <reference local="FIN_PAYMENT_ID_USED" foreign="FIN_PAYMENT_ID"/>
       </foreign-key>
+      <index name="FIN_PAYMENTCREDIT_PAYMENT_IDX" unique="false">
+        <index-column name="FIN_PAYMENT_ID"/>
+      </index>
       <check name="FIN_CR_PAYMENT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="FIN_PAY_EXEC_PROCESS_PARA" name="FIN_PAYRUNPARA_PAYEXECPROCPARA">
         <reference local="FIN_PAY_EXEC_PROCESS_PARA_ID" foreign="FIN_PAY_EXEC_PROCESS_PARA_ID"/>
       </foreign-key>
+      <index name="FIN_PYMTRUNPARA_PYMTRUN_IDX" unique="false">
+        <index-column name="FIN_PAYMENT_RUN_ID"/>
+      </index>
       <check name="FIN_PAYMENTRUNPARA_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/FIN_PAYMENT_RUN_PAYMENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT_RUN_PAYMENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="AD_CLIENT" name="FIN_PAYMENTRUNPAYMENT_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
+      <index name="FIN_PYMTRUNPYMT_PYMTRUN_IDX" unique="false">
+        <index-column name="FIN_PAYMENT_RUN_ID"/>
+      </index>
       <check name="FIN_PAYMENTRUNPAY_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="FIN_PAYMENTRUNPAY_VALCHK_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/FIN_PAY_EXEC_PROCESS_PARA.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/FIN_PAY_EXEC_PROCESS_PARA.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -82,6 +82,9 @@
       <foreign-key foreignTable="FIN_PAY_EXEC_PROCESS" name="FIN_PAYEXECPROCPARA_PAYEXECPRO">
         <reference local="FIN_PAY_EXEC_PROCESS_ID" foreign="FIN_PAY_EXEC_PROCESS_ID"/>
       </foreign-key>
+      <index name="FIN_PAYEXCPRCPAR_PAYEXCPRC_IDX" unique="false">
+        <index-column name="FIN_PAY_EXEC_PROCESS_ID"/>
+      </index>
       <check name="FIN_PAYEXECPROCPARA_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="FIN_PAYEXECPROCPARA_MANDAT_CHK"><![CDATA[ISMANDATORY IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/GL_JOURNAL.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/GL_JOURNAL.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -209,6 +209,9 @@
       <foreign-key foreignTable="USER2" name="GL_JOURNAL_USER2">
         <reference local="USER2_ID" foreign="USER2_ID"/>
       </foreign-key>
+      <index name="GL_JOURNAL_JOURNALBATCH_IDX" unique="false">
+        <index-column name="GL_JOURNALBATCH_ID"/>
+      </index>
       <unique name="GL_JOURNAL_DOCNO">
         <unique-column name="AD_ORG_ID"/>
         <unique-column name="C_PERIOD_ID"/>
--- a/src-db/database/model/tables/GL_JOURNALLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/GL_JOURNALLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -238,6 +238,9 @@
       <foreign-key foreignTable="USER2" name="GL_JOURNALLINE_USER2">
         <reference local="USER2_ID" foreign="USER2_ID"/>
       </foreign-key>
+      <index name="GL_JOURNALLINE_JOURNAL_IDX" unique="false">
+        <index-column name="GL_JOURNAL_ID"/>
+      </index>
       <check name="GL_JOURNALLINE_C_TAX_ID_CHK"><![CDATA[(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)]]></check>
       <check name="GL_JOURNALLINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="GL_JOURNALLINE_ISGENERATED_CHK"><![CDATA[ISGENERATED IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/MA_CCP.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_CCP.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -70,6 +70,9 @@
       <foreign-key foreignTable="MA_CCP_GROUP" name="MA_CCP_GROUP_MACCP">
         <reference local="MA_CCP_GROUP_ID" foreign="MA_CCP_GROUP_ID"/>
       </foreign-key>
+      <index name="MA_CCP_CCPGROUP_IDX" unique="false">
+        <index-column name="MA_CCP_GROUP_ID"/>
+      </index>
       <check name="MA_CCP_CRITICAL_CHECK"><![CDATA[CRITICAL IN ('Y', 'N')]]></check>
       <check name="MA_CCP_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/MA_CCP_SHIFT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_CCP_SHIFT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="AD_CLIENT" name="MA_CCP_SHIFT_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
+      <index name="MA_CCPSHIFT_CCPGROUP_IDX" unique="false">
+        <index-column name="MA_CCP_GROUP_ID"/>
+      </index>
       <check name="MA_CCP_SHIFT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_COSTCENTER_EMPLOYEE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_COSTCENTER_EMPLOYEE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,6 +65,9 @@
       <foreign-key foreignTable="MA_COSTCENTER_VERSION" name="MA_COSTCENTER_EMPLOYEE_MA_COST">
         <reference local="MA_COSTCENTER_VERSION_ID" foreign="MA_COSTCENTER_VERSION_ID"/>
       </foreign-key>
+      <index name="MA_COSTCNTREMP_COSTCNTRVER_IDX" unique="false">
+        <index-column name="MA_COSTCENTER_VERSION_ID"/>
+      </index>
       <check name="MA_COSTCENTER_E_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="MA_COSTCENTER_E_SPLIT_CHECK"><![CDATA[SPLIT IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/MA_COSTCENTER_IC.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_COSTCENTER_IC.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="MA_INDIRECT_COST" name="MA_COSTCENTER_IC_MA_INDIRECT_C">
         <reference local="MA_INDIRECT_COST_ID" foreign="MA_INDIRECT_COST_ID"/>
       </foreign-key>
+      <index name="MA_COSTCNTRIC_COSTCNTRVER_IDX" unique="false">
+        <index-column name="MA_COSTCENTER_VERSION_ID"/>
+      </index>
       <check name="MA_COSTCENTER_I_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_COSTCENTER_MACHINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_COSTCENTER_MACHINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_MACHINE" name="MA_COSTCENTER_MACHINE_MA_MACHI">
         <reference local="MA_MACHINE_ID" foreign="MA_MACHINE_ID"/>
       </foreign-key>
+      <index name="MA_COSTCNTRMAC_COSTCNTRVER_IDX" unique="false">
+        <index-column name="MA_COSTCENTER_VERSION_ID"/>
+      </index>
       <check name="MA_COSTCENTER_M_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_COSTCENTER_VERSION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_COSTCENTER_VERSION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -62,6 +62,9 @@
       <foreign-key foreignTable="MA_COSTCENTER" name="MA_COSTCENTER_VERSION_MA_COSTC">
         <reference local="MA_COSTCENTER_ID" foreign="MA_COSTCENTER_ID"/>
       </foreign-key>
+      <index name="MA_COSTCNTRVER_COSTCNTR_IDX" unique="false">
+        <index-column name="MA_COSTCENTER_ID"/>
+      </index>
       <check name="MA_COSTCENTER_V_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_GLOBALUSE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_GLOBALUSE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -89,6 +89,9 @@
       <foreign-key foreignTable="M_PRODUCTION" name="MA_GLOBALUSE_M_PRODUCTION">
         <reference local="M_PRODUCTION_ID" foreign="M_PRODUCTION_ID"/>
       </foreign-key>
+      <index name="MA_GLOBALUSE_PRODUCTION_IDX" unique="false">
+        <index-column name="M_PRODUCTION_ID"/>
+      </index>
       <check name="MA_GLOBALUSE_CHECK1"><![CDATA[((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))]]></check>
       <check name="MA_GLOBALUSE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/MA_INDIRECT_COST_VALUE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_INDIRECT_COST_VALUE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -74,6 +74,9 @@
       <foreign-key foreignTable="MA_INDIRECT_COST" name="MA_INDIRECT_COST_VALUE_MA_INDI">
         <reference local="MA_INDIRECT_COST_ID" foreign="MA_INDIRECT_COST_ID"/>
       </foreign-key>
+      <index name="MA_INDCOSTVALUE_INDCOST_IDX" unique="false">
+        <index-column name="MA_INDIRECT_COST_ID"/>
+      </index>
       <check name="MA_INDIRECT_COST_VALUE_CAL_CH1"><![CDATA[CALCULATED IN ('Y', 'N')]]></check>
       <check name="MA_INDIRECT_COST_VALUE_CAL_CHK"><![CDATA[CALCULATE IN ('Y', 'N')]]></check>
       <check name="MA_INDIRECT_COST_VALUE_ISA_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/MA_MACHINESTATION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MACHINESTATION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="MA_WORKSTATION" name="MA_WORKSTATION_MAMACHINSTAT">
         <reference local="MA_WORKSTATION_ID" foreign="MA_WORKSTATION_ID"/>
       </foreign-key>
+      <index name="MA_MACHINESTATION_WKST_IDX" unique="false">
+        <index-column name="MA_WORKSTATION_ID"/>
+      </index>
       <check name="MA_MACHINESTATI_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MACHINE_COST.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MACHINE_COST.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -94,6 +94,9 @@
       <foreign-key foreignTable="MA_MACHINE" name="MA_MACHINE_COST_MA_MACHINE">
         <reference local="MA_MACHINE_ID" foreign="MA_MACHINE_ID"/>
       </foreign-key>
+      <index name="MA_MACHINECOST_MACHINE_IDX" unique="false">
+        <index-column name="MA_MACHINE_ID"/>
+      </index>
       <check name="MA_MACHINE_COST_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MAINTENANCE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MAINTENANCE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -80,6 +80,12 @@
       <foreign-key foreignTable="MA_MAINT_OPERATION" name="MA_MAINTENANCE_MA_MAINT_OPERAT">
         <reference local="MA_MAINT_OPERATION_ID" foreign="MA_MAINT_OPERATION_ID"/>
       </foreign-key>
+      <index name="MA_MAINTENANCE_MACHINE_IDX" unique="false">
+        <index-column name="MA_MACHINE_ID"/>
+      </index>
+      <index name="MA_MAINTENANCE_MACHINETYPE_IDX" unique="false">
+        <index-column name="MA_MACHINE_TYPE_ID"/>
+      </index>
       <check name="MA_MAINTENANCE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MAINT_PERIODICITY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MAINT_PERIODICITY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -70,6 +70,9 @@
       <foreign-key foreignTable="MA_MAINTENANCE" name="MA_MAINT_PERIODICITY_MA_MAINTE">
         <reference local="MA_MAINTENANCE_ID" foreign="MA_MAINTENANCE_ID"/>
       </foreign-key>
+      <index name="MA_MAINTPERIOD_MAINTENANCE_IDX" unique="false">
+        <index-column name="MA_MAINTENANCE_ID"/>
+      </index>
       <check name="MA_MAINT_PERIODICITY_EXCLU_CHK"><![CDATA[EXCLUDEWEEKEND IN ('Y', 'N')]]></check>
       <check name="MA_MAINT_PERIODICITY_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/MA_MAINT_SCHEDULED.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MAINT_SCHEDULED.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -113,6 +113,9 @@
       <foreign-key foreignTable="MA_MAINTENANCE" name="MA_MAINT_SCHEDULED_MA_MAINTENA">
         <reference local="MA_MAINTENANCE_ID" foreign="MA_MAINTENANCE_ID"/>
       </foreign-key>
+      <index name="MA_MAINTSCD_MAINTPART_IDX" unique="false">
+        <index-column name="MA_MAINT_PART_ID"/>
+      </index>
       <check name="MA_MAINT_SCHEDU_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MAINT_WORKER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MAINT_WORKER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="MA_MAINT_PART" name="MA_MAINT_WORKER_MA_MAINT_PART">
         <reference local="MA_MAINT_PART_ID" foreign="MA_MAINT_PART_ID"/>
       </foreign-key>
+      <index name="MA_MAINTWORKER_MAINTPART_IDX" unique="false">
+        <index-column name="MA_MAINT_PART_ID"/>
+      </index>
       <check name="MA_MAINT_WORKER_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MEASURE_GROUP.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MEASURE_GROUP.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_MEASURE_SHIFT" name="MA_MEASURESHIFT_MAMEASUREGROUP">
         <reference local="MA_MEASURE_SHIFT_ID" foreign="MA_MEASURE_SHIFT_ID"/>
       </foreign-key>
+      <index name="MA_MEASUREGRP_MEASURESHIFT_IDX" unique="false">
+        <index-column name="MA_MEASURE_SHIFT_ID"/>
+      </index>
       <check name="MA_MEASURE_GROU_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MEASURE_TIME.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MEASURE_TIME.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="AD_CLIENT" name="MA_MEASURE_TIME_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
+      <index name="MA_MEASURETIME_MEASUREGRP_IDX" unique="false">
+        <index-column name="MA_MEASURE_GROUP_ID"/>
+      </index>
       <check name="MA_MEASURE_TIME_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_MEASURE_VALUES.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_MEASURE_VALUES.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -73,6 +73,9 @@
       <foreign-key foreignTable="MA_MEASURE_TIME" name="MA_MEASURETIME_MAMEASUREVALUES">
         <reference local="MA_MEASURE_TIME_ID" foreign="MA_MEASURE_TIME_ID"/>
       </foreign-key>
+      <index name="MA_MEASUREVAL_MEASURETIME_IDX" unique="false">
+        <index-column name="MA_MEASURE_TIME_ID"/>
+      </index>
       <check name="MA_MEASURE_VALU_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PC_TEST.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PC_TEST.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="MA_PERIODIC_CONTROL" name="MA_PERIODIC_CONTROL_MAPCTEST">
         <reference local="MA_PERIODIC_CONTROL_ID" foreign="MA_PERIODIC_CONTROL_ID"/>
       </foreign-key>
+      <index name="MA_PCTEST_PERIODICCONTROL_IDX" unique="false">
+        <index-column name="MA_PERIODIC_CONTROL_ID"/>
+      </index>
       <check name="MA_PC_TEST_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PC_VALUE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PC_VALUE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="MA_PC_TEST" name="MA_PC_TEST_MAPCVALUE">
         <reference local="MA_PC_TEST_ID" foreign="MA_PC_TEST_ID"/>
       </foreign-key>
+      <index name="MA_PCVALUE_PCCASE_IDX" unique="false">
+        <index-column name="MA_PC_CASE_ID"/>
+      </index>
       <check name="MA_PC_VALUE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PL_EMPLOYEE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PL_EMPLOYEE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -72,6 +72,9 @@
       <foreign-key foreignTable="M_PRODUCTIONPLAN" name="MA_PL_EMPLOYEE_M_PRODUCTIONPLA">
         <reference local="M_PRODUCTIONPLAN_ID" foreign="M_PRODUCTIONPLAN_ID"/>
       </foreign-key>
+      <index name="MA_PLEMPLOYEE_PRODUCTIONPL_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
       <check name="MA_PL_EMPLOYEE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PL_IC.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PL_IC.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_INDIRECT_COST" name="MA_PL_IC_MA_INDIRECT_COST">
         <reference local="MA_INDIRECT_COST_ID" foreign="MA_INDIRECT_COST_ID"/>
       </foreign-key>
+      <index name="MA_PLIC_PRODUCTIONPLAN_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
       <check name="MA_PL_IC_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PL_INVOICELINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PL_INVOICELINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="M_PRODUCTIONPLAN" name="MA_PL_INVOICELINE_M_PRODUCTION">
         <reference local="M_PRODUCTIONPLAN_ID" foreign="M_PRODUCTIONPLAN_ID"/>
       </foreign-key>
+      <index name="MA_PLINVOICELINE_PRODPLAN_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
       <check name="MA_PL_INVOICELI_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PL_MACHINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PL_MACHINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="MA_MACHINE" name="MA_PL_MACHINE_MA_MACHINE">
         <reference local="MA_MACHINE_ID" foreign="MA_MACHINE_ID"/>
       </foreign-key>
+      <index name="MA_PLMACHINE_PRODPLAN_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
       <check name="MA_PL_MACHINE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_PROCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_PROCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,6 +65,9 @@
       <foreign-key foreignTable="MA_WORKSTATION" name="MA_WORKSTATION_MAPROCESS">
         <reference local="MA_WORKSTATION_ID" foreign="MA_WORKSTATION_ID"/>
       </foreign-key>
+      <index name="MA_PROCESS_WORKSTATION_IDX" unique="false">
+        <index-column name="MA_WORKSTATION_ID"/>
+      </index>
       <check name="MA_PROCESS_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_SEQUENCE" name="MA_SEQUENCE_EMPLOYEE_MA_SEQUEN">
         <reference local="MA_SEQUENCE_ID" foreign="MA_SEQUENCE_ID"/>
       </foreign-key>
+      <index name="MA_SEQUENCEEMPLOYEE_SEQ_IDX" unique="false">
+        <index-column name="MA_SEQUENCE_ID"/>
+      </index>
       <check name="MA_SEQUENCE_EMPLOYEE_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_SEQUENCE_IC.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCE_IC.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_SEQUENCE" name="MA_SEQUENCE_IC_MA_SEQUENCE">
         <reference local="MA_SEQUENCE_ID" foreign="MA_SEQUENCE_ID"/>
       </foreign-key>
+      <index name="MA_SEQUENCEIC_SEQUENCE_IDX" unique="false">
+        <index-column name="MA_SEQUENCE_ID"/>
+      </index>
       <check name="MA_SEQUENCE_IC_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_SEQUENCE" name="MA_SEQUENCE_MACHINE_MA_SEQUENC">
         <reference local="MA_SEQUENCE_ID" foreign="MA_SEQUENCE_ID"/>
       </foreign-key>
+      <index name="MA_SEQUENCEMACHINE_SEQ_IDX" unique="false">
+        <index-column name="MA_SEQUENCE_ID"/>
+      </index>
       <check name="MA_SEQUENCE_MACHINE_ISACTI_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_TOOLSET.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_TOOLSET.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -65,6 +65,9 @@
       <foreign-key foreignTable="MA_TOOLSET_TYPE" name="MA_TOOLSET_TYPEMATOOLSET">
         <reference local="MA_TOOLSET_TYPE_ID" foreign="MA_TOOLSET_TYPE_ID"/>
       </foreign-key>
+      <index name="MA_TOOLSET_TOOLSETTYPE_IDX" unique="false">
+        <index-column name="MA_TOOLSET_TYPE_ID"/>
+      </index>
       <check name="MA_TOOLSET_DISCARDED_CHECK"><![CDATA[DISCARDED IN ('Y', 'N')]]></check>
       <check name="MA_TOOLSET_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/MA_TOOLSETPROCESS.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_TOOLSETPROCESS.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="MA_TOOLSET_TYPE" name="MA_TOOLSETTYPEMATOOLSETPROCESS">
         <reference local="MA_TOOLSET_TYPE_ID" foreign="MA_TOOLSET_TYPE_ID"/>
       </foreign-key>
+      <index name="MA_TOOLSETPROCESS_PROCESS_IDX" unique="false">
+        <index-column name="MA_PROCESS_ID"/>
+      </index>
       <check name="MA_TOOLSETPROCE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_TOOLSETUSED.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_TOOLSETUSED.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="AD_CLIENT" name="MA_TOOLSETUSED_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
+      <index name="MA_TOOLSETUSED_PRODPLAN_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
       <check name="MA_TOOLSETUSED_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_WEEMPLOYEE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_WEEMPLOYEE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="AD_CLIENT" name="MA_WEEMPLOYEE_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
+      <index name="MA_WEEMPLOYEE_PRODUCTION_IDX" unique="false">
+        <index-column name="M_PRODUCTION_ID"/>
+      </index>
       <check name="MA_WEEMPLOYEE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MA_WEINCIDENCE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MA_WEINCIDENCE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -72,6 +72,12 @@
       <foreign-key foreignTable="M_PRODUCTIONPLAN" name="MA_WEINCIDENCE_M_PRODUCTIONPLA">
         <reference local="M_PRODUCTIONPLAN_ID" foreign="M_PRODUCTIONPLAN_ID"/>
       </foreign-key>
+      <index name="MA_WEINCIDENCE_PRODPLAN_IDX" unique="false">
+        <index-column name="M_PRODUCTIONPLAN_ID"/>
+      </index>
+      <index name="MA_WEINCIDENCE_PRODUCTION_IDX" unique="false">
+        <index-column name="M_PRODUCTION_ID"/>
+      </index>
       <check name="MA_WEINCIDENCE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MRP_PLANNINGMETHODLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MRP_PLANNINGMETHODLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -66,6 +66,9 @@
       <foreign-key foreignTable="MRP_PLANNINGMETHOD" name="MRP_PLANNINGMETHOD_PMLINE">
         <reference local="MRP_PLANNINGMETHOD_ID" foreign="MRP_PLANNINGMETHOD_ID"/>
       </foreign-key>
+      <index name="MRP_PLANMETLINE_PLANMET_IDX" unique="false">
+        <index-column name="MRP_PLANNINGMETHOD_ID"/>
+      </index>
       <check name="MRP_PLANNINGMETHODLINE_ISA_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/MRP_SALESFORECASTLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/MRP_SALESFORECASTLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -61,6 +61,9 @@
       <foreign-key foreignTable="MRP_SALESFORECAST" name="MRP_SALESFORECASTLINE_MRP_SALE">
         <reference local="MRP_SALESFORECAST_ID" foreign="MRP_SALESFORECAST_ID"/>
       </foreign-key>
+      <index name="MRP_SALEFRCTLINE_SALEFRCT_IDX" unique="false">
+        <index-column name="MRP_SALESFORECAST_ID"/>
+      </index>
       <check name="MRP_SALESFORECASTLINE_ISAC_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_ATTRIBUTEVALUE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_ATTRIBUTEVALUE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="M_ATTRIBUTE" name="M_ATTRIBUTEVALUE_M_ATTRIBUTE" onDelete="cascade">
         <reference local="M_ATTRIBUTE_ID" foreign="M_ATTRIBUTE_ID"/>
       </foreign-key>
+      <index name="M_ATTRIBUTEVALUE_ATTRIBUTE_IDX" unique="false">
+        <index-column name="M_ATTRIBUTE_ID"/>
+      </index>
       <check name="M_ATTRIBUTEVALU_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_DISCOUNTSCHEMALINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_DISCOUNTSCHEMALINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -175,6 +175,9 @@
       <foreign-key foreignTable="M_PRODUCT" name="M_DISCOUNTSCHEMALINE_M_PRODUCT" onDelete="setnull">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
+      <index name="M_DISCTSCHMLINE_DISCTSCHM_IDX" unique="false">
+        <index-column name="M_DISCOUNTSCHEMA_ID"/>
+      </index>
       <check name="M_DISCOUNTSCHEMALINE_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_FREIGHT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_FREIGHT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -120,5 +120,8 @@
       <foreign-key foreignTable="C_REGION" name="M_FREIGHT_TO_REGION">
         <reference local="TO_REGION_ID" foreign="C_REGION_ID"/>
       </foreign-key>
+      <index name="M_FREIGHT_SHIPPER_IDX" unique="false">
+        <index-column name="M_SHIPPER_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/M_RAPPEL_BPARTNER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RAPPEL_BPARTNER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -73,6 +73,12 @@
       <foreign-key foreignTable="M_RAPPEL" name="M_RAPPEL_M_RAPPEL_BPARTNER">
         <reference local="M_RAPPEL_ID" foreign="M_RAPPEL_ID"/>
       </foreign-key>
+      <index name="M_RAPPELBPARTNER_BPARTNER_IDX" unique="false">
+        <index-column name="C_BPARTNER_ID"/>
+      </index>
+      <index name="M_RAPPELBPARTNER_RAPPEL_IDX" unique="false">
+        <index-column name="M_RAPPEL_ID"/>
+      </index>
       <check name="M_RAPPEL_BPARTNER_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="M_RAPPEL_BPARTNER_ISSOTRX_CHK"><![CDATA[ISSOTRX IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/M_RAPPEL_INVOICE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RAPPEL_INVOICE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="M_RAPPEL_BPARTNER" name="M_RAPPEL_INVOICE_M_RAPPEL_BPAR">
         <reference local="M_RAPPEL_BPARTNER_ID" foreign="M_RAPPEL_BPARTNER_ID"/>
       </foreign-key>
+      <index name="M_RAPPELINVOICE_RAPPELBP_IDX" unique="false">
+        <index-column name="M_RAPPEL_BPARTNER_ID"/>
+      </index>
       <check name="M_RAPPEL_INVOIC_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_RAPPEL_PRODUCT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RAPPEL_PRODUCT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,5 +53,8 @@
       <foreign-key foreignTable="AD_ORG" name="M_RAPPEL_PRODUCT_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="M_RAPPELPRODUCT_RAPPEL_IDX" unique="false">
+        <index-column name="M_RAPPEL_ID"/>
+      </index>
     </table>
   </database>
--- a/src-db/database/model/tables/M_RAPPEL_PRODUCTCATEGORY.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RAPPEL_PRODUCTCATEGORY.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="M_PRODUCT_CATEGORY" name="M_RAPPEL_PRODUCTCATEGORY_M_PRO">
         <reference local="M_PRODUCT_CATEGORY_ID" foreign="M_PRODUCT_CATEGORY_ID"/>
       </foreign-key>
+      <index name="M_RAPPELPRODUCTCTG_RAPPEL_IDX" unique="false">
+        <index-column name="M_RAPPEL_ID"/>
+      </index>
       <check name="M_RAPPEL_PRODUCTCATEGORY_I_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_RAPPEL_SCALE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RAPPEL_SCALE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="AD_ORG" name="M_RAPPEL_SCALE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="M_RAPPELSCALE_RAPPEL_IDX" unique="false">
+        <index-column name="M_RAPPEL_ID"/>
+      </index>
       <check name="M_RAPPEL_SCALE_DISCOUNT_CHK"><![CDATA[(DISCOUNT >= 0) AND (DISCOUNT <= 100)]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_REQUISITIONLINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_REQUISITIONLINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -186,6 +186,9 @@
       <foreign-key foreignTable="C_CURRENCY" name="M_REQUISITIONLINE_C_CURRENCY">
         <reference local="C_CURRENCY_ID" foreign="C_CURRENCY_ID"/>
       </foreign-key>
+      <index name="M_REQUISITIONLN_REQUISIT_IDX" unique="false">
+        <index-column name="M_REQUISITION_ID"/>
+      </index>
       <check name="M_REQUISITIONLI_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_REQUISITIONORDER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_REQUISITIONORDER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,9 @@
       <foreign-key foreignTable="M_REQUISITIONLINE" name="M_REQUISITIONORDER_M_REQUISITI">
         <reference local="M_REQUISITIONLINE_ID" foreign="M_REQUISITIONLINE_ID"/>
       </foreign-key>
+      <index name="M_REQUISITIONORDER_REQLINE_IDX" unique="false">
+        <index-column name="M_REQUISITIONLINE_ID"/>
+      </index>
       <check name="M_REQORDER_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/M_RESERVATION_STOCK.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_RESERVATION_STOCK.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -92,6 +92,9 @@
       <index name="M_RESERVATION_STOCK_SD" unique="false">
         <index-column name="M_STORAGE_DETAIL_ID"/>
       </index>
+      <index name="M_RESERVSTOCK_ORDERLINE_IDX" unique="false">
+        <index-column name="C_ORDERLINE_ID"/>
+      </index>
       <check name="M_RESERVATION_STOCK_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="M_RESERVATION_STOCK_ALLOC_CHK"><![CDATA[ISALLOCATED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/M_TRANSACTION.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_TRANSACTION.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -168,6 +168,9 @@
       <index name="M_TRANSACTION_INVENTORYLINE" unique="false">
         <index-column name="M_INVENTORYLINE_ID"/>
       </index>
+      <index name="M_TRANSACTION_LOCATOR_IDX" unique="false">
+        <index-column name="M_LOCATOR_ID"/>
+      </index>
       <index name="M_TRANSACTION_MOVEMENTLINE" unique="false">
         <index-column name="M_MOVEMENTLINE_ID"/>
       </index>
--- a/src-db/database/model/tables/M_WAREHOUSE_SHIPPER.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/M_WAREHOUSE_SHIPPER.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -57,6 +57,12 @@
       <foreign-key foreignTable="M_WAREHOUSE" name="M_WAREHOUSE_SHIPPER_M_WAREHOUS">
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
+      <index name="M_WAREHOUSESHIPPER_BP_IDX" unique="false">
+        <index-column name="C_BPARTNER_ID"/>
+      </index>
+      <index name="M_WRHSSHIPPER_WRHS_IDX" unique="false">
+        <index-column name="M_WAREHOUSE_ID"/>
+      </index>
       <check name="M_WAREHOUSE_SHI_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/S_RESOURCEASSIGNMENT.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/S_RESOURCEASSIGNMENT.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -70,6 +70,9 @@
       <foreign-key foreignTable="S_RESOURCE" name="S_RESOURCEASSIGNMENT_S_RESOURC">
         <reference local="S_RESOURCE_ID" foreign="S_RESOURCE_ID"/>
       </foreign-key>
+      <index name="S_RESOURCEASSIGNMENT_RESRC_IDX" unique="false">
+        <index-column name="S_RESOURCE_ID"/>
+      </index>
       <check name="S_RESOURCEASSIGNMENT_ISACT_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="S_RESOURCEASSIGNMENT_ISCON_CHK"><![CDATA[ISCONFIRMED IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/S_RESOURCEUNAVAILABLE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/S_RESOURCEUNAVAILABLE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -58,6 +58,9 @@
       <foreign-key foreignTable="S_RESOURCE" name="S_RESOURCEUNAVAILABLE_S_RESOUR" onDelete="cascade">
         <reference local="S_RESOURCE_ID" foreign="S_RESOURCE_ID"/>
       </foreign-key>
+      <index name="S_RESRCUNAVAILABLE_RESRC_IDX" unique="false">
+        <index-column name="S_RESOURCE_ID"/>
+      </index>
       <check name="S_RESOURCEUNAVA_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/tables/S_TIMEEXPENSELINE.xml	Mon Aug 12 08:41:47 2013 +0200
+++ b/src-db/database/model/tables/S_TIMEEXPENSELINE.xml	Mon Aug 12 09:31:25 2013 +0200
@@ -205,6 +205,12 @@
       <foreign-key foreignTable="USER2" name="S_TIMEXPLINE_USER2">
         <reference local="USER2_ID" foreign="USER2_ID"/>
       </foreign-key>
+      <index name="S_TIMEEXPENSELINE_BPARTNER_IDX" unique="false">
+        <index-column name="C_BPARTNER_ID"/>
+      </index>
+      <index name="S_TIMEEXPENSELN_TIMEEXPESE_IDX" unique="false">
+        <index-column name="S_TIMEEXPENSE_ID"/>
+      </index>
       <check name="S_TIMEEXPENSELINE_CHECK1"><![CDATA[(ISINVOICED = 'N') OR (C_BPARTNER_ID IS NOT NULL)]]></check>
       <check name="S_TIMEEXPENSELINE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="S_TIMEEXPENSELINE_ISINVOIC_CHK"><![CDATA[ISINVOICED IN ('Y', 'N')]]></check>