alter table solicitations add column if not exists contact_email text;
alter table solicitations add column if not exists draft_id text;

create table if not exists mail_sends (
  id text primary key,
  draft_id text,
  solicitation_id text,
  to_name text not null,
  to_email text not null,
  from_email text not null,
  subject text not null,
  body text not null,
  status text not null default 'queued',
  bounce_reason text,
  created_at timestamptz not null default now()
);
