renaming sql script name
Project: http://git-wip-us.apache.org/repos/asf/incubator-fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-fineract/commit/3774900a Tree: http://git-wip-us.apache.org/repos/asf/incubator-fineract/tree/3774900a Diff: http://git-wip-us.apache.org/repos/asf/incubator-fineract/diff/3774900a Branch: refs/heads/develop Commit: 3774900aecb6a0ed18559a9e4a2f38898ee8f43d Parents: 8bdc5f3 Author: Nazeer Hussain Shaik <[email protected]> Authored: Thu Jun 9 16:31:06 2016 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Thu Jun 9 16:31:06 2016 +0530 ---------------------------------------------------------------------- .../migrations/core_db/V309__add_loan_write_off_reason_code.sql | 5 +++++ .../core_db/V4001__add_loan_write_off_reason_code.sql | 5 ----- 2 files changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/3774900a/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 new file mode 100644 index 0000000..422e6ae --- /dev/null +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V309__add_loan_write_off_reason_code.sql @@ -0,0 +1,5 @@ +INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('WriteOffReasons', 1); + +ALTER TABLE `m_loan` +add column `writeoff_reason_cv_id` INT(11) NULL DEFAULT NULL, +add CONSTRAINT `FK_writeoffreason_m_loan_m_code_value` FOREIGN KEY (`writeoff_reason_cv_id`) REFERENCES `m_code_value` (`id`); http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/3774900a/fineract-provider/src/main/resources/sql/migrations/core_db/V4001__add_loan_write_off_reason_code.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V4001__add_loan_write_off_reason_code.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V4001__add_loan_write_off_reason_code.sql deleted file mode 100644 index 422e6ae..0000000 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V4001__add_loan_write_off_reason_code.sql +++ /dev/null @@ -1,5 +0,0 @@ -INSERT INTO `m_code` (`code_name`, `is_system_defined`) VALUES ('WriteOffReasons', 1); - -ALTER TABLE `m_loan` -add column `writeoff_reason_cv_id` INT(11) NULL DEFAULT NULL, -add CONSTRAINT `FK_writeoffreason_m_loan_m_code_value` FOREIGN KEY (`writeoff_reason_cv_id`) REFERENCES `m_code_value` (`id`);
