CREATE TABLE fax_status (
  id int(11) NOT NULL auto_increment,
  fax_id int(11) default NULL,
  recipient varchar(50) default NULL,
  active int(1) default '0',
  status int(1) default '0',
  tx_time time default NULL,
  tx_date date default NULL,
  sub_time time default NULL,
  sub_date date default NULL,
  fax_number varchar(15) default NULL,
  err_code varchar(50) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;