CREATE TABLE awl ( recipient TEXT NOT NULL DEFAULT "", sender TEXT NOT NULL DEFAULT "", expires INTEGER NOT NULL DEFAULT 0 ); CREATE UNIQUE INDEX rcpt_mail ON awl (recipient, sender); CREATE INDEX expires ON awl (expires);