eudoxia0 / crane

An ORM for Common Lisp.
http://eudoxia.me/crane/
201 stars 19 forks source link

Foreign keys are not enforced in sqlite. #42

Closed wnortje closed 8 years ago

wnortje commented 9 years ago

By default SQlite does not enforce foreign key constraints. This feature must be switched on every time a database connection is opened. The query to enable it is:

PRAGMA foreign_keys = ON;

More information here https://www.sqlite.org/foreignkeys.html#fk_enable.