CREATE TABLE IF NOT EXISTS users ( username TEXT PRIMARY KEY, password BLOB NOT NULL ); CREATE TABLE IF NOT EXISTS aliases ( recipient TEXT PRIMARY KEY, destination TEXT, FOREIGN KEY(destination) REFERENCES users(username) )