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);

3. Copy Project URL and anon key from Settings → API
4. Paste them above and click Save & Connect