Database Migrations in Prisma

# Create a new migration
npx prisma migrate dev --name add_user_table

# Apply migrations in production
npx prisma migrate deploy

# Create migration without applying (preview)
npx prisma migrate dev --create-only

# Reset database (removes all data!)
npx prisma migrate reset

# Check migration status
npx prisma migrate status

# Resolve failed migrations
npx prisma migrate resolve --applied "20231201123456_migration_name"

// BASH_BLOCK:
# Development workflow
npx prisma migrate dev    # Create and apply migration
npx prisma generate        # Regenerate Prisma Client
npx prisma studio          # Open GUI to view/edit data

# Production deployment
npx prisma migrate deploy  # Apply pending migrations
npx prisma generate        # Generate Prisma Client

# Migration management
npx prisma migrate diff \
  --from-schema-datamodel prisma/schema.prisma \
  --to-schema-datasource prisma/schema.prisma \
  --script > migration.sql