From mboxrd@z Thu Jan 1 00:00:00 1970 Return-path: Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by metis.ext.pengutronix.de with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j2wvj-0004j8-Ik for ptxdist@pengutronix.de; Sat, 15 Feb 2020 13:52:20 +0100 Received: by mail-wm1-x342.google.com with SMTP id g1so12777550wmh.4 for ; Sat, 15 Feb 2020 04:52:19 -0800 (PST) From: Bruno Thomsen Date: Sat, 15 Feb 2020 13:52:05 +0100 Message-Id: <20200215125205.31606-1-bruno.thomsen@gmail.com> MIME-Version: 1.0 Subject: [ptxdist] [PATCH] sqlite: enable foreign keys by default List-Id: PTXdist Development Mailing List List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: ptxdist@pengutronix.de Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Errors-To: ptxdist-bounces@pengutronix.de Sender: "ptxdist" To: ptxdist@pengutronix.de Cc: Bruno Thomsen , bth@kamstrup.com 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 --- 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