-- Add product_code to products table
ALTER TABLE public.products ADD COLUMN IF NOT EXISTS product_code TEXT;

-- Create an index for faster lookups if needed (optional but good practice)
-- CREATE INDEX IF NOT EXISTS idx_products_product_code ON public.products(product_code);