-- Add photo_path column to guards_controls table
ALTER TABLE `guards_controls` 
ADD COLUMN `photo_path` VARCHAR(500) NULL AFTER `notes`;

-- Index for faster photo lookups
CREATE INDEX `idx_photo_path` ON `guards_controls`(`photo_path`);
