{"action":"created","comment":{"url":"https://api.github.com/repos/spree/spree/pulls/comments/26583550","id":26583550,"diff_hunk":"@@ -0,0 +1,27 @@\n+class AddMissingIndexes < ActiveRecord::Migration\n+  def change\n+    add_index   :spree_promotion_rules_users, \n+                        [:user_id, :promotion_rule_id], \n+                        name: 'index_promotion_rules_users_on_user_id_and_promotion_rule_id'\n+    add_index   :spree_products_promotion_rules, \n+                        [:promotion_rule_id, :product_id], \n+                        name: 'index_products_promotion_rules_on_promotion_rule_and_product'\n+    add_index :spree_orders, :canceler_id\n+    add_index :spree_orders, :store_id\n+    add_index :spree_orders_promotions, [:promotion_id, :order_id]\n+    add_index :spree_properties_prototypes, :prototype_id\n+    add_index   :spree_properties_prototypes, \n+                        [:prototype_id, :property_id], \n+                        name:  'index_properties_prototypes_on_prototype_and_property'\n+    add_index :spree_users, :bill_address_id\n+    add_index :spree_users, :ship_address_id\n+    add_index :spree_taxons_prototypes, [:prototype_id, :taxon_id]\n+    add_index :spree_option_types_prototypes, :prototype_id\n+    add_index   :spree_option_types_prototypes, \n+                        [:prototype_id, :option_type_id], \n+                        name: 'index_option_types_prototypes_on_prototype_and_option_type'","path":"core/db/migrate/20150314013438_add_missing_indexes.rb","position":22,"original_position":22,"commit_id":"4a0ae4110953eb7e72eff174b821cdcbb1b48699","original_commit_id":"4a0ae4110953eb7e72eff174b821cdcbb1b48699","user":{"login":"houndci","id":6697940,"avatar_url":"https://avatars.githubusercontent.com/u/6697940?v=3","gravatar_id":"","url":"https://api.github.com/users/houndci","html_url":"https://github.com/houndci","followers_url":"https://api.github.com/users/houndci/followers","following_url":"https://api.github.com/users/houndci/following{/other_user}","gists_url":"https://api.github.com/users/houndci/gists{/gist_id}","starred_url":"https://api.github.com/users/houndci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/houndci/subscriptions","organizations_url":"https://api.github.com/users/houndci/orgs","repos_url":"https://api.github.com/users/houndci/repos","events_url":"https://api.github.com/users/houndci/events{/privacy}","received_events_url":"https://api.github.com/users/houndci/received_events","type":"User","site_admin":false},"body":"Align the parameters of a method call if they span more than one line.","created_at":"2015-03-17T15:34:07Z","updated_at":"2015-03-17T15:34:07Z","html_url":"https://github.com/spree/spree/pull/6192#discussion_r26583550","pull_request_url":"https://api.github.com/repos/spree/spree/pulls/6192","_links":{"self":{"href":"https://api.github.com/repos/spree/spree/pulls/comments/26583550"},"html":{"href":"https://github.com/spree/spree/pull/6192#discussion_r26583550"},"pull_request":{"href":"https://api.github.com/repos/spree/spree/pulls/6192"}}},"pull_request":{"url":"https://api.github.com/repos/spree/spree/pulls/6192","id":31346356,"html_url":"https://github.com/spree/spree/pull/6192","diff_url":"https://github.com/spree/spree/pull/6192.diff","patch_url":"https://github.com/spree/spree/pull/6192.patch","issue_url":"https://api.github.com/repos/spree/spree/issues/6192","number":6192,"state":"open","locked":false,"title":"Add missing indexes to several tables","user":{"login":"mvidaurre","id":12237,"avatar_url":"https://avatars.githubusercontent.com/u/12237?v=3","gravatar_id":"","url":"https://api.github.com/users/mvidaurre","html_url":"https://github.com/mvidaurre","followers_url":"https://api.github.com/users/mvidaurre/followers","following_url":"https://api.github.com/users/mvidaurre/following{/other_user}","gists_url":"https://api.github.com/users/mvidaurre/gists{/gist_id}","starred_url":"https://api.github.com/users/mvidaurre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvidaurre/subscriptions","organizations_url":"https://api.github.com/users/mvidaurre/orgs","repos_url":"https://api.github.com/users/mvidaurre/repos","events_url":"https://api.github.com/users/mvidaurre/events{/privacy}","received_events_url":"https://api.github.com/users/mvidaurre/received_events","type":"User","site_admin":false},"body":"I found this additional indexes useful. Please give your feedback. This is an split of previous PR #6179","created_at":"2015-03-17T15:34:02Z","updated_at":"2015-03-17T15:34:08Z","closed_at":null,"merged_at":null,"merge_commit_sha":"038e7647ad93875c71ad34839f2b967311c4ee7a","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/spree/spree/pulls/6192/commits","review_comments_url":"https://api.github.com/repos/spree/spree/pulls/6192/comments","review_comment_url":"https://api.github.com/repos/spree/spree/pulls/comments{/number}","comments_url":"https://api.github.com/repos/spree/spree/issues/6192/comments","statuses_url":"https://api.github.com/repos/spree/spree/statuses/4a0ae4110953eb7e72eff174b821cdcbb1b48699","head":{"label":"AgilTec:adding_more_indexes","ref":"adding_more_indexes","sha":"4a0ae4110953eb7e72eff174b821cdcbb1b48699","user":{"login":"AgilTec","id":382549,"avatar_url":"https://avatars.githubusercontent.com/u/382549?v=3","gravatar_id":"","url":"https://api.github.com/users/AgilTec","html_url":"https://github.com/AgilTec","followers_url":"https://api.github.com/users/AgilTec/followers","following_url":"https://api.github.com/users/AgilTec/following{/other_user}","gists_url":"https://api.github.com/users/AgilTec/gists{/gist_id}","starred_url":"https://api.github.com/users/AgilTec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AgilTec/subscriptions","organizations_url":"https://api.github.com/users/AgilTec/orgs","repos_url":"https://api.github.com/users/AgilTec/repos","events_url":"https://api.github.com/users/AgilTec/events{/privacy}","received_events_url":"https://api.github.com/users/AgilTec/received_events","type":"Organization","site_admin":false},"repo":{"id":10611263,"name":"spree","full_name":"AgilTec/spree","owner":{"login":"AgilTec","id":382549,"avatar_url":"https://avatars.githubusercontent.com/u/382549?v=3","gravatar_id":"","url":"https://api.github.com/users/AgilTec","html_url":"https://github.com/AgilTec","followers_url":"https://api.github.com/users/AgilTec/followers","following_url":"https://api.github.com/users/AgilTec/following{/other_user}","gists_url":"https://api.github.com/users/AgilTec/gists{/gist_id}","starred_url":"https://api.github.com/users/AgilTec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AgilTec/subscriptions","organizations_url":"https://api.github.com/users/AgilTec/orgs","repos_url":"https://api.github.com/users/AgilTec/repos","events_url":"https://api.github.com/users/AgilTec/events{/privacy}","received_events_url":"https://api.github.com/users/AgilTec/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/AgilTec/spree","description":"Spree is a complete open source e-commerce solution for Ruby on Rails.","fork":true,"url":"https://api.github.com/repos/AgilTec/spree","forks_url":"https://api.github.com/repos/AgilTec/spree/forks","keys_url":"https://api.github.com/repos/AgilTec/spree/keys{/key_id}","collaborators_url":"https://api.github.com/repos/AgilTec/spree/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/AgilTec/spree/teams","hooks_url":"https://api.github.com/repos/AgilTec/spree/hooks","issue_events_url":"https://api.github.com/repos/AgilTec/spree/issues/events{/number}","events_url":"https://api.github.com/repos/AgilTec/spree/events","assignees_url":"https://api.github.com/repos/AgilTec/spree/assignees{/user}","branches_url":"https://api.github.com/repos/AgilTec/spree/branches{/branch}","tags_url":"https://api.github.com/repos/AgilTec/spree/tags","blobs_url":"https://api.github.com/repos/AgilTec/spree/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/AgilTec/spree/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/AgilTec/spree/git/refs{/sha}","trees_url":"https://api.github.com/repos/AgilTec/spree/git/trees{/sha}","statuses_url":"https://api.github.com/repos/AgilTec/spree/statuses/{sha}","languages_url":"https://api.github.com/repos/AgilTec/spree/languages","stargazers_url":"https://api.github.com/repos/AgilTec/spree/stargazers","contributors_url":"https://api.github.com/repos/AgilTec/spree/contributors","subscribers_url":"https://api.github.com/repos/AgilTec/spree/subscribers","subscription_url":"https://api.github.com/repos/AgilTec/spree/subscription","commits_url":"https://api.github.com/repos/AgilTec/spree/commits{/sha}","git_commits_url":"https://api.github.com/repos/AgilTec/spree/git/commits{/sha}","comments_url":"https://api.github.com/repos/AgilTec/spree/comments{/number}","issue_comment_url":"https://api.github.com/repos/AgilTec/spree/issues/comments{/number}","contents_url":"https://api.github.com/repos/AgilTec/spree/contents/{+path}","compare_url":"https://api.github.com/repos/AgilTec/spree/compare/{base}...{head}","merges_url":"https://api.github.com/repos/AgilTec/spree/merges","archive_url":"https://api.github.com/repos/AgilTec/spree/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/AgilTec/spree/downloads","issues_url":"https://api.github.com/repos/AgilTec/spree/issues{/number}","pulls_url":"https://api.github.com/repos/AgilTec/spree/pulls{/number}","milestones_url":"https://api.github.com/repos/AgilTec/spree/milestones{/number}","notifications_url":"https://api.github.com/repos/AgilTec/spree/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/AgilTec/spree/labels{/name}","releases_url":"https://api.github.com/repos/AgilTec/spree/releases{/id}","created_at":"2013-06-10T23:01:43Z","updated_at":"2015-03-14T04:51:23Z","pushed_at":"2015-03-17T15:29:28Z","git_url":"git://github.com/AgilTec/spree.git","ssh_url":"git@github.com:AgilTec/spree.git","clone_url":"https://github.com/AgilTec/spree.git","svn_url":"https://github.com/AgilTec/spree","homepage":"http://spreecommerce.com","size":67426,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"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":"spree:master","ref":"master","sha":"2efbd7dbf3f0e3b0d3b1c940ca6350eef99fe496","user":{"login":"spree","id":56702,"avatar_url":"https://avatars.githubusercontent.com/u/56702?v=3","gravatar_id":"","url":"https://api.github.com/users/spree","html_url":"https://github.com/spree","followers_url":"https://api.github.com/users/spree/followers","following_url":"https://api.github.com/users/spree/following{/other_user}","gists_url":"https://api.github.com/users/spree/gists{/gist_id}","starred_url":"https://api.github.com/users/spree/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spree/subscriptions","organizations_url":"https://api.github.com/users/spree/orgs","repos_url":"https://api.github.com/users/spree/repos","events_url":"https://api.github.com/users/spree/events{/privacy}","received_events_url":"https://api.github.com/users/spree/received_events","type":"Organization","site_admin":false},"repo":{"id":3314,"name":"spree","full_name":"spree/spree","owner":{"login":"spree","id":56702,"avatar_url":"https://avatars.githubusercontent.com/u/56702?v=3","gravatar_id":"","url":"https://api.github.com/users/spree","html_url":"https://github.com/spree","followers_url":"https://api.github.com/users/spree/followers","following_url":"https://api.github.com/users/spree/following{/other_user}","gists_url":"https://api.github.com/users/spree/gists{/gist_id}","starred_url":"https://api.github.com/users/spree/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spree/subscriptions","organizations_url":"https://api.github.com/users/spree/orgs","repos_url":"https://api.github.com/users/spree/repos","events_url":"https://api.github.com/users/spree/events{/privacy}","received_events_url":"https://api.github.com/users/spree/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/spree/spree","description":"Spree is a complete open source e-commerce solution for Ruby on Rails.","fork":false,"url":"https://api.github.com/repos/spree/spree","forks_url":"https://api.github.com/repos/spree/spree/forks","keys_url":"https://api.github.com/repos/spree/spree/keys{/key_id}","collaborators_url":"https://api.github.com/repos/spree/spree/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/spree/spree/teams","hooks_url":"https://api.github.com/repos/spree/spree/hooks","issue_events_url":"https://api.github.com/repos/spree/spree/issues/events{/number}","events_url":"https://api.github.com/repos/spree/spree/events","assignees_url":"https://api.github.com/repos/spree/spree/assignees{/user}","branches_url":"https://api.github.com/repos/spree/spree/branches{/branch}","tags_url":"https://api.github.com/repos/spree/spree/tags","blobs_url":"https://api.github.com/repos/spree/spree/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/spree/spree/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/spree/spree/git/refs{/sha}","trees_url":"https://api.github.com/repos/spree/spree/git/trees{/sha}","statuses_url":"https://api.github.com/repos/spree/spree/statuses/{sha}","languages_url":"https://api.github.com/repos/spree/spree/languages","stargazers_url":"https://api.github.com/repos/spree/spree/stargazers","contributors_url":"https://api.github.com/repos/spree/spree/contributors","subscribers_url":"https://api.github.com/repos/spree/spree/subscribers","subscription_url":"https://api.github.com/repos/spree/spree/subscription","commits_url":"https://api.github.com/repos/spree/spree/commits{/sha}","git_commits_url":"https://api.github.com/repos/spree/spree/git/commits{/sha}","comments_url":"https://api.github.com/repos/spree/spree/comments{/number}","issue_comment_url":"https://api.github.com/repos/spree/spree/issues/comments{/number}","contents_url":"https://api.github.com/repos/spree/spree/contents/{+path}","compare_url":"https://api.github.com/repos/spree/spree/compare/{base}...{head}","merges_url":"https://api.github.com/repos/spree/spree/merges","archive_url":"https://api.github.com/repos/spree/spree/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/spree/spree/downloads","issues_url":"https://api.github.com/repos/spree/spree/issues{/number}","pulls_url":"https://api.github.com/repos/spree/spree/pulls{/number}","milestones_url":"https://api.github.com/repos/spree/spree/milestones{/number}","notifications_url":"https://api.github.com/repos/spree/spree/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/spree/spree/labels{/name}","releases_url":"https://api.github.com/repos/spree/spree/releases{/id}","created_at":"2008-03-10T14:45:35Z","updated_at":"2015-03-17T15:21:02Z","pushed_at":"2015-03-17T15:19:38Z","git_url":"git://github.com/spree/spree.git","ssh_url":"git@github.com:spree/spree.git","clone_url":"https://github.com/spree/spree.git","svn_url":"https://github.com/spree/spree","homepage":"http://spreecommerce.com","size":132720,"stargazers_count":6120,"watchers_count":6120,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2864,"mirror_url":null,"open_issues_count":79,"forks":2864,"open_issues":79,"watchers":6120,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/spree/spree/pulls/6192"},"html":{"href":"https://github.com/spree/spree/pull/6192"},"issue":{"href":"https://api.github.com/repos/spree/spree/issues/6192"},"comments":{"href":"https://api.github.com/repos/spree/spree/issues/6192/comments"},"review_comments":{"href":"https://api.github.com/repos/spree/spree/pulls/6192/comments"},"review_comment":{"href":"https://api.github.com/repos/spree/spree/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/spree/spree/pulls/6192/commits"},"statuses":{"href":"https://api.github.com/repos/spree/spree/statuses/4a0ae4110953eb7e72eff174b821cdcbb1b48699"}}}}