--- a/server/sqlutils.py	Thu Jan 15 18:53:45 2015 +0100
+++ b/server/sqlutils.py	Thu Jan 15 19:17:32 2015 +0100
@@ -500,6 +500,8 @@
         return (dt.weekday() + 1) % 7
     cnx.create_function("WEEKDAY", 1, weekday)
 
+    cnx.cursor().execute("pragma foreign_keys = on")
+
     import yams.constraints
     yams.constraints.patch_sqlite_decimal()