CREATE TABLE access_auth (
  authenticated_id TEXT NOT NULL default '',
  action TEXT NOT NULL default '',
  sender_host_address TEXT NOT NULL default '',
  ASN TEXT NOT NULL default '',
  country TEXT NOT NULL default '',
  continent TEXT NOT NULL default '',
  received_ip_address TEXT NOT NULL default '',
  created_on INTEGER NOT NULL DEFAULT 0,
  expired_on INTEGER NOT NULL DEFAULT 0,
  smtp_message TEXT NOT NULL default '',
  log_message TEXT NOT NULL default ''
);

CREATE INDEX authenticated_id ON access_auth (authenticated_id, expired_on);
