-- Add category_id to products table
alter table products 
add column if not exists category_id uuid references categories(id) on delete set null;

-- Optional: Create an index for better performance
create index if not exists idx_products_category_id on products(category_id);
