-- Add is_hot column to products table
ALTER TABLE public.products ADD COLUMN is_hot boolean NOT NULL DEFAULT false;

-- Add comment to explain the column
COMMENT ON COLUMN public.products.is_hot IS 'Indicates if the product is marked as hot/trending';