diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 18:07:02 +0200 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 18:07:02 +0200 |
| commit | 3b60dab1dbf2b435d3c1281a27e46bb27c42a521 (patch) | |
| tree | dd3a94bc2ffa3a53e7a5a7025f072c61d185dc5e | |
| parent | 9cf66ecd399162eec0bd50c53692cc5e7b2d2005 (diff) | |
| download | nixos-3b60dab1dbf2b435d3c1281a27e46bb27c42a521.tar nixos-3b60dab1dbf2b435d3c1281a27e46bb27c42a521.tar.gz nixos-3b60dab1dbf2b435d3c1281a27e46bb27c42a521.tar.bz2 nixos-3b60dab1dbf2b435d3c1281a27e46bb27c42a521.tar.xz nixos-3b60dab1dbf2b435d3c1281a27e46bb27c42a521.zip | |
...
| -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 | ''} |