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

-- Create index for better performance when querying recommended products
CREATE INDEX idx_products_is_recommended ON public.products(is_recommended) WHERE is_recommended = true;