#!/bin/bash

DB_HOST='localhost'
DB_USER='root'
DB_PASS='password'
DB='default'

functionAlterTable(){
	read a b c <<< "${ROW}"
	echo "START QUERY: alter table $a modify $b char(36);"
	mysql -h $DB_HOST -u $DB_USER --password="$DB_PASS" $DB -e "alter table $a modify $b char(36);"
	echo "END QUERY: alter table $a modify $b char(36);"
	echo '-------------------';
}

mysql -h $DB_HOST -u $DB_USER --password="$DB_PASS" $DB -e "SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='$DB' AND COLUMN_TYPE='varchar(36)'" | while read RESULTS;
do
	CNT=${#RESULTS[@]}
	for ((i=0 ; i<${CNT}; i++))
	do
		ROW=${RESULTS[$i]}
		functionAlterTable
	done
done