diff options
| author | Aleksander Machniak <alec@alec.pl> | 2021-10-03 13:10:14 +0300 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2021-10-03 13:10:14 +0300 |
| commit | 48fbf110af3f76128de7bbe7f6ce0e48247513e4 (patch) | |
| tree | f6a361b7b4dfe522f52f6091e7f7bb3a676610eb /program/lib/Roundcube/db/sqlite.php | |
| parent | 626332d42a6c4d12389b40ae57113e95f3b2ce56 (diff) | |
SQLite: Use foreign keys, require SQLite >= 3.6.19 (#8159)
Diffstat (limited to 'program/lib/Roundcube/db/sqlite.php')
| -rw-r--r-- | program/lib/Roundcube/db/sqlite.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/program/lib/Roundcube/db/sqlite.php b/program/lib/Roundcube/db/sqlite.php index 4182f7535..87e9c8384 100644 --- a/program/lib/Roundcube/db/sqlite.php +++ b/program/lib/Roundcube/db/sqlite.php @@ -76,7 +76,10 @@ class rcube_db_sqlite extends rcube_db } // Enable WAL mode to fix locking issues like #8035. - $dbh->query("PRAGMA journal_mode=WAL"); + $dbh->query("PRAGMA journal_mode = WAL"); + + // Enable foreign keys (requires sqlite 3.6.19 compiled with FK support) + $dbh->query("PRAGMA foreign_keys = ON"); } /** |