{"action":"closed","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1127","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1127/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1127/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1127/events","html_url":"https://github.com/aspnet/EntityFramework/issues/1127","id":49936164,"number":1127,"title":"SQLite: Lift AddForeignKey ops to CreateTable when gen'ing SQL","user":{"login":"anpete","id":1210944,"avatar_url":"https://avatars.githubusercontent.com/u/1210944?v=3","gravatar_id":"","url":"https://api.github.com/users/anpete","html_url":"https://github.com/anpete","followers_url":"https://api.github.com/users/anpete/followers","following_url":"https://api.github.com/users/anpete/following{/other_user}","gists_url":"https://api.github.com/users/anpete/gists{/gist_id}","starred_url":"https://api.github.com/users/anpete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anpete/subscriptions","organizations_url":"https://api.github.com/users/anpete/orgs","repos_url":"https://api.github.com/users/anpete/repos","events_url":"https://api.github.com/users/anpete/events{/privacy}","received_events_url":"https://api.github.com/users/anpete/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/bug","name":"bug","color":"f7c6c7"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2014-11-24T20:11:06Z","updated_at":"2015-04-29T20:43:58Z","closed_at":"2015-04-29T20:43:58Z","body":"When creating tables with FKs in SQLite, SQL gen for migrations ops currently throws NotImplemented for AddFK operation. But, when we are creating the table in the same migration, we should be able to lift the FK into the Create Table statement itself and thus avoid the SQLite limitation."}}