{"action":"created","issue":{"url":"https://api.github.com/repos/iDTLabssl/fineract/issues/24","repository_url":"https://api.github.com/repos/iDTLabssl/fineract","labels_url":"https://api.github.com/repos/iDTLabssl/fineract/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/iDTLabssl/fineract/issues/24/comments","events_url":"https://api.github.com/repos/iDTLabssl/fineract/issues/24/events","html_url":"https://github.com/iDTLabssl/fineract/pull/24","id":242482817,"number":24,"title":"container added","user":{"login":"nikIntrasoft","id":29913786,"avatar_url":"https://avatars0.githubusercontent.com/u/29913786?v=3","gravatar_id":"","url":"https://api.github.com/users/nikIntrasoft","html_url":"https://github.com/nikIntrasoft","followers_url":"https://api.github.com/users/nikIntrasoft/followers","following_url":"https://api.github.com/users/nikIntrasoft/following{/other_user}","gists_url":"https://api.github.com/users/nikIntrasoft/gists{/gist_id}","starred_url":"https://api.github.com/users/nikIntrasoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nikIntrasoft/subscriptions","organizations_url":"https://api.github.com/users/nikIntrasoft/orgs","repos_url":"https://api.github.com/users/nikIntrasoft/repos","events_url":"https://api.github.com/users/nikIntrasoft/events{/privacy}","received_events_url":"https://api.github.com/users/nikIntrasoft/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-07-12T19:03:56Z","updated_at":"2017-07-13T11:29:53Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/iDTLabssl/fineract/pulls/24","html_url":"https://github.com/iDTLabssl/fineract/pull/24","diff_url":"https://github.com/iDTLabssl/fineract/pull/24.diff","patch_url":"https://github.com/iDTLabssl/fineract/pull/24.patch"},"body":"Description of the issue/feature this PR addresses:\r\n\r\nCurrent behavior before PR:\r\nGLIM application added\r\n\r\nDesired behavior after PR is merged:\r\nMultiple child loans are created with parent loan:\r\nsql migration:\r\n\r\n_create table `glim_accounts`(\r\n`id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n`account_number` varchar(50) NOT NULL,\r\n`principal_amount` bigint(20) NOT NULL,\r\n`child_accounts_count` int NOT NULL,\r\n`accepting_child` tinyint NOT NULL DEFAULT 0,\r\n PRIMARY KEY (`id`),\r\n UNIQUE KEY `glim_account_no_UNIQUE` (`account_number`)\r\n ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;_\r\n \r\n_alter table `m_loan` add CONSTRAINT `FK_glim_id` FOREIGN KEY  (`glim_id`) REFERENCES `glim_accounts` (`id`);_\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/iDTLabssl/fineract/issues/comments/315051316","html_url":"https://github.com/iDTLabssl/fineract/pull/24#issuecomment-315051316","issue_url":"https://api.github.com/repos/iDTLabssl/fineract/issues/24","id":315051316,"user":{"login":"ottoman91","id":5113475,"avatar_url":"https://avatars3.githubusercontent.com/u/5113475?v=3","gravatar_id":"","url":"https://api.github.com/users/ottoman91","html_url":"https://github.com/ottoman91","followers_url":"https://api.github.com/users/ottoman91/followers","following_url":"https://api.github.com/users/ottoman91/following{/other_user}","gists_url":"https://api.github.com/users/ottoman91/gists{/gist_id}","starred_url":"https://api.github.com/users/ottoman91/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ottoman91/subscriptions","organizations_url":"https://api.github.com/users/ottoman91/orgs","repos_url":"https://api.github.com/users/ottoman91/repos","events_url":"https://api.github.com/users/ottoman91/events{/privacy}","received_events_url":"https://api.github.com/users/ottoman91/received_events","type":"User","site_admin":false},"created_at":"2017-07-13T11:29:53Z","updated_at":"2017-07-13T11:29:53Z","body":"@nikIntrasoft there is an error in the SQL migration. it should be as follows: \r\n\r\nCREATE TABLE `glim_accounts`(\r\n`id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r\n`account_number` varchar(50) NOT NULL,\r\n`principal_amount` bigint(20) NOT NULL,\r\n`child_accounts_count` int NOT NULL,\r\n`accepting_child` tinyint NOT NULL,\r\nPRIMARY KEY (`id`),\r\nUNIQUE KEY `glim_account_no_UNIQUE` (`account_number`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;\r\n\r\nALTER TABLE `m_loan` ADD COLUMN `glim_id` BIGINT(20) NULL DEFAULT NULL AFTER `fund_id` ;\r\nALTER TABLE `m_loan` ADD CONSTRAINT `FK_glim_id` FOREIGN KEY (`glim_id`) REFERENCES `glim_accounts` (`id`); \r\n"}}
{"actor":{"display_login":"ottoman91"}}