{"action":"opened","number":1686,"pull_request":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686","id":35847150,"html_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1686","diff_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1686.diff","patch_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1686.patch","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1686","number":1686,"state":"open","locked":false,"title":"RFE#946 : Change Collation w/o changing data and Confirm before changing","user":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"body":"Work-in-progress.\r\nCurrently only works for Non-indexed and Non-key Columns. \r\n\r\n*Help/ suggestions for implementation for indexed and key columns welcome.*\r\nThe [documentation](https://dev.mysql.com/doc/refman/5.5/en/column-indexes.html) mentions : \r\n> When you index a BLOB or TEXT column, you must specify a prefix length for the index\r\n\r\nSo, when changing collation of the indexed or Key column, I **cannot** temporarily change it to BLOB because of the above mentioned reason. \r\n\r\nSigned-off-by: Deven Bansod <devenbansod.bits@gmail.com>","created_at":"2015-05-20T15:55:03Z","updated_at":"2015-05-20T15:55:03Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686/commits","review_comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686/comments","review_comment_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/comments{/number}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1686/comments","statuses_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/1255f491c14c5f42d9a546995bbc35f4f0fd1cfb","head":{"label":"devenbansod:rfe946","ref":"rfe946","sha":"1255f491c14c5f42d9a546995bbc35f4f0fd1cfb","user":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"repo":{"id":33041806,"name":"phpmyadmin","full_name":"devenbansod/phpmyadmin","owner":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/devenbansod/phpmyadmin","description":"phpMyAdmin itself","fork":true,"url":"https://api.github.com/repos/devenbansod/phpmyadmin","forks_url":"https://api.github.com/repos/devenbansod/phpmyadmin/forks","keys_url":"https://api.github.com/repos/devenbansod/phpmyadmin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/devenbansod/phpmyadmin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/devenbansod/phpmyadmin/teams","hooks_url":"https://api.github.com/repos/devenbansod/phpmyadmin/hooks","issue_events_url":"https://api.github.com/repos/devenbansod/phpmyadmin/issues/events{/number}","events_url":"https://api.github.com/repos/devenbansod/phpmyadmin/events","assignees_url":"https://api.github.com/repos/devenbansod/phpmyadmin/assignees{/user}","branches_url":"https://api.github.com/repos/devenbansod/phpmyadmin/branches{/branch}","tags_url":"https://api.github.com/repos/devenbansod/phpmyadmin/tags","blobs_url":"https://api.github.com/repos/devenbansod/phpmyadmin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/devenbansod/phpmyadmin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/devenbansod/phpmyadmin/git/refs{/sha}","trees_url":"https://api.github.com/repos/devenbansod/phpmyadmin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/devenbansod/phpmyadmin/statuses/{sha}","languages_url":"https://api.github.com/repos/devenbansod/phpmyadmin/languages","stargazers_url":"https://api.github.com/repos/devenbansod/phpmyadmin/stargazers","contributors_url":"https://api.github.com/repos/devenbansod/phpmyadmin/contributors","subscribers_url":"https://api.github.com/repos/devenbansod/phpmyadmin/subscribers","subscription_url":"https://api.github.com/repos/devenbansod/phpmyadmin/subscription","commits_url":"https://api.github.com/repos/devenbansod/phpmyadmin/commits{/sha}","git_commits_url":"https://api.github.com/repos/devenbansod/phpmyadmin/git/commits{/sha}","comments_url":"https://api.github.com/repos/devenbansod/phpmyadmin/comments{/number}","issue_comment_url":"https://api.github.com/repos/devenbansod/phpmyadmin/issues/comments{/number}","contents_url":"https://api.github.com/repos/devenbansod/phpmyadmin/contents/{+path}","compare_url":"https://api.github.com/repos/devenbansod/phpmyadmin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/devenbansod/phpmyadmin/merges","archive_url":"https://api.github.com/repos/devenbansod/phpmyadmin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/devenbansod/phpmyadmin/downloads","issues_url":"https://api.github.com/repos/devenbansod/phpmyadmin/issues{/number}","pulls_url":"https://api.github.com/repos/devenbansod/phpmyadmin/pulls{/number}","milestones_url":"https://api.github.com/repos/devenbansod/phpmyadmin/milestones{/number}","notifications_url":"https://api.github.com/repos/devenbansod/phpmyadmin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/devenbansod/phpmyadmin/labels{/name}","releases_url":"https://api.github.com/repos/devenbansod/phpmyadmin/releases{/id}","created_at":"2015-03-28T16:55:00Z","updated_at":"2015-05-08T18:53:48Z","pushed_at":"2015-05-20T15:42:53Z","git_url":"git://github.com/devenbansod/phpmyadmin.git","ssh_url":"git@github.com:devenbansod/phpmyadmin.git","clone_url":"https://github.com/devenbansod/phpmyadmin.git","svn_url":"https://github.com/devenbansod/phpmyadmin","homepage":"http://www.phpmyadmin.net/","size":568488,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"phpmyadmin:master","ref":"master","sha":"a9cd7d5604a2b86fe8f18e63344d79e3317f1368","user":{"login":"phpmyadmin","id":1351977,"avatar_url":"https://avatars.githubusercontent.com/u/1351977?v=3","gravatar_id":"","url":"https://api.github.com/users/phpmyadmin","html_url":"https://github.com/phpmyadmin","followers_url":"https://api.github.com/users/phpmyadmin/followers","following_url":"https://api.github.com/users/phpmyadmin/following{/other_user}","gists_url":"https://api.github.com/users/phpmyadmin/gists{/gist_id}","starred_url":"https://api.github.com/users/phpmyadmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpmyadmin/subscriptions","organizations_url":"https://api.github.com/users/phpmyadmin/orgs","repos_url":"https://api.github.com/users/phpmyadmin/repos","events_url":"https://api.github.com/users/phpmyadmin/events{/privacy}","received_events_url":"https://api.github.com/users/phpmyadmin/received_events","type":"Organization","site_admin":false},"repo":{"id":3217621,"name":"phpmyadmin","full_name":"phpmyadmin/phpmyadmin","owner":{"login":"phpmyadmin","id":1351977,"avatar_url":"https://avatars.githubusercontent.com/u/1351977?v=3","gravatar_id":"","url":"https://api.github.com/users/phpmyadmin","html_url":"https://github.com/phpmyadmin","followers_url":"https://api.github.com/users/phpmyadmin/followers","following_url":"https://api.github.com/users/phpmyadmin/following{/other_user}","gists_url":"https://api.github.com/users/phpmyadmin/gists{/gist_id}","starred_url":"https://api.github.com/users/phpmyadmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpmyadmin/subscriptions","organizations_url":"https://api.github.com/users/phpmyadmin/orgs","repos_url":"https://api.github.com/users/phpmyadmin/repos","events_url":"https://api.github.com/users/phpmyadmin/events{/privacy}","received_events_url":"https://api.github.com/users/phpmyadmin/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/phpmyadmin/phpmyadmin","description":"phpMyAdmin itself","fork":false,"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","forks_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/forks","keys_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/teams","hooks_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/hooks","issue_events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/events{/number}","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/events","assignees_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/assignees{/user}","branches_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/branches{/branch}","tags_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/tags","blobs_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/refs{/sha}","trees_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/{sha}","languages_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/languages","stargazers_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/stargazers","contributors_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/contributors","subscribers_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/subscribers","subscription_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/subscription","commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/commits{/sha}","git_commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/commits{/sha}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/comments{/number}","issue_comment_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments{/number}","contents_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/contents/{+path}","compare_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/merges","archive_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/downloads","issues_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues{/number}","pulls_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls{/number}","milestones_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/milestones{/number}","notifications_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels{/name}","releases_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/releases{/id}","created_at":"2012-01-19T13:21:52Z","updated_at":"2015-05-20T09:15:57Z","pushed_at":"2015-05-20T15:24:44Z","git_url":"git://github.com/phpmyadmin/phpmyadmin.git","ssh_url":"git@github.com:phpmyadmin/phpmyadmin.git","clone_url":"https://github.com/phpmyadmin/phpmyadmin.git","svn_url":"https://github.com/phpmyadmin/phpmyadmin","homepage":"http://www.phpmyadmin.net/","size":711380,"stargazers_count":1206,"watchers_count":1206,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":712,"mirror_url":null,"open_issues_count":4,"forks":712,"open_issues":4,"watchers":1206,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686"},"html":{"href":"https://github.com/phpmyadmin/phpmyadmin/pull/1686"},"issue":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1686"},"comments":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1686/comments"},"review_comments":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686/comments"},"review_comment":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1686/commits"},"statuses":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/1255f491c14c5f42d9a546995bbc35f4f0fd1cfb"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":188,"deletions":25,"changed_files":2}}