diff options
-rw-r--r-- | hosts/surtr/postgresql.nix | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix index e4a83e63..510437aa 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix | |||
@@ -33,12 +33,12 @@ in { | |||
33 | create table virtual_mailbox ( | 33 | create table virtual_mailbox ( |
34 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), | 34 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), |
35 | local text, | 35 | local text, |
36 | CHECK (local IS DISTINCT FROM ''''), | 36 | CHECK (local IS DISTINCT FROM '''), |
37 | domain text NOT NULL, | 37 | domain text NOT NULL, |
38 | CHECK (domain <> ''''), | 38 | CHECK (domain <> '''), |
39 | mailbox text NOT NULL, | 39 | mailbox text NOT NULL, |
40 | CHECK (mailbox <> ''''), | 40 | CHECK (mailbox <> '''), |
41 | UNIQUE(COALESCE(local, ''''), domain) | 41 | UNIQUE(COALESCE(local, '''), domain) |
42 | ); | 42 | ); |
43 | COMMIT; | 43 | COMMIT; |
44 | ''} | 44 | ''} |