Database

-- Create profiles table
CREATE TABLE public.profiles (
  id TEXT PRIMARY KEY,
  name TEXT,
  email TEXT UNIQUE NOT NULL,
  customer_id TEXT UNIQUE,
  price_id TEXT,
  has_access BOOLEAN DEFAULT false,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Enable security
ALTER TABLE public.profiles ENABLE ROW LEVEL SECURITY;

-- Speed up lookups
CREATE INDEX idx_profiles_customer_id ON public.profiles(customer_id);
CREATE INDEX idx_profiles_email ON public.profiles(email);

-- Create leads table
CREATE TABLE public.leads (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Enable security
ALTER TABLE public.leads ENABLE ROW LEVEL SECURITY;

-- Speed up queries
CREATE INDEX idx_leads_email ON public.leads(email);
CREATE INDEX idx_leads_created_at ON public.leads(created_at DESC);

create table stripe_events (
  id text primary key,
  type text not null,
  created_at timestamptz default now()
);

-- Enable security
ALTER TABLE public.stripe_events ENABLE ROW LEVEL SECURITY;