{"action":"created","issue":{"url":"https://api.github.com/repos/Zebrots/Zebrots/issues/2","repository_url":"https://api.github.com/repos/Zebrots/Zebrots","labels_url":"https://api.github.com/repos/Zebrots/Zebrots/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/Zebrots/Zebrots/issues/2/comments","events_url":"https://api.github.com/repos/Zebrots/Zebrots/issues/2/events","html_url":"https://github.com/Zebrots/Zebrots/pull/2","id":238426801,"number":2,"title":"Add schema file","user":{"login":"ThalyaFlourishing","id":22850224,"avatar_url":"https://avatars0.githubusercontent.com/u/22850224?v=3","gravatar_id":"","url":"https://api.github.com/users/ThalyaFlourishing","html_url":"https://github.com/ThalyaFlourishing","followers_url":"https://api.github.com/users/ThalyaFlourishing/followers","following_url":"https://api.github.com/users/ThalyaFlourishing/following{/other_user}","gists_url":"https://api.github.com/users/ThalyaFlourishing/gists{/gist_id}","starred_url":"https://api.github.com/users/ThalyaFlourishing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ThalyaFlourishing/subscriptions","organizations_url":"https://api.github.com/users/ThalyaFlourishing/orgs","repos_url":"https://api.github.com/users/ThalyaFlourishing/repos","events_url":"https://api.github.com/users/ThalyaFlourishing/events{/privacy}","received_events_url":"https://api.github.com/users/ThalyaFlourishing/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-06-26T02:22:38Z","updated_at":"2017-06-26T03:25:16Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Zebrots/Zebrots/pulls/2","html_url":"https://github.com/Zebrots/Zebrots/pull/2","diff_url":"https://github.com/Zebrots/Zebrots/pull/2.diff","patch_url":"https://github.com/Zebrots/Zebrots/pull/2.patch"},"body":"Not sure whether it is needed, but here is a complete .sql file to go with our current database structure."},"comment":{"url":"https://api.github.com/repos/Zebrots/Zebrots/issues/comments/310955340","html_url":"https://github.com/Zebrots/Zebrots/pull/2#issuecomment-310955340","issue_url":"https://api.github.com/repos/Zebrots/Zebrots/issues/2","id":310955340,"user":{"login":"nubered","id":3600698,"avatar_url":"https://avatars1.githubusercontent.com/u/3600698?v=3","gravatar_id":"","url":"https://api.github.com/users/nubered","html_url":"https://github.com/nubered","followers_url":"https://api.github.com/users/nubered/followers","following_url":"https://api.github.com/users/nubered/following{/other_user}","gists_url":"https://api.github.com/users/nubered/gists{/gist_id}","starred_url":"https://api.github.com/users/nubered/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nubered/subscriptions","organizations_url":"https://api.github.com/users/nubered/orgs","repos_url":"https://api.github.com/users/nubered/repos","events_url":"https://api.github.com/users/nubered/events{/privacy}","received_events_url":"https://api.github.com/users/nubered/received_events","type":"User","site_admin":false},"created_at":"2017-06-26T03:25:16Z","updated_at":"2017-06-26T03:25:16Z","body":"I believe that auto_increment field, ie the id, should be explicitly set to 'NOT NULL'. Check out https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html  In addition, I feel that the columns which we know need to have a value when entering data, should be explicitly set to 'NOT NULL', too. Otherwise, the rest looks good.  "}}
{"actor":{"display_login":"nubered"}}