Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 8B6C6200B33 for ; Wed, 29 Jun 2016 13:16:49 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 8A0C7160A6F; Wed, 29 Jun 2016 11:16:49 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 41B59160A4D for ; Wed, 29 Jun 2016 13:16:47 +0200 (CEST) Received: (qmail 23542 invoked by uid 500); 29 Jun 2016 11:16:46 -0000 Mailing-List: contact commits-help@fineract.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@fineract.incubator.apache.org Delivered-To: mailing list commits@fineract.incubator.apache.org Received: (qmail 23533 invoked by uid 99); 29 Jun 2016 11:16:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2016 11:16:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E4ABD187B93 for ; Wed, 29 Jun 2016 11:16:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.646 X-Spam-Level: X-Spam-Status: No, score=-4.646 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-1.426] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id s-g85ndiMO7k for ; Wed, 29 Jun 2016 11:16:32 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id E62C260E25 for ; Wed, 29 Jun 2016 11:16:29 +0000 (UTC) Received: (qmail 22523 invoked by uid 99); 29 Jun 2016 11:16:29 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2016 11:16:29 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id CDF92E5CE1; Wed, 29 Jun 2016 11:16:28 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: nazeer1100126@apache.org To: commits@fineract.incubator.apache.org Date: Wed, 29 Jun 2016 11:16:30 -0000 Message-Id: <16db718646d14076831d3572122101fd@git.apache.org> In-Reply-To: <593f7832cdb043d683c01d38a0268599@git.apache.org> References: <593f7832cdb043d683c01d38a0268599@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [3/9] incubator-fineract git commit: Adding License, Notice, Apache license to sql, sh, bat files archived-at: Wed, 29 Jun 2016 11:16:49 -0000 http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V286__partial_period_interest_calcualtion.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V286__partial_period_interest_calcualtion.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V286__partial_period_interest_calcualtion.sql index d107b76..b0a901e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V286__partial_period_interest_calcualtion.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V286__partial_period_interest_calcualtion.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 `allow_partial_period_interest_calcualtion` TINYINT(1) NOT NULL DEFAULT '0' AFTER `interest_calculated_in_period_enum`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V287__alter_spm_scorecard.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V287__alter_spm_scorecard.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V287__alter_spm_scorecard.sql index a5b852b..e94effc 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V287__alter_spm_scorecard.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V287__alter_spm_scorecard.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 FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS `m_survey_scorecards`; CREATE TABLE `m_survey_scorecards` ( http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V288__overdraft_interest.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V288__overdraft_interest.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V288__overdraft_interest.sql index ca3843f..11d1f5d 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V288__overdraft_interest.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V288__overdraft_interest.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` ADD COLUMN `nominal_annual_interest_rate_overdraft` DECIMAL(19,6) NULL DEFAULT 0 AFTER `overdraft_limit`, ADD COLUMN `total_overdraft_interest_derived` DECIMAL(19,6) NULL DEFAULT 0 AFTER `total_interest_posted_derived`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V289__client_non_person.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V289__client_non_person.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V289__client_non_person.sql index 1393860..b7311e2 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V289__client_non_person.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V289__client_non_person.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 ("Constitution", true); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V28__accounting-abstractions-and-autoposting.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V28__accounting-abstractions-and-autoposting.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V28__accounting-abstractions-and-autoposting.sql index 8861af9..c5119dd 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V28__accounting-abstractions-and-autoposting.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V28__accounting-abstractions-and-autoposting.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 `acc_accounting_rule` ( `id` BIGINT(20) NOT NULL, `name` 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/V290__shares_dividends_permissions_script.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V290__shares_dividends_permissions_script.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V290__shares_dividends_permissions_script.sql index 1bf56e9..5d6cb52 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V290__shares_dividends_permissions_script.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V290__shares_dividends_permissions_script.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 ('SHAREPRODUCT', 'CREATE_SHAREPRODUCT', 'SHAREPRODUCT', 'CREATE', 0), ('SHAREPRODUCT', 'UPDATE_SHAREPRODUCT', 'SHAREPRODUCT', 'CREATE', 0), http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V291__organisation_start_date_config.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V291__organisation_start_date_config.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V291__organisation_start_date_config.sql index 90848f0..4407beb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V291__organisation_start_date_config.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V291__organisation_start_date_config.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 `c_configuration` ADD COLUMN `date_value` DATE NULL DEFAULT NULL AFTER `value`; \ 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/V292__update_organisation_start_date.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V292__update_organisation_start_date.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V292__update_organisation_start_date.sql index 5bb8e91..2b21641 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V292__update_organisation_start_date.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V292__update_organisation_start_date.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`, `value`, `date_value`, `enabled`, `is_trap_door`, `description`) VALUES ('organisation-start-date', 0, NULL, 0, 0, NULL); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V293__interest_rate_chart_support_for_amounts.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V293__interest_rate_chart_support_for_amounts.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V293__interest_rate_chart_support_for_amounts.sql index ccd4028..15ed511 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V293__interest_rate_chart_support_for_amounts.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V293__interest_rate_chart_support_for_amounts.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_interest_rate_slab` CHANGE COLUMN `from_period` `from_period` INT(11) NULL DEFAULT NULL, CHANGE COLUMN `period_type_enum` `period_type_enum` SMALLINT(5) NULL DEFAULT NULL ; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V294__configuration_for_paymnettype_application_forDisbursement_charge.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V294__configuration_for_paymnettype_application_forDisbursement_charge.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V294__configuration_for_paymnettype_application_forDisbursement_charge.sql index 3c4ac2b..70a39b7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V294__configuration_for_paymnettype_application_forDisbursement_charge.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V294__configuration_for_paymnettype_application_forDisbursement_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 `c_configuration` (`name`, `value`, `enabled`, `is_trap_door`, `description`) VALUES ('paymenttype-applicable-for-disbursement-charges', NULL, 0, 0, 'Is the Disbursement Entry need to be considering the fund source of the paymnet type'); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V295__configuration_for_interest_charged_date_same_as_disbursal_date.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V295__configuration_for_interest_charged_date_same_as_disbursal_date.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V295__configuration_for_interest_charged_date_same_as_disbursal_date.sql index 0d1c255..f995b83 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V295__configuration_for_interest_charged_date_same_as_disbursal_date.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V295__configuration_for_interest_charged_date_same_as_disbursal_date.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`, `value`, `date_value`, `enabled`, `is_trap_door`, `description`) VALUES ('interest-charged-from-date-same-as-disbursal-date', 0, NULL, 0, 0, NULL); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V296__skip_repayment_on first-day_of_month.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V296__skip_repayment_on first-day_of_month.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V296__skip_repayment_on first-day_of_month.sql index be3d7a2..4a6dc99 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V296__skip_repayment_on first-day_of_month.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V296__skip_repayment_on first-day_of_month.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,value,description) values("skip-repayment-on-first-day-of-month",14,"skipping repayment on first day of month"); \ 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/V297__Adding_Meeting_Time_column.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V297__Adding_Meeting_Time_column.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V297__Adding_Meeting_Time_column.sql index 9d4b2a7..8b151db 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V297__Adding_Meeting_Time_column.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V297__Adding_Meeting_Time_column.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_calendar add meeting_time Time \ 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/V298__savings_interest_tax.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V298__savings_interest_tax.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V298__savings_interest_tax.sql index 1bc0854..e3a3ceb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V298__savings_interest_tax.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V298__savings_interest_tax.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_tax_component` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V299__share_products.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V299__share_products.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V299__share_products.sql index 509d167..969c419 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V299__share_products.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V299__share_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. +-- + CREATE TABLE `m_share_product` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARCHAR(200) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V29__add-support-for-annual-fees-on-savings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V29__add-support-for-annual-fees-on-savings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V29__add-support-for-annual-fees-on-savings.sql index a471920..2d7f565 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V29__add-support-for-annual-fees-on-savings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V29__add-support-for-annual-fees-on-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_savings_product` ADD COLUMN `annual_fee_amount` DECIMAL(19,6) NULL DEFAULT NULL AFTER `withdrawal_fee_type_enum`, ADD COLUMN `annual_fee_on_month` SMALLINT(5) NULL DEFAULT NULL AFTER `annual_fee_amount`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V2__mifosx-base-reference-data-utf8.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V2__mifosx-base-reference-data-utf8.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V2__mifosx-base-reference-data-utf8.sql index 73d4bfe..0aa274c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V2__mifosx-base-reference-data-utf8.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V2__mifosx-base-reference-data-utf8.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. +-- + -- currency symbols may not apply through command line on windows so use a different client like mysql workbench INSERT INTO `ref_loan_transaction_processing_strategy` http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V300__configuration_for_allow_changing_of_emi_amount.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V300__configuration_for_allow_changing_of_emi_amount.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V300__configuration_for_allow_changing_of_emi_amount.sql index dc784ca..6d955f1 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V300__configuration_for_allow_changing_of_emi_amount.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V300__configuration_for_allow_changing_of_emi_amount.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` CHANGE COLUMN `name` `name` VARCHAR(100) NULL DEFAULT NULL AFTER `id`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V301__recurring_moratorium_principal_periods.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V301__recurring_moratorium_principal_periods.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V301__recurring_moratorium_principal_periods.sql index ad4ddf3..cba3b51 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V301__recurring_moratorium_principal_periods.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V301__recurring_moratorium_principal_periods.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 `recurring_moratorium_principal_periods` SMALLINT(5) NULL DEFAULT NULL AFTER `grace_on_principal_periods`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql index 9397b2e..1f04d1e 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V302__add_status_to_client_identifier.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_identifier` ADD COLUMN `status` INT(5) NOT NULL DEFAULT 300 AFTER `document_key`, DROP INDEX `unique_client_identifier`, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V303__Savings_Account_Dormancy.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V303__Savings_Account_Dormancy.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V303__Savings_Account_Dormancy.sql index 6820148..72d7025 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V303__Savings_Account_Dormancy.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V303__Savings_Account_Dormancy.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 `is_dormancy_tracking_active` SMALLINT(1) NULL, ADD COLUMN `days_to_inactive` INT(11) NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V304__customer_self_service_third_party_transfers.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V304__customer_self_service_third_party_transfers.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V304__customer_self_service_third_party_transfers.sql index fc6be77..00d07e8 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V304__customer_self_service_third_party_transfers.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V304__customer_self_service_third_party_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. +-- + INSERT INTO `c_configuration` (`name`, `value`, `date_value`, `enabled`, `is_trap_door`, `description`) VALUES ( 'daily-tpt-limit', 0, NULL, 0, 0, 'Daily limit for third party transfers'); CREATE TABLE `m_selfservice_beneficiaries_tpt` ( http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V305__compounding_and_rest_frequency_nth_day_freq_and_insertion_script_for_accrual_job.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V305__compounding_and_rest_frequency_nth_day_freq_and_insertion_script_for_accrual_job.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V305__compounding_and_rest_frequency_nth_day_freq_and_insertion_script_for_accrual_job.sql index fba505b..f5af1fd 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V305__compounding_and_rest_frequency_nth_day_freq_and_insertion_script_for_accrual_job.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V305__compounding_and_rest_frequency_nth_day_freq_and_insertion_script_for_accrual_job.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_interest_recalculation_additional_details` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `loan_repayment_schedule_id` BIGINT NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V306__add_domancy_tracking_job_to_savings_group.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V306__add_domancy_tracking_job_to_savings_group.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V306__add_domancy_tracking_job_to_savings_group.sql index ff7e468..56b5e7d 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V306__add_domancy_tracking_job_to_savings_group.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V306__add_domancy_tracking_job_to_savings_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. +-- + UPDATE `job` SET `task_priority`=3, `scheduler_group`=1 WHERE `name`='Update Savings Dormant Accounts'; \ 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/V307__add_share_notes.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V307__add_share_notes.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V307__add_share_notes.sql index 9e52c3e..3cf5a12 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V307__add_share_notes.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V307__add_share_notes.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_note` ADD COLUMN `share_account_id` BIGINT(20) NULL DEFAULT NULL AFTER `savings_account_transaction_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/V308__add_interest_recalculation_in_savings_account.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V308__add_interest_recalculation_in_savings_account.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V308__add_interest_recalculation_in_savings_account.sql index 010766a..16585e8 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V308__add_interest_recalculation_in_savings_account.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V308__add_interest_recalculation_in_savings_account.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` ADD COLUMN `last_interest_calculation_date` DATE NULL DEFAULT NULL AFTER `tax_group_id`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.sql index 422e6ae..95cb92c 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.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 ('WriteOffReasons', 1); 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/V30__add-referenceNumber-to-acc_gl_journal_entry.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V30__add-referenceNumber-to-acc_gl_journal_entry.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V30__add-referenceNumber-to-acc_gl_journal_entry.sql index 2e77fda..7ce406a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V30__add-referenceNumber-to-acc_gl_journal_entry.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V30__add-referenceNumber-to-acc_gl_journal_entry.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 `acc_gl_journal_entry` add column `ref_num` varchar(100) default NULL AFTER `reversed`; \ 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/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql index 17089ad..3073abb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V310__copy_data_from_entitytoentityaccess_to_entitytoentitymapping.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 ignore into m_entity_to_entity_mapping (from_id,to_id,rel_id) select mea.entity_id as fromId, mea.second_entity_id as toid, http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V311__foreclosure_details.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V311__foreclosure_details.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V311__foreclosure_details.sql index 63bfc29..ddf27c5 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V311__foreclosure_details.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V311__foreclosure_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. +-- + INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'FORECLOSURE_LOAN', 'LOAN', 'FORECLOSURE', 0), ('portfolio', 'FORECLOSURE_LOAN_CHECKER', 'LOAN', 'FORECLOSURE_CHECKER', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V31__drop-autopostings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V31__drop-autopostings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V31__drop-autopostings.sql index f2e3618..7aa3ea9 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V31__drop-autopostings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V31__drop-autopostings.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. +-- + drop table `acc_auto_posting`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V32__associate-disassociate-clients-from-group-permissions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V32__associate-disassociate-clients-from-group-permissions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V32__associate-disassociate-clients-from-group-permissions.sql index 700eb36..f6ba6b9 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V32__associate-disassociate-clients-from-group-permissions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V32__associate-disassociate-clients-from-group-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 ('portfolio', 'ASSOCIATECLIENTS_GROUP', 'GROUP', 'ASSOCIATECLIENTS', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V33__drop_unique_check_on_stretchy_report_parameter.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V33__drop_unique_check_on_stretchy_report_parameter.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V33__drop_unique_check_on_stretchy_report_parameter.sql index af31b43..2fe5faa 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V33__drop_unique_check_on_stretchy_report_parameter.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V33__drop_unique_check_on_stretchy_report_parameter.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 stretchy_report_parameter DROP INDEX `report_id_name_UNIQUE` ; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V34__add_unique_check_on_stretchy_report_parameter.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V34__add_unique_check_on_stretchy_report_parameter.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V34__add_unique_check_on_stretchy_report_parameter.sql index eec244f..e270641 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V34__add_unique_check_on_stretchy_report_parameter.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V34__add_unique_check_on_stretchy_report_parameter.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 stretchy_report_parameter ADD UNIQUE INDEX `report_parameter_unique` (`report_id` ASC, `parameter_id` ASC) ; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V35__add_hierarchy_column_for_acc_gl_account.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V35__add_hierarchy_column_for_acc_gl_account.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V35__add_hierarchy_column_for_acc_gl_account.sql index f84fceb..d8b9ece 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V35__add_hierarchy_column_for_acc_gl_account.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V35__add_hierarchy_column_for_acc_gl_account.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 `acc_gl_account` ADD COLUMN `hierarchy` varchar(50) AFTER `parent_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/V36__add_tag_id_column_for_acc_gl_account.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V36__add_tag_id_column_for_acc_gl_account.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V36__add_tag_id_column_for_acc_gl_account.sql index 9dadf2f..47518b6 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V36__add_tag_id_column_for_acc_gl_account.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V36__add_tag_id_column_for_acc_gl_account.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_account` ADD COLUMN `tag_id` INT(11) NULL DEFAULT NULL AFTER `classification_enum`, ADD INDEX `FKGLACC000000002` (`tag_id`), http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V37__add-center-group-collection-sheet-permissions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V37__add-center-group-collection-sheet-permissions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V37__add-center-group-collection-sheet-permissions.sql index 141f1fc..24c0ab7 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V37__add-center-group-collection-sheet-permissions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V37__add-center-group-collection-sheet-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 ('portfolio', 'SAVECOLLECTIONSHEET_GROUP', 'GROUP', 'SAVECOLLECTIONSHEET', 0); INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'SAVECOLLECTIONSHEET_CENTER', 'CENTER', 'SAVECOLLECTIONSHEET', 0); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V38__add-group-summary-details-report.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V38__add-group-summary-details-report.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V38__add-group-summary-details-report.sql index 467c197..848aca5 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V38__add-group-summary-details-report.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V38__add-group-summary-details-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`, `core_report`, `use_report`, `description`, `report_sql`) http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V39__payment-channels-updates.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V39__payment-channels-updates.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V39__payment-channels-updates.sql index 5ca90f9..66b94d9 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V39__payment-channels-updates.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V39__payment-channels-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. +-- + INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('PaymentType',1); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql index 589056b..aca686b 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V3__mifosx-permissions-and-authorisation-utf8.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. +-- +  -- ========= roles and permissions ========= http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V40__add_permissions_for_accounting_rule.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V40__add_permissions_for_accounting_rule.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V40__add_permissions_for_accounting_rule.sql index 9959cfd..3e2de8a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V40__add_permissions_for_accounting_rule.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V40__add_permissions_for_accounting_rule.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 ('organistion', 'DELETE_ACCOUNTINGRULE', 'ACCOUNTINGRULE', 'DELETE', 0),('organistion', 'CREATE_ACCOUNTINGRULE', 'ACCOUNTINGRULE', 'CREATE', 0),('organistion', 'UPDATE_ACCOUNTINGRULE', 'ACCOUNTINGRULE', '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/V41__group-summary-reports.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V41__group-summary-reports.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V41__group-summary-reports.sql index 91c17af..06997da 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V41__group-summary-reports.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V41__group-summary-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. +-- + DELETE FROM `stretchy_report` where report_name = 'GroupSummaryDetails'; DELETE FROM `m_permission` where entity_name = 'GroupSummaryDetails'; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V42__Add_default_value_for_id_for_acc_accounting_rule.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V42__Add_default_value_for_id_for_acc_accounting_rule.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V42__Add_default_value_for_id_for_acc_accounting_rule.sql index d0d9d87..619ff21 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V42__Add_default_value_for_id_for_acc_accounting_rule.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V42__Add_default_value_for_id_for_acc_accounting_rule.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 `acc_accounting_rule` CHANGE COLUMN `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT FIRST; \ 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/V43__accounting-for-savings.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V43__accounting-for-savings.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V43__accounting-for-savings.sql index cf2e1ce..7c884f4 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V43__accounting-for-savings.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V43__accounting-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. +-- + /*add accounting type field to savings product*/ ALTER TABLE `m_savings_product` ADD COLUMN `accounting_type` SMALLINT(5) NOT NULL AFTER `lockin_period_frequency_enum`; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V44__document-increase-size-of-column-type.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V44__document-increase-size-of-column-type.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V44__document-increase-size-of-column-type.sql index c09286c..6424ed2 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V44__document-increase-size-of-column-type.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V44__document-increase-size-of-column-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_document` CHANGE COLUMN `type` `type` VARCHAR(500) NULL DEFAULT NULL AFTER `size`; \ 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/V45__create_acc_rule_tags_table.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V45__create_acc_rule_tags_table.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V45__create_acc_rule_tags_table.sql index b17bc2e..d10b09a 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V45__create_acc_rule_tags_table.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V45__create_acc_rule_tags_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 `acc_rule_tags` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `acc_rule_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/V46__extend_datatables_api.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V46__extend_datatables_api.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V46__extend_datatables_api.sql index 8a90512..2cf8623 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V46__extend_datatables_api.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V46__extend_datatables_api.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/V47__staff-hierarchy-link-to-users.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V47__staff-hierarchy-link-to-users.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V47__staff-hierarchy-link-to-users.sql index 9a220bd..d83a733 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V47__staff-hierarchy-link-to-users.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V47__staff-hierarchy-link-to-users.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_appuser` 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/V48__adding-S3-Support.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V48__adding-S3-Support.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V48__adding-S3-Support.sql index 775e96e..aed77f5 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V48__adding-S3-Support.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V48__adding-S3-Support.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 (name,enabled) VALUES ('amazon-S3',0); /*New table for storing details of external services used*/ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V49__track-loan-charge-payment-transactions.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V49__track-loan-charge-payment-transactions.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V49__track-loan-charge-payment-transactions.sql index 3e6a983..c4899eb 100755 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V49__track-loan-charge-payment-transactions.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V49__track-loan-charge-payment-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. +-- + CREATE TABLE `m_loan_charge_paid_by` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `loan_transaction_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/V4__mifosx-core-reports-utf8.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql index 9995005..60297fb 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V4__mifosx-core-reports-utf8.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. +-- + truncate table stretchy_report; truncate table stretchy_parameter; truncate table stretchy_report_parameter; http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/07c3cd1b/fineract-provider/src/main/resources/sql/migrations/core_db/V50__add-grace-settings-to-loan-product.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V50__add-grace-settings-to-loan-product.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V50__add-grace-settings-to-loan-product.sql index 96f23e9..e0a670b 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V50__add-grace-settings-to-loan-product.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V50__add-grace-settings-to-loan-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 `grace_on_principal_periods` SMALLINT(5) NULL DEFAULT NULL AFTER `max_number_of_repayments`, ADD COLUMN `grace_on_interest_periods` SMALLINT(5) NULL DEFAULT NULL AFTER `grace_on_principal_periods`,