Sign in

Get these from your Supabase project → Settings → API

Get your token from sparrowsms.com → Dashboard → API Token

Run this SQL in your Supabase SQL Editor to create the required tables:

-- Run this in Supabase SQL Editor

create table if not exists bookings (
  id uuid primary key default gen_random_uuid(),
  created_at timestamp with time zone default now(),
  client_name text not null,
  phone text,
  email text,
  address text,
  referred_by text,
  event_type text,
  event_date date,
  venue text,
  budget numeric,
  services text,
  notes text,
  status text default 'pending',
  sms_alert boolean default true,
  sms_sent boolean default false
);

create table if not exists events (
  id uuid primary key default gen_random_uuid(),
  created_at timestamp with time zone default now(),
  title text not null,
  category text default 'work',
  event_date date,
  event_time text,
  location text,
  client_name text,
  notes text,
  sms_alert boolean default true,
  sms_sent boolean default false
);

create table if not exists sms_log (
  id uuid primary key default gen_random_uuid(),
  sent_at timestamp with time zone default now(),
  phone text,
  message text,
  status text,
  reference_id text
);

Copy SQL