Google Git
Sign in
apache / fineract / 6ecbd28121f5fb20781c4a7f1135223d94364eab / . / fineract-provider / src / main / resources / sql / migrations / core_db
tree: a739c93d1c73101b5e9c59ddb16b4ee0a063c657 [path history] [tgz]
  1. V100__Group_saving_summary_report.sql
  2. V101__add_mulitplesof_to_account_transfers_table.sql
  3. V102__client_attendance_tables.sql
  4. V103__cluster_support_for_batch_jobs.sql
  5. V104__permissions_for_transfers.sql
  6. V105__track_loan_transaction_against_office.sql
  7. V106__more_permissions_for_transfers.sql
  8. V107__datatable_code_mappings.sql
  9. V108__client_has_transfer_office.sql
  10. V109__account_transfer_withdrawal_fee_configuration.sql
  11. V10__interest-posting-fields-for-savings.sql
  12. V110__group_center_close.sql
  13. V111_1__set default_transfers_in_suspense_account_for_existing_loan_products.sql
  14. V111__disable_constraint_approach_for_datatables_by_default.sql
  15. V112__mixreport_sql_support.sql
  16. V113__track_savings_transaction_against_office.sql
  17. V114__set_default_transfers_in_suspense_account_for_existing_savings_products - Copy.sql
  18. V115__permissions_for_cache_api.sql
  19. V116__track_currency_for_journal_entries.sql
  20. V117__loan_charge_from_savings.sql
  21. V118_1__savings_charge_patch_update.sql
  22. V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql
  23. V118_3__permissions_form_propose_and_accept_client_transfers.sql
  24. V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql
  25. V118_5__batch_job_entry_for_pay_savings_charge.sql
  26. V118_6__defaults_for_income_from_penalties_for savings_product.sql
  27. V118_7__move_withdrawal_annual_fee_to_charges.sql
  28. V118_8__track_overpayments_seperately_in_loan_transactions.sql
  29. V118__savings_charge.sql
  30. V119__add_template_table.sql
  31. V11__add-payment-details.sql
  32. V120__accounting_running_balance.sql
  33. V121__accounting_running_balance_for_organization.sql
  34. V122__recurring_fee_support_for_savings.sql
  35. V123__remove_payment_mode_for_savings.sql
  36. V124__added_min_max_cap_for_charges.sql
  37. V125__added_column_for_actual_fee_amount_or_percentage.sql
  38. V126__initial_database_structure_for_sms_outbound.sql
  39. V127__mobile_no_fields.sql
  40. V128__added_loan_installment_charge.sql
  41. V129__client_and_group_timeline.sql
  42. V12__add_external_id_to_couple_of_tables.sql
  43. V130__calendar-history-table.sql
  44. V131__holiday-status-column-and-permissions.sql
  45. V132__borrower_cycle_changes.sql
  46. V133__adding_payment_detail_with_journal_entry.sql
  47. V134_1__submitted_date_updation_for_clients.sql
  48. V134_2__permissions_spelling_correction.sql
  49. V134__added_column_value_on_c_configuration.sql
  50. V135__added_permission_for_undo_written_off.sql
  51. V136_1__update_script_strechy_parameter.sql
  52. V137__added_is_active_column_in_m_staff.sql
  53. V138__add_short_name_for_m_product_loan_and_m_savings_product.sql
  54. V139__default_value_for_is_active_updated_to_true_in_m_staff.sql
  55. V13__add_group_and_client_pending_configuration.sql
  56. V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql
  57. V140__added_loan_charge_status.sql
  58. V141__add_early_repayment_strategy.sql
  59. V142__read_savingsaccount_charge_permission.sql
  60. V143__create_journalentry_checker_permission.sql
  61. V144__spelling_mistake_corrections.sql
  62. V145__add_force_password_reset_in_c_configuration.sql
  63. V146__tranche_loans.sql
  64. V147__tranche_loans_column_name_changes.sql
  65. V148__overdraft_changes.sql
  66. V149__add_created_date_savings_transaction.sql
  67. V14__rename_status_id_to_enum.sql
  68. V150__basic_savings_report.sql
  69. V151__add_default_savings_account_to_client.sql
  70. V152__added_grace_for_over_due.sql
  71. V153__Insert_missed_permissions.sql
  72. V154__aging_details.sql
  73. V155__stretchy_into_pentaho.sql
  74. V156__added_loan_saving_txns_pentaho.sql
  75. V157__overdue_charge_improvements.sql
  76. V158__dashboard_and_navigation_queries.sql
  77. V159__add_transaction_id_column_m_portfolio_command_source.sql
  78. V15__center_permissions.sql
  79. V160_2__Allow_nullValue_For_principal_on_lonProduct.sql
  80. V160__standing_instruction_changes.sql
  81. V161__added_accrual_batch_job.sql
  82. V162__overdue_charge_batch_job.sql
  83. V163__added_npa_for_loans.sql
  84. V164__fd_and_rd_deposit_tables.sql
  85. V165__added_permission_for_disburse_to_saving_account.sql
  86. V166__added_deposit_amount_to_product_term_and_preclosure.sql
  87. V167__added_columns_for_writtenOff_loans_recovered.sql
  88. V168__added_transfer_fixed_deposit_interest_to_linked_account.sql
  89. V169__update_dashboard_reports_to_core_reports_use_report_to_false.sql
  90. V16__drop_min_max_column_on_loan_table.sql
  91. V170__update_deposit_accounts_maturity_details_job.sql
  92. V171__added_mandatory_savings_and_rd_changes.sql
  93. V172__accounting_changes_for_transfers.sql
  94. V173__ppi.sql
  95. V174__remove_interest_accrual.sql
  96. V175__added_incentive_interest_rates.sql
  97. V176__updates_to_financial_activity_accounts.sql
  98. V177__cleanup_for_client_incentives.sql
  99. V178__updates_to_financial_activity_accounts_pt2.sql
  100. V179__updates_to_action_names_for_maker_checker_permissions.sql
  101. V17__update_stretchy_reporting_ddl.sql
  102. V180__update_report_schemas_for_disbursed_vs_awaitingdisbursal_and_groupnamesbystaff.sql
  103. V181__standing_instruction_logging.sql
  104. V182__added_min_required_balance_to_savings_product.sql
  105. V183__added_min_balance_for_interest_calculation.sql
  106. V184__update_min_required_balance_for_savings_product.sql
  107. V185__add_accrual_till_date_for_periodic_accrual.sql
  108. V186__added_periodic_accrual_job.sql
  109. V187__added_permission_to_periodic_accrual.sql
  110. V188__add_savingscharge_inactivate_permissions.sql
  111. V189__m_loan_interest_recalculation_tables.sql
  112. V18__update_stretchy_reporting_reportSql.sql
  113. V190__add_associategroup_disassociategroup_permissions.sql
  114. V191__update_gl_account_increase_size_of_name_col.sql
  115. V192__interest_recalculate_job.sql
  116. V193__added_column_joiningDate_for_staff.sql
  117. V194__added_recalculatedInterestComponent_for_interest_recalculation.sql
  118. V195__moved_rest_frequency_to_product_level.sql
  119. V196__added_loan_running_balance_to_transactions.sql
  120. V197__updated_loan_running_balance_of_transactions.sql
  121. V198__loan_rescheduling_tables_and_permissions.sql
  122. V199__removed_extra_columns_from_schedule_history.sql
  123. V19__report_maintenance_permissions.sql
  124. V1__mifosplatform-core-ddl-latest.sql
  125. V200__alter_savings_account_for_start_interest_calculation_date.sql
  126. V201__webhooks.sql
  127. V202__savings_officer_history_table.sql
  128. V203__added_subbmittedDate_loantransaction.sql
  129. V204__insert_script_for_charges_paid_by_for_accruals.sql
  130. V205__fix_for_charge_and_interest_waiver_with_accruals.sql
  131. V206__interest_posting_configuration.sql
  132. V207__min_max_clients_per_group.sql
  133. V208__min_max_clients_in_group_redux.sql
  134. V209__add_all_report_names_in_m_permission_table.sql
  135. V20__report_maint_perms_really_configuration.sql
  136. V210__track_manually_adjusted_transactions.sql
  137. V211__minimum_days_between_disbursal_and_first_repayment.sql
  138. V212__add_NthDay_and_DayOfWeek_columns_loan.sql
  139. V213__NthDay_and_DayOfWeek_columns_should_be_nullable.sql
  140. V214__alter_table_add_create_SI_at_disbursement.sql
  141. V215__guarantee_on_hold_fund_changes.sql
  142. V216__adding_loan_proposed_amount_to_loan.sql
  143. V217__client_substatus_and_codevalue_description.sql
  144. V218__add_user_and_datetime_for_loan_savings_transactions.sql
  145. V219__guarantor_on_hold_fund_changes_for_account.sql
  146. V21__activation-permissions-for-clients.sql
  147. V220__account_number_preferences.sql
  148. V221__add_version_for_m_savings_account.sql
  149. V222__guarantor_on_hold_fund_changes_for_transactions.sql
  150. V223__add_version_for_m_loan_account.sql
  151. V224__client_lifecycle_adding_statuses.sql
  152. V225__permissions_for_updating_recurring_deposit_amount.sql
  153. V226__configuration_for_enforcing_calendars_for_jlg_loans.sql
  154. V227__loan-refund-permissions.sql
  155. V228__entity_to_entity_access.sql
  156. V229__teller_cash_management.sql
  157. V22__alter-group-for-consistency-add-permissions.sql
  158. V230__role_status_and_correspoding_permissions.sql
  159. V231__m_cashier_transaction_added_currency_code.sql
  160. V232__insert_center_closure_reason.sql
  161. V233__Savings_Transaction_Receipt.sql
  162. V234__opening_balaces_setup.sql
  163. V235__add_ugd_template_id_m_hook.sql
  164. V236__individual_collection_sheet_permissions.sql
  165. V237__add_threshold_config_for_last_instalment.sql
  166. V238__update_staff_display_name_length.sql
  167. V239__Loan_Transaction_Receipt.sql
  168. V23__remove-enable-disable-configuration-for-client-group-status.sql
  169. V240__arrears_aging_config_for_interest_recalculation.sql
  170. V241__fixed_emi_changes.sql
  171. V242__entitytoentitymappingrelation.sql
  172. V243__alter_loan_disbursement_details.sql
  173. V244__staff_assignment_history_table.sql
  174. V245__open_rd_changes.sql
  175. V246__drop_group_client_foreign_key_from_m_loan.sql
  176. V247__consistency_wrt_spelling_principalThresholdForLastInstalment.sql
  177. V248__added_password_never_expired_to_User.sql
  178. V249__workingdays_permissions.sql
  179. V24__add-group-client-foreign-key-constraint-in-loan-table.sql
  180. V250__password_validation_policy.sql
  181. V251__paymentType_table.sql
  182. V252__bug_fix_teller_cash_management.sql
  183. V253__product_loan_configurable_attributes.sql
  184. V254__General_Ledger_Report.sql
  185. V255__pre_close_interest_period_config.sql
  186. V256__Update script for General_Ledger_report.sql
  187. V257__staff_image_association.sql
  188. V258__interest_compounding_changes.sql
  189. V259__alter_working_days.sql
  190. V25__update_client_reports_for_status_and_activation_change.sql
  191. V260__alter_password_validation_policy.sql
  192. V261__Update script for Client_Loan_Account_Schedule_Report.sql
  193. V262__accountNumber_for_groups.sql
  194. V263__mifos_reports.sql
  195. V264__insert_paymenttype_and_report_read_permission.sql
  196. V265__modify_external_service_schema.sql
  197. V266__client_fees.sql
  198. V267__client_transaction_permissions.sql
  199. V268__update_gmail_password.sql
  200. V269__increased_calendar_title_length .sql
  201. V26__add-support-for-withdrawal-fees-on-savings.sql
  202. V270__add_rounding_mode_configuration.sql
  203. V271__accounting_for_client_charges.sql
  204. V272__loan_tranche_disbursement_charge.sql
  205. V273__oauth_changes.sql
  206. V274__Loan_Reschedule_Code_Value.sql
  207. V275__loan_transaction_to_repayment_schedule_mapping.sql
  208. V276__loan_recalulated_till_date.sql
  209. V277__Loan_Product_Provisioning.sql
  210. V278__LoanTransactionProcessingStrategy.sql
  211. V279__floating_rates.sql
  212. V27__add-loan-type-column-to-loan-table.sql
  213. V280__spm_framework_initial_tables.sql
  214. V281__add_configuration_param_backdate-penalties.sql
  215. V282__CustomerSelfService.sql
  216. V283__Variable_Installments.sql
  217. V284__update_codevalue.sql
  218. V285__undo_last_tranche_script.sql
  219. V286__partial_period_interest_calcualtion.sql
  220. V287__alter_spm_scorecard.sql
  221. V288__overdraft_interest.sql
  222. V289__client_non_person.sql
  223. V28__accounting-abstractions-and-autoposting.sql
  224. V290__shares_dividends_permissions_script.sql
  225. V291__organisation_start_date_config.sql
  226. V292__update_organisation_start_date.sql
  227. V293__interest_rate_chart_support_for_amounts.sql
  228. V294__configuration_for_paymnettype_application_forDisbursement_charge.sql
  229. V29__add-support-for-annual-fees-on-savings.sql
  230. V2__mifosx-base-reference-data-utf8.sql
  231. V30__add-referenceNumber-to-acc_gl_journal_entry.sql
  232. V31__drop-autopostings.sql
  233. V32__associate-disassociate-clients-from-group-permissions.sql
  234. V33__drop_unique_check_on_stretchy_report_parameter.sql
  235. V34__add_unique_check_on_stretchy_report_parameter.sql
  236. V35__add_hierarchy_column_for_acc_gl_account.sql
  237. V36__add_tag_id_column_for_acc_gl_account.sql
  238. V37__add-center-group-collection-sheet-permissions.sql
  239. V38__add-group-summary-details-report.sql
  240. V39__payment-channels-updates.sql
  241. V3__mifosx-permissions-and-authorisation-utf8.sql
  242. V40__add_permissions_for_accounting_rule.sql
  243. V41__group-summary-reports.sql
  244. V42__Add_default_value_for_id_for_acc_accounting_rule.sql
  245. V43__accounting-for-savings.sql
  246. V44__document-increase-size-of-column-type.sql
  247. V45__create_acc_rule_tags_table.sql
  248. V46__extend_datatables_api.sql
  249. V47__staff-hierarchy-link-to-users.sql
  250. V48__adding-S3-Support.sql
  251. V49__track-loan-charge-payment-transactions.sql
  252. V4__mifosx-core-reports-utf8.sql
  253. V50__add-grace-settings-to-loan-product.sql
  254. V51__track-additional-details-related-to-installment-performance.sql
  255. V52__add_boolean_support_cols_to_acc_accounting_rule.sql
  256. V53__track-advance-and-late-payments-on-installment.sql
  257. V54__charge-to-income-account-mappings.sql
  258. V55__add-additional-transaction-processing-strategies.sql
  259. V56__track-overpaid-amount-on-loans.sql
  260. V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql
  261. V58__create-holiday-tables_changed.sql
  262. V59__add_group_roles_schema_and_permissions.sql
  263. V5__update-savings-product-and-account-tables.sql
  264. V60__quipo_dashboard_reports.sql
  265. V61__txn_running_balance_example.sql
  266. V62__add_staff_id_to_m_client_changed.sql
  267. V63__add_sync_disbursement_with_meeting_column_to_loan.sql
  268. V64__add_permission_for_assign_staff.sql
  269. V65__fix_rupee_symbol_issues.sql
  270. V66__client_close_functionality.sql
  271. V67__loans_in_advance_table.sql
  272. V68__quipo_dashboard_reports_updated.sql
  273. V69__loans_in_advance_initialise.sql
  274. V6__add_min_max_principal_column_to_loan.sql
  275. V70__quipo_program_detail_query_fix.sql
  276. V71__insert_reschedule_repayment_to_configuration.sql
  277. V72__add_m_loan_counter_changes.sql
  278. V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql
  279. V74__alter_m_loan_counter_table_add_group.sql
  280. V75__add_reschedule-repayments-on-holidays_to_configuration.sql
  281. V76__rename_permission_grouping.sql
  282. V77__alter_m_product_loan_changes.sql
  283. V78__breakdown_portfolio_grouping.sql
  284. V79__schedule_jobs_tables.sql
  285. V7__remove_read_makerchecker_permission.sql
  286. V80__schedule_jobs_tables_updates.sql
  287. V81__savings_related_changes.sql
  288. V82__schedule_jobs_tables_updates_for_running_status.sql
  289. V83__non-working-days-table.sql
  290. V84__undo_savings_transaction_permission.sql
  291. V85__product_mix_related_changes.sql
  292. V86__update-working-days.sql
  293. V87__add_permission_for_scheduler.sql
  294. V88__added_update_constrain_for_scheduler_jobs.sql
  295. V89__added_scheduler_group.sql
  296. V8__deposit-transaction-permissions-if-they-exist.sql
  297. V90__client_performance_history_reports.sql
  298. V91_1__configuration_settings_for_holiday_and_non_workingday.sql
  299. V91__apply_annual_fees_permission.sql
  300. V92__group_center_assign_staff_permission.sql
  301. V93__loan_transaction_external_id.sql
  302. V94__added_savings_accont type.sql
  303. V95__batch_job_postInterest.sql
  304. V96__savings_accounts_transfers_table.sql
  305. V97__add_permission_for_adjust_savings_transaction.sql
  306. V98__added_currency_roundof_for_multipleof.sql
  307. V9__add_min_max_constraint_column_to_loan_loanproduct.sql