From 0b0be3f0018f80f8345b60672eca6bcf37ec2b5c Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Sat, 7 Jun 2025 10:21:02 +0200
Subject: ...

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

(limited to 'hosts/surtr/postgresql/default.nix')

diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix
index 0ae29058..dedd4c7c 100644
--- a/hosts/surtr/postgresql/default.nix
+++ b/hosts/surtr/postgresql/default.nix
@@ -297,6 +297,17 @@ in {
 
           COMMIT;
 
+
+          BEGIN;
+          SELECT _v.register_patch('013-internal', ARRAY['000-base'], null);
+
+          CREATE TABLE relay_access (
+            id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
+            mailbox uuid REFERENCES mailbox(id),
+            domain citext NOT NULL CONSTRAINT domain_non_empty CHECK (domain <> '''),
+          );
+
+          COMMIT;
         ''}
 
         psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" ''
-- 
cgit v1.2.3