# HG changeset patch
# User Olaf Wintermann <olaf.wintermann@gmail.com>
# Date 1769014939 -3600
# Node ID c160700751eccc22f77ff2a861eb4487939d8a01
# Parent  34c723ed7190020064b21a9e91a9c18ff03b71fe
enable sqlite foreign_keys = ON by default

diff -r 34c723ed7190 -r c160700751ec dbutils/sqlite.c
--- a/dbutils/sqlite.c	Wed Jan 21 17:59:45 2026 +0100
+++ b/dbutils/sqlite.c	Wed Jan 21 18:02:19 2026 +0100
@@ -47,7 +47,13 @@
     DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true);
     if(!conn) {
         sqlite3_close(db);
+    } else {
+        if(dbuSqlExec(conn, "PRAGMA foreign_keys = ON;")) {
+            dbuConnectionFree(conn);
+            return NULL;
+        }
     }
+    
     return conn;
 }