{"action":"created","issue":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/699","repository_url":"https://api.github.com/repos/opencloset/opencloset","labels_url":"https://api.github.com/repos/opencloset/opencloset/issues/699/labels{/name}","comments_url":"https://api.github.com/repos/opencloset/opencloset/issues/699/comments","events_url":"https://api.github.com/repos/opencloset/opencloset/issues/699/events","html_url":"https://github.com/opencloset/opencloset/issues/699","id":132902626,"number":699,"title":"의류의 허벅지사이즈 자료 DB 일괄 수정","user":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/opencloset/opencloset/labels/%EC%8B%A4DB","name":"실DB","color":"e11d21"},{"url":"https://api.github.com/repos/opencloset/opencloset/labels/%ED%86%B5%EA%B3%84","name":"통계","color":"009800"}],"state":"open","locked":false,"assignee":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-02-11T06:52:03Z","updated_at":"2016-02-11T10:07:58Z","closed_at":null,"body":"![index](https://cloud.githubusercontent.com/assets/52704/12970873/530b4162-d0d7-11e5-8e11-be257cf6cbaf.png)\r\n\r\n지난 1년간의 대여자료의 리뷰를 통해서 기존 DB에서 잘못 입력되 의류치수 관련 정보를 제거합니다.\r\n\r\n- [ ] jacket에서 허벅지 있는거 모두 NA\r\n- [ ] pants에서 0인값들 모두 NA\r\n- [ ] skirt에서 허벅지 있는거 모두 NA\r\n- [ ] 허벅지가 있을수 있는 옷 종류 : pants\r\n"},"comment":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/comments/182790111","html_url":"https://github.com/opencloset/opencloset/issues/699#issuecomment-182790111","issue_url":"https://api.github.com/repos/opencloset/opencloset/issues/699","id":182790111,"user":{"login":"yongbin","id":52704,"avatar_url":"https://avatars.githubusercontent.com/u/52704?v=3","gravatar_id":"","url":"https://api.github.com/users/yongbin","html_url":"https://github.com/yongbin","followers_url":"https://api.github.com/users/yongbin/followers","following_url":"https://api.github.com/users/yongbin/following{/other_user}","gists_url":"https://api.github.com/users/yongbin/gists{/gist_id}","starred_url":"https://api.github.com/users/yongbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yongbin/subscriptions","organizations_url":"https://api.github.com/users/yongbin/orgs","repos_url":"https://api.github.com/users/yongbin/repos","events_url":"https://api.github.com/users/yongbin/events{/privacy}","received_events_url":"https://api.github.com/users/yongbin/received_events","type":"User","site_admin":false},"created_at":"2016-02-11T10:07:58Z","updated_at":"2016-02-11T10:07:58Z","body":"> 허벅지가 있을수 있는 옷 종류 : pants\r\n\r\n\r\n## 확인\r\n```sql\r\nSELECT `code`, `thigh` FROM `clothes` WHERE `category` NOT IN (  'pants' ) AND `thigh` IS NOT NULL \r\n\r\n```\r\n## 처리\r\n```sql\r\nUPDATE `clothes` SET `thigh` = NULL \r\nWHERE `category` NOT IN (  'pants' ) AND `thigh` IS NOT NULL \r\nLIMIT 6709\r\n\r\n```\r\n\r\n적용했습니다."}}