Pour activer les notifications persistantes, exécutez cette migration dans l'éditeur SQL Supabase :

CREATE TABLE IF NOT EXISTS notifications (
  id          uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  created_at  timestamptz NOT NULL DEFAULT now(),
  expires_at  timestamptz NOT NULL DEFAULT (now() + interval '7 days'),
  filiale     text NOT NULL CHECK (filiale IN ('transport','btp','immobilier','oasis','cafe_oryx','global')),
  priority    text NOT NULL DEFAULT '1_info' CHECK (priority IN ('1_info','2_warning','3_critical')),
  title       text NOT NULL,
  body        text,
  icon        text DEFAULT 'bell',
  read_by     jsonb NOT NULL DEFAULT '{}',
  wa_sent     boolean NOT NULL DEFAULT false,
  source_table text,
  source_id   uuid
);
CREATE INDEX IF NOT EXISTS idx_notif_filiale   ON notifications(filiale);
CREATE INDEX IF NOT EXISTS idx_notif_priority  ON notifications(priority);
CREATE INDEX IF NOT EXISTS idx_notif_created   ON notifications(created_at DESC);
ALTER TABLE notifications ENABLE ROW LEVEL SECURITY;
CREATE POLICY "all_authenticated" ON notifications FOR ALL USING (auth.role() = 'authenticated');

Configurez quels événements génèrent des notifications automatiques. Ces règles s'appliquent côté client (notifications locales) en attendant la migration Supabase.