diff options
author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-16 20:40:50 +0100 |
---|---|---|
committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-16 20:40:50 +0100 |
commit | 3a0d7137658dfa40f5d2ef09869160b03f0409a4 (patch) | |
tree | c6a6ca166288985fbea953c341e0e56b3dbf831c /hosts/surtr | |
parent | 3409d4a9128bff673ebb3638ec3dc37ad10a3010 (diff) | |
download | nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.gz nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.bz2 nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.tar.xz nixos-3a0d7137658dfa40f5d2ef09869160b03f0409a4.zip |
...
Diffstat (limited to 'hosts/surtr')
-rw-r--r-- | hosts/surtr/postgresql/default.nix | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 019ed3a5..9cfcc365 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix | |||
@@ -228,10 +228,10 @@ in { | |||
228 | 228 | ||
229 | ALTER TABLE mailbox_mapping DROP CONSTRAINT local_domain_unique; | 229 | ALTER TABLE mailbox_mapping DROP CONSTRAINT local_domain_unique; |
230 | CREATE UNIQUE INDEX local_domain_unique ON mailbox_mapping (local, domain) WHERE extension IS null; | 230 | CREATE UNIQUE INDEX local_domain_unique ON mailbox_mapping (local, domain) WHERE extension IS null; |
231 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique USING INDEX local_domain_unique; | 231 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_domain_unique UNIQUE USING INDEX local_domain_unique; |
232 | 232 | ||
233 | CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); | 233 | CREATE UNIQUE INDEX local_extension_domain_unique ON mailbox_mapping (local, extension, domain); |
234 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique USING INDEX local_extension_domain_unique; | 234 | ALTER TABLE mailbox_mapping ADD CONSTRAINT local_extension_domain_unique UNIQUE USING INDEX local_extension_domain_unique; |
235 | 235 | ||
236 | ALTER TABLE mailbox_mapping ADD COLUMN reject bool NOT NULL DEFAULT false; | 236 | ALTER TABLE mailbox_mapping ADD COLUMN reject bool NOT NULL DEFAULT false; |
237 | 237 | ||