diff options
Diffstat (limited to 'hosts/surtr/postgresql')
-rw-r--r-- | hosts/surtr/postgresql/default.nix | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index 0ae29058..dedd4c7c 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix | |||
@@ -297,6 +297,17 @@ in { | |||
297 | 297 | ||
298 | COMMIT; | 298 | COMMIT; |
299 | 299 | ||
300 | |||
301 | BEGIN; | ||
302 | SELECT _v.register_patch('013-internal', ARRAY['000-base'], null); | ||
303 | |||
304 | CREATE TABLE relay_access ( | ||
305 | id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(), | ||
306 | mailbox uuid REFERENCES mailbox(id), | ||
307 | domain citext NOT NULL CONSTRAINT domain_non_empty CHECK (domain <> '''), | ||
308 | ); | ||
309 | |||
310 | COMMIT; | ||
300 | ''} | 311 | ''} |
301 | 312 | ||
302 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' | 313 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' |