🛵 Delivery Agents

Manage authorized delivery personnel email addresses for order dispatch notifications and app access.

⚠️ Action Required: Create 'delivery_agents' table in Supabase

The database table delivery_agents was not detected yet. Copy and run the SQL below in your Supabase SQL Editor to create it in 5 seconds:

CREATE TABLE IF NOT EXISTS public.delivery_agents (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  name text,
  email text NOT NULL UNIQUE,
  phone text,
  is_active boolean DEFAULT true NOT NULL,
  created_at timestamp with time zone DEFAULT timezone('utc'::text, now()) NOT NULL,
  updated_at timestamp with time zone DEFAULT timezone('utc'::text, now()) NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_delivery_agents_email ON public.delivery_agents (email);
ALTER TABLE public.delivery_agents ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Delivery agents accessible by service role" ON public.delivery_agents
  AS PERMISSIVE FOR ALL TO service_role USING (true) WITH CHECK (true);

Total Agents 0

👥

Active Agents 0

✅

Inactive 0

⏸️

➕ Add Delivery Agent

📋 Agent Roster (0)

🔍

Agent Details	Status	Added Date	Actions
Loading delivery agents...