SQLite Migrations: Lift foreign key creation to CREATE TABLE statements

(I'm looking for feedback on a few of the TODOs.)
We're going to make the schema name part of the table name.