-- Add composite index for customer warranty lookups (customer profile screen).
-- Without this index, queries filtering by customer_id on a large warranties table
-- would require a full table scan.
-- Pattern: 45_add_indexes_for_hot_queries.sql
ALTER TABLE `warranties` ADD KEY `idx_customer` (`customer_id`, `created_at`);
