SQL de Configuration Base de Données

Copiez et exécutez dans Supabase → SQL Editor pour créer toutes les tables et politiques.

-- ═══════════════════════════════════════════
-- Z BRANDER — Supabase Full Setup v2
-- Run in: Supabase > SQL Editor
-- ═══════════════════════════════════════════

-- TABLE: leads
CREATE TABLE IF NOT EXISTS leads (
  id         UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  name       TEXT NOT NULL,
  email      TEXT NOT NULL,
  phone      TEXT,
  message    TEXT,
  service    TEXT,
  budget     TEXT,
  plan       TEXT,
  currency   TEXT DEFAULT 'EUR',
  status     TEXT DEFAULT 'new',
  source     TEXT DEFAULT 'website',
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- TABLE: lead_notes
CREATE TABLE IF NOT EXISTS lead_notes (
  id         UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  lead_id    UUID REFERENCES leads(id) ON DELETE CASCADE,
  content    TEXT NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- TABLE: projects
CREATE TABLE IF NOT EXISTS projects (
  id             UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  client_name    TEXT NOT NULL,
  client_email   TEXT,
  service        TEXT,
  status         TEXT DEFAULT 'pending',
  budget         DECIMAL(10,2),
  total_price    DECIMAL(10,2),
  deposit_paid   DECIMAL(10,2) DEFAULT 0,
  currency       TEXT DEFAULT 'EUR',
  deadline       DATE,
  notes          TEXT,
  created_at     TIMESTAMPTZ DEFAULT NOW(),
  updated_at     TIMESTAMPTZ DEFAULT NOW()
);

-- TABLE: site_config (CMS persistence)
CREATE TABLE IF NOT EXISTS site_config (
  id         UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  data       JSONB NOT NULL DEFAULT '{}',
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

-- Enable RLS
ALTER TABLE leads       ENABLE ROW LEVEL SECURITY;
ALTER TABLE lead_notes  ENABLE ROW LEVEL SECURITY;
ALTER TABLE projects    ENABLE ROW LEVEL SECURITY;
ALTER TABLE site_config ENABLE ROW LEVEL SECURITY;

-- Policies: leads
CREATE POLICY "public_insert_leads" ON leads FOR INSERT TO anon WITH CHECK (true);
CREATE POLICY "admin_select_leads"  ON leads FOR SELECT TO authenticated USING (true);
CREATE POLICY "admin_update_leads"  ON leads FOR UPDATE TO authenticated USING (true);
CREATE POLICY "admin_delete_leads"  ON leads FOR DELETE TO authenticated USING (true);

-- Policies: lead_notes
CREATE POLICY "admin_all_lead_notes" ON lead_notes FOR ALL TO authenticated USING (true);

-- Policies: projects
CREATE POLICY "admin_all_projects" ON projects FOR ALL TO authenticated USING (true);

-- Policies: site_config
CREATE POLICY "public_read_config"  ON site_config FOR SELECT USING (true);
CREATE POLICY "admin_write_config"  ON site_config FOR ALL TO authenticated USING (true);

-- Insert default site_config row
INSERT INTO site_config (data) VALUES ('{}') ON CONFLICT DO NOTHING;

-- Supabase Storage bucket (run separately in Storage > New Bucket):
-- Name: zbrander-media | Public: true