create table public.job_schedule (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references auth.users not null,
  project_id uuid references public.projects,
  customer_name text, job_type text default 'installation',
  job_date date not null, time_start time, time_end time,
  technician text, technician_id uuid, series_id uuid,
  recurrence jsonb, is_exception boolean default false,
  reminder_sent_at timestamptz,
  notes text, status text default 'scheduled',
  created_at timestamptz default now()
);
create table public.technicians (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references auth.users not null,
  name text not null, email text, phone text,
  color text default '#3b82f6', active boolean default true,
  created_at timestamptz default now()
);
alter table public.job_schedule enable row level security;
alter table public.technicians enable row level security;
create policy "own_jobs" on public.job_schedule
  for all using (auth.uid()=user_id) with check (auth.uid()=user_id);
create policy "own_techs" on public.technicians
  for all using (auth.uid()=user_id) with check (auth.uid()=user_id);