-- Copy this entire block and paste into Supabase SQL Editor create table if not exists customers ( id text primary key, first text not null, surname text not null, phone text, email text, notes text, created_at timestamptz default now() ); create table if not exists vehicles ( id text primary key, customer_id text references customers(id), plate text not null, model text, type text, colour text ); create table if not exists bookings ( id text primary key, cust_id text references customers(id), cust_name text, plate text, model text, veh_type text, colour text, date date, time text, pkg text, pkg_price numeric default 0, addons jsonb default '[]', discount_id text, discount_name text, discount_amt numeric default 0, loyalty_card text, notes text, status text default 'pending', total numeric default 0, is_addon_only boolean default false, created_at timestamptz default now() ); create table if not exists eod_reports ( id text primary key, date date unique not null, z_read_no integer, total_sales numeric default 0, credit_cards numeric default 0, cash numeric default 0, petty_expenses numeric default 0, cash_deposited numeric default 0, cash_balance numeric default 0, frees_vouchers numeric default 0, notes text, created_at timestamptz default now() ); -- Enable Row Level Security (open read/write for intranet use) alter table customers enable row level security; alter table vehicles enable row level security; alter table bookings enable row level security; alter table eod_reports enable row level security; create policy "allow all" on customers for all using (true) with check (true); create policy "allow all" on vehicles for all using (true) with check (true); create policy "allow all" on bookings for all using (true) with check (true); create policy "allow all" on eod_reports for all using (true) with check (true);