Migration Master

Workflow

1. Schema Planning

• Identify the necessary changes (New table, Add column, Drop index).
• Plan the Up (Apply) and Down (Rollback) operations.

2. Implementation

1. Migration File: Create a timestamped file in

   database/migrations/

   .
2. Definition: Use the Atlas schema builder to define tables and columns.
3. Seeding: (Optional) Implement seeders for initial or demo data.

3. Standards

• Always include Rollback logic.
• Ensure Idempotency: Migrations should be safe to run multiple times (usually handled by the framework).
• Document Breaking Changes.

Resources

• Assets: Skeleton migration file.
• References: Supported column types in SQLite vs MySQL.