merchant

commit 2981863ec280cd2d1eb9e0bb668e4c1e47348c1a
parent a71c3a4c0821bbd478a3527a320edbc39524f9ef
Author: Florian Dold <florian@dold.me>
Date:   Thu, 11 Jun 2026 15:59:41 +0200

remove unused merchant_instances columns

Diffstat:
A
src/backenddb/sql-schema/merchant-0040.sql
 | 
33
+++++++++++++++++++++++++++++++++
M
src/backenddb/sql-schema/meson.build
 | 
4
++--

2 files changed, 35 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/sql-schema/merchant-0040.sql b/src/backenddb/sql-schema/merchant-0040.sql
@@ -0,0 +1,33 @@
+--
+-- This file is part of TALER
+-- Copyright (C) 2026 Taler Systems SA
+--
+-- TALER is free software; you can redistribute it and/or modify it under the
+-- terms of the GNU General Public License as published by the Free Software
+-- Foundation; either version 3, or (at your option) any later version.
+--
+-- TALER is distributed in the hope that it will be useful, but WITHOUT ANY
+-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
+-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License along with
+-- TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
+
+-- @file merchant-0039.sql
+-- @brief Remove unused columns from merchant.merchant_instances.
+-- These validation_needed and validation_expired columns are not needed, since
+-- merchant instances are only created after MFA validation in the first place.
+-- They are an artifact of how self-provisioning worked in an earlier version.
+-- @author Florian Dold
+
+BEGIN;
+
+SELECT _v.register_patch('merchant-0040', NULL, NULL);
+
+SET search_path TO merchant;
+
+ALTER TABLE merchant_instances
+  DROP COLUMN validation_needed,
+  DROP COLUMN validation_expiration;
+
+COMMIT;
diff --git a/src/backenddb/sql-schema/meson.build b/src/backenddb/sql-schema/meson.build
@@ -114,6 +114,7 @@ generated_sql = [
     ['merchant-0037.sql'],
     ['merchant-0038.sql'],
     ['merchant-0039.sql'],
+    ['merchant-0040.sql'],
 ]
 
 foreach g : generated_sql
@@ -141,4 +142,4 @@ custom_target(
         command: ['./preprocess-sql.sh', '@INPUT@'],
         install: true,
         install_dir: sqldir,
-    )
-\ No newline at end of file
+    )