create table if not exists jobs (id text primary key, job_data jsonb not null, version bigint default 1, updated_at timestamptz default now(), updated_by text);
create table if not exists leads (id text primary key, lead_data jsonb not null, version bigint default 1, updated_at timestamptz default now(), updated_by text);
create table if not exists users_tbl (id text primary key, user_data jsonb not null);
create table if not exists app_kv (key text primary key, value jsonb, updated_at timestamptz default now());
create table if not exists record_locks (record_id text primary key, locked_by_name text, locked_by_id text, expires_at timestamptz);
alter table jobs disable row level security;
alter table leads disable row level security;
alter table users_tbl disable row level security;
alter table app_kv disable row level security;
alter table record_locks disable row level security;
alter publication supabase_realtime add table jobs;
alter publication supabase_realtime add table leads;
