{"action":"opened","number":13559,"pull_request":{"url":"https://api.github.com/repos/modxcms/revolution/pulls/13559","id":132104131,"html_url":"https://github.com/modxcms/revolution/pull/13559","diff_url":"https://github.com/modxcms/revolution/pull/13559.diff","patch_url":"https://github.com/modxcms/revolution/pull/13559.patch","issue_url":"https://api.github.com/repos/modxcms/revolution/issues/13559","number":13559,"state":"open","locked":false,"title":"Reduce varchar and text index prefixes for utf8mb4 support in mysql","user":{"login":"opengeek","id":232812,"avatar_url":"https://avatars0.githubusercontent.com/u/232812?v=4","gravatar_id":"","url":"https://api.github.com/users/opengeek","html_url":"https://github.com/opengeek","followers_url":"https://api.github.com/users/opengeek/followers","following_url":"https://api.github.com/users/opengeek/following{/other_user}","gists_url":"https://api.github.com/users/opengeek/gists{/gist_id}","starred_url":"https://api.github.com/users/opengeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opengeek/subscriptions","organizations_url":"https://api.github.com/users/opengeek/orgs","repos_url":"https://api.github.com/users/opengeek/repos","events_url":"https://api.github.com/users/opengeek/events{/privacy}","received_events_url":"https://api.github.com/users/opengeek/received_events","type":"User","site_admin":false},"body":"### What does it do?\r\nReduces varchar field sizes and prefixed text indexes to 191 from anything larger.\r\n\r\n### Why is it needed?\r\nUTF8MB4 support in MySQL has a maximum index length and page size of 191 characters when using InnoDB.\r\n\r\n### Related issue(s)/PR(s)\r\n#12445","created_at":"2017-07-24T17:33:49Z","updated_at":"2017-07-24T17:33:49Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/modxcms/revolution/pulls/13559/commits","review_comments_url":"https://api.github.com/repos/modxcms/revolution/pulls/13559/comments","review_comment_url":"https://api.github.com/repos/modxcms/revolution/pulls/comments{/number}","comments_url":"https://api.github.com/repos/modxcms/revolution/issues/13559/comments","statuses_url":"https://api.github.com/repos/modxcms/revolution/statuses/d0f111f9e8b3b2155ae7c80374442b03c55eb7eb","head":{"label":"opengeek:utf8mb4","ref":"utf8mb4","sha":"d0f111f9e8b3b2155ae7c80374442b03c55eb7eb","user":{"login":"opengeek","id":232812,"avatar_url":"https://avatars0.githubusercontent.com/u/232812?v=4","gravatar_id":"","url":"https://api.github.com/users/opengeek","html_url":"https://github.com/opengeek","followers_url":"https://api.github.com/users/opengeek/followers","following_url":"https://api.github.com/users/opengeek/following{/other_user}","gists_url":"https://api.github.com/users/opengeek/gists{/gist_id}","starred_url":"https://api.github.com/users/opengeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opengeek/subscriptions","organizations_url":"https://api.github.com/users/opengeek/orgs","repos_url":"https://api.github.com/users/opengeek/repos","events_url":"https://api.github.com/users/opengeek/events{/privacy}","received_events_url":"https://api.github.com/users/opengeek/received_events","type":"User","site_admin":false},"repo":{"id":961126,"name":"revolution","full_name":"opengeek/revolution","owner":{"login":"opengeek","id":232812,"avatar_url":"https://avatars0.githubusercontent.com/u/232812?v=4","gravatar_id":"","url":"https://api.github.com/users/opengeek","html_url":"https://github.com/opengeek","followers_url":"https://api.github.com/users/opengeek/followers","following_url":"https://api.github.com/users/opengeek/following{/other_user}","gists_url":"https://api.github.com/users/opengeek/gists{/gist_id}","starred_url":"https://api.github.com/users/opengeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opengeek/subscriptions","organizations_url":"https://api.github.com/users/opengeek/orgs","repos_url":"https://api.github.com/users/opengeek/repos","events_url":"https://api.github.com/users/opengeek/events{/privacy}","received_events_url":"https://api.github.com/users/opengeek/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/opengeek/revolution","description":"MODx Revolution - Content Application Platform","fork":true,"url":"https://api.github.com/repos/opengeek/revolution","forks_url":"https://api.github.com/repos/opengeek/revolution/forks","keys_url":"https://api.github.com/repos/opengeek/revolution/keys{/key_id}","collaborators_url":"https://api.github.com/repos/opengeek/revolution/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/opengeek/revolution/teams","hooks_url":"https://api.github.com/repos/opengeek/revolution/hooks","issue_events_url":"https://api.github.com/repos/opengeek/revolution/issues/events{/number}","events_url":"https://api.github.com/repos/opengeek/revolution/events","assignees_url":"https://api.github.com/repos/opengeek/revolution/assignees{/user}","branches_url":"https://api.github.com/repos/opengeek/revolution/branches{/branch}","tags_url":"https://api.github.com/repos/opengeek/revolution/tags","blobs_url":"https://api.github.com/repos/opengeek/revolution/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/opengeek/revolution/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/opengeek/revolution/git/refs{/sha}","trees_url":"https://api.github.com/repos/opengeek/revolution/git/trees{/sha}","statuses_url":"https://api.github.com/repos/opengeek/revolution/statuses/{sha}","languages_url":"https://api.github.com/repos/opengeek/revolution/languages","stargazers_url":"https://api.github.com/repos/opengeek/revolution/stargazers","contributors_url":"https://api.github.com/repos/opengeek/revolution/contributors","subscribers_url":"https://api.github.com/repos/opengeek/revolution/subscribers","subscription_url":"https://api.github.com/repos/opengeek/revolution/subscription","commits_url":"https://api.github.com/repos/opengeek/revolution/commits{/sha}","git_commits_url":"https://api.github.com/repos/opengeek/revolution/git/commits{/sha}","comments_url":"https://api.github.com/repos/opengeek/revolution/comments{/number}","issue_comment_url":"https://api.github.com/repos/opengeek/revolution/issues/comments{/number}","contents_url":"https://api.github.com/repos/opengeek/revolution/contents/{+path}","compare_url":"https://api.github.com/repos/opengeek/revolution/compare/{base}...{head}","merges_url":"https://api.github.com/repos/opengeek/revolution/merges","archive_url":"https://api.github.com/repos/opengeek/revolution/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/opengeek/revolution/downloads","issues_url":"https://api.github.com/repos/opengeek/revolution/issues{/number}","pulls_url":"https://api.github.com/repos/opengeek/revolution/pulls{/number}","milestones_url":"https://api.github.com/repos/opengeek/revolution/milestones{/number}","notifications_url":"https://api.github.com/repos/opengeek/revolution/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/opengeek/revolution/labels{/name}","releases_url":"https://api.github.com/repos/opengeek/revolution/releases{/id}","deployments_url":"https://api.github.com/repos/opengeek/revolution/deployments","created_at":"2010-10-04T16:55:22Z","updated_at":"2015-04-17T05:16:24Z","pushed_at":"2017-07-24T17:31:16Z","git_url":"git://github.com/opengeek/revolution.git","ssh_url":"git@github.com:opengeek/revolution.git","clone_url":"https://github.com/opengeek/revolution.git","svn_url":"https://github.com/opengeek/revolution","homepage":"http://rtfm.modx.com/display/revolution","size":54706,"stargazers_count":4,"watchers_count":4,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":1,"forks":1,"open_issues":1,"watchers":4,"default_branch":"autoload-2.3"}},"base":{"label":"modxcms:2.x","ref":"2.x","sha":"11ff488cd29b66e54272006d5f02093938299f38","user":{"login":"modxcms","id":232723,"avatar_url":"https://avatars3.githubusercontent.com/u/232723?v=4","gravatar_id":"","url":"https://api.github.com/users/modxcms","html_url":"https://github.com/modxcms","followers_url":"https://api.github.com/users/modxcms/followers","following_url":"https://api.github.com/users/modxcms/following{/other_user}","gists_url":"https://api.github.com/users/modxcms/gists{/gist_id}","starred_url":"https://api.github.com/users/modxcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/modxcms/subscriptions","organizations_url":"https://api.github.com/users/modxcms/orgs","repos_url":"https://api.github.com/users/modxcms/repos","events_url":"https://api.github.com/users/modxcms/events{/privacy}","received_events_url":"https://api.github.com/users/modxcms/received_events","type":"Organization","site_admin":false},"repo":{"id":806201,"name":"revolution","full_name":"modxcms/revolution","owner":{"login":"modxcms","id":232723,"avatar_url":"https://avatars3.githubusercontent.com/u/232723?v=4","gravatar_id":"","url":"https://api.github.com/users/modxcms","html_url":"https://github.com/modxcms","followers_url":"https://api.github.com/users/modxcms/followers","following_url":"https://api.github.com/users/modxcms/following{/other_user}","gists_url":"https://api.github.com/users/modxcms/gists{/gist_id}","starred_url":"https://api.github.com/users/modxcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/modxcms/subscriptions","organizations_url":"https://api.github.com/users/modxcms/orgs","repos_url":"https://api.github.com/users/modxcms/repos","events_url":"https://api.github.com/users/modxcms/events{/privacy}","received_events_url":"https://api.github.com/users/modxcms/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/modxcms/revolution","description":"MODX Revolution - Content Management Framework","fork":false,"url":"https://api.github.com/repos/modxcms/revolution","forks_url":"https://api.github.com/repos/modxcms/revolution/forks","keys_url":"https://api.github.com/repos/modxcms/revolution/keys{/key_id}","collaborators_url":"https://api.github.com/repos/modxcms/revolution/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/modxcms/revolution/teams","hooks_url":"https://api.github.com/repos/modxcms/revolution/hooks","issue_events_url":"https://api.github.com/repos/modxcms/revolution/issues/events{/number}","events_url":"https://api.github.com/repos/modxcms/revolution/events","assignees_url":"https://api.github.com/repos/modxcms/revolution/assignees{/user}","branches_url":"https://api.github.com/repos/modxcms/revolution/branches{/branch}","tags_url":"https://api.github.com/repos/modxcms/revolution/tags","blobs_url":"https://api.github.com/repos/modxcms/revolution/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/modxcms/revolution/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/modxcms/revolution/git/refs{/sha}","trees_url":"https://api.github.com/repos/modxcms/revolution/git/trees{/sha}","statuses_url":"https://api.github.com/repos/modxcms/revolution/statuses/{sha}","languages_url":"https://api.github.com/repos/modxcms/revolution/languages","stargazers_url":"https://api.github.com/repos/modxcms/revolution/stargazers","contributors_url":"https://api.github.com/repos/modxcms/revolution/contributors","subscribers_url":"https://api.github.com/repos/modxcms/revolution/subscribers","subscription_url":"https://api.github.com/repos/modxcms/revolution/subscription","commits_url":"https://api.github.com/repos/modxcms/revolution/commits{/sha}","git_commits_url":"https://api.github.com/repos/modxcms/revolution/git/commits{/sha}","comments_url":"https://api.github.com/repos/modxcms/revolution/comments{/number}","issue_comment_url":"https://api.github.com/repos/modxcms/revolution/issues/comments{/number}","contents_url":"https://api.github.com/repos/modxcms/revolution/contents/{+path}","compare_url":"https://api.github.com/repos/modxcms/revolution/compare/{base}...{head}","merges_url":"https://api.github.com/repos/modxcms/revolution/merges","archive_url":"https://api.github.com/repos/modxcms/revolution/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/modxcms/revolution/downloads","issues_url":"https://api.github.com/repos/modxcms/revolution/issues{/number}","pulls_url":"https://api.github.com/repos/modxcms/revolution/pulls{/number}","milestones_url":"https://api.github.com/repos/modxcms/revolution/milestones{/number}","notifications_url":"https://api.github.com/repos/modxcms/revolution/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/modxcms/revolution/labels{/name}","releases_url":"https://api.github.com/repos/modxcms/revolution/releases{/id}","deployments_url":"https://api.github.com/repos/modxcms/revolution/deployments","created_at":"2010-07-29T21:03:57Z","updated_at":"2017-07-21T11:05:53Z","pushed_at":"2017-07-24T16:12:56Z","git_url":"git://github.com/modxcms/revolution.git","ssh_url":"git@github.com:modxcms/revolution.git","clone_url":"https://github.com/modxcms/revolution.git","svn_url":"https://github.com/modxcms/revolution","homepage":"https://modx.com/","size":54891,"stargazers_count":843,"watchers_count":843,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":458,"mirror_url":null,"open_issues_count":682,"forks":458,"open_issues":682,"watchers":843,"default_branch":"2.x"}},"_links":{"self":{"href":"https://api.github.com/repos/modxcms/revolution/pulls/13559"},"html":{"href":"https://github.com/modxcms/revolution/pull/13559"},"issue":{"href":"https://api.github.com/repos/modxcms/revolution/issues/13559"},"comments":{"href":"https://api.github.com/repos/modxcms/revolution/issues/13559/comments"},"review_comments":{"href":"https://api.github.com/repos/modxcms/revolution/pulls/13559/comments"},"review_comment":{"href":"https://api.github.com/repos/modxcms/revolution/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/modxcms/revolution/pulls/13559/commits"},"statuses":{"href":"https://api.github.com/repos/modxcms/revolution/statuses/d0f111f9e8b3b2155ae7c80374442b03c55eb7eb"}},"merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":true,"commits":1,"additions":176,"deletions":176,"changed_files":51}}
{"actor":{"display_login":"opengeek"}}