Database Migration

Create a database migration for the following change:

## Change
[Describe what needs to change in the database schema]

## Requirements
- Migration must be reversible (include rollback)
- Preserve existing data
- Handle the case where the table/column already exists
- Add appropriate indexes for query performance

## Context
- Current schema relevant parts: [describe or point to schema file]
- Expected data volume: [approximate rows]