Chaing migration script file extention from txt to sql
Project: http://git-wip-us.apache.org/repos/asf/fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/fineract/commit/455ef982 Tree: http://git-wip-us.apache.org/repos/asf/fineract/tree/455ef982 Diff: http://git-wip-us.apache.org/repos/asf/fineract/diff/455ef982 Branch: refs/heads/develop Commit: 455ef98276d87ee6aadbd67863d86be61d71c04c Parents: b831fa5 Author: Nazeer Hussain Shaik <[email protected]> Authored: Wed Aug 2 18:33:42 2017 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Wed Aug 2 18:33:42 2017 +0530 ---------------------------------------------------------------------- .../V328__family_members_sql_support.sql | 60 ++++++++++++++++++++ .../V328__family_members_sql_support.txt | 60 -------------------- 2 files changed, 60 insertions(+), 60 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/fineract/blob/455ef982/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.sql new file mode 100644 index 0000000..e6e1101 --- /dev/null +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.sql @@ -0,0 +1,60 @@ +-- +-- 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_family_members` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `client_id` bigint(20) NOT NULL, + `firstname` varchar(50) NOT NULL, + `middlename` varchar(50) DEFAULT NULL, + `lastname` varchar(50) DEFAULT NULL, + `qualification` varchar(50) DEFAULT NULL, + `relationship_cv_id` int(11) NOT NULL, + `marital_status_cv_id` int(11) DEFAULT NULL, + `gender_cv_id` int(11) DEFAULT NULL, + `date_of_birth` date DEFAULT NULL, + `age` int(11) DEFAULT NULL, + `profession_cv_id` int(11) DEFAULT NULL, + `mobile_number` varchar(50) DEFAULT NULL, + `is_dependent` tinyint(4) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `FK_m_family_members_client_id_m_client` (`client_id`), + KEY `FK_m_family_members_relationship_m_code_value` (`relationship_cv_id`), + KEY `FK_m_family_members_marital_status_m_code_value` (`marital_status_cv_id`), + KEY `FK_m_family_members_gender_m_code_value` (`gender_cv_id`), + KEY `FK_m_family_members_profession_m_code_value` (`profession_cv_id`), + CONSTRAINT `FK_m_family_members_client_id_m_client` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), + CONSTRAINT `FK_m_family_members_gender_m_code_value` FOREIGN KEY (`gender_cv_id`) REFERENCES `m_code_value` (`id`), + CONSTRAINT `FK_m_family_members_marital_status_m_code_value` FOREIGN KEY (`marital_status_cv_id`) REFERENCES `m_code_value` (`id`), + CONSTRAINT `FK_m_family_members_profession_m_code_value` FOREIGN KEY (`profession_cv_id`) REFERENCES `m_code_value` (`id`), + CONSTRAINT `FK_m_family_members_relationship_m_code_value` FOREIGN KEY (`relationship_cv_id`) REFERENCES `m_code_value` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 + + +-- permissions + +INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'CREATE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'CREATE', 0); +INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'UPDATE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'UPDATE', 0); +INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'DELETE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'DELETE', 0); + +-- code inserts + +INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('MARITAL STATUS', 1); +INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('RELATIONSHIP', 1); +INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('PROFESSION', 1); http://git-wip-us.apache.org/repos/asf/fineract/blob/455ef982/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.txt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.txt b/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.txt deleted file mode 100644 index e6e1101..0000000 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V328__family_members_sql_support.txt +++ /dev/null @@ -1,60 +0,0 @@ --- --- 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_family_members` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT, - `client_id` bigint(20) NOT NULL, - `firstname` varchar(50) NOT NULL, - `middlename` varchar(50) DEFAULT NULL, - `lastname` varchar(50) DEFAULT NULL, - `qualification` varchar(50) DEFAULT NULL, - `relationship_cv_id` int(11) NOT NULL, - `marital_status_cv_id` int(11) DEFAULT NULL, - `gender_cv_id` int(11) DEFAULT NULL, - `date_of_birth` date DEFAULT NULL, - `age` int(11) DEFAULT NULL, - `profession_cv_id` int(11) DEFAULT NULL, - `mobile_number` varchar(50) DEFAULT NULL, - `is_dependent` tinyint(4) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `FK_m_family_members_client_id_m_client` (`client_id`), - KEY `FK_m_family_members_relationship_m_code_value` (`relationship_cv_id`), - KEY `FK_m_family_members_marital_status_m_code_value` (`marital_status_cv_id`), - KEY `FK_m_family_members_gender_m_code_value` (`gender_cv_id`), - KEY `FK_m_family_members_profession_m_code_value` (`profession_cv_id`), - CONSTRAINT `FK_m_family_members_client_id_m_client` FOREIGN KEY (`client_id`) REFERENCES `m_client` (`id`), - CONSTRAINT `FK_m_family_members_gender_m_code_value` FOREIGN KEY (`gender_cv_id`) REFERENCES `m_code_value` (`id`), - CONSTRAINT `FK_m_family_members_marital_status_m_code_value` FOREIGN KEY (`marital_status_cv_id`) REFERENCES `m_code_value` (`id`), - CONSTRAINT `FK_m_family_members_profession_m_code_value` FOREIGN KEY (`profession_cv_id`) REFERENCES `m_code_value` (`id`), - CONSTRAINT `FK_m_family_members_relationship_m_code_value` FOREIGN KEY (`relationship_cv_id`) REFERENCES `m_code_value` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 - - --- permissions - -INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'CREATE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'CREATE', 0); -INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'UPDATE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'UPDATE', 0); -INSERT INTO `m_permission` (`grouping`, `code`, `entity_name`, `action_name`, `can_maker_checker`) VALUES ('portfolio', 'DELETE_FAMILYMEMBERS', 'FAMILYMEMBERS', 'DELETE', 0); - --- code inserts - -INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('MARITAL STATUS', 1); -INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('RELATIONSHIP', 1); -INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('PROFESSION', 1);
