Create Database Migration

When To Use

Use this skill when designing schemas, creating new Eloquent model backing tables, adding indexes, or modifying existing database columns.

Workflow

1. Verify conventions: Inspect nearby migration files to ensure naming compatibility.
2. Scaffold migration: Run php artisan make:migration create_xxx_table.
3. Define constraints: Declare explicit relationships, types, indexes, and unique attributes.
4. Define down operation: Ensure the migration is reversible (implement down() properly dropping added columns or tables).
5. Dry run checks: Run local migrations and rollbacks to verify structural success.

Examples

Good Example