AgendAI — sua vida organizada, sem complicação

-- 1. ESTRUTURA MANAGERS (Atualizado)
create table if not exists managers (
  id bigint generated by default as identity primary key,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null,
  name text,
  establishment_name text,
  specialty text,
  city text,
  neighborhood text,
  username text,
  temp_password text,
  expiration_days int default 30,
  is_active boolean default true,
  secret_word text,
  photo_url text,
  contact_whatsapp text,
  address text,
  services jsonb default '[]'::jsonb,
  working_hours jsonb default '{}'::jsonb
);

-- 2. TABELA DE AGENDAMENTOS (Nova)
create table if not exists appointments (
  id bigint generated by default as identity primary key,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null,
  manager_id bigint references managers(id),
  client_name text,
  client_phone text,
  service_name text,
  service_price numeric,
  service_duration int,
  appointment_time timestamp with time zone,
  status text default 'pending', -- pending, confirmed, completed, cancelled
  notes text
);

create table if not exists config (key text primary key, value text);
create table if not exists leads (id bigint generated by default as identity primary key, created_at timestamp with time zone default timezone('utc'::text, now()) not null, email text);

-- 3. PERMISSÕES
alter table managers disable row level security;
alter table config disable row level security;
alter table leads disable row level security;
alter table appointments disable row level security;