diff options
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; |