-- Copiez ce script dans Supabase → SQL Editor → Run
create table if not exists engins      (id text primary key, nom text, type text, proprio text, ville text, cap text, prix numeric, statut text, gps boolean, emoji text, validated boolean, created_at timestamptz default now());
create table if not exists clients     (id text primary key, societe text, contact text, tel text, email text, secteur text, ville text, locations int default 0, total numeric default 0, statut text, created_at timestamptz default now());
create table if not exists contrats    (id text primary key, client text, "enginId" text, engin text, chantier text, debut text, fin text, montant numeric, statut text, created_at timestamptz default now());
create table if not exists demandes    (id text primary key, client text, engin text, chantier text, debut text, fin text, statut text, created_at timestamptz default now());
create table if not exists paiements   (id text primary key, "contratId" text, client text, montant numeric, date text, mode text, statut text, created_at timestamptz default now());
create table if not exists maintenance (id text primary key, "enginId" text, engin text, type text, description text, date text, cout numeric, statut text, created_at timestamptz default now());
create table if not exists partenaires (id text primary key, nom text, contact text, tel text, email text, ville text, engins int default 0, created_at timestamptz default now());
create table if not exists platform_params (id text primary key default 'main', nom text, email text, tel text, adresse text, commission numeric, "commPart" numeric, tva numeric, devise text, om text, mtn text, rib text, rccm text, nif text, site text);

-- Activer RLS (Row Level Security) — à configurer selon vos besoins
alter table engins      enable row level security;
alter table clients     enable row level security;
alter table contrats    enable row level security;
alter table demandes    enable row level security;
alter table paiements   enable row level security;
alter table maintenance enable row level security;
alter table partenaires enable row level security;
alter table platform_params enable row level security;

-- Politique lecture/écriture publique (mode démo — à restreindre en production)
create policy "public_all" on engins      for all using (true) with check (true);
create policy "public_all" on clients     for all using (true) with check (true);
create policy "public_all" on contrats    for all using (true) with check (true);
create policy "public_all" on demandes    for all using (true) with check (true);
create policy "public_all" on paiements   for all using (true) with check (true);
create policy "public_all" on maintenance for all using (true) with check (true);
create policy "public_all" on partenaires for all using (true) with check (true);
create policy "public_all" on platform_params for all using (true) with check (true);