Accès administrateur

-- Table partenaires CREATE TABLE IF NOT EXISTS partners ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, name text NOT NULL, contact text, email text UNIQUE, phone text, zones text, calendly text, meet_link text, status text DEFAULT 'active', notes text, created_at timestamptz DEFAULT now() ); -- Table rendez-vous CREATE TABLE IF NOT EXISTS appointments ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, partner_id uuid REFERENCES partners(id), first_name text NOT NULL, last_name text NOT NULL, phone text, email text, cp text, city text, appt_date date, appt_time time, type text, budget text, timing text, progress text, spouse text, source text, status text DEFAULT 'new', notes text, link text, position text, created_at timestamptz DEFAULT now() ); -- Table liaison auth <-> partenaire CREATE TABLE IF NOT EXISTS partner_users ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, user_id uuid REFERENCES auth.users(id) ON DELETE CASCADE, partner_id uuid REFERENCES partners(id) ON DELETE CASCADE, created_at timestamptz DEFAULT now(), UNIQUE(user_id) ); -- RLS ALTER TABLE partners ENABLE ROW LEVEL SECURITY; ALTER TABLE appointments ENABLE ROW LEVEL SECURITY; ALTER TABLE partner_users ENABLE ROW LEVEL SECURITY; CREATE POLICY "admin_all" ON partners FOR ALL USING (true); CREATE POLICY "admin_all" ON appointments FOR ALL USING (true); CREATE POLICY "admin_all" ON partner_users FOR ALL USING (true);