Statistiques Globales

CREATE POLICY "places_update_admin" ON places FOR UPDATE USING (true);
CREATE POLICY "places_delete_admin" ON places FOR DELETE USING (true);

CREATE TABLE IF NOT EXISTS reports (
  id           uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  content_type text, content_id text, content_text text,
  reason       text, detail text,
  ai_verdict   text, ai_severity text,
  session_id   text, created_at timestamptz DEFAULT now(),
  resolved     boolean DEFAULT false
);
ALTER TABLE reports ENABLE ROW LEVEL SECURITY;
CREATE POLICY "reports_insert" ON reports FOR INSERT WITH CHECK (true);
CREATE POLICY "reports_read"   ON reports FOR SELECT USING (true);