1-- +goose Up
 2-- +goose StatementBegin
 3-- Add indexes on created_at columns for better ORDER BY performance
 4CREATE INDEX IF NOT EXISTS idx_sessions_created_at ON sessions (created_at);
 5CREATE INDEX IF NOT EXISTS idx_messages_created_at ON messages (created_at);
 6CREATE INDEX IF NOT EXISTS idx_files_created_at ON files (created_at);
 7-- +goose StatementEnd
 8
 9-- +goose Down
10-- +goose StatementBegin
11DROP INDEX IF EXISTS idx_sessions_created_at;
12DROP INDEX IF EXISTS idx_messages_created_at;
13DROP INDEX IF EXISTS idx_files_created_at;
14-- +goose StatementEnd