http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql index 7f2a76a..fd07ec5 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_2__product_mapping_delete_duplicate_fund_source_to_account_mappings.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + delete from acc_product_mapping where financial_account_type=10 and payment_type is not null; \ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_3__permissions_form_propose_and_accept_client_transfers.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_3__permissions_form_propose_and_accept_client_transfers.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_3__permissions_form_propose_and_accept_client_transfers.sql index 431bccb..cb48ef7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_3__permissions_form_propose_and_accept_client_transfers.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_3__permissions_form_propose_and_accept_client_transfers.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /**Permissions for proposing and accepting a transfer**/ INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'PROPOSEANDACCEPTTRANSFER_CLIENT', 'CLIENT', 'PROPOSEANDACCEPTTRANSFER', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql index 6fbb2e3..7448d1f 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_4__reset_default_transfers_in_suspense_account_for_existing_savings_products.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /***Delete previously set defaults**/ delete from acc_product_mapping where financial_account_type=10 and product_type=2; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_5__batch_job_entry_for_pay_savings_charge.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_5__batch_job_entry_for_pay_savings_charge.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_5__batch_job_entry_for_pay_savings_charge.sql index fd5fb58..d42e480 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_5__batch_job_entry_for_pay_savings_charge.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_5__batch_job_entry_for_pay_savings_charge.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + INSERT INTO `job` (`name`, `display_name`, `cron_expression`, `create_time`, `task_priority`, `group_name`, `previous_run_start_time`, `next_run_time`, `job_key`, `initializing_errorlog`, `is_active`, `currently_running`, `updates_allowed`, `scheduler_group`, `is_misfired`) VALUES ('Pay Due Savings Charges', 'Pay Due Savings Charges', '0 0 12 * * ?', '2013-09-23 00:00:00', 5, NULL, NULL, NULL, 'Pay Due Savings ChargesJobDetail1 _ DEFAULT', NULL, 1, 0, 1, 0, 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_6__defaults_for_income_from_penalties_for savings_product.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_6__defaults_for_income_from_penalties_for savings_product.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_6__defaults_for_income_from_penalties_for savings_product.sql index 54d2372..0005b6c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_6__defaults_for_income_from_penalties_for savings_product.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_6__defaults_for_income_from_penalties_for savings_product.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /***Set defaults for income from Penalties for existing Saving Products**/ INSERT INTO `acc_product_mapping` (`gl_account_id`,`product_id`,`product_type`,`payment_type`,`charge_id`,`financial_account_type`) select mapping.gl_account_id,mapping.product_id,mapping.product_type,mapping.payment_type,mapping.charge_id, 5 http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_7__move_withdrawal_annual_fee_to_charges.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_7__move_withdrawal_annual_fee_to_charges.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_7__move_withdrawal_annual_fee_to_charges.sql index 8f03fbf..505d960 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_7__move_withdrawal_annual_fee_to_charges.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_7__move_withdrawal_annual_fee_to_charges.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_savings_account_charge` CHANGE COLUMN `due_for_collection_as_of_date` `charge_due_date` DATE NULL DEFAULT NULL AFTER `charge_time_enum`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_8__track_overpayments_seperately_in_loan_transactions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_8__track_overpayments_seperately_in_loan_transactions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_8__track_overpayments_seperately_in_loan_transactions.sql index 8ff31ea..8da617a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118_8__track_overpayments_seperately_in_loan_transactions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118_8__track_overpayments_seperately_in_loan_transactions.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /***Set defaults for income from Penalties for existing Saving Products**/ ALTER TABLE `m_loan_transaction` ADD COLUMN `overpayment_portion_derived` DECIMAL(19,6) NULL DEFAULT NULL AFTER `penalty_charges_portion_derived`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V118__savings_charge.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V118__savings_charge.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V118__savings_charge.sql index 83ea756..eb80cdb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V118__savings_charge.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V118__savings_charge.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + CREATE TABLE `m_savings_account_charge` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `savings_account_id` BIGINT(20) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V119__add_template_table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V119__add_template_table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V119__add_template_table.sql index 2454a20..6eff29c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V119__add_template_table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V119__add_template_table.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + DROP TABLE IF EXISTS `m_template`; CREATE TABLE `m_template` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V11__add-payment-details.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V11__add-payment-details.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V11__add-payment-details.sql index 22aed1f..dd199b6 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V11__add-payment-details.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V11__add-payment-details.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /* New table for storing transaction details (for both loan and savings) */ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V120__accounting_running_balance.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V120__accounting_running_balance.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V120__accounting_running_balance.sql index 6d338d9..02898e6 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V120__accounting_running_balance.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V120__accounting_running_balance.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `acc_gl_journal_entry` ADD COLUMN `is_running_balance_caculated` TINYINT NOT NULL DEFAULT '0' AFTER `lastmodified_date`, ADD COLUMN `office_running_balance` DECIMAL(19,6) NOT NULL DEFAULT '0.000000' AFTER `is_running_balance_caculated`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V121__accounting_running_balance_for_organization.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V121__accounting_running_balance_for_organization.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V121__accounting_running_balance_for_organization.sql index 5946090..3f4b13c 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V121__accounting_running_balance_for_organization.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V121__accounting_running_balance_for_organization.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `acc_gl_journal_entry` ADD COLUMN `organization_running_balance` DECIMAL(19,6) NOT NULL DEFAULT '0.000000' AFTER `office_running_balance`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V122__recurring_fee_support_for_savings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V122__recurring_fee_support_for_savings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V122__recurring_fee_support_for_savings.sql index 85f4c80..67ce97c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V122__recurring_fee_support_for_savings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V122__recurring_fee_support_for_savings.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_charge` ADD COLUMN `fee_on_day` SMALLINT(5) NULL AFTER `amount`, ADD COLUMN `fee_interval` SMALLINT(5) NULL AFTER `fee_on_day`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V123__remove_payment_mode_for_savings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V123__remove_payment_mode_for_savings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V123__remove_payment_mode_for_savings.sql index 9051325..e78e77d 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V123__remove_payment_mode_for_savings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V123__remove_payment_mode_for_savings.sql @@ -1,2 +1,21 @@ +-- +-- 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. +-- + ALTER TABLE `m_charge` CHANGE COLUMN `charge_payment_mode_enum` `charge_payment_mode_enum` SMALLINT(5) NULL DEFAULT NULL AFTER `charge_calculation_enum`; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V124__added_min_max_cap_for_charges.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V124__added_min_max_cap_for_charges.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V124__added_min_max_cap_for_charges.sql index eac4db7..9daae3f 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V124__added_min_max_cap_for_charges.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V124__added_min_max_cap_for_charges.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_charge` ADD COLUMN `min_cap` DECIMAL(19,6) NULL AFTER `is_deleted`, ADD COLUMN `max_cap` DECIMAL(19,6) NULL AFTER `min_cap`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V125__added_column_for_actual_fee_amount_or_percentage.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V125__added_column_for_actual_fee_amount_or_percentage.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V125__added_column_for_actual_fee_amount_or_percentage.sql index 400c658..9b9c010 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V125__added_column_for_actual_fee_amount_or_percentage.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V125__added_column_for_actual_fee_amount_or_percentage.sql @@ -1,2 +1,21 @@ +-- +-- 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. +-- + ALTER TABLE `m_loan_charge` ADD COLUMN `charge_amount_or_percentage` DECIMAL(19,6) NULL DEFAULT NULL AFTER `calculation_on_amount`; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V126__initial_database_structure_for_sms_outbound.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V126__initial_database_structure_for_sms_outbound.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V126__initial_database_structure_for_sms_outbound.sql index 9257f49..d629a9f 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V126__initial_database_structure_for_sms_outbound.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V126__initial_database_structure_for_sms_outbound.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + DROP TABLE IF EXISTS `sms_messages_outbound`; CREATE TABLE `sms_messages_outbound` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V127__mobile_no_fields.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V127__mobile_no_fields.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V127__mobile_no_fields.sql index 7e9f9b1..cb1441c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V127__mobile_no_fields.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V127__mobile_no_fields.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_client` ADD COLUMN `mobile_no` VARCHAR(50) NULL DEFAULT NULL AFTER `display_name`, ADD UNIQUE INDEX `mobile_no_UNIQUE` (`mobile_no` ASC); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V128__added_loan_installment_charge.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V128__added_loan_installment_charge.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V128__added_loan_installment_charge.sql index ed95e72..2251256 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V128__added_loan_installment_charge.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V128__added_loan_installment_charge.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + CREATE TABLE `m_loan_installment_charge` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `loan_charge_id` BIGINT(20) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V129__client_and_group_timeline.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V129__client_and_group_timeline.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V129__client_and_group_timeline.sql index 1c88248..f583b19 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V129__client_and_group_timeline.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V129__client_and_group_timeline.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_client` ADD `submittedon_date` DATE NULL DEFAULT NULL , ADD `submittedon_userid` BIGINT( 20 ) NULL DEFAULT NULL , ADD `activatedon_userid` BIGINT( 20 ) NULL DEFAULT NULL , http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V12__add_external_id_to_couple_of_tables.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V12__add_external_id_to_couple_of_tables.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V12__add_external_id_to_couple_of_tables.sql index 9803937..fe83e44 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V12__add_external_id_to_couple_of_tables.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V12__add_external_id_to_couple_of_tables.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE m_group ADD UNIQUE INDEX `external_id_UNIQUE` (`external_id` ASC) ; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V130__calendar-history-table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V130__calendar-history-table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V130__calendar-history-table.sql index 4592559..f0ccb59 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V130__calendar-history-table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V130__calendar-history-table.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + CREATE TABLE `m_calendar_history` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `calendar_id` BIGINT(20) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V131__holiday-status-column-and-permissions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V131__holiday-status-column-and-permissions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V131__holiday-status-column-and-permissions.sql index e5268f6..a7ae7d7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V131__holiday-status-column-and-permissions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V131__holiday-status-column-and-permissions.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_holiday` ADD COLUMN `status_enum` INT(5) NOT NULL DEFAULT '100' AFTER `repayments_rescheduled_to`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V132__borrower_cycle_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V132__borrower_cycle_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V132__borrower_cycle_changes.sql index e65437a..d29fb86 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V132__borrower_cycle_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V132__borrower_cycle_changes.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + CREATE TABLE `m_product_loan_variations_borrower_cycle` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `loan_product_id` BIGINT(20) NOT NULL DEFAULT '0', http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V133__adding_payment_detail_with_journal_entry.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V133__adding_payment_detail_with_journal_entry.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V133__adding_payment_detail_with_journal_entry.sql index a434861..1178078 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V133__adding_payment_detail_with_journal_entry.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V133__adding_payment_detail_with_journal_entry.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `acc_gl_journal_entry` ADD COLUMN `loan_transaction_id` BIGINT(20) NULL AFTER `transaction_id`, ADD COLUMN `savings_transaction_id` BIGINT(20) NULL AFTER `loan_transaction_id`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_1__submitted_date_updation_for_clients.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_1__submitted_date_updation_for_clients.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_1__submitted_date_updation_for_clients.sql index 962c095..3fadd00 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_1__submitted_date_updation_for_clients.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_1__submitted_date_updation_for_clients.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + UPDATE m_client mc SET mc.submittedon_date=mc.activation_date where mc.submittedon_date is NULL; UPDATE m_client mc SET mc.submittedon_date=now() where mc.submittedon_date is NULL; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql index afcd37c..333819e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V134_2__permissions_spelling_correction.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + update m_permission set grouping="organisation" where grouping = "organistion"; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V134__added_column_value_on_c_configuration.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V134__added_column_value_on_c_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V134__added_column_value_on_c_configuration.sql index b66bd6e..004b93d 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V134__added_column_value_on_c_configuration.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V134__added_column_value_on_c_configuration.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `c_configuration` ADD COLUMN `value` INT NULL AFTER `name`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V135__added_permission_for_undo_written_off.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V135__added_permission_for_undo_written_off.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V135__added_permission_for_undo_written_off.sql index 7162657..fe39aba 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V135__added_permission_for_undo_written_off.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V135__added_permission_for_undo_written_off.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('transaction_loan', 'UNDOWRITEOFF_LOAN', 'LOAN', 'UNDOWRITEOFF', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V136_1__update_script_strechy_parameter.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V136_1__update_script_strechy_parameter.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V136_1__update_script_strechy_parameter.sql index d5b7866..8385462 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V136_1__update_script_strechy_parameter.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V136_1__update_script_strechy_parameter.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + UPDATE stretchy_parameter SET `parameter_sql`='select p.id, p.`name`\r\nfrom m_product_loan p\r\nwhere (p.currency_code = \'${currencyId}\' or \'-1\'= \'${currencyId}\')\r\norder by 2' WHERE parameter_name='loanProductIdSelectAll'; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V137__added_is_active_column_in_m_staff.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V137__added_is_active_column_in_m_staff.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V137__added_is_active_column_in_m_staff.sql index 2726e08..46093c6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V137__added_is_active_column_in_m_staff.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V137__added_is_active_column_in_m_staff.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + ALTER TABLE `m_staff` ADD COLUMN `is_active` TINYINT(1) DEFAULT '0' AFTER `organisational_role_parent_staff_id`; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V138__add_short_name_for_m_product_loan_and_m_savings_product.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V138__add_short_name_for_m_product_loan_and_m_savings_product.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V138__add_short_name_for_m_product_loan_and_m_savings_product.sql index 656d012..97f207d 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V138__add_short_name_for_m_product_loan_and_m_savings_product.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V138__add_short_name_for_m_product_loan_and_m_savings_product.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_product_loan` ADD COLUMN `short_name` VARCHAR(4) NULL DEFAULT NULL AFTER `id`; update m_product_loan set short_name=concat(LEFT(name,2), RIGHT(id,2)) where short_name is null; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V139__default_value_for_is_active_updated_to_true_in_m_staff.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V139__default_value_for_is_active_updated_to_true_in_m_staff.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V139__default_value_for_is_active_updated_to_true_in_m_staff.sql index 8706102..22fea79 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V139__default_value_for_is_active_updated_to_true_in_m_staff.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V139__default_value_for_is_active_updated_to_true_in_m_staff.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_staff` CHANGE COLUMN `is_active` `is_active` TINYINT(1) NOT NULL DEFAULT '1' AFTER `organisational_role_parent_staff_id`; UPDATE `m_staff` SET `is_active`=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql index 57e6dc9..7d355ef 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V13__add_group_and_client_pending_configuration.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + /* http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql index 8bdc81b..7517d31 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V140_1__added_payment_detail_id_in_ac_gl_journal_entry.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `acc_gl_journal_entry` ADD COLUMN `payment_details_id` BIGINT(20) NULL AFTER `organization_running_balance`, ADD CONSTRAINT `FK_acc_gl_journal_entry_m_payment_detail` FOREIGN KEY (`payment_details_id`) REFERENCES `m_payment_detail` (`id`); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V140__added_loan_charge_status.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V140__added_loan_charge_status.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V140__added_loan_charge_status.sql index 3536ffa..431bf2e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V140__added_loan_charge_status.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V140__added_loan_charge_status.sql @@ -1,2 +1,21 @@ +-- +-- 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. +-- + ALTER TABLE `m_loan_charge` ADD COLUMN `is_active` TINYINT(1) NOT NULL DEFAULT '1' AFTER `max_cap`; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V141__add_early_repayment_strategy.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V141__add_early_repayment_strategy.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V141__add_early_repayment_strategy.sql index 1039bfa..6541b3e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V141__add_early_repayment_strategy.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V141__add_early_repayment_strategy.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + INSERT INTO `ref_loan_transaction_processing_strategy` ( `code`, `name`) VALUES ( 'early-repayment-strategy', 'Early Repayment Strategy'); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V142__read_savingsaccount_charge_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V142__read_savingsaccount_charge_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V142__read_savingsaccount_charge_permission.sql index bdda0e8..53dc2ac 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V142__read_savingsaccount_charge_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V142__read_savingsaccount_charge_permission.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + insert into `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'READ_SAVINGSACCOUNTCHARGE', 'SAVINGSACCOUNTCHARGE', 'READ', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V143__create_journalentry_checker_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V143__create_journalentry_checker_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V143__create_journalentry_checker_permission.sql index d78bf70..6301d7d 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V143__create_journalentry_checker_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V143__create_journalentry_checker_permission.sql @@ -1 +1,20 @@ +-- +-- 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. +-- + insert into `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('accounting', 'CREATE_JOURNALENTRY_CHECKER', 'JOURNALENTRY', 'CREATE', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V144__spelling_mistake_corrections.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V144__spelling_mistake_corrections.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V144__spelling_mistake_corrections.sql index f0b5b41..19509bb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V144__spelling_mistake_corrections.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V144__spelling_mistake_corrections.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + RENAME TABLE `x_table_cloumn_code_mappings` TO `x_table_column_code_mappings`; ALTER TABLE `acc_gl_journal_entry` http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V145__add_force_password_reset_in_c_configuration.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V145__add_force_password_reset_in_c_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V145__add_force_password_reset_in_c_configuration.sql index b80b1a8..61b3eb3 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V145__add_force_password_reset_in_c_configuration.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V145__add_force_password_reset_in_c_configuration.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + INSERT INTO `c_configuration` (`id`, `name`, `value`, `enabled`) VALUES (NULL, 'force-password-reset-days', '0', '0'); ALTER TABLE `m_appuser` ADD `last_time_password_updated` DATE NOT NULL , http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V146__tranche_loans.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V146__tranche_loans.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V146__tranche_loans.sql index badd956..f76a0fe 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V146__tranche_loans.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V146__tranche_loans.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_product_loan` ADD COLUMN `multi_disburse_loan` TINYINT(1) NOT NULL DEFAULT '0' AFTER `close_date`, ADD COLUMN `max_tranche_count` INT(2) NULL DEFAULT NULL AFTER `multi_disburse_loan`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V147__tranche_loans_column_name_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V147__tranche_loans_column_name_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V147__tranche_loans_column_name_changes.sql index dc92a11..994ec61 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V147__tranche_loans_column_name_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V147__tranche_loans_column_name_changes.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_product_loan` CHANGE COLUMN `multi_disburse_loan` `allow_multiple_disbursals` TINYINT(1) NOT NULL DEFAULT '0' AFTER `close_date`, CHANGE COLUMN `max_tranche_count` `max_disbursals` INT(2) NULL DEFAULT NULL AFTER `allow_multiple_disbursals`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V148__overdraft_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V148__overdraft_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V148__overdraft_changes.sql index cfe7a41..a4b5daf 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V148__overdraft_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V148__overdraft_changes.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_savings_product` ADD COLUMN `allow_overdraft` TINYINT(1) NOT NULL DEFAULT '0' AFTER `withdrawal_fee_for_transfer`, ADD COLUMN `overdraft_limit` DECIMAL(19,6) NULL DEFAULT NULL AFTER `allow_overdraft`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V149__add_created_date_savings_transaction.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V149__add_created_date_savings_transaction.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V149__add_created_date_savings_transaction.sql index 7af5f3c..bc87cbc 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V149__add_created_date_savings_transaction.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V149__add_created_date_savings_transaction.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_savings_account_transaction` ADD COLUMN `created_date` DATETIME NOT NULL AFTER `cumulative_balance_derived`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V14__rename_status_id_to_enum.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V14__rename_status_id_to_enum.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V14__rename_status_id_to_enum.sql index 8e43f31..2e77a20 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V14__rename_status_id_to_enum.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V14__rename_status_id_to_enum.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE m_group CHANGE COLUMN `status_id` `status_enum` INT(5) NOT NULL DEFAULT '300' ; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V150__basic_savings_report.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V150__basic_savings_report.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V150__basic_savings_report.sql index 0b17ade..ba907dd 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V150__basic_savings_report.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V150__basic_savings_report.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_category`, `report_sql`, `description`, `core_report`, `use_report`) VALUES ('Savings Transactions', 'Pentaho', NULL, 'Savings', NULL, NULL, 0, 1); INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_category`, `report_sql`, `description`, `core_report`, `use_report`) VALUES ('Client Savings Summary', 'Pentaho', NULL, 'Savings', NULL, NULL, 0, 1); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V151__add_default_savings_account_to_client.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V151__add_default_savings_account_to_client.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V151__add_default_savings_account_to_client.sql index c3e040e..3da2169 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V151__add_default_savings_account_to_client.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V151__add_default_savings_account_to_client.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_client` ADD COLUMN `default_savings_account` BIGINT(20) NULL DEFAULT NULL AFTER `default_savings_product`, ADD CONSTRAINT `FK_m_client_m_savings_account` FOREIGN KEY (`default_savings_account`) REFERENCES `m_savings_account` (`id`); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V152__added_grace_for_over_due.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V152__added_grace_for_over_due.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V152__added_grace_for_over_due.sql index fe94c76..d796d89 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V152__added_grace_for_over_due.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V152__added_grace_for_over_due.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + ALTER TABLE `m_product_loan` ADD COLUMN `grace_on_arrears_ageing` SMALLINT(5) NULL DEFAULT NULL AFTER `max_outstanding_loan_balance`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V153__Insert_missed_permissions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V153__Insert_missed_permissions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V153__Insert_missed_permissions.sql index d257259..e4c5004 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V153__Insert_missed_permissions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V153__Insert_missed_permissions.sql @@ -1,3 +1,22 @@ +-- +-- 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. +-- + INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('accounting', 'READ_ACCOUNTINGRULE', 'ACCOUNTINGRULE', 'READ', 0); INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('accounting', 'READ_JOURNALENTRY', 'JOURNALENTRY', 'READ', 0); INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('accounting', 'READ_GLACCOUNT', 'GLACCOUNT', 'READ', 0);
