diff options
Diffstat (limited to 'hosts/surtr/postgresql/default.nix')
-rw-r--r-- | hosts/surtr/postgresql/default.nix | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 3640ff12..e29da0b8 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix | |||
@@ -297,7 +297,6 @@ in { | |||
297 | 297 | ||
298 | COMMIT; | 298 | COMMIT; |
299 | 299 | ||
300 | |||
301 | BEGIN; | 300 | BEGIN; |
302 | SELECT _v.register_patch('014-relay', ARRAY['000-base'], null); | 301 | SELECT _v.register_patch('014-relay', ARRAY['000-base'], null); |
303 | 302 | ||
@@ -308,6 +307,13 @@ in { | |||
308 | ); | 307 | ); |
309 | 308 | ||
310 | COMMIT; | 309 | COMMIT; |
310 | |||
311 | BEGIN; | ||
312 | SELECT _v.register_patch('015-relay-unique', ARRAY['000-base', '014-relay'], null); | ||
313 | |||
314 | CREATE UNIQUE INDEX relay_unique ON relay_access (mailbox, domain); | ||
315 | |||
316 | COMMIT; | ||
311 | ''} | 317 | ''} |
312 | 318 | ||
313 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' | 319 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' |