-- Handshake intern matching: score every open seat. A 0 still qualifies as a Fan.

alter table applications add column if not exists applied_role text;
alter table applications add column if not exists offer_path text;
alter table applications add column if not exists offer_role text;
alter table applications add column if not exists decision_copy text;
alter table applications add column if not exists match_json jsonb;
