From 3538009b53d9aadc31514ef72cb963c24c567bfb Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Thu, 5 May 2022 19:43:23 +0200 Subject: ... --- hosts/surtr/postgresql.nix | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'hosts/surtr') diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix index e3384fbd..4ce2342c 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix @@ -34,7 +34,7 @@ in { id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), mailbox text NOT NULL CONSTRAINT mailbox_non_empty CHECK (mailbox <> '''), quota_bytes bigint CONSTRAINT quota_bytes_positive CHECK (CASE WHEN quota_bytes IS NOT NULL THEN quota_bytes > 0 ELSE true END), - CONSTRAINT mailbox_unique UNIQUE mailbox + CONSTRAINT mailbox_unique UNIQUE (mailbox) ); CREATE TABLE mailbox_mapping ( id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), -- cgit v1.2.3