#!/bin/bash

DB="growthdeskuser_wa_username_wa2"
USER="growthdeskuser_wa_username_esusr"

echo "Enter MySQL password:"
read -s PASSWORD

echo ""
echo "Fetching tables with 'id' column..."

# Get all tables with an 'id' column
TABLES=$(mysql -u "$USER" -p"$PASSWORD" -N -e "
    SELECT table_name 
    FROM information_schema.columns
    WHERE table_schema = '$DB'
    AND column_name = 'id';
")

if [ -z "$TABLES" ]; then
    echo "No tables with 'id' column found."
    exit 1
fi

echo "Running ALTER TABLE on each table..."
echo ""

SUCCESS=0
FAILED=0

for TABLE in $TABLES; do
    echo -n "  Altering $TABLE ... "
    
    RESULT=$(mysql -u "$USER" -p"$PASSWORD" "$DB" -e "
        ALTER TABLE \`$TABLE\` MODIFY \`id\` INT NOT NULL AUTO_INCREMENT PRIMARY KEY;
    " 2>&1)
    
    if [ $? -eq 0 ]; then
        echo "✓ Done"
        ((SUCCESS++))
    else
        echo "✗ Failed: $RESULT"
        ((FAILED++))
    fi
done

echo ""
echo "=============================="
echo "  Done! Success: $SUCCESS | Failed: $FAILED"
echo "=============================="