commit 922ab726e1553119a2d1c49f8084b6d1f74bfdcd
from: Oliver Lowe <o@olowe.co>
date: Tue Mar 22 01:34:34 2022 UTC

Disallow creating a mailbox without parent domain

commit - 9935e8d449f0f7a5b1be268702547e57ef97711e
commit + 922ab726e1553119a2d1c49f8084b6d1f74bfdcd
blob - b656ad90a2b3865d566c4cb05d7deb1e224efb2c
blob + d25b82b74f4eff3bb917af7f8db7483495e17dc6
--- init.sql
+++ init.sql
@@ -12,7 +12,7 @@ CREATE TABLE domains (
 CREATE TABLE mailboxes (
 	address TEXT PRIMARY KEY,
 	password TEXT NOT NULL,
-	domain TEXT NOT NULL
+	FOREIGN KEY(domain) REFERENCES domains(domain) NOT NULL
 );
 
 CREATE TABLE aliases (