commit 8a8f6795ece016bc9d56f8c6ec29838ed9682790
from: Oliver Lowe <o@olowe.co>
date: Mon Mar 07 06:01:34 2022 UTC

Ensure no conflict in domains, mailboxes etc.

commit - a15802b2eec7c07293e60b2465cc2c3d644ad1a2
commit + 8a8f6795ece016bc9d56f8c6ec29838ed9682790
blob - c021ed5090519afa2c0e43c4d3cc68d4c7135c95
blob + 66a6cf42578c33eb747bad892eebd22861f8c3a3
--- init.sql
+++ init.sql
@@ -1,25 +1,25 @@
 CREATE TABLE accounts (
 	id INTEGER PRIMARY KEY AUTOINCREMENT,
 	name TEXT NOT NULL,
-	username TEXT NOT NULL,
+	username TEXT UNIQUE NOT NULL,
 	password TEXT NOT NULL
 );
 
 CREATE TABLE domains (
 	id INTEGER PRIMARY KEY AUTOINCREMENT,
 	account_id INTEGER NOT NULL,
-	domain VARCHAR(255) NOT NULL
+	domain VARCHAR(255) UNIQUE NOT NULL
 );
 
 CREATE TABLE mailboxes (
 	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	address VARCHAR(255) NOT NULL,
+	address VARCHAR(255) UNIQUE NOT NULL,
 	password VARCHAR(255) NOT NULL,
 	domain_id INTEGER NOT NULL
 );
 
 CREATE TABLE aliases (
 	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	recipient VARCHAR(255) NOT NULL,
+	recipient VARCHAR(255) UNIQUE NOT NULL,
 	destination VARCHAR(255) NOT NULL
 );