libeufin

commit 6342692b317b7c6645b9159995c2c7397958e241
parent aa55a2a99cfcfc9d7f3bfcc6f2a5234d3c1f58e2
Author: MS <ms@taler.net>
Date:   Wed, 26 Jul 2023 12:34:36 +0200

DB refactoring: tables in schemas.

Diffstat:
M
database-versioning/new/nexus-0001-refactor.sql
 | 
3
+++
M
database-versioning/new/sandbox-0001-refactor.sql
 | 
3
+++

2 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/database-versioning/new/nexus-0001-refactor.sql b/database-versioning/new/nexus-0001-refactor.sql
@@ -4,6 +4,9 @@ BEGIN;
 
 SELECT _v.register_patch('nexus-0001', NULL, NULL);
 
+CREATE SCHEMA nexus;
+SET search_path TO nexus;
+
 -- start of: user management
 
 CREATE TABLE IF NOT EXISTS nexus_users
diff --git a/database-versioning/new/sandbox-0001-refactor.sql b/database-versioning/new/sandbox-0001-refactor.sql
@@ -8,6 +8,9 @@ BEGIN;
 
 SELECT _v.register_patch('sandbox-0001', NULL, NULL);
 
+CREATE SCHEMA sandbox;
+SET search_path TO sandbox;
+
 -- start of: demobank config tables
 
 CREATE TABLE IF NOT EXISTS demobank_configs