Corrugated Box Costing Engine

1. Go to supabase.com → New project
2. In the SQL Editor, run this once to create the tables:

create table if not exists aic_quotes (
  qnum text primary key,
  data jsonb not null,
  created_at timestamptz default now()
);
create table if not exists aic_customers (
  id text primary key,
  data jsonb not null,
  updated_at timestamptz default now()
);
create table if not exists aic_approved_rates (
  qnum text primary key,
  data jsonb not null,
  updated_at timestamptz default now()
);
create table if not exists aic_snapshots (
  qnum text primary key,
  data jsonb not null,
  created_at timestamptz default now()
);
create table if not exists aic_counter (
  id text primary key,
  val integer not null default 1
);
insert into aic_counter (id, val) values ('quote_seq', 1) on conflict do nothing;
-- Enable public access (RLS off for internal tool)
alter table aic_quotes enable row level security;
alter table aic_customers enable row level security;
alter table aic_approved_rates enable row level security;
alter table aic_snapshots enable row level security;
alter table aic_counter enable row level security;
create policy "allow all" on aic_quotes for all using (true) with check (true);
create policy "allow all" on aic_customers for all using (true) with check (true);
create policy "allow all" on aic_approved_rates for all using (true) with check (true);
create policy "allow all" on aic_snapshots for all using (true) with check (true);
create policy "allow all" on aic_counter for all using (true) with check (true);

-- ⚡ IMPORTANT: Atomic quote sequence (prevents duplicate quote numbers when 2 users save at the same time)
-- Run this in Supabase SQL Editor → New Query
create or replace function aic_next_quote_seq()
returns integer language plpgsql security definer as $$
declare next_val integer;
begin
  update aic_counter set val = val + 1 where id = 'quote_seq' returning val into next_val;
  return next_val;
end;
$$;

3. Copy Project URL and anon key from Settings → API
4. Paste them above and click Save & Connect
5. Run the aic_next_quote_seq function SQL above to prevent duplicate quote numbers