#!/bin/bash
DBNAME=`basename $1 .sql.gz`
rm -f $DBNAME.sql
gunzip $DBNAME.sql.gz

echo "use $1" > tmp_table_update.sql


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

rm systools_actual_table_data.sql
for db_table in access_code bill_config clients config dept_printer_config ecr functions external_programs payment_types places print_servers printer_messages printer_model printer_ports printer_types printers waiters table_icons 
do
     mysqldump -c -t -u euro3g -peuro3g $1 $db_table >> systools_actual_table_data.sql
		  
done 
   
for db_table in access_code bill_config clients config delim_grid dept_printer_config ecr functions external_programs payment_types places print_servers printer_messages printer_model printer_ports printer_types printers waiters table_grid table_icons user_keys
do

    echo "#" >> tmp_table_update.sql
    echo "### Update table $db_table" >> tmp_table_update.sql
    echo "#" >> tmp_table_update.sql
    echo "delete from $db_table;" >> tmp_table_update.sql
    cat $DBNAME.sql | grep "INSERT INTO \`*$db_table\`* " >> tmp_table_update.sql
    cat systools_actual_table_data.sql | grep "INSERT INTO \`*$db_table\`* " >> tmp_table_update.sql

done
rm $DBNAME.sql.tmp
cat tmp_table_update.sql | patch_sql | mysql -f -u euro3g -peuro3g $1
rm tmp_table_update.sql
rm systools_actual_table_data.sql


