enable foreign_key pragma at database opening

1 files changed, 10 insertions, 0 deletions

diff --git a/midori/midori-bookmarks.c b/midori/midori-bookmarks.c
index 33139164..af789f39 100644
--- a/midori/midori-bookmarks.c
+++ b/midori/midori-bookmarks.c
@@ -250,6 +250,16 @@ midori_bookmarks_new (char** errmsg)
 
     if (newfile_did_exist)
     {
+        const gchar* setup_stmt = "PRAGMA foreign_keys = ON;";
+        /* initial setup */
+        if (sqlite3_exec (db, setup_stmt, NULL, NULL, &sql_errmsg) != SQLITE_OK)
+        {
+            *errmsg = g_strdup_printf (_("Couldn't setup bookmarks: %s\n"),
+                sql_errmsg ? sql_errmsg : "(err = NULL)");
+            sqlite3_free (sql_errmsg);
+            goto init_failed;
+        }
+
         /* we are done */
         goto init_success;
     }