Explaining SQLite foreign keys support with unit tests

Today I got confused by foreign keys support in SQLite. I couldn't explain why my schema migration script has failed so I wrote some unit tests to clarify my…