#!/bin/bash

echo "🔧 Cleaning Phase 12 (single-tenant mode)..."

# Find Phase 12 files safely
FILES=$(grep -rl "school_id" app/Models/Communication app/Services/Communication app/Listeners/CEE database/migrations 2>/dev/null)

for file in $FILES; do
  echo "Fixing: $file"

  # remove full column lines in migrations
  sed -i '/school_id/d' "$file"

  # remove array-style usage safely
  sed -i 's/\"school_id\"[^,]*,//g' "$file"
  sed -i 's/school_id[^,)]*,//g' "$file"

done

echo "✅ Done. Phase 12 is now single-tenant safe."