diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:40:22 +0200 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:40:22 +0200 |
| commit | 261bf65c6a34fe8d9a81c2c017b7ef1435da5fea (patch) | |
| tree | 35fcb964490f873e9f5a0cbaab524deadf45ae7d /hosts | |
| parent | 3c5a3ac95b84c2f263afcd2b5952dc29f517955d (diff) | |
| download | nixos-261bf65c6a34fe8d9a81c2c017b7ef1435da5fea.tar nixos-261bf65c6a34fe8d9a81c2c017b7ef1435da5fea.tar.gz nixos-261bf65c6a34fe8d9a81c2c017b7ef1435da5fea.tar.bz2 nixos-261bf65c6a34fe8d9a81c2c017b7ef1435da5fea.tar.xz nixos-261bf65c6a34fe8d9a81c2c017b7ef1435da5fea.zip | |
...
Diffstat (limited to 'hosts')
| -rw-r--r-- | hosts/surtr/postgresql.nix | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix index 798857f5..932ff531 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix | |||
| @@ -40,7 +40,7 @@ in { | |||
| 40 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), | 40 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), |
| 41 | local text CONSTRAINT local_non_empty CHECK (local IS DISTINCT FROM '''), | 41 | local text CONSTRAINT local_non_empty CHECK (local IS DISTINCT FROM '''), |
| 42 | domain text NOT NULL CONSTRAINT domain_non_empty CHECK (domain <> '''), | 42 | domain text NOT NULL CONSTRAINT domain_non_empty CHECK (domain <> '''), |
| 43 | mailbox uuid REFERENCES virtual_mailbox(id) | 43 | mailbox uuid REFERENCES virtual_mailbox(id), |
| 44 | CONSTRAINT local_domain_unique UNIQUE (local, domain) | 44 | CONSTRAINT local_domain_unique UNIQUE (local, domain) |
| 45 | ); | 45 | ); |
| 46 | CREATE UNIQUE INDEX domain_unique ON virtual_mailbox_mapping (domain) WHERE local IS NULL; | 46 | CREATE UNIQUE INDEX domain_unique ON virtual_mailbox_mapping (domain) WHERE local IS NULL; |