From 1c2283ea17da5bbb5f4f8449a0701aaeb2c8b52b Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Sat, 7 Jun 2025 13:38:00 +0200 Subject: recipient_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 208017eb..840b46c6 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix @@ -326,6 +326,18 @@ in { ); COMMIT; + + BEGIN; + SELECT _v.register_patch('016-recipient_bcc', null, null); + + CREATE TABLE recipient_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