1 CREATE TABLE accounts (
2 	id INTEGER PRIMARY KEY AUTOINCREMENT,
3 	name TEXT NOT NULL,
4 	username TEXT NOT NULL,
5 	password TEXT NOT NULL
6 );
7 
8 CREATE TABLE domains (
9 	id INTEGER PRIMARY KEY AUTOINCREMENT,
10 	account_id INTEGER NOT NULL,
11 	domain VARCHAR(255) NOT NULL
12 );
13 
14 CREATE TABLE mailboxes (
15 	id INTEGER PRIMARY KEY AUTOINCREMENT,
16 	address VARCHAR(255) NOT NULL,
17 	password VARCHAR(255) NOT NULL,
18 	domain_id INTEGER NOT NULL
19 );
20 
21 CREATE TABLE aliases (
22 	id INTEGER PRIMARY KEY AUTOINCREMENT,
23 	recipient VARCHAR(255) NOT NULL,
24 	destination VARCHAR(255) NOT NULL
25 );