From 14ce3d9fa8700b4c0aa035c86a7e55af905dbf28 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Fri, 26 Mar 2021 12:49:35 +0100 Subject: Build: simplify proj.db generation (#2605) - change foreign key check, so that it is enabled outside of the transaction where we insert things, and can make the sqlite3 process fail in case of violations, without the postcheck done in the autoconf build - autoconf and cmake builds: simplification related to the above (which also means that cmake builds now have the fkey check, which was omitted until now) --- data/sql/proj_db_table_defs.sql | 3 --- 1 file changed, 3 deletions(-) (limited to 'data/sql/proj_db_table_defs.sql') diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index e43dfad4..2969178b 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1,8 +1,5 @@ --- Table structures -PRAGMA page_size = 4096; -PRAGMA foreign_keys = 1; - CREATE TABLE metadata( key TEXT NOT NULL PRIMARY KEY CHECK (length(key) >= 1), value TEXT NOT NULL -- cgit v1.2.3