This is an automated email from the ASF dual-hosted git repository.
adamsaghy pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
The following commit(s) were added to refs/heads/develop by this push:
new 334da61ed8 FINERACT-2348: Add missing indexes
334da61ed8 is described below
commit 334da61ed890b66b95745ac199f712f434646f97
Author: Adam Saghy <[email protected]>
AuthorDate: Mon Oct 6 10:09:08 2025 +0200
FINERACT-2348: Add missing indexes
---
...create_loan_amortization_allocation_mapping.xml | 60 ++++++++++++++++++++++
1 file changed, 60 insertions(+)
diff --git
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0195_create_loan_amortization_allocation_mapping.xml
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0195_create_loan_amortization_allocation_mapping.xml
index 31ee2c26af..1c1dc74704 100644
---
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0195_create_loan_amortization_allocation_mapping.xml
+++
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0195_create_loan_amortization_allocation_mapping.xml
@@ -104,4 +104,64 @@
onDelete="RESTRICT" onUpdate="RESTRICT"
referencedColumnNames="id"
referencedTableName="m_loan_transaction"
validate="true"/>
</changeSet>
+ <changeSet id="4" author="fineract" context="postgresql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping" columnNames="loan_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index concurrently idx_m_loan_am_all_map_base_loan_id on
m_loan_amortization_allocation_mapping(loan_id);
+ </sql>
+ </changeSet>
+ <changeSet id="5" author="fineract" context="mysql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping" columnNames="loan_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index idx_m_loan_am_all_map_base_loan_id on
batch_step_execution(loan_id);
+ </sql>
+ </changeSet>
+ <changeSet id="6" author="fineract" context="postgresql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping"
columnNames="base_loan_transaction_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index concurrently idx_m_loan_am_all_map_base_loan_txn_id
on m_loan_amortization_allocation_mapping(base_loan_transaction_id);
+ </sql>
+ </changeSet>
+ <changeSet id="7" author="fineract" context="mysql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping"
columnNames="base_loan_transaction_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index idx_m_loan_am_all_map_base_loan_txn_id on
batch_step_execution(base_loan_transaction_id);
+ </sql>
+ </changeSet>
+ <changeSet id="8" author="fineract" context="postgresql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping"
columnNames="amortization_loan_transaction_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index concurrently idx_m_loan_am_all_map_amort_loan_txn_id
on m_loan_amortization_allocation_mapping(amortization_loan_transaction_id);
+ </sql>
+ </changeSet>
+ <changeSet id="9" author="fineract" context="mysql"
runInTransaction="false">
+ <preConditions onFail="MARK_RAN">
+ <not>
+ <indexExists
tableName="m_loan_amortization_allocation_mapping"
columnNames="amortization_loan_transaction_id"/>
+ </not>
+ </preConditions>
+ <sql>
+ create index idx_m_loan_am_all_map_amort_loan_txn_id on
batch_step_execution(amortization_loan_transaction_id);
+ </sql>
+ </changeSet>
</databaseChangeLog>
