CREATE TABLE awl ( recipient TEXT NOT NULL DEFAULT "", sender TEXT NOT NULL DEFAULT "", action TEXT NOT NULL DEFAULT "", message TEXT NOT NULL DEFAULT "" ); CREATE UNIQUE INDEX rcpt_mail ON awl (recipient, sender);