-- Tombstone ads: public market cards with raise figures, investor counts, and last-updated.

alter table capstone_projects add column if not exists vehicle text default 'sponsored_research';
alter table capstone_projects add column if not exists investment_type text default 'donation';
alter table capstone_projects add column if not exists share_type text;
alter table capstone_projects add column if not exists investors integer not null default 0;
alter table capstone_projects add column if not exists funded_cents integer not null default 0;
alter table capstone_projects add column if not exists min_raise_cents integer not null default 0;
alter table capstone_projects add column if not exists max_raise_cents integer not null default 0;
alter table capstone_projects add column if not exists min_investment_cents integer not null default 0;
alter table capstone_projects add column if not exists authorized_shares integer not null default 0;
alter table capstone_projects add column if not exists shares_offered integer not null default 0;
alter table capstone_projects add column if not exists price_per_share_cents integer not null default 0;
alter table capstone_projects add column if not exists banner_src text;
alter table capstone_projects add column if not exists closes_at date;
alter table capstone_projects add column if not exists last_updated_at timestamptz not null default now();
alter table capstone_projects add column if not exists approval_status text not null default 'pending';
alter table capstone_projects add column if not exists publish_status text not null default 'unpublished';