# $Id: sql.txt,v 1.2 2004/11/28 14:55:42 tommy Exp $
#

create table incoming (
  id int auto_increment,
  queue_id varchar(16),
  message_id varchar(255),
  arrive_time datetime,
  hostname varchar(255),
  ipaddr varchar(255),
  uid int,
  user varchar(255),
  sender varchar(255),
  size int unsigned,
  old bool,
  unique (id),
  index (queue_id)
);

create table outgoing (
  id int,
  action_time datetime,
  recipient varchar(255),
  status varchar(255),
  relay varchar(255),
  delay int,
  info text,
  index (id)
);

create table work (
  filename varchar(255),
  inode int,
  pos int,
  unique (filename)
);
