CREATE TABLE accounts (
	username TEXT PRIMARY KEY,
	password TEXT NOT NULL,
	name TEXT NOT NULL
);

CREATE TABLE domains (
	domain TEXT PRIMARY KEY,
	account TEXT NOT NULL
);

CREATE TABLE mailboxes (
	address TEXT PRIMARY KEY,
	password TEXT NOT NULL,
	FOREIGN KEY(domain) REFERENCES domains(domain) NOT NULL
);

CREATE TABLE aliases (
	recipient TEXT PRIMARY KEY,
	destination TEXT NOT NULL
);