summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--hosts/surtr/postgresql.nix2
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;