summaryrefslogtreecommitdiff
path: root/hosts/surtr/postgresql/default.nix
diff options
context:
space:
mode:
Diffstat (limited to 'hosts/surtr/postgresql/default.nix')
-rw-r--r--hosts/surtr/postgresql/default.nix11
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" ''