use island42;
drop table if exists sms_log;

create table sms_log (
  id int(11) NOT NULL primary key auto_increment,
  sent timestamp NOT NULL default now(),
  scheduled timestamp NOT NULL,
  to_user_id int(11) NOT NULL,
  to_number varchar(20) NOT NULL,
  doco_code varchar(25) NOT NULL,
  text_body varchar(160) NOT NULL default '',
  url text NOT NULL default '',
  response varchar(255) NOT NULL default ''
) type=InnoDB;

create index sms_log_i1 on sms_log(response);
create index sms_log_i2 on sms_log(to_user_id);