This is an automated email from the ASF dual-hosted git repository. aleks pushed a commit to branch develop in repository https://gitbox.apache.org/repos/asf/fineract.git
commit cad37ed956e45d9dae7ad2099d6260cc24106450 Author: Adam Saghy <[email protected]> AuthorDate: Sun Aug 7 23:14:12 2022 +0200 FINERACT-1670: Add some missing indexes --- .../db/changelog/tenant/changelog-tenant.xml | 2 ++ .../tenant/parts/0032_add_some_missing_indexes.xml | 36 ++++++++++++++++++++++ 2 files changed, 38 insertions(+) diff --git a/fineract-provider/src/main/resources/db/changelog/tenant/changelog-tenant.xml b/fineract-provider/src/main/resources/db/changelog/tenant/changelog-tenant.xml index b1cbcb18f..946fae600 100644 --- a/fineract-provider/src/main/resources/db/changelog/tenant/changelog-tenant.xml +++ b/fineract-provider/src/main/resources/db/changelog/tenant/changelog-tenant.xml @@ -51,4 +51,6 @@ <include file="parts/0029_add_delinquency_buckets.xml" relativeToChangelogFile="true"/> <include file="parts/0030_add_audit_entries_to_business_date.xml" relativeToChangelogFile="true"/> <include file="parts/0031_add_audit_entries_to_client_identifier.xml" relativeToChangelogFile="true"/> + <include file="parts/0032_add_some_missing_indexes.xml" relativeToChangelogFile="true"/> +>>>>>>> 92a62bc2d (FINERACT-1670: Add some missing indexes) </databaseChangeLog> diff --git a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0032_add_some_missing_indexes.xml b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0032_add_some_missing_indexes.xml new file mode 100644 index 000000000..0935dea78 --- /dev/null +++ b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0032_add_some_missing_indexes.xml @@ -0,0 +1,36 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + Licensed to the Apache Software Foundation (ASF) under one + or more contributor license agreements. See the NOTICE file + distributed with this work for additional information + regarding copyright ownership. The ASF licenses this file + to you under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance + with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, + software distributed under the License is distributed on an + "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the + specific language governing permissions and limitations + under the License. + +--> +<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"; + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd";> + <changeSet author="fineract" id="missing-indexes-1"> + <createIndex indexName="FK_client_transaction_submitted_on_date" tableName="m_client_transaction"> + <column name="submitted_on_date"/> + </createIndex> + + </changeSet> + <changeSet id="fineract" author="missing-indexes-2"> + <createIndex indexName="FK_acc_gl_journal_entry_submitted_on_date" tableName="acc_gl_journal_entry"> + <column name="submitted_on_date"/> + </createIndex> + </changeSet> +</databaseChangeLog>
