{"action":"closed","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/5007","repository_url":"https://api.github.com/repos/sequelize/sequelize","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/5007/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/5007/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/5007/events","html_url":"https://github.com/sequelize/sequelize/issues/5007","id":121262640,"number":5007,"title":"SQLite migrations lose foreign keys on any column change","user":{"login":"jocull","id":246455,"avatar_url":"https://avatars.githubusercontent.com/u/246455?v=3","gravatar_id":"","url":"https://api.github.com/users/jocull","html_url":"https://github.com/jocull","followers_url":"https://api.github.com/users/jocull/followers","following_url":"https://api.github.com/users/jocull/following{/other_user}","gists_url":"https://api.github.com/users/jocull/gists{/gist_id}","starred_url":"https://api.github.com/users/jocull/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jocull/subscriptions","organizations_url":"https://api.github.com/users/jocull/orgs","repos_url":"https://api.github.com/users/jocull/repos","events_url":"https://api.github.com/users/jocull/events{/privacy}","received_events_url":"https://api.github.com/users/jocull/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2015-12-09T14:55:55Z","updated_at":"2017-01-10T05:21:45Z","closed_at":"2017-01-10T05:21:45Z","body":"I have a migration that iteratively walks through a series of columns, renaming them. However, I found that if I run a series of remove/create column calls, only the last one in keeps its foreign key constraint.\n\nI believe it has to do with Sequelize's way of moving data into a backup table, performing changes, and then moving it back.\n\nI'm not sure if this is a problem in other dialects.\n"}}
{"actor":{"display_login":"sushantdhiman"}}