{"action":"closed","issue":{"url":"https://api.github.com/repos/OkwufuluezeD/MySQL/issues/1","labels_url":"https://api.github.com/repos/OkwufuluezeD/MySQL/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/OkwufuluezeD/MySQL/issues/1/comments","events_url":"https://api.github.com/repos/OkwufuluezeD/MySQL/issues/1/events","html_url":"https://github.com/OkwufuluezeD/MySQL/issues/1","id":103057953,"number":1,"title":"Exercise 1: Manipulate testing_table","user":{"login":"OkwufuluezeD","id":13135088,"avatar_url":"https://avatars.githubusercontent.com/u/13135088?v=3","gravatar_id":"","url":"https://api.github.com/users/OkwufuluezeD","html_url":"https://github.com/OkwufuluezeD","followers_url":"https://api.github.com/users/OkwufuluezeD/followers","following_url":"https://api.github.com/users/OkwufuluezeD/following{/other_user}","gists_url":"https://api.github.com/users/OkwufuluezeD/gists{/gist_id}","starred_url":"https://api.github.com/users/OkwufuluezeD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/OkwufuluezeD/subscriptions","organizations_url":"https://api.github.com/users/OkwufuluezeD/orgs","repos_url":"https://api.github.com/users/OkwufuluezeD/repos","events_url":"https://api.github.com/users/OkwufuluezeD/events{/privacy}","received_events_url":"https://api.github.com/users/OkwufuluezeD/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"osifoanosike","id":9961991,"avatar_url":"https://avatars.githubusercontent.com/u/9961991?v=3","gravatar_id":"","url":"https://api.github.com/users/osifoanosike","html_url":"https://github.com/osifoanosike","followers_url":"https://api.github.com/users/osifoanosike/followers","following_url":"https://api.github.com/users/osifoanosike/following{/other_user}","gists_url":"https://api.github.com/users/osifoanosike/gists{/gist_id}","starred_url":"https://api.github.com/users/osifoanosike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/osifoanosike/subscriptions","organizations_url":"https://api.github.com/users/osifoanosike/orgs","repos_url":"https://api.github.com/users/osifoanosike/repos","events_url":"https://api.github.com/users/osifoanosike/events{/privacy}","received_events_url":"https://api.github.com/users/osifoanosike/received_events","type":"User","site_admin":false},"milestone":null,"comments":0,"created_at":"2015-08-25T15:57:14Z","updated_at":"2015-08-31T09:03:15Z","closed_at":"2015-08-31T09:03:15Z","body":"https://github.com/OkwufuluezeD/MySQL/blob/master/Exercise1.sql\r\n\r\nAlter TableCreate a table named \"testing_table\" with following fields:name (string)contact_name (string)roll_no (string)Now:Delete column name, rename contact_name to username. Add two fields first_name, last_name. Also change the type of roll_no to integer."}}