[core] PRAGMA FOREIGN_KEYS = on by default for ALL connections

[permahorse]

investigate, unless there is some heavy penalty - it should be ON for every connection