#!/bin/bash
DBNAME=`basename $1 .sql.gz`

function patch_sql
{
  systools/patch_sql
#sed 's/TYPE=MyISAM/ENGINE=MyISAM/g; s/timestamp([0-9]*)/timestamp/g'
}

rm -f $DBNAME.sql
gunzip $DBNAME.sql.gz
if [ $2"." == "." ]
then
  cat $DBNAME.sql | fgrep -v "INSERT INTO" | mysql -f -u euro3g -peuro3g $1
else
  echo "use $1" > tmp_table_update.sql
  echo "drop table $2;" >> tmp_table_update.sql
  FILELINES=`wc -l $DBNAME.sql | awk '{ print $1 }'` 
  CREATELINE=`grep -n "CREATE TABLE \`*$2\`*" $DBNAME.sql | awk -F: '{ print $1 }'`
  tail -$(( $FILELINES-$CREATELINE+1 )) $DBNAME.sql > $DBNAME.sql.tmp
  head -`grep -En "\) (TYPE|ENGINE)=" $DBNAME.sql.tmp | head -1 | awk -F: '{ print $1 }'` $DBNAME.sql.tmp >> tmp_table_update.sql
  cat tmp_table_update.sql | patch_sql | mysql -f -u euro3g -peuro3g $1
fi


