http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V51__track-additional-details-related-to-installment-performance.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V51__track-additional-details-related-to-installment-performance.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V51__track-additional-details-related-to-installment-performance.sql index a59e5ec..8f4b668 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V51__track-additional-details-related-to-installment-performance.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V51__track-additional-details-related-to-installment-performance.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_loan_repayment_schedule` ADD COLUMN `obligations_met_on_date` DATE NULL DEFAULT NULL AFTER `completed_derived`;
http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V52__add_boolean_support_cols_to_acc_accounting_rule.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V52__add_boolean_support_cols_to_acc_accounting_rule.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V52__add_boolean_support_cols_to_acc_accounting_rule.sql index f042770..16bc0c6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V52__add_boolean_support_cols_to_acc_accounting_rule.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V52__add_boolean_support_cols_to_acc_accounting_rule.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_accounting_rule` ADD COLUMN `allow_multiple_debits` TINYINT(1) NOT NULL DEFAULT '0' AFTER `debit_account_id`, ADD COLUMN `allow_multiple_credits` TINYINT(1) NOT NULL DEFAULT '0' AFTER `credit_account_id`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V53__track-advance-and-late-payments-on-installment.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V53__track-advance-and-late-payments-on-installment.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V53__track-advance-and-late-payments-on-installment.sql index f7858d0..457b826 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V53__track-advance-and-late-payments-on-installment.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V53__track-advance-and-late-payments-on-installment.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_loan_repayment_schedule` ADD COLUMN `total_paid_in_advance_derived` DECIMAL(19,6) NULL DEFAULT NULL AFTER `penalty_charges_waived_derived`, ADD COLUMN `total_paid_late_derived` DECIMAL(19,6) NULL DEFAULT NULL AFTER `total_paid_in_advance_derived`; \ 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/V54__charge-to-income-account-mappings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V54__charge-to-income-account-mappings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V54__charge-to-income-account-mappings.sql index ef63134..75e9727 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V54__charge-to-income-account-mappings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V54__charge-to-income-account-mappings.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_product_mapping` ADD COLUMN `charge_id` BIGINT(20) NULL DEFAULT NULL AFTER `payment_type`, ADD CONSTRAINT `FK_acc_product_mapping_m_charge` FOREIGN KEY (`charge_id`) REFERENCES `m_charge` (`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/V55__add-additional-transaction-processing-strategies.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V55__add-additional-transaction-processing-strategies.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V55__add-additional-transaction-processing-strategies.sql index 48c10f6..54400ed 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V55__add-additional-transaction-processing-strategies.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V55__add-additional-transaction-processing-strategies.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 `ref_loan_transaction_processing_strategy` DROP COLUMN `lastmodified_date` , DROP COLUMN `lastmodifiedby_id` , http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V56__track-overpaid-amount-on-loans.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V56__track-overpaid-amount-on-loans.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V56__track-overpaid-amount-on-loans.sql index 99a235e..ebb820a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V56__track-overpaid-amount-on-loans.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V56__track-overpaid-amount-on-loans.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` ADD COLUMN `total_overpaid_derived` DECIMAL(19,6) NULL DEFAULT NULL AFTER `total_outstanding_derived`; \ 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/V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql index bb52beb..c64939c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V57__add_default_values_to_debit_and_credit_accounts_acc_accounting_rule.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_accounting_rule` CHANGE COLUMN `debit_account_id` `debit_account_id` BIGINT(20) NULL DEFAULT NULL AFTER `office_id`, CHANGE COLUMN `credit_account_id` `credit_account_id` BIGINT(20) NULL DEFAULT NULL AFTER `allow_multiple_debits`; \ 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/V58__create-holiday-tables_changed.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V58__create-holiday-tables_changed.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V58__create-holiday-tables_changed.sql index 35d8326..72d9aa6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V58__create-holiday-tables_changed.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V58__create-holiday-tables_changed.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_holiday`( `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/V59__add_group_roles_schema_and_permissions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V59__add_group_roles_schema_and_permissions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V59__add_group_roles_schema_and_permissions.sql index 16ad5f0..41ceda1 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V59__add_group_roles_schema_and_permissions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V59__add_group_roles_schema_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. +-- + INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('GROUPROLE', 1); INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'ASSIGNROLE_GROUP', 'GROUP', 'ASSIGNROLE', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V5__update-savings-product-and-account-tables.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V5__update-savings-product-and-account-tables.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V5__update-savings-product-and-account-tables.sql index a97eab7..3f6d8b4 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V5__update-savings-product-and-account-tables.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V5__update-savings-product-and-account-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_savings_product` DROP COLUMN `nominal_interest_rate_period_frequency_enum`, CHANGE COLUMN `nominal_interest_rate_per_period` `nominal_annual_interest_rate` DECIMAL(19,6) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V60__quipo_dashboard_reports.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V60__quipo_dashboard_reports.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V60__quipo_dashboard_reports.sql index 22d79e8..1943a5a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V60__quipo_dashboard_reports.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V60__quipo_dashboard_reports.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. +-- + /* Leaving as out-of-box (but non-core reports) for now could be removed later if people think too many non-generic reports are being added http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V61__txn_running_balance_example.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V61__txn_running_balance_example.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V61__txn_running_balance_example.sql index 4a13da0..56fdc4c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V61__txn_running_balance_example.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V61__txn_running_balance_example.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. +-- + /* Leaving as out-of-box (but non-core report) for now could be removed later if people think too many non-generic http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V62__add_staff_id_to_m_client_changed.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V62__add_staff_id_to_m_client_changed.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V62__add_staff_id_to_m_client_changed.sql index af90c29..00d19de 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V62__add_staff_id_to_m_client_changed.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V62__add_staff_id_to_m_client_changed.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 ('portfolio', 'UNASSIGNSTAFF_CLIENT', 'CLIENT', 'UNASSIGNSTAFF', 0); ALTER TABLE m_client ADD COLUMN `staff_id` BIGINT(20) NULL DEFAULT NULL AFTER `office_id`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V63__add_sync_disbursement_with_meeting_column_to_loan.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V63__add_sync_disbursement_with_meeting_column_to_loan.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V63__add_sync_disbursement_with_meeting_column_to_loan.sql index b909e82..30908e6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V63__add_sync_disbursement_with_meeting_column_to_loan.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V63__add_sync_disbursement_with_meeting_column_to_loan.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_loan` http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V64__add_permission_for_assign_staff.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V64__add_permission_for_assign_staff.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V64__add_permission_for_assign_staff.sql index ac46c06..9b3caa5 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V64__add_permission_for_assign_staff.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V64__add_permission_for_assign_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. +-- + INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'ASSIGNSTAFF_CLIENT', 'CLIENT', 'ASSIGNSTAFF', 0); \ 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/V65__fix_rupee_symbol_issues.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V65__fix_rupee_symbol_issues.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V65__fix_rupee_symbol_issues.sql index abc3730..9f687e9 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V65__fix_rupee_symbol_issues.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V65__fix_rupee_symbol_issues.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. +-- + /***Work around for issues on non Unicode safe connections**/ UPDATE `m_currency` SET `display_symbol`=CHAR(226, 130, 185) WHERE `id`=64; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V66__client_close_functionality.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V66__client_close_functionality.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V66__client_close_functionality.sql index 9c54817..d66c3de 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V66__client_close_functionality.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V66__client_close_functionality.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_code` (`code_name`, `is_system_defined`) VALUES ('ClientClosureReason', 1); ALTER TABLE `m_client` ADD COLUMN `closure_reason_cv_id` INT(11) NULL DEFAULT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V67__loans_in_advance_table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V67__loans_in_advance_table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V67__loans_in_advance_table.sql index d6c60d7..47261e1 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V67__loans_in_advance_table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V67__loans_in_advance_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. +-- + /* table contains details of loans that have had overpayments aka payments in advance */ CREATE TABLE `m_loan_paid_in_advance` ( http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V68__quipo_dashboard_reports_updated.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V68__quipo_dashboard_reports_updated.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V68__quipo_dashboard_reports_updated.sql index 7326448..9eaf39f 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V68__quipo_dashboard_reports_updated.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V68__quipo_dashboard_reports_updated.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. +-- + /* Leaving as out-of-box (but non-core reports) for now could be removed later if people think too many non-generic reports are being added http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V69__loans_in_advance_initialise.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V69__loans_in_advance_initialise.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V69__loans_in_advance_initialise.sql index 1341d77..ab60607 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V69__loans_in_advance_initialise.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V69__loans_in_advance_initialise.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. +-- + /* initialises m_loan_paid_in_advance table... same sql is run in daily batch job */ truncate m_loan_paid_in_advance; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V6__add_min_max_principal_column_to_loan.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V6__add_min_max_principal_column_to_loan.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V6__add_min_max_principal_column_to_loan.sql index 4a5c527..d47c6ed 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V6__add_min_max_principal_column_to_loan.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V6__add_min_max_principal_column_to_loan.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 `min_principal_amount` DECIMAL(19,6) NOT NULL AFTER `principal_amount`, ADD COLUMN `max_principal_amount` DECIMAL(19,6) NOT NULL AFTER `min_principal_amount`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V70__quipo_program_detail_query_fix.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V70__quipo_program_detail_query_fix.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V70__quipo_program_detail_query_fix.sql index dcf2952..7c166c3 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V70__quipo_program_detail_query_fix.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V70__quipo_program_detail_query_fix.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 stretchy_report set report_sql = http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V71__insert_reschedule_repayment_to_configuration.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V71__insert_reschedule_repayment_to_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V71__insert_reschedule_repayment_to_configuration.sql index e902697..fa447cc 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V71__insert_reschedule_repayment_to_configuration.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V71__insert_reschedule_repayment_to_configuration.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 `c_configuration` (`name`, `enabled`) VALUES ('reschedule-future-repayments', 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/V72__add_m_loan_counter_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V72__add_m_loan_counter_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V72__add_m_loan_counter_changes.sql index 3cd450c..234d85f 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V72__add_m_loan_counter_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V72__add_m_loan_counter_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 ADD COLUMN `include_in_borrower_cycle` TINYINT(1) 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/V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql index a6f57a7..af55437 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V73__add_repayments_rescheduled_to_and_processed_column_to_holiday.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 `repayments_rescheduled_to` DATETIME NOT NULL AFTER `to_date`, ADD COLUMN `processed` TINYINT(1) NOT NULL DEFAULT '0' AFTER `repayments_rescheduled_to`; \ 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/V74__alter_m_loan_counter_table_add_group.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V74__alter_m_loan_counter_table_add_group.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V74__alter_m_loan_counter_table_add_group.sql index a8df34c..c8b0c12 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V74__alter_m_loan_counter_table_add_group.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V74__alter_m_loan_counter_table_add_group.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 `m_client_loan_counter`; ALTER TABLE `m_loan` ADD COLUMN `loan_counter` SMALLINT NULL DEFAULT NULL AFTER `sync_disbursement_with_meeting`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V75__add_reschedule-repayments-on-holidays_to_configuration.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V75__add_reschedule-repayments-on-holidays_to_configuration.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V75__add_reschedule-repayments-on-holidays_to_configuration.sql index 1325e36..c5ab303 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V75__add_reschedule-repayments-on-holidays_to_configuration.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V75__add_reschedule-repayments-on-holidays_to_configuration.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 `c_configuration` (`name`) VALUES ('reschedule-repayments-on-holidays'); \ 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/V76__rename_permission_grouping.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql index 109f954..5def9a6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V76__rename_permission_grouping.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. +-- + /* break-out center and group permissions from porfolio grouping */ update m_permission http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V77__alter_m_product_loan_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V77__alter_m_product_loan_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V77__alter_m_product_loan_changes.sql index c8a5869..ade7340 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V77__alter_m_product_loan_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V77__alter_m_product_loan_changes.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_product_loan` add column `start_date` DATE NULL DEFAULT NULL , add column `close_date` DATE NULL DEFAULT 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/V78__breakdown_portfolio_grouping.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql index f6b4790..acc3bef 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V78__breakdown_portfolio_grouping.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. +-- + /* grouping is misspelt but also should be under accounting */ update m_permission http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V79__schedule_jobs_tables.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V79__schedule_jobs_tables.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V79__schedule_jobs_tables.sql index a53af33..853ed90 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V79__schedule_jobs_tables.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V79__schedule_jobs_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. +-- + CREATE TABLE `scheduled_jobs` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `job_name` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci', http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V7__remove_read_makerchecker_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V7__remove_read_makerchecker_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V7__remove_read_makerchecker_permission.sql index 8a507e4..27b8017 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V7__remove_read_makerchecker_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V7__remove_read_makerchecker_permission.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. +-- + /* Remove READ_MAKERCHECKER permission as no longer used. http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V80__schedule_jobs_tables_updates.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V80__schedule_jobs_tables_updates.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V80__schedule_jobs_tables_updates.sql index 19dfa51..ea24db7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V80__schedule_jobs_tables_updates.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V80__schedule_jobs_tables_updates.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 `scheduled_jobs` TO `job`; RENAME TABLE `scheduled_job_runhistory` TO `job_run_history`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V81__savings_related_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V81__savings_related_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V81__savings_related_changes.sql index b36b4ae..7cfed45 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V81__savings_related_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V81__savings_related_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_note` ADD COLUMN `savings_account_id` BIGINT(20) NULL DEFAULT NULL AFTER `loan_transaction_id`, ADD COLUMN `savings_account_transaction_id` BIGINT(20) NULL DEFAULT NULL AFTER `savings_account_id`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V82__schedule_jobs_tables_updates_for_running_status.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V82__schedule_jobs_tables_updates_for_running_status.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V82__schedule_jobs_tables_updates_for_running_status.sql index e540dca..f3b0cd4 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V82__schedule_jobs_tables_updates_for_running_status.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V82__schedule_jobs_tables_updates_for_running_status.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 `job` ADD COLUMN `currently_running` TINYINT(1) NOT NULL DEFAULT '0' AFTER `is_active`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V83__non-working-days-table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V83__non-working-days-table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V83__non-working-days-table.sql index 475a0ee..a33ec58 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V83__non-working-days-table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V83__non-working-days-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_working_days` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `recurrence` VARCHAR(100) NULL DEFAULT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V84__undo_savings_transaction_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V84__undo_savings_transaction_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V84__undo_savings_transaction_permission.sql index 16860a4..7e83660 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V84__undo_savings_transaction_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V84__undo_savings_transaction_permission.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 http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V85__product_mix_related_changes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V85__product_mix_related_changes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V85__product_mix_related_changes.sql index 704fe22..6c4e745 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V85__product_mix_related_changes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V85__product_mix_related_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_portfolio_command_source` ADD COLUMN `product_id` BIGINT NULL DEFAULT NULL AFTER `processing_result_enum`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V86__update-working-days.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V86__update-working-days.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V86__update-working-days.sql index 323b00a..445d8da 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V86__update-working-days.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V86__update-working-days.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. +-- + TRUNCATE `m_working_days`; INSERT INTO `m_working_days` (`recurrence`, `repayment_rescheduling_enum`) VALUES ('FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU', 2); \ 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/V87__add_permission_for_scheduler.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V87__add_permission_for_scheduler.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V87__add_permission_for_scheduler.sql index 4e7d90f..8eec12e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V87__add_permission_for_scheduler.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V87__add_permission_for_scheduler.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 ('jobs', 'UPDATE_SCHEDULER', 'SCHEDULER', 'UPDATE', 0); \ 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/V88__added_update_constrain_for_scheduler_jobs.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V88__added_update_constrain_for_scheduler_jobs.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V88__added_update_constrain_for_scheduler_jobs.sql index c73bc93..dd2cd2c 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V88__added_update_constrain_for_scheduler_jobs.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V88__added_update_constrain_for_scheduler_jobs.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 `job` ADD COLUMN `updates_allowed` TINYINT(1) NOT NULL DEFAULT '1' AFTER `currently_running`; \ 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/V89__added_scheduler_group.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V89__added_scheduler_group.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V89__added_scheduler_group.sql index 95f6f1c..bb318b3 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V89__added_scheduler_group.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V89__added_scheduler_group.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 `job` ADD COLUMN `scheduler_group` SMALLINT(2) NOT NULL DEFAULT '0' AFTER `updates_allowed`; \ 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/V8__deposit-transaction-permissions-if-they-exist.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql index db40322..9901d08 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V8__deposit-transaction-permissions-if-they-exist.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. +-- + delete from m_permission where grouping = 'transaction_deposit'; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V90__client_performance_history_reports.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V90__client_performance_history_reports.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V90__client_performance_history_reports.sql index a6fdf5d..b613d8c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V90__client_performance_history_reports.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V90__client_performance_history_reports.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. +-- + INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_category`, `report_sql`, `description`, `core_report`, `use_report`) VALUES ('ClientSummary ', 'Table', NULL, NULL, 'SELECT x.* FROM m_client c, m_office o, \n(\n SELECT a.loanCycle, a.activeLoans, b.lastLoanAmount, d.activeSavings, d.totalSavings FROM \n (SELECT IFNULL(MAX(l.loan_counter),0) AS loanCycle, COUNT(l.id) AS activeLoans FROM m_loan l WHERE l.loan_status_id=300 AND l.client_id=${clientId}) a, \n (SELECT count(l.id), IFNULL(l.principal_amount,0) AS \'lastLoanAmount\' FROM m_loan l WHERE l.client_id=${clientId} AND l.disbursedon_date = (SELECT IFNULL(MAX(disbursedon_date),NOW()) FROM m_loan where client_id=${clientId} and loan_status_id=300)) b, \n (SELECT COUNT(s.id) AS \'activeSavings\', IFNULL(SUM(s.account_balance_derived),0) AS \'totalSavings\' FROM m_savings_account s WHERE s.status_enum=300 AND s.client_id=${clientId}) d\n) x\nWHERE c.id=${clientId} AND o.id = c.office_id AN D o.hierarchy LIKE CONCAT(\'${currentUserHierarchy}\', \'%\')', 'Utility query for getting the client summary details', 1, 0); INSERT INTO `stretchy_report` (`report_name`, `report_type`, `report_subtype`, `report_category`, `report_sql`, `description`, `core_report`, `use_report`) VALUES ('LoanCyclePerProduct', 'Table', NULL, NULL, 'SELECT lp.name AS \'productName\', MAX(l.loan_product_counter) AS \'loanProductCycle\' FROM m_loan l JOIN m_product_loan lp ON l.product_id=lp.id WHERE lp.include_in_borrower_cycle=1 AND l.loan_product_counter IS NOT NULL AND l.client_id=${clientId} GROUP BY l.product_id', 'Utility query for getting the client loan cycle details', 1, 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V91_1__configuration_settings_for_holiday_and_non_workingday.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V91_1__configuration_settings_for_holiday_and_non_workingday.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V91_1__configuration_settings_for_holiday_and_non_workingday.sql index 0b84ea2..71c3a34 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V91_1__configuration_settings_for_holiday_and_non_workingday.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V91_1__configuration_settings_for_holiday_and_non_workingday.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. +-- + INSERT INTO `c_configuration` (`name`, `enabled`) VALUES ('allow-transactions-on-holiday', 0); INSERT INTO `c_configuration` (`name`, `enabled`) VALUES ('allow-transactions-on-non_workingday', 0); \ 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/V91__apply_annual_fees_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V91__apply_annual_fees_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V91__apply_annual_fees_permission.sql index c82bc74..f2457a3 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V91__apply_annual_fees_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V91__apply_annual_fees_permission.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 http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql index d471067..c6c4f04 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V92__group_center_assign_staff_permission.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. +-- + INSERT INTO `m_permission` (grouping,code,`entity_name`,`action_name`,`can_maker_checker`) values('portfolio_group','ASSIGNSTAFF_GROUP','GROUP','ASSIGNSTAFF',0); \ 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/V93__loan_transaction_external_id.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V93__loan_transaction_external_id.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V93__loan_transaction_external_id.sql index e5b136c..be6102c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V93__loan_transaction_external_id.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V93__loan_transaction_external_id.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_loan_transaction ADD COLUMN `external_id` VARCHAR(100) NULL DEFAULT NULL AFTER `is_reversed` , ADD UNIQUE INDEX `external_id_UNIQUE` (`external_id` ASC) ; \ 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/V94__added_savings_accont type.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V94__added_savings_accont type.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V94__added_savings_accont type.sql index 87985e7..1ad8b89 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V94__added_savings_accont type.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V94__added_savings_accont type.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_savings_account` ADD COLUMN `account_type_enum` SMALLINT(5) NOT NULL DEFAULT '1' AFTER `status_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/V95__batch_job_postInterest.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V95__batch_job_postInterest.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V95__batch_job_postInterest.sql index 58fda9d..33f2c0b 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V95__batch_job_postInterest.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V95__batch_job_postInterest.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`) VALUES ('Post Interest For Savings', 'Post Interest For Savings', '0 0 0 1/1 * ? *', now(), 5, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V96__savings_accounts_transfers_table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V96__savings_accounts_transfers_table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V96__savings_accounts_transfers_table.sql index 425b17b..d4b3de3 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V96__savings_accounts_transfers_table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V96__savings_accounts_transfers_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. +-- + INSERT INTO `m_permission` (`grouping`,`code`,`entity_name`,`action_name`,`can_maker_checker`) VALUES
