create table shares
(
  rem_host varchar(128),
  client varchar(128),
  username varchar(128),
  our_result varchar(16),
  upstream_result varchar(16),
  reason varchar(64),
  difficulty double,
  time timestamp default now(),
  hash varchar(64),
  unique_id varchar(64),
  block_difficulty double
) engine innodb;

create index shares_time_idx_2 on shares(username, time, our_result, difficulty);
create index share_hash_idx on shares(hash);
create index shares_up_result on shares(upstream_result);
create index shares_time_idx_3 on shares(time);
create unique index shares_unique_idx on shares(unique_id);


create table witty_remarks
(
  order_id int unique not null,
  remark varchar(100) character set utf8 not null,
  used boolean default false,
  primary key(order_id)
) engine innodb;

create unique index witty_remarks_next_idx on witty_remarks(used, order_id);
create index witty_remarks_remark_idx on witty_remarks(remark);