Correct V322 sql... remove DB name in SQL
Project: http://git-wip-us.apache.org/repos/asf/incubator-fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-fineract/commit/73f8d5eb Tree: http://git-wip-us.apache.org/repos/asf/incubator-fineract/tree/73f8d5eb Diff: http://git-wip-us.apache.org/repos/asf/incubator-fineract/diff/73f8d5eb Branch: refs/heads/develop Commit: 73f8d5eba5cc5d7a6a13f1ed85e46bb55fcbffd1 Parents: 19ba91a Author: Adi Narayana Raju <adi.r...@confluxtechnologies.com> Authored: Mon Nov 14 19:13:32 2016 +0530 Committer: Adi Narayana Raju <adi.r...@confluxtechnologies.com> Committed: Mon Nov 14 19:13:32 2016 +0530 ---------------------------------------------------------------------- .../main/resources/sql/migrations/core_db/V322__sms_campaign.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/73f8d5eb/fineract-provider/src/main/resources/sql/migrations/core_db/V322__sms_campaign.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V322__sms_campaign.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V322__sms_campaign.sql index 025cc3d..21664a1 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V322__sms_campaign.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V322__sms_campaign.sql @@ -195,7 +195,7 @@ INSERT INTO `stretchy_parameter` (`parameter_name`, `parameter_variable`, `param VALUES ('SelectLoanType', 'loanType', 'Loan Type', 'select', 'number', '-1', 'Y', "select\nenum_id as id,\nenum_value as value\nfrom r_enum_value\nwhere enum_name = 'loan_type_enum'", NULL); INSERT INTO `stretchy_parameter` (`parameter_name`, `parameter_variable`, `parameter_label`, `parameter_displayType`, `parameter_FormatType`, `parameter_default`, `special`, `selectOne`, `selectAll`, `parameter_sql`, `parent_id`) VALUES ('DefaultSavings', 'savingsId', 'Savings', 'none', 'number', '-1', NULL, NULL, 'Y', NULL, 5); -INSERT INTO `mifostenant-default`.`stretchy_parameter` (`parameter_name`, `parameter_variable`, `parameter_label`, `parameter_displayType`, `parameter_FormatType`, `parameter_default`, `selectAll`, `parameter_sql`, `parent_id`) VALUES ('DefaultSavingsTransactionId', 'savingsTransactionId', 'Savings Transaction', 'none', 'number', '-1', 'Y', NULL, '5'); +INSERT INTO `stretchy_parameter` (`parameter_name`, `parameter_variable`, `parameter_label`, `parameter_displayType`, `parameter_FormatType`, `parameter_default`, `selectAll`, `parameter_sql`, `parent_id`) VALUES ('DefaultSavingsTransactionId', 'savingsTransactionId', 'Savings Transaction', 'none', 'number', '-1', 'Y', NULL, '5'); SET @LRej = (select id from `stretchy_report` where `report_name`='Loan Rejected'); SET @LApp = (select id from `stretchy_report` where `report_name`='Loan Approved');
