1 901f37ea 2022-02-27 o CREATE TABLE accounts (
 2 9935e8d4 2022-03-21 o 	username TEXT PRIMARY KEY,
 3 9935e8d4 2022-03-21 o 	password TEXT NOT NULL,
 4 9935e8d4 2022-03-21 o 	name TEXT NOT NULL
 5 901f37ea 2022-02-27 o );
 6 901f37ea 2022-02-27 o 
 7 901f37ea 2022-02-27 o CREATE TABLE domains (
 8 9935e8d4 2022-03-21 o 	domain TEXT PRIMARY KEY,
 9 9935e8d4 2022-03-21 o 	account TEXT NOT NULL
10 901f37ea 2022-02-27 o );
11 901f37ea 2022-02-27 o 
12 901f37ea 2022-02-27 o CREATE TABLE mailboxes (
13 9935e8d4 2022-03-21 o 	address TEXT PRIMARY KEY,
14 9935e8d4 2022-03-21 o 	password TEXT NOT NULL,
15 922ab726 2022-03-22 o 	FOREIGN KEY(domain) REFERENCES domains(domain) NOT NULL
16 901f37ea 2022-02-27 o );
17 901f37ea 2022-02-27 o 
18 1aed0ca2 2022-02-26 o CREATE TABLE aliases (
19 9935e8d4 2022-03-21 o 	recipient TEXT PRIMARY KEY,
20 9935e8d4 2022-03-21 o 	destination TEXT NOT NULL
21 1aed0ca2 2022-02-26 o );