details: https://code.openbravo.com/erp/devel/pi/rev/d4d102140b5c changeset: 20966:d4d102140b5c user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon Aug 12 08:41:47 2013 +0200 summary: related to issue 20421: Review needed indexes
Changed position of some unique indexes/constrains in order to make first column in the index usable for parent-child tab relationships details: https://code.openbravo.com/erp/devel/pi/rev/3993ddeadfe3 changeset: 20967:3993ddeadfe3 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon Aug 12 09:31:25 2013 +0200 summary: 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 details: https://code.openbravo.com/erp/devel/pi/rev/a7c526a32254 changeset: 20968:a7c526a32254 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon Aug 12 09:43:24 2013 +0200 summary: related to issue 20421: Review needed indexes Added indexes for parent-child tab relationships for tables with other index or unique including relationship not in first place of the index. Adding new indexes for these cases. diffstat: modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_MENU_PARAMETERS.xml | 2 +- modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml | 3 ++ modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml | 3 ++ modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml | 3 ++ modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml | 6 +++++ modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml | 3 ++ modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml | 3 ++ modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml | 3 ++ modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml | 6 +++++ modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml | 3 ++ modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml | 3 ++ modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml | 3 ++ modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml | 3 ++ modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml | 3 ++ modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml | 3 ++ modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml | 3 ++ modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml | 3 ++ src-db/database/model/tables/AD_ALERTRECIPIENT.xml | 3 ++ src-db/database/model/tables/AD_COLUMN.xml | 3 ++ src-db/database/model/tables/AD_DATASET_COLUMN.xml | 3 ++ src-db/database/model/tables/AD_DATASET_TABLE.xml | 3 ++ src-db/database/model/tables/AD_EP_PROCEDURES.xml | 3 ++ src-db/database/model/tables/AD_EXCEPTIONS.xml | 3 ++ src-db/database/model/tables/AD_FORM_ACCESS.xml | 3 ++ src-db/database/model/tables/AD_MODEL_OBJECT.xml | 12 ++++++++++ src-db/database/model/tables/AD_MODEL_OBJECT_MAPPING.xml | 3 ++ src-db/database/model/tables/AD_MODEL_OBJECT_PARA.xml | 3 ++ src-db/database/model/tables/AD_MODULE_DBPREFIX.xml | 3 ++ src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml | 3 ++ src-db/database/model/tables/AD_ORG_ACCTSCHEMA.xml | 3 ++ src-db/database/model/tables/AD_ORG_WAREHOUSE.xml | 3 ++ src-db/database/model/tables/AD_PACKAGE.xml | 3 ++ src-db/database/model/tables/AD_PROCESS_ACCESS.xml | 3 ++ src-db/database/model/tables/AD_REF_SEARCH.xml | 3 ++ src-db/database/model/tables/AD_REF_SEARCH_COLUMN.xml | 3 ++ src-db/database/model/tables/AD_TABLE_ACCESS.xml | 3 ++ src-db/database/model/tables/AD_TEXTINTERFACES_TRL.xml | 2 +- src-db/database/model/tables/AD_USER_ROLES.xml | 3 ++ src-db/database/model/tables/AD_WINDOW_ACCESS.xml | 3 ++ src-db/database/model/tables/A_AMORTIZATIONLINE.xml | 6 +++++ src-db/database/model/tables/A_ASSET.xml | 3 ++ src-db/database/model/tables/C_ACCTSCHEMA_GL.xml | 3 ++ src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml | 3 ++ src-db/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml | 3 ++ src-db/database/model/tables/C_ACCT_RPT_GROUP.xml | 3 ++ src-db/database/model/tables/C_ACCT_RPT_NODE.xml | 3 ++ src-db/database/model/tables/C_BPARTNER_DISCOUNT.xml | 3 ++ src-db/database/model/tables/C_BUDGETLINE.xml | 3 ++ src-db/database/model/tables/C_CITY.xml | 3 ++ src-db/database/model/tables/C_COMMISSIONDETAIL.xml | 3 ++ src-db/database/model/tables/C_CONVERSION_RATE_DOCUMENT.xml | 3 ++ src-db/database/model/tables/C_DEBT_PAYMENT.xml | 3 ++ src-db/database/model/tables/C_DP_MANAGEMENTLINE.xml | 3 ++ src-db/database/model/tables/C_ELEMENTVALUE_OPERAND.xml | 3 ++ src-db/database/model/tables/C_INVOICE_DISCOUNT.xml | 3 ++ src-db/database/model/tables/C_INVOICE_REVERSE.xml | 3 ++ src-db/database/model/tables/C_NONBUSINESSDAY.xml | 3 ++ src-db/database/model/tables/C_ORDER_DISCOUNT.xml | 3 ++ src-db/database/model/tables/C_PAYMENTTERMLINE.xml | 3 ++ src-db/database/model/tables/C_PHASE.xml | 3 ++ src-db/database/model/tables/C_POC_EMAILDEFINITION.xml | 3 ++ src-db/database/model/tables/C_PROJECTLINE.xml | 3 ++ src-db/database/model/tables/C_PROJECTPHASE.xml | 3 ++ src-db/database/model/tables/C_PROJECTPROPOSAL.xml | 3 ++ src-db/database/model/tables/C_PROJECTPROPOSALLINE.xml | 3 ++ src-db/database/model/tables/C_PROJECTPROPOSALTASK.xml | 3 ++ src-db/database/model/tables/C_PROJECTTASK.xml | 3 ++ src-db/database/model/tables/C_PROJECT_VENDOR.xml | 3 ++ src-db/database/model/tables/C_REMITTANCELINE.xml | 3 ++ src-db/database/model/tables/C_REMITTANCE_PARAMETER.xml | 3 ++ src-db/database/model/tables/C_SALARY_CATEGORY_COST.xml | 3 ++ src-db/database/model/tables/C_TASK.xml | 3 ++ src-db/database/model/tables/C_TAXREGISTER.xml | 3 ++ src-db/database/model/tables/C_TAXREGISTERLINE.xml | 3 ++ src-db/database/model/tables/C_TAXREGISTER_TYPE_LINES.xml | 3 ++ src-db/database/model/tables/C_TAX_ZONE.xml | 3 ++ src-db/database/model/tables/C_UOM_CONVERSION.xml | 3 ++ src-db/database/model/tables/FIN_BANKFILE_EXCEPTION.xml | 3 ++ src-db/database/model/tables/FIN_BANKSTATEMENT.xml | 3 ++ src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml | 3 ++ src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml | 3 ++ src-db/database/model/tables/FIN_PAYMENT_CREDIT.xml | 3 ++ src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml | 3 ++ src-db/database/model/tables/FIN_PAYMENT_RUN_PAYMENT.xml | 3 ++ src-db/database/model/tables/FIN_PAY_EXEC_PROCESS_PARA.xml | 3 ++ src-db/database/model/tables/GL_JOURNAL.xml | 3 ++ src-db/database/model/tables/GL_JOURNALLINE.xml | 3 ++ src-db/database/model/tables/MA_CCP.xml | 3 ++ src-db/database/model/tables/MA_CCP_SHIFT.xml | 3 ++ src-db/database/model/tables/MA_COSTCENTER_EMPLOYEE.xml | 3 ++ src-db/database/model/tables/MA_COSTCENTER_IC.xml | 3 ++ src-db/database/model/tables/MA_COSTCENTER_MACHINE.xml | 3 ++ src-db/database/model/tables/MA_COSTCENTER_VERSION.xml | 3 ++ src-db/database/model/tables/MA_GLOBALUSE.xml | 3 ++ src-db/database/model/tables/MA_INDIRECT_COST_VALUE.xml | 3 ++ src-db/database/model/tables/MA_MACHINESTATION.xml | 3 ++ src-db/database/model/tables/MA_MACHINE_COST.xml | 3 ++ src-db/database/model/tables/MA_MAINTENANCE.xml | 6 +++++ src-db/database/model/tables/MA_MAINT_PERIODICITY.xml | 3 ++ src-db/database/model/tables/MA_MAINT_SCHEDULED.xml | 3 ++ src-db/database/model/tables/MA_MAINT_WORKER.xml | 3 ++ src-db/database/model/tables/MA_MEASURE_GROUP.xml | 3 ++ src-db/database/model/tables/MA_MEASURE_TIME.xml | 3 ++ src-db/database/model/tables/MA_MEASURE_VALUES.xml | 3 ++ src-db/database/model/tables/MA_PC_TEST.xml | 3 ++ src-db/database/model/tables/MA_PC_VALUE.xml | 3 ++ src-db/database/model/tables/MA_PL_EMPLOYEE.xml | 3 ++ src-db/database/model/tables/MA_PL_IC.xml | 3 ++ src-db/database/model/tables/MA_PL_INVOICELINE.xml | 3 ++ src-db/database/model/tables/MA_PL_MACHINE.xml | 3 ++ src-db/database/model/tables/MA_PROCESS.xml | 3 ++ src-db/database/model/tables/MA_SEQUENCE_EMPLOYEE.xml | 3 ++ src-db/database/model/tables/MA_SEQUENCE_IC.xml | 3 ++ src-db/database/model/tables/MA_SEQUENCE_MACHINE.xml | 3 ++ src-db/database/model/tables/MA_TOOLSET.xml | 3 ++ src-db/database/model/tables/MA_TOOLSETPROCESS.xml | 3 ++ src-db/database/model/tables/MA_TOOLSETUSED.xml | 3 ++ src-db/database/model/tables/MA_WEEMPLOYEE.xml | 3 ++ src-db/database/model/tables/MA_WEINCIDENCE.xml | 6 +++++ src-db/database/model/tables/MRP_PLANNINGMETHODLINE.xml | 3 ++ src-db/database/model/tables/MRP_SALESFORECASTLINE.xml | 3 ++ src-db/database/model/tables/M_ATTRIBUTEVALUE.xml | 3 ++ src-db/database/model/tables/M_DISCOUNTSCHEMALINE.xml | 3 ++ src-db/database/model/tables/M_FREIGHT.xml | 3 ++ src-db/database/model/tables/M_RAPPEL_BPARTNER.xml | 6 +++++ src-db/database/model/tables/M_RAPPEL_INVOICE.xml | 3 ++ src-db/database/model/tables/M_RAPPEL_PRODUCT.xml | 3 ++ src-db/database/model/tables/M_RAPPEL_PRODUCTCATEGORY.xml | 3 ++ src-db/database/model/tables/M_RAPPEL_SCALE.xml | 3 ++ src-db/database/model/tables/M_REQUISITIONLINE.xml | 3 ++ src-db/database/model/tables/M_REQUISITIONORDER.xml | 3 ++ src-db/database/model/tables/M_RESERVATION_STOCK.xml | 3 ++ src-db/database/model/tables/M_TRANSACTION.xml | 3 ++ src-db/database/model/tables/M_WAREHOUSE_SHIPPER.xml | 6 +++++ src-db/database/model/tables/S_RESOURCEASSIGNMENT.xml | 3 ++ src-db/database/model/tables/S_RESOURCEUNAVAILABLE.xml | 3 ++ src-db/database/model/tables/S_TIMEEXPENSELINE.xml | 6 +++++ 138 files changed, 441 insertions(+), 3 deletions(-) diffs (truncated from 1806 to 300 lines): diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_MENU_PARAMETERS.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_MENU_PARAMETERS.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_MENU_PARAMETERS.xml Mon Aug 12 09:43:24 2013 +0200 @@ -66,8 +66,8 @@ <reference local="AD_MENU_ID" foreign="AD_MENU_ID"/> </foreign-key> <unique name="OBUIAPP_MENU_PARAMETERS_NAME"> + <unique-column name="AD_MENU_ID"/> <unique-column name="AD_CLIENT_ID"/> - <unique-column name="AD_MENU_ID"/> <unique-column name="NAME"/> </unique> <check name="OBUIAPP_MP_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NAVBAR_ROLE_ACCESS.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PROCESS_ACCESS.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_REF_WINDOW.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_ROLE_ACCESS.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml --- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_REF_MASK.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml --- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE_DEPENDENCY.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml --- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_UIDEFINITION.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml --- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_ACCESS.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml --- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml --- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS_MENU_TRL.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml --- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_LIST.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml --- a/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_URL.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml --- a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml --- a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml --- a/modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.service.integration.openid/src-db/database/model/tables/OBSOID_USER_IDENTIFIER.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml --- a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml Mon Aug 12 09:43:24 2013 +0200 @@ -136,8 +136,8 @@ <reference local="VALUEFIELD_ID" foreign="OBUISEL_SELECTOR_FIELD_ID"/> </foreign-key> <unique name="OBUISEL_S_NAME"> + <unique-column name="AD_REFERENCE_ID"/> <unique-column name="NAME"/> - <unique-column name="AD_REFERENCE_ID"/> </unique> <check name="OBUISEL_CUSTOM_QUERY_CHK"><![CDATA[CUSTOM_QUERY IN ('Y', 'N')]]></check> <check name="OBUISEL_SEL_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> diff -r 38dc65517c76 -r a7c526a32254 modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml --- a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 src-db/database/model/tables/AD_ALERTRECIPIENT.xml --- a/src-db/database/model/tables/AD_ALERTRECIPIENT.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/src-db/database/model/tables/AD_ALERTRECIPIENT.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 src-db/database/model/tables/AD_COLUMN.xml --- a/src-db/database/model/tables/AD_COLUMN.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/src-db/database/model/tables/AD_COLUMN.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 src-db/database/model/tables/AD_DATASET_COLUMN.xml --- a/src-db/database/model/tables/AD_DATASET_COLUMN.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/src-db/database/model/tables/AD_DATASET_COLUMN.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 src-db/database/model/tables/AD_DATASET_TABLE.xml --- a/src-db/database/model/tables/AD_DATASET_TABLE.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/src-db/database/model/tables/AD_DATASET_TABLE.xml Mon Aug 12 09:43:24 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> diff -r 38dc65517c76 -r a7c526a32254 src-db/database/model/tables/AD_EP_PROCEDURES.xml --- a/src-db/database/model/tables/AD_EP_PROCEDURES.xml Fri Aug 09 12:48:41 2013 +0200 +++ b/src-db/database/model/tables/AD_EP_PROCEDURES.xml Mon Aug 12 09:43:24 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"/> ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
