-- tc_users: Kein Passwort gespeichert! Auth läuft über die Datenbank. create table tc_users ( email text primary key, name text, company text, initial text, role text default 'kunde', paket text, betreuer text, leads int default 0, termine int default 0, bewerber int default 0, dokumente jsonb default '[]'::jsonb, created_at timestamptz default now() ); create table tc_leads ( id uuid primary key default gen_random_uuid(), customer_email text, name text, company text, branche text, quelle text, phase text, score int, notiz text, scheduled_date date, created_at timestamptz default now() ); create table tc_bewerber ( id uuid primary key default gen_random_uuid(), customer_email text, name text, rolle text, telefon text, email text, verfuegbarkeit text, gehalt text, status text, kompetenzen text, notizen text, scheduled_date date, created_at timestamptz default now() ); create table tc_berichte ( customer_email text primary key, report_data jsonb, updated_at timestamptz default now() ); create table tc_termine ( id uuid primary key default gen_random_uuid(), customer_email text, title text, datum text, uhrzeit text, status text, created_at timestamptz default now() ); -- Row Level Security deaktivieren für einfaches Setup: alter table tc_users enable row level security; alter table tc_leads enable row level security; alter table tc_bewerber enable row level security; alter table tc_berichte enable row level security; alter table tc_termine enable row level security; create policy "public_access" on tc_users for all using (true) with check (true); create policy "public_access" on tc_leads for all using (true) with check (true); create policy "public_access" on tc_bewerber for all using (true) with check (true); create policy "public_access" on tc_berichte for all using (true) with check (true); create policy "public_access" on tc_termine for all using (true) with check (true); create table tc_chat ( id uuid primary key default gen_random_uuid(), customer_email text, sender_role text, sender_name text, text text, created_at timestamptz default now() ); alter table tc_chat enable row level security; create policy "public_access" on tc_chat for all using (true) with check (true); create table tc_ziele ( customer_email text primary key, ziel_data jsonb, updated_at timestamptz default now() ); alter table tc_ziele enable row level security; create policy "public_access" on tc_ziele for all using (true) with check (true); create table if not exists tc_config ( key text primary key, value text, updated_at timestamptz default now() ); alter table tc_config enable row level security; create policy "public_access" on tc_config for all using (true) with check (true); alter publication supabase_realtime add table tc_leads; alter publication supabase_realtime add table tc_bewerber; alter publication supabase_realtime add table tc_berichte; alter publication supabase_realtime add table tc_termine; alter publication supabase_realtime add table tc_ziele; create table if not exists tc_leistungen ( customer_email text not null, service_id text not null, status text not null default 'offen', menge_done integer not null default 0, menge_total integer, notiz text default '', updated_at timestamptz default now(), updated_by text default '', primary key (customer_email, service_id) ); alter table tc_leistungen enable row level security; create policy "public_access" on tc_leistungen for all using (true) with check (true); alter publication supabase_realtime add table tc_leistungen; create table if not exists tc_svc_states ( customer_email text primary key, state_data jsonb not null default '{}', updated_at timestamptz default now(), updated_by text default '' ); alter table tc_svc_states enable row level security; create policy "public_access" on tc_svc_states for all using (true) with check (true); alter publication supabase_realtime add table tc_svc_states; alter publication supabase_realtime add table tc_chat; -- tc_mitarbeiter: Dynamisch angelegte Mitarbeiter (Anzeige-Daten, KEIN Klartext-PW) create table if not exists tc_mitarbeiter ( email text primary key, name text, position text, dept text, role text default 'admin', custom_permissions jsonb default '[]'::jsonb, angelegt text, angelegt_von text, updated_at timestamptz default now() ); alter table tc_mitarbeiter enable row level security; create policy "public_access" on tc_mitarbeiter for all using (true) with check (true); -- tc_ma_login: Login-Daten für dynamische Mitarbeiter (PBKDF2-gehashte PWs) create table if not exists tc_ma_login ( email text primary key, pwh text not null, name text, role text, paket text, updated_at timestamptz default now() ); alter table tc_ma_login enable row level security; create policy "public_access" on tc_ma_login for all using (true) with check (true); -- tc_aufgaben: Aufgaben pro Kunde, mit Zuweisung & Fälligkeit create table if not exists tc_aufgaben ( id uuid primary key default gen_random_uuid(), titel text not null, beschreibung text, customer_email text, assigned_to text, prioritaet text default 'normal', status text default 'offen', faelligkeit date, completed_at timestamptz, created_by text, created_at timestamptz default now(), updated_at timestamptz default now() ); alter table tc_aufgaben enable row level security; create policy "public_access" on tc_aufgaben for all using (true) with check (true); alter publication supabase_realtime add table tc_aufgaben; -- Erweiterung tc_users für vollständigen Kunden-Sync zwischen allen Admins/Geräten alter table tc_users add column if not exists vertragsbeginn text; alter table tc_users add column if not exists leistungsbereiche jsonb default '[]'::jsonb; alter table tc_users add column if not exists leistungs_details jsonb default '{}'::jsonb; alter table tc_users add column if not exists vorort_termin text; alter table tc_users add column if not exists rechnungen jsonb default '[]'::jsonb; alter publication supabase_realtime add table tc_users;