From da8ddb18d6f3996b900c47128a71e0800732e2e5 Mon Sep 17 00:00:00 2001 From: Peter van Dijk Date: Wed, 3 Aug 2022 11:47:14 +0200 Subject: [PATCH] auth sqlite3: abort schema transactions on error --- modules/gsqlite3backend/3.4.0_to_4.0.0_schema.sqlite3.sql | 2 ++ modules/gsqlite3backend/4.0.0_to_4.2.0_schema.sqlite3.sql | 2 ++ modules/gsqlite3backend/4.2.0_to_4.3.0_schema.sqlite3.sql | 2 ++ modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql | 2 ++ modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql | 2 ++ modules/gsqlite3backend/dnssec-3.x_to_3.4.0_schema.sqlite3.sql | 2 ++ 6 files changed, 12 insertions(+) diff --git a/modules/gsqlite3backend/3.4.0_to_4.0.0_schema.sqlite3.sql b/modules/gsqlite3backend/3.4.0_to_4.0.0_schema.sqlite3.sql index 2543c55371..53ebcad283 100644 --- a/modules/gsqlite3backend/3.4.0_to_4.0.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/3.4.0_to_4.0.0_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + -- Disable foreign keys, if any PRAGMA foreign_keys = 0; diff --git a/modules/gsqlite3backend/4.0.0_to_4.2.0_schema.sqlite3.sql b/modules/gsqlite3backend/4.0.0_to_4.2.0_schema.sqlite3.sql index 47c39addc3..b22f0534a8 100644 --- a/modules/gsqlite3backend/4.0.0_to_4.2.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/4.0.0_to_4.2.0_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + BEGIN TRANSACTION; CREATE TEMPORARY TABLE records_backup ( id INTEGER PRIMARY KEY, diff --git a/modules/gsqlite3backend/4.2.0_to_4.3.0_schema.sqlite3.sql b/modules/gsqlite3backend/4.2.0_to_4.3.0_schema.sqlite3.sql index a6ca8fd3dc..a6703c2d79 100644 --- a/modules/gsqlite3backend/4.2.0_to_4.3.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/4.2.0_to_4.3.0_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + BEGIN TRANSACTION; CREATE TABLE cryptokeys_temp ( id INTEGER PRIMARY KEY, diff --git a/modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql b/modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql index 26eb9972fc..37dc72fb01 100644 --- a/modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql +++ b/modules/gsqlite3backend/4.3.0_to_4.3.1_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + CREATE INDEX records_lookup_idx ON records(name, type); CREATE INDEX records_lookup_id_idx ON records(domain_id, name, type); CREATE INDEX records_order_idx ON records(domain_id, ordername); diff --git a/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql b/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql index f2d55d4831..d46bb1c344 100644 --- a/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/4.3.1_to_4.7.0_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + PRAGMA foreign_keys = 0; BEGIN TRANSACTION; diff --git a/modules/gsqlite3backend/dnssec-3.x_to_3.4.0_schema.sqlite3.sql b/modules/gsqlite3backend/dnssec-3.x_to_3.4.0_schema.sqlite3.sql index dc2f6c4b65..bfa924e22f 100644 --- a/modules/gsqlite3backend/dnssec-3.x_to_3.4.0_schema.sqlite3.sql +++ b/modules/gsqlite3backend/dnssec-3.x_to_3.4.0_schema.sqlite3.sql @@ -1,3 +1,5 @@ +.bail on + CREATE TABLE comments ( id INTEGER PRIMARY KEY, domain_id INTEGER NOT NULL, -- 2.47.2