1 CREATE TABLE accounts (
2 	username TEXT PRIMARY KEY,
3 	password TEXT NOT NULL,
4 	name TEXT NOT NULL
5 );
6 
7 CREATE TABLE domains (
8 	domain TEXT PRIMARY KEY,
9 	account TEXT NOT NULL
10 );
11 
12 CREATE TABLE mailboxes (
13 	address TEXT PRIMARY KEY,
14 	password TEXT NOT NULL,
15 	FOREIGN KEY(domain) REFERENCES domains(domain) NOT NULL
16 );
17 
18 CREATE TABLE aliases (
19 	recipient TEXT PRIMARY KEY,
20 	destination TEXT NOT NULL
21 );