create table bookings (
  id text primary key,
  status text default 'pending',
  name text, email text, phone text,
  address text, notes text, region text,
  service_id text, service_name text,
  rate numeric, hours numeric, cleaners int,
  date text, time text, addon_qty jsonb,
  base_clean numeric, addons_total numeric,
  total numeric, deposit numeric, remaining numeric,
  created_at timestamptz default now(),
  completed_at timestamptz
);
create table team_members (
  id text primary key,
  fname text, lname text,
  username text unique, email text,
  password_hash text, role text default 'member',
  active boolean default true,
  created_at timestamptz default now()
);
alter table bookings enable row level security;
alter table team_members enable row level security;
create policy "Allow all" on bookings for all using (true);
create policy "Allow all" on team_members for all using (true);