Commit Diff

Commit:
922ab726e1553119a2d1c49f8084b6d1f74bfdcd
From:
Oliver Lowe <o@olowe.co>
Date:
Message:
Disallow creating a mailbox without parent domain
Actions:
Patch | Tree
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 (