-- Migration 010: Add USB manufacturer and product strings
-- Date: 2025-12-31
-- Description: Add iManufacturer and iProduct fields for USB device information

-- Add iManufacturer field (USB manufacturer string from lsusb)
ALTER TABLE peripherals ADD COLUMN iManufacturer TEXT;

-- Add iProduct field (USB product string from lsusb)
ALTER TABLE peripherals ADD COLUMN iProduct TEXT;

-- Create indexes for searching
CREATE INDEX IF NOT EXISTS idx_peripherals_imanufacturer ON peripherals(iManufacturer);
CREATE INDEX IF NOT EXISTS idx_peripherals_iproduct ON peripherals(iProduct);
