From b797f3c77cda5618594935be5c69e297b09eb362 Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Sat, 7 Jun 2025 13:29:24 +0200
Subject: sender_bcc_maps

---
 hosts/surtr/postgresql/default.nix | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'hosts/surtr/postgresql')

diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix
index e29da0b8..2908435d 100644
--- a/hosts/surtr/postgresql/default.nix
+++ b/hosts/surtr/postgresql/default.nix
@@ -314,6 +314,18 @@ in {
           CREATE UNIQUE INDEX relay_unique ON relay_access (mailbox, domain);
 
           COMMIT;
+
+          BEGIN;
+          SELECT _v.register_patch('015-sender_bcc', ARRAY[], null);
+
+          CREATE TABLE sender_bcc_maps (
+            id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
+            key text NOT NULL CONSTRAINT key_not_empty CHECK (key <> '''),
+            value text NOT NULL CONSTRAINT value_not_empty CHECK (value <> '''),
+            CONSTRAINT key_unique UNIQUE (key)
+          );
+
+          COMMIT;
         ''}
 
         psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" ''
-- 
cgit v1.2.3