1 CREATE TABLE IF NOT EXISTS users (
2 	username TEXT PRIMARY KEY,
3 	password BLOB NOT NULL
4 );
5 
6 CREATE TABLE IF NOT EXISTS aliases (
7 	recipient TEXT PRIMARY KEY,
8 	destination TEXT,
9 	FOREIGN KEY(destination) REFERENCES users(username)
10 )