Supabase Setup — run once in SQL editor
create table garments (
id serial primary key,
name text not null,
cat text,
type text,
price numeric,
price_type text,
description text,
badge text,
icon text,
img_url text,
sizes text[],
available boolean default true,
created_at timestamptz default now()
);
create table enquiries (
id serial primary key,
firstname text, lastname text,
email text, phone text,
garment_type text, occasion text, budget text, notes text,
bust numeric, waist numeric, hips numeric,
shoulder numeric, arm_length numeric, dress_length numeric,
fabrics text[],
status text default 'new',
created_at timestamptz default now()
);
-- Storage bucket (run in dashboard: Storage → New bucket → "garments" → Public)
-- RLS: allow anon inserts for enquiries
alter table enquiries enable row level security;
create policy "anon insert" on enquiries for insert to anon with check (true);
create policy "admin read" on enquiries for select to anon using (true);
-- RLS: allow anon reads for garments
alter table garments enable row level security;
create policy "public read" on garments for select using (true);
create policy "admin write" on garments for all using (true) with check (true);
