{"action":"created","issue":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/1740","labels_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/1740/labels{/name}","comments_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/1740/comments","events_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/1740/events","html_url":"https://github.com/ParadiseSS13/Paradise/pull/1740","id":100902628,"number":1740,"title":"-tg- underware overhaul","user":{"login":"tigercat2000","id":10103534,"avatar_url":"https://avatars.githubusercontent.com/u/10103534?v=3","gravatar_id":"","url":"https://api.github.com/users/tigercat2000","html_url":"https://github.com/tigercat2000","followers_url":"https://api.github.com/users/tigercat2000/followers","following_url":"https://api.github.com/users/tigercat2000/following{/other_user}","gists_url":"https://api.github.com/users/tigercat2000/gists{/gist_id}","starred_url":"https://api.github.com/users/tigercat2000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tigercat2000/subscriptions","organizations_url":"https://api.github.com/users/tigercat2000/orgs","repos_url":"https://api.github.com/users/tigercat2000/repos","events_url":"https://api.github.com/users/tigercat2000/events{/privacy}","received_events_url":"https://api.github.com/users/tigercat2000/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/labels/Refactor","name":"Refactor","color":"FFB626"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-08-14T00:47:32Z","updated_at":"2015-08-15T00:58:46Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/pulls/1740","html_url":"https://github.com/ParadiseSS13/Paradise/pull/1740","diff_url":"https://github.com/ParadiseSS13/Paradise/pull/1740.diff","patch_url":"https://github.com/ParadiseSS13/Paradise/pull/1740.patch"},"body":"This commit overhauls the underwear/undershirt system to -tg-'s text-based\r\nversion. No more magic numbers, just text states.\r\n\r\nNote, this modifies the SQL Schema, and existing databases must be\r\nmodified by the following SQL:\r\n\r\nALTER TABLE server_db.characters\r\n\t    CHANGE underwear underwear MEDIUMTEXT NOT NULL,\r\n\t    CHANGE undershirt undershirt MEDIUMTEXT NOT NULL;"},"comment":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/comments/131275233","html_url":"https://github.com/ParadiseSS13/Paradise/pull/1740#issuecomment-131275233","issue_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/1740","id":131275233,"user":{"login":"Markolie","id":3009534,"avatar_url":"https://avatars.githubusercontent.com/u/3009534?v=3","gravatar_id":"","url":"https://api.github.com/users/Markolie","html_url":"https://github.com/Markolie","followers_url":"https://api.github.com/users/Markolie/followers","following_url":"https://api.github.com/users/Markolie/following{/other_user}","gists_url":"https://api.github.com/users/Markolie/gists{/gist_id}","starred_url":"https://api.github.com/users/Markolie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Markolie/subscriptions","organizations_url":"https://api.github.com/users/Markolie/orgs","repos_url":"https://api.github.com/users/Markolie/repos","events_url":"https://api.github.com/users/Markolie/events{/privacy}","received_events_url":"https://api.github.com/users/Markolie/received_events","type":"User","site_admin":false},"created_at":"2015-08-15T00:58:46Z","updated_at":"2015-08-15T00:58:46Z","body":"I want to merge this, but we need to make sure we make the SQL changes first.\r\n\r\n@Earthdivine Do you have MySQL access?"}}