#!/bin/bash
user="user"
pass="pass"
wdb="waad99"
server="localhost"   

deuxpath="Tables/clt_2.4" 
majpath="Mises_a_jour/Structure_DB/Update_SQL_CORE_Trunk"

echo "[Patching] Structure DB"
for i in $( ls $majpath/*.sql -C -1 );
 do
  echo "[Patching]" $i
  mysql -h $server --user=$user --password=$pass $wdb < $i
 done
echo "[Patching] Trunk Termine..."

echo "[Patching] Structure DB vers 2.4"
for i in $( ls $deuxpath/*.sql -C -1 );
 do
  echo "[Patching]" $i
  mysql -h $server --user=$user --password=$pass $wdb < $i
 done
echo "[Patching] 2.4 Termine..."