Use Triggers for Foreign Key Constraints

[jazzyb]

The PRAGMA foreign_keys = ON; method of ensuring foreign key constraints puts limits on what we are able to do with SQLite ALTER TABLE. See this commit note for details.