-- Migration 009: Add thumbnail_path to peripheral_photos
-- Date: 2025-12-31

-- Add thumbnail_path field (path to thumbnail image)
ALTER TABLE peripheral_photos ADD COLUMN thumbnail_path TEXT;

-- Thumbnails will be stored in uploads/peripherals/photos/{id}/thumbnail/
-- and generated automatically on upload