CREATE TABLE messages (
  messageid varchar(255) NOT NULL,
  env_from varchar(255) NOT NULL,
  env_rcpt varchar(255) NOT NULL,
  message longtext,
  ts timestamp NOT NULL,
  messagelen int(11),
  UNIQUE KEY messageid (messageid),
  KEY (ts), KEY (messagelen), KEY (env_from), KEY (env_rcpt)
);