Update email addresses below — changes sync instantly to all devices via Supabase.
Supply Chain and Management receive action links via email. Separate multiple Supply Chain emails with commas.
-- Run once in Supabase SQL Editor:
create table if not exists fast_track_requests (
id text primary key,
submitted_at text, requestor_name text, requestor_email text,
customer_name text, location text, order_type text, sop_number text,
part_number text, part_description text, quantity text,
repeat_npi text, tooling text, customer_reqs text, ra_justification text,
expedite_fee text, expedite_amount text, attachment_title text,
sc_name text, sc_email text, bom_status text, tooling_status text,
order_impact text, lead_time text, sc_decision text, sc_comments text, reviewed_at text,
escalation_reason text, mgmt_decision text, mgmt_comments text,
mgmt_reviewed_at text, stage text, status text,
updated_at timestamptz default now()
);
alter table fast_track_requests enable row level security;
create policy "Allow all" on fast_track_requests for all using (true) with check (true);
create table if not exists portal_config (
key text primary key, value text, updated_at timestamptz default now()
);
alter table portal_config enable row level security;
create policy "Allow all" on portal_config for all using (true) with check (true);