Removing autoincrement values from 15 in V334__notification_module_tables.sql
Project: http://git-wip-us.apache.org/repos/asf/fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/fineract/commit/3e1705a4 Tree: http://git-wip-us.apache.org/repos/asf/fineract/tree/3e1705a4 Diff: http://git-wip-us.apache.org/repos/asf/fineract/diff/3e1705a4 Branch: refs/heads/develop Commit: 3e1705a4773fa214df0173e90df05739f143b486 Parents: c60c660 Author: Nazeer Hussain Shaik <[email protected]> Authored: Mon Aug 21 16:17:52 2017 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Mon Aug 21 16:17:52 2017 +0530 ---------------------------------------------------------------------- .../sql/migrations/core_db/V334__notification_module_tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/fineract/blob/3e1705a4/fineract-provider/src/main/resources/sql/migrations/core_db/V334__notification_module_tables.sql ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V334__notification_module_tables.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V334__notification_module_tables.sql index 8fa6dd6..8d68126 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V334__notification_module_tables.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V334__notification_module_tables.sql @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `notification_generator` ( `notification_content` text, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; +); CREATE TABLE IF NOT EXISTS `notification_mapper` ( @@ -39,7 +39,7 @@ CREATE TABLE IF NOT EXISTS `notification_mapper` ( PRIMARY KEY (`id`), KEY `notification_mapper` (`user_id`), KEY `notification_id` (`notification_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; +); ALTER TABLE `notification_mapper` ADD CONSTRAINT `notification_mapper_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `m_appuser` (`id`),
