diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:44:10 +0200 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-05 19:44:10 +0200 |
| commit | 640d58894f11595bd91a9628575bbda0d802cdad (patch) | |
| tree | 0fa07983de353b0fdf546889d93e00b8f709470b /hosts | |
| parent | 3538009b53d9aadc31514ef72cb963c24c567bfb (diff) | |
| download | nixos-640d58894f11595bd91a9628575bbda0d802cdad.tar nixos-640d58894f11595bd91a9628575bbda0d802cdad.tar.gz nixos-640d58894f11595bd91a9628575bbda0d802cdad.tar.bz2 nixos-640d58894f11595bd91a9628575bbda0d802cdad.tar.xz nixos-640d58894f11595bd91a9628575bbda0d802cdad.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 4ce2342c..20cebdea 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 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; |