USE mailserver;

# table struct

CREATE TABLE messagestodeliver
(
  MessageID int(12) unsigned default NULL,
  ReceivedTime int(10) unsigned default NULL,
  DomainTo varchar(65) default NULL,
  ToMailBoxID int(10) unsigned default NULL,
  FromMailBoxID int(10) unsigned default NULL,
  FromHostName text,
  FromIP text,
  FileSize int(10) unsigned default NULL,
  MailFrom text,
  ReceiptTo text,
  MessageText longtext,
  KEY MessageID (MessageID, ReceivedTime, DomainTo, ToMailBoxID, FromMailBoxID)
) TYPE=MyISAM;