#!/bin/bash

echo "🔧 Fixing failed migration on production..."
echo ""
echo "Run these commands on your production server:"
echo ""
echo "# Navigate to API directory"
echo "cd /home/theinitiative/public_html/lenseekapi.zbeetech.com"
echo ""
echo "# Option 1: Mark the failed migration as rolled back"
echo "npx prisma migrate resolve --rolled-back 20250927191124_update_schedule_codes"
echo ""
echo "# Then use db push to sync the schema (safer for production)"
echo "npx prisma db push"
echo ""
echo "# Regenerate Prisma client"
echo "npx prisma generate"
echo ""
echo "# Restart PM2"
echo "pm2 restart lenseek-api"
echo ""
echo "---"
echo ""
echo "# Alternative Option 2: Mark as applied if changes are already in DB"
echo "npx prisma migrate resolve --applied 20250927191124_update_schedule_codes"
echo ""
echo "# Then deploy remaining migrations"
echo "npx prisma migrate deploy"
echo ""
echo "# Regenerate Prisma client"
echo "npx prisma generate"
echo ""
echo "# Restart PM2"
echo "pm2 restart lenseek-api"