Github user ShruthiRajaram commented on a diff in the pull request:
https://github.com/apache/fineract/pull/465#discussion_r206854038
--- Diff:
fineract-provider/src/main/resources/sql/migrations/core_db/V343__rates.sql ---
@@ -0,0 +1,62 @@
+--
+-- 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 IF NOT EXISTS `m_rate` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `name` varchar(250) NOT NULL,
+ `percentage` decimal(10,2) NOT NULL,
+ `active` tinyint(1) DEFAULT '0',
+ `product_apply` varchar(100) NOT NULL,
+ `created_date` datetime NULL DEFAULT NULL,
+ `createdby_id` bigint(20) NOT NULL,
+ `lastmodifiedby_id` bigint(20) NOT NULL,
+ `lastmodified_date` datetime NULL DEFAULT NULL,
+ `approve_user` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `FK_M_RATE_CREATE_USER` (`createdby_id`),
+ KEY `FK_M_RATE_APPROVE_USER` (`approve_user`),
+ CONSTRAINT `FK_M_RATE_APPROVE_USER` FOREIGN KEY (`approve_user`)
REFERENCES `m_appuser` (`id`),
+ CONSTRAINT `FK_M_RATE_CREATE_USER` FOREIGN KEY (`createdby_id`)
REFERENCES `m_appuser` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
--- End diff --
remove ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
---
