{"action":"created","issue":{"url":"https://api.github.com/repos/do-team/Q-Q/issues/1","repository_url":"https://api.github.com/repos/do-team/Q-Q","labels_url":"https://api.github.com/repos/do-team/Q-Q/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/do-team/Q-Q/issues/1/comments","events_url":"https://api.github.com/repos/do-team/Q-Q/issues/1/events","html_url":"https://github.com/do-team/Q-Q/issues/1","id":159165004,"number":1,"title":"Database model","user":{"login":"martinsalaj","id":18599661,"avatar_url":"https://avatars.githubusercontent.com/u/18599661?v=3","gravatar_id":"","url":"https://api.github.com/users/martinsalaj","html_url":"https://github.com/martinsalaj","followers_url":"https://api.github.com/users/martinsalaj/followers","following_url":"https://api.github.com/users/martinsalaj/following{/other_user}","gists_url":"https://api.github.com/users/martinsalaj/gists{/gist_id}","starred_url":"https://api.github.com/users/martinsalaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinsalaj/subscriptions","organizations_url":"https://api.github.com/users/martinsalaj/orgs","repos_url":"https://api.github.com/users/martinsalaj/repos","events_url":"https://api.github.com/users/martinsalaj/events{/privacy}","received_events_url":"https://api.github.com/users/martinsalaj/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/do-team/Q-Q/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"martinsalaj","id":18599661,"avatar_url":"https://avatars.githubusercontent.com/u/18599661?v=3","gravatar_id":"","url":"https://api.github.com/users/martinsalaj","html_url":"https://github.com/martinsalaj","followers_url":"https://api.github.com/users/martinsalaj/followers","following_url":"https://api.github.com/users/martinsalaj/following{/other_user}","gists_url":"https://api.github.com/users/martinsalaj/gists{/gist_id}","starred_url":"https://api.github.com/users/martinsalaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinsalaj/subscriptions","organizations_url":"https://api.github.com/users/martinsalaj/orgs","repos_url":"https://api.github.com/users/martinsalaj/repos","events_url":"https://api.github.com/users/martinsalaj/events{/privacy}","received_events_url":"https://api.github.com/users/martinsalaj/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2016-06-08T13:35:18Z","updated_at":"2016-06-08T15:56:43Z","closed_at":null,"body":"Table **Groups**\r\n- **groupId**  _int (PK) autoincrement_\r\n- **name** _string NOT NULL_\r\n- **description** _string_\r\n- **insertTimestamp** _datetime NOT NULL_\r\n\r\n\r\nTable **Messages**\r\n- **msgId** _int (PK) autoincrement_ \r\n- **parentMsgId** _int (FK)_\r\n- **groupId** _int NOT NULL (FK)_\r\n- **content** _string NOT NULL_\r\n- **starCnt** _int NOT NULL DEFAULT(0)_\r\n- **insertTimestamp** _datetime NOT NULL_\r\n"},"comment":{"url":"https://api.github.com/repos/do-team/Q-Q/issues/comments/224636578","html_url":"https://github.com/do-team/Q-Q/issues/1#issuecomment-224636578","issue_url":"https://api.github.com/repos/do-team/Q-Q/issues/1","id":224636578,"user":{"login":"martinsalaj","id":18599661,"avatar_url":"https://avatars.githubusercontent.com/u/18599661?v=3","gravatar_id":"","url":"https://api.github.com/users/martinsalaj","html_url":"https://github.com/martinsalaj","followers_url":"https://api.github.com/users/martinsalaj/followers","following_url":"https://api.github.com/users/martinsalaj/following{/other_user}","gists_url":"https://api.github.com/users/martinsalaj/gists{/gist_id}","starred_url":"https://api.github.com/users/martinsalaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinsalaj/subscriptions","organizations_url":"https://api.github.com/users/martinsalaj/orgs","repos_url":"https://api.github.com/users/martinsalaj/repos","events_url":"https://api.github.com/users/martinsalaj/events{/privacy}","received_events_url":"https://api.github.com/users/martinsalaj/received_events","type":"User","site_admin":false},"created_at":"2016-06-08T15:56:43Z","updated_at":"2016-06-08T15:56:43Z","body":"ALTER TABLE `q-q`.`messages` \r\nADD INDEX `groupId_idx` (`groupId` ASC),\r\nADD INDEX `FK_parentMsgId_idx` (`parentMsgId` ASC);\r\nALTER TABLE `q-q`.`messages` \r\nADD CONSTRAINT `FK_groupId`\r\n  FOREIGN KEY (`groupId`)\r\n  REFERENCES `q-q`.`groups` (`groupId`)\r\n  ON DELETE RESTRICT\r\n  ON UPDATE RESTRICT,\r\nADD CONSTRAINT `FK_parentMsgId`\r\n  FOREIGN KEY (`parentMsgId`)\r\n  REFERENCES `q-q`.`messages` (`msgId`)\r\n  ON DELETE RESTRICT\r\n  ON UPDATE RESTRICT;\r\n"}}
{"actor":{"display_login":"martinsalaj"}}