{"action":"created","issue":{"url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/2","repository_url":"https://api.github.com/repos/Wolfie-Home/Documents","labels_url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/2/comments","events_url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/2/events","html_url":"https://github.com/Wolfie-Home/Documents/issues/2","id":171935533,"number":2,"title":"Resign MySQL DB Schema in the Design Document","user":{"login":"cjackie","id":4708191,"avatar_url":"https://avatars.githubusercontent.com/u/4708191?v=3","gravatar_id":"","url":"https://api.github.com/users/cjackie","html_url":"https://github.com/cjackie","followers_url":"https://api.github.com/users/cjackie/followers","following_url":"https://api.github.com/users/cjackie/following{/other_user}","gists_url":"https://api.github.com/users/cjackie/gists{/gist_id}","starred_url":"https://api.github.com/users/cjackie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjackie/subscriptions","organizations_url":"https://api.github.com/users/cjackie/orgs","repos_url":"https://api.github.com/users/cjackie/repos","events_url":"https://api.github.com/users/cjackie/events{/privacy}","received_events_url":"https://api.github.com/users/cjackie/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"cjackie","id":4708191,"avatar_url":"https://avatars.githubusercontent.com/u/4708191?v=3","gravatar_id":"","url":"https://api.github.com/users/cjackie","html_url":"https://github.com/cjackie","followers_url":"https://api.github.com/users/cjackie/followers","following_url":"https://api.github.com/users/cjackie/following{/other_user}","gists_url":"https://api.github.com/users/cjackie/gists{/gist_id}","starred_url":"https://api.github.com/users/cjackie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjackie/subscriptions","organizations_url":"https://api.github.com/users/cjackie/orgs","repos_url":"https://api.github.com/users/cjackie/repos","events_url":"https://api.github.com/users/cjackie/events{/privacy}","received_events_url":"https://api.github.com/users/cjackie/received_events","type":"User","site_admin":false},"assignees":[{"login":"cjackie","id":4708191,"avatar_url":"https://avatars.githubusercontent.com/u/4708191?v=3","gravatar_id":"","url":"https://api.github.com/users/cjackie","html_url":"https://github.com/cjackie","followers_url":"https://api.github.com/users/cjackie/followers","following_url":"https://api.github.com/users/cjackie/following{/other_user}","gists_url":"https://api.github.com/users/cjackie/gists{/gist_id}","starred_url":"https://api.github.com/users/cjackie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjackie/subscriptions","organizations_url":"https://api.github.com/users/cjackie/orgs","repos_url":"https://api.github.com/users/cjackie/repos","events_url":"https://api.github.com/users/cjackie/events{/privacy}","received_events_url":"https://api.github.com/users/cjackie/received_events","type":"User","site_admin":false},{"login":"kbumsik","id":7823583,"avatar_url":"https://avatars.githubusercontent.com/u/7823583?v=3","gravatar_id":"","url":"https://api.github.com/users/kbumsik","html_url":"https://github.com/kbumsik","followers_url":"https://api.github.com/users/kbumsik/followers","following_url":"https://api.github.com/users/kbumsik/following{/other_user}","gists_url":"https://api.github.com/users/kbumsik/gists{/gist_id}","starred_url":"https://api.github.com/users/kbumsik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbumsik/subscriptions","organizations_url":"https://api.github.com/users/kbumsik/orgs","repos_url":"https://api.github.com/users/kbumsik/repos","events_url":"https://api.github.com/users/kbumsik/events{/privacy}","received_events_url":"https://api.github.com/users/kbumsik/received_events","type":"User","site_admin":false}],"milestone":null,"comments":10,"created_at":"2016-08-18T15:51:12Z","updated_at":"2016-08-22T15:08:13Z","closed_at":null,"body":"The schema needs to be changed and removes JSON objects in the table. And express relationships in a database way.\r\nsimilar issue: [1](https://github.com/Wolfie-Home/webserver2/issues/3)\r\nReasons:\r\n- cleaner design; easy to reason and think about.\r\n- conform to convention. As a result, potential reuse of existing library, code or algorithm.\r\n- performance(not that important, since it is a small project)"},"comment":{"url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/comments/241443733","html_url":"https://github.com/Wolfie-Home/Documents/issues/2#issuecomment-241443733","issue_url":"https://api.github.com/repos/Wolfie-Home/Documents/issues/2","id":241443733,"user":{"login":"cjackie","id":4708191,"avatar_url":"https://avatars.githubusercontent.com/u/4708191?v=3","gravatar_id":"","url":"https://api.github.com/users/cjackie","html_url":"https://github.com/cjackie","followers_url":"https://api.github.com/users/cjackie/followers","following_url":"https://api.github.com/users/cjackie/following{/other_user}","gists_url":"https://api.github.com/users/cjackie/gists{/gist_id}","starred_url":"https://api.github.com/users/cjackie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjackie/subscriptions","organizations_url":"https://api.github.com/users/cjackie/orgs","repos_url":"https://api.github.com/users/cjackie/repos","events_url":"https://api.github.com/users/cjackie/events{/privacy}","received_events_url":"https://api.github.com/users/cjackie/received_events","type":"User","site_admin":false},"created_at":"2016-08-22T15:08:13Z","updated_at":"2016-08-22T15:08:13Z","body":"@kbumsik \r\nHaha, do you have to do a presentation at the end as well? I had to do one for my internship. Anyway, good job.\r\n\r\nSo, I have tried to import your DB schema with the following command:\r\n```\r\nmysql -u [username] -p[password] [db] < Create_tables.sql \r\n```\r\nand I recieved:\r\n_ERROR 1067 (42000) at line 11: Invalid default value for 'CreatedTime'_\r\n\r\n"}}
{"actor":{"display_login":"cjackie"}}