mailarchive of the ptxdist mailing list
 help / color / mirror / Atom feed
From: Bruno Thomsen <bruno.thomsen@gmail.com>
To: ptxdist@pengutronix.de
Cc: Bruno Thomsen <bruno.thomsen@gmail.com>, bth@kamstrup.com
Subject: [ptxdist] [PATCH] sqlite: enable foreign keys by default
Date: Sat, 15 Feb 2020 13:52:05 +0100	[thread overview]
Message-ID: <20200215125205.31606-1-bruno.thomsen@gmail.com> (raw)

Support for foreign_keys pragma was already enabled at
compile-time, but it was not enabled by default on new
database connections. It's still possible to turn off
enforcement at runtime.
This makes it easier to work on databases that uses
this feature without causing them to end up in an
invalid state.

Signed-off-by: Bruno Thomsen <bruno.thomsen@gmail.com>
---
 rules/sqlite.make | 1 +
 1 file changed, 1 insertion(+)

diff --git a/rules/sqlite.make b/rules/sqlite.make
index b23c2d377..e0b26e3cb 100644
--- a/rules/sqlite.make
+++ b/rules/sqlite.make
@@ -42,6 +42,7 @@ SQLITE_CONF_ENV := \
 	$(CROSS_ENV) \
 	ac_cv_header_zlib_h=no \
 	CPPFLAGS=" \
+	-DSQLITE_DEFAULT_FOREIGN_KEYS=1 \
 	-DSQLITE_ENABLE_COLUMN_METADATA=1 \
 	-DSQLITE_ENABLE_FTS3_PARENTHESIS=1 \
 	-DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \
-- 
2.24.1


_______________________________________________
ptxdist mailing list
ptxdist@pengutronix.de

             reply	other threads:[~2020-02-15 12:52 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-02-15 12:52 Bruno Thomsen [this message]
2020-02-21  7:23 ` Michael Olbrich
2020-02-21 11:20   ` Bruno Thomsen
2020-02-21 11:41     ` Uwe Kleine-König

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20200215125205.31606-1-bruno.thomsen@gmail.com \
    --to=bruno.thomsen@gmail.com \
    --cc=bth@kamstrup.com \
    --cc=ptxdist@pengutronix.de \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox