{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/6795","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/6795/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/6795/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/6795/events","html_url":"https://github.com/joomla/joomla-cms/pull/6795","id":69278856,"number":6795,"title":"Remove indexes from contentitem_tag_map","user":{"login":"sovainfo","id":1137613,"avatar_url":"https://avatars.githubusercontent.com/u/1137613?v=3","gravatar_id":"","url":"https://api.github.com/users/sovainfo","html_url":"https://github.com/sovainfo","followers_url":"https://api.github.com/users/sovainfo/followers","following_url":"https://api.github.com/users/sovainfo/following{/other_user}","gists_url":"https://api.github.com/users/sovainfo/gists{/gist_id}","starred_url":"https://api.github.com/users/sovainfo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sovainfo/subscriptions","organizations_url":"https://api.github.com/users/sovainfo/orgs","repos_url":"https://api.github.com/users/sovainfo/repos","events_url":"https://api.github.com/users/sovainfo/events{/privacy}","received_events_url":"https://api.github.com/users/sovainfo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/PR-staging","name":"PR-staging","color":"c7def8"},{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/RTC","name":"RTC","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/joomla/joomla-cms/milestones/7","html_url":"https://github.com/joomla/joomla-cms/milestones/Joomla!%203.5.0","labels_url":"https://api.github.com/repos/joomla/joomla-cms/milestones/7/labels","id":944889,"number":7,"title":"Joomla! 3.5.0","description":"","creator":{"login":"rdeutz","id":467356,"avatar_url":"https://avatars.githubusercontent.com/u/467356?v=3","gravatar_id":"","url":"https://api.github.com/users/rdeutz","html_url":"https://github.com/rdeutz","followers_url":"https://api.github.com/users/rdeutz/followers","following_url":"https://api.github.com/users/rdeutz/following{/other_user}","gists_url":"https://api.github.com/users/rdeutz/gists{/gist_id}","starred_url":"https://api.github.com/users/rdeutz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdeutz/subscriptions","organizations_url":"https://api.github.com/users/rdeutz/orgs","repos_url":"https://api.github.com/users/rdeutz/repos","events_url":"https://api.github.com/users/rdeutz/events{/privacy}","received_events_url":"https://api.github.com/users/rdeutz/received_events","type":"User","site_admin":false},"open_issues":46,"closed_issues":87,"state":"open","created_at":"2015-01-21T08:12:44Z","updated_at":"2015-10-25T17:35:44Z","due_on":"2015-11-03T23:00:00Z","closed_at":null},"comments":10,"created_at":"2015-04-18T07:13:50Z","updated_at":"2015-10-25T18:18:12Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/6795","html_url":"https://github.com/joomla/joomla-cms/pull/6795","diff_url":"https://github.com/joomla/joomla-cms/pull/6795.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/6795.patch"},"body":"Removing indexes that are not needed.\r\nThis assumes the primary key is using type_id instead of type_alias. See #6748 \r\nThe indexes on type_id and tag_id are redundant because of the other\r\nindexes avialable. The index on tag-name (tag_id, type_alias) only\r\nexisted for MsSQL."},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/150950829","html_url":"https://github.com/joomla/joomla-cms/pull/6795#issuecomment-150950829","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/6795","id":150950829,"user":{"login":"sovainfo","id":1137613,"avatar_url":"https://avatars.githubusercontent.com/u/1137613?v=3","gravatar_id":"","url":"https://api.github.com/users/sovainfo","html_url":"https://github.com/sovainfo","followers_url":"https://api.github.com/users/sovainfo/followers","following_url":"https://api.github.com/users/sovainfo/following{/other_user}","gists_url":"https://api.github.com/users/sovainfo/gists{/gist_id}","starred_url":"https://api.github.com/users/sovainfo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sovainfo/subscriptions","organizations_url":"https://api.github.com/users/sovainfo/orgs","repos_url":"https://api.github.com/users/sovainfo/repos","events_url":"https://api.github.com/users/sovainfo/events{/privacy}","received_events_url":"https://api.github.com/users/sovainfo/received_events","type":"User","site_admin":false},"created_at":"2015-10-25T18:18:12Z","updated_at":"2015-10-25T18:18:12Z","body":"Changed the version to 3.5.0, don't understand why this bugfix is delayed to a minor update!\r\nKept the date as is, consider it absurd to predict the date upon creation of a fix!\r\n\r\nNote that all three files are renamed using Github, despite it only shows one on the commit!"}}