# Database Migration Guide

After updating the code, run these commands to create and apply the database migration:

```bash
# Build and start containers
docker compose up --build -d

# Create migration
docker compose exec backend uv run flask db migrate -m "Add YouTube audio support and download job tracking"

# Apply migration
docker compose exec backend uv run flask db upgrade

# Verify services are running
docker compose ps

# View logs
docker compose logs -f backend
docker compose logs -f celery-worker
```

## Services

- **Backend**: http://localhost:5001
- **Frontend**: http://localhost:3000
- **Celery Flower (monitoring)**: http://localhost:5555
- **Redis**: localhost:6379

## Troubleshooting

If migration fails:
```bash
# Check if database is accessible
docker compose exec backend ls -la backend/instance/

# Reset if needed (WARNING: destroys data)
docker compose down -v
docker compose up --build -d
docker compose exec backend uv run flask db init
docker compose exec backend uv run flask db migrate -m "Initial migration"
docker compose exec backend uv run flask db upgrade
```