Migration Tab

Development Master: ✅ Up to date (v20240115_143022)
Testing: ⚠️ 2 pending migrations
Production: ✅ Up to date (v20240115_143022)

import type { Knex } from "knex";

export async function up(knex: Knex): Promise<void> {
  await knex.schema.alterTable("users", (table) => {
    table.string("phone", 20).nullable();
  });
}

export async function down(knex: Knex): Promise<void> {
  await knex.schema.alterTable("users", (table) => {
    table.dropColumn("phone");
  });
}

Development Master:
  ✓ 20240116_101530_add_user_phone (0.2s)

Testing:
  ✓ 20240116_101530_add_user_phone (0.2s)

All migrations applied successfully!

Rolling back last migration...

Development Master:
  ✓ Rollback 20240116_101530_add_user_phone

Rollback completed successfully!

📋 Migration: 20240116_101530_add_user_profile

Changes:
  ✅ Table: users
     + column: profile_image (string, nullable)
     + column: bio (text, nullable)
     + index: (email) unique

  ⚠️ Table: posts
     - column: deprecated_field
     ⚠️ Warning: Data in this column will be lost!

✅ 20240115_120000_create_users_table.ts
✅ 20240115_130000_create_posts_table.ts
📋 20240116_101530_add_user_phone.ts      ← Next to run
📋 20240116_102045_add_post_tags.ts

# Run in CLI
pnpm migrate clear  # Delete migration records
pnpm migrate status # Check current status

# ❌ Bad example: All changes at once
- Modify 10 Entities simultaneously
- Run migration once

# ✅ Good example: Break into small units
- Modify 1 Entity at a time
- Create and run migration
- Test, then proceed to next Entity

1. Test on Development DB
   ↓
2. Verify on Testing DB
   ↓
3. Backup data
   ↓
4. Apply to Production DB