{"action":"opened","number":5851,"pull_request":{"url":"https://api.github.com/repos/sequelize/sequelize/pulls/5851","id":68804837,"html_url":"https://github.com/sequelize/sequelize/pull/5851","diff_url":"https://github.com/sequelize/sequelize/pull/5851.diff","patch_url":"https://github.com/sequelize/sequelize/pull/5851.patch","issue_url":"https://api.github.com/repos/sequelize/sequelize/issues/5851","number":5851,"state":"open","locked":false,"title":"fixes issue #5808 removeColumn tries to delete nonexistent foreign keys","user":{"login":"paolord","id":1720393,"avatar_url":"https://avatars.githubusercontent.com/u/1720393?v=3","gravatar_id":"","url":"https://api.github.com/users/paolord","html_url":"https://github.com/paolord","followers_url":"https://api.github.com/users/paolord/followers","following_url":"https://api.github.com/users/paolord/following{/other_user}","gists_url":"https://api.github.com/users/paolord/gists{/gist_id}","starred_url":"https://api.github.com/users/paolord/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paolord/subscriptions","organizations_url":"https://api.github.com/users/paolord/orgs","repos_url":"https://api.github.com/users/paolord/repos","events_url":"https://api.github.com/users/paolord/events{/privacy}","received_events_url":"https://api.github.com/users/paolord/received_events","type":"User","site_admin":false},"body":"### Pull Request check-list\r\n\r\n_Please make sure to review and check all of these items:_\r\n\r\n- [x] Does `npm run test` or `npm run test-DIALECT` pass with this change (including linting)?\r\n- [x] Does your issue contain a link to existing issue (Closes #[issue]) or a description of the issue you are solving?\r\n- [x] Have you added new tests to prevent regressions?\r\n- [x] Have you added an entry under `Future` in the changelog?\r\n\r\n_NOTE: these things are not required to open a PR and can be done afterwards / while the PR is open._\r\n\r\n### Description of change\r\nattempt to fix issue #5808 \r\nhad a previous pull request with a passing build on the actual code [#5830](https://github.com/sequelize/sequelize/pull/5830)\r\nneeded integration tests and merged my changes into a single commit so I made I new pull request for it\r\nI also ran this in a successful build in travis on my [fork](https://travis-ci.org/paolord/sequelize/builds/127562142) ","created_at":"2016-05-04T02:51:58Z","updated_at":"2016-05-04T02:51:58Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/sequelize/sequelize/pulls/5851/commits","review_comments_url":"https://api.github.com/repos/sequelize/sequelize/pulls/5851/comments","review_comment_url":"https://api.github.com/repos/sequelize/sequelize/pulls/comments{/number}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/5851/comments","statuses_url":"https://api.github.com/repos/sequelize/sequelize/statuses/23b0ace1a1da3825ff0c093e8dafb0565e12ed34","head":{"label":"paolord:master","ref":"master","sha":"23b0ace1a1da3825ff0c093e8dafb0565e12ed34","user":{"login":"paolord","id":1720393,"avatar_url":"https://avatars.githubusercontent.com/u/1720393?v=3","gravatar_id":"","url":"https://api.github.com/users/paolord","html_url":"https://github.com/paolord","followers_url":"https://api.github.com/users/paolord/followers","following_url":"https://api.github.com/users/paolord/following{/other_user}","gists_url":"https://api.github.com/users/paolord/gists{/gist_id}","starred_url":"https://api.github.com/users/paolord/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paolord/subscriptions","organizations_url":"https://api.github.com/users/paolord/orgs","repos_url":"https://api.github.com/users/paolord/repos","events_url":"https://api.github.com/users/paolord/events{/privacy}","received_events_url":"https://api.github.com/users/paolord/received_events","type":"User","site_admin":false},"repo":{"id":57326193,"name":"sequelize","full_name":"paolord/sequelize","owner":{"login":"paolord","id":1720393,"avatar_url":"https://avatars.githubusercontent.com/u/1720393?v=3","gravatar_id":"","url":"https://api.github.com/users/paolord","html_url":"https://github.com/paolord","followers_url":"https://api.github.com/users/paolord/followers","following_url":"https://api.github.com/users/paolord/following{/other_user}","gists_url":"https://api.github.com/users/paolord/gists{/gist_id}","starred_url":"https://api.github.com/users/paolord/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paolord/subscriptions","organizations_url":"https://api.github.com/users/paolord/orgs","repos_url":"https://api.github.com/users/paolord/repos","events_url":"https://api.github.com/users/paolord/events{/privacy}","received_events_url":"https://api.github.com/users/paolord/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/paolord/sequelize","description":"Sequelize is an easy-to-use multi sql dialect ORM for Node.js & io.js. It currently supports MySQL, MariaDB, SQLite, PostgreSQL and MSSQL.","fork":true,"url":"https://api.github.com/repos/paolord/sequelize","forks_url":"https://api.github.com/repos/paolord/sequelize/forks","keys_url":"https://api.github.com/repos/paolord/sequelize/keys{/key_id}","collaborators_url":"https://api.github.com/repos/paolord/sequelize/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/paolord/sequelize/teams","hooks_url":"https://api.github.com/repos/paolord/sequelize/hooks","issue_events_url":"https://api.github.com/repos/paolord/sequelize/issues/events{/number}","events_url":"https://api.github.com/repos/paolord/sequelize/events","assignees_url":"https://api.github.com/repos/paolord/sequelize/assignees{/user}","branches_url":"https://api.github.com/repos/paolord/sequelize/branches{/branch}","tags_url":"https://api.github.com/repos/paolord/sequelize/tags","blobs_url":"https://api.github.com/repos/paolord/sequelize/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/paolord/sequelize/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/paolord/sequelize/git/refs{/sha}","trees_url":"https://api.github.com/repos/paolord/sequelize/git/trees{/sha}","statuses_url":"https://api.github.com/repos/paolord/sequelize/statuses/{sha}","languages_url":"https://api.github.com/repos/paolord/sequelize/languages","stargazers_url":"https://api.github.com/repos/paolord/sequelize/stargazers","contributors_url":"https://api.github.com/repos/paolord/sequelize/contributors","subscribers_url":"https://api.github.com/repos/paolord/sequelize/subscribers","subscription_url":"https://api.github.com/repos/paolord/sequelize/subscription","commits_url":"https://api.github.com/repos/paolord/sequelize/commits{/sha}","git_commits_url":"https://api.github.com/repos/paolord/sequelize/git/commits{/sha}","comments_url":"https://api.github.com/repos/paolord/sequelize/comments{/number}","issue_comment_url":"https://api.github.com/repos/paolord/sequelize/issues/comments{/number}","contents_url":"https://api.github.com/repos/paolord/sequelize/contents/{+path}","compare_url":"https://api.github.com/repos/paolord/sequelize/compare/{base}...{head}","merges_url":"https://api.github.com/repos/paolord/sequelize/merges","archive_url":"https://api.github.com/repos/paolord/sequelize/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/paolord/sequelize/downloads","issues_url":"https://api.github.com/repos/paolord/sequelize/issues{/number}","pulls_url":"https://api.github.com/repos/paolord/sequelize/pulls{/number}","milestones_url":"https://api.github.com/repos/paolord/sequelize/milestones{/number}","notifications_url":"https://api.github.com/repos/paolord/sequelize/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/paolord/sequelize/labels{/name}","releases_url":"https://api.github.com/repos/paolord/sequelize/releases{/id}","deployments_url":"https://api.github.com/repos/paolord/sequelize/deployments","created_at":"2016-04-28T18:51:14Z","updated_at":"2016-04-28T18:51:19Z","pushed_at":"2016-05-03T16:17:28Z","git_url":"git://github.com/paolord/sequelize.git","ssh_url":"git@github.com:paolord/sequelize.git","clone_url":"https://github.com/paolord/sequelize.git","svn_url":"https://github.com/paolord/sequelize","homepage":"http://sequelizejs.com","size":17361,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","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":"sequelize:master","ref":"master","sha":"e1b5ab5df894a1d4c1ef50c86d49e514d531aa12","user":{"login":"sequelize","id":3591786,"avatar_url":"https://avatars.githubusercontent.com/u/3591786?v=3","gravatar_id":"","url":"https://api.github.com/users/sequelize","html_url":"https://github.com/sequelize","followers_url":"https://api.github.com/users/sequelize/followers","following_url":"https://api.github.com/users/sequelize/following{/other_user}","gists_url":"https://api.github.com/users/sequelize/gists{/gist_id}","starred_url":"https://api.github.com/users/sequelize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sequelize/subscriptions","organizations_url":"https://api.github.com/users/sequelize/orgs","repos_url":"https://api.github.com/users/sequelize/repos","events_url":"https://api.github.com/users/sequelize/events{/privacy}","received_events_url":"https://api.github.com/users/sequelize/received_events","type":"Organization","site_admin":false},"repo":{"id":790359,"name":"sequelize","full_name":"sequelize/sequelize","owner":{"login":"sequelize","id":3591786,"avatar_url":"https://avatars.githubusercontent.com/u/3591786?v=3","gravatar_id":"","url":"https://api.github.com/users/sequelize","html_url":"https://github.com/sequelize","followers_url":"https://api.github.com/users/sequelize/followers","following_url":"https://api.github.com/users/sequelize/following{/other_user}","gists_url":"https://api.github.com/users/sequelize/gists{/gist_id}","starred_url":"https://api.github.com/users/sequelize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sequelize/subscriptions","organizations_url":"https://api.github.com/users/sequelize/orgs","repos_url":"https://api.github.com/users/sequelize/repos","events_url":"https://api.github.com/users/sequelize/events{/privacy}","received_events_url":"https://api.github.com/users/sequelize/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sequelize/sequelize","description":"Sequelize is an easy-to-use multi sql dialect ORM for Node.js & io.js. It currently supports MySQL, MariaDB, SQLite, PostgreSQL and MSSQL.","fork":false,"url":"https://api.github.com/repos/sequelize/sequelize","forks_url":"https://api.github.com/repos/sequelize/sequelize/forks","keys_url":"https://api.github.com/repos/sequelize/sequelize/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sequelize/sequelize/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sequelize/sequelize/teams","hooks_url":"https://api.github.com/repos/sequelize/sequelize/hooks","issue_events_url":"https://api.github.com/repos/sequelize/sequelize/issues/events{/number}","events_url":"https://api.github.com/repos/sequelize/sequelize/events","assignees_url":"https://api.github.com/repos/sequelize/sequelize/assignees{/user}","branches_url":"https://api.github.com/repos/sequelize/sequelize/branches{/branch}","tags_url":"https://api.github.com/repos/sequelize/sequelize/tags","blobs_url":"https://api.github.com/repos/sequelize/sequelize/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sequelize/sequelize/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sequelize/sequelize/git/refs{/sha}","trees_url":"https://api.github.com/repos/sequelize/sequelize/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sequelize/sequelize/statuses/{sha}","languages_url":"https://api.github.com/repos/sequelize/sequelize/languages","stargazers_url":"https://api.github.com/repos/sequelize/sequelize/stargazers","contributors_url":"https://api.github.com/repos/sequelize/sequelize/contributors","subscribers_url":"https://api.github.com/repos/sequelize/sequelize/subscribers","subscription_url":"https://api.github.com/repos/sequelize/sequelize/subscription","commits_url":"https://api.github.com/repos/sequelize/sequelize/commits{/sha}","git_commits_url":"https://api.github.com/repos/sequelize/sequelize/git/commits{/sha}","comments_url":"https://api.github.com/repos/sequelize/sequelize/comments{/number}","issue_comment_url":"https://api.github.com/repos/sequelize/sequelize/issues/comments{/number}","contents_url":"https://api.github.com/repos/sequelize/sequelize/contents/{+path}","compare_url":"https://api.github.com/repos/sequelize/sequelize/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sequelize/sequelize/merges","archive_url":"https://api.github.com/repos/sequelize/sequelize/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sequelize/sequelize/downloads","issues_url":"https://api.github.com/repos/sequelize/sequelize/issues{/number}","pulls_url":"https://api.github.com/repos/sequelize/sequelize/pulls{/number}","milestones_url":"https://api.github.com/repos/sequelize/sequelize/milestones{/number}","notifications_url":"https://api.github.com/repos/sequelize/sequelize/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sequelize/sequelize/labels{/name}","releases_url":"https://api.github.com/repos/sequelize/sequelize/releases{/id}","deployments_url":"https://api.github.com/repos/sequelize/sequelize/deployments","created_at":"2010-07-22T07:11:11Z","updated_at":"2016-05-03T21:43:26Z","pushed_at":"2016-05-03T22:34:04Z","git_url":"git://github.com/sequelize/sequelize.git","ssh_url":"git@github.com:sequelize/sequelize.git","clone_url":"https://github.com/sequelize/sequelize.git","svn_url":"https://github.com/sequelize/sequelize","homepage":"http://sequelizejs.com","size":53495,"stargazers_count":6407,"watchers_count":6407,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1352,"mirror_url":null,"open_issues_count":715,"forks":1352,"open_issues":715,"watchers":6407,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/sequelize/sequelize/pulls/5851"},"html":{"href":"https://github.com/sequelize/sequelize/pull/5851"},"issue":{"href":"https://api.github.com/repos/sequelize/sequelize/issues/5851"},"comments":{"href":"https://api.github.com/repos/sequelize/sequelize/issues/5851/comments"},"review_comments":{"href":"https://api.github.com/repos/sequelize/sequelize/pulls/5851/comments"},"review_comment":{"href":"https://api.github.com/repos/sequelize/sequelize/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/sequelize/sequelize/pulls/5851/commits"},"statuses":{"href":"https://api.github.com/repos/sequelize/sequelize/statuses/23b0ace1a1da3825ff0c093e8dafb0565e12ed34"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":19,"deletions":2,"changed_files":3}}