-- Add billing_interval to products to support subscription and one-time products
-- Values: 'one_time', 'monthly', 'yearly'
ALTER TABLE public.products ADD COLUMN IF NOT EXISTS billing_interval TEXT DEFAULT 'monthly' NOT NULL
  CHECK (billing_interval IN ('one_time', 'monthly', 'yearly'));
