-- Lots table create table if not exists items ( id uuid default gen_random_uuid() primary key, name text not null, sku text, description text, image_data text, sizes jsonb default '[]'::jsonb, created_at timestamptz default now() ); -- Orders table create table if not exists orders ( id uuid default gen_random_uuid() primary key, ref text, cust_name text not null, phone text, address text, city text, pincode text, state text, courier text, item_id uuid references items(id), item_name text, sizes_ordered jsonb default '{}'::jsonb, total_qty integer default 0, order_date text, notes text, status text default 'pending', dispatch_date text, created_at timestamptz default now() ); -- Allow public read/write (family portal) alter table items enable row level security; alter table orders enable row level security; create policy "allow all" on items for all using (true) with check (true); create policy "allow all" on orders for all using (true) with check (true);