migration_scriptCREATE INDEX idx_support_tickets_status ON support_tickets(status);
task_descriptionAdd an index on the "status" column of support_tickets to speed up filtering open tickets.
initial_schema_ddl
CREATE TABLE support_tickets ( id INTEGER PRIMARY KEY, subject TEXT NOT NULL, status TEXT NOT NULL );
verification_querySELECT name FROM pragma_index_list('support_tickets');
initial_fixture_data
INSERT INTO support_tickets (id, subject, status) VALUES (1, 'Login fails on mobile', 'open'), (2, 'Refund request', 'closed'), (3, 'Dashboard slow to load', 'open');
expected_verification_result
[
[
"idx_support_tickets_status"
]
]