Generate random data table with string and int PK

gen.sh

#!/bin/sh

echo " CREATE TABLE myTable ("
echo ' `address` varchar(255) default NULL,'
echo ' `city` varchar(50) default NULL,'
echo ' PRIMARY KEY (`address`)'
echo ' ) ENGINE=MyISAM;'

echo '';

rm sql_string.sql

for i in {1..5000}
do
        a="`pwgen 10` `pwgen 5` `pwgen 10`"
        b="`pwgen 8`"
        echo "step $i"
        echo "INSERT INTO \`myTable\` (\`address\`,\`city\`) VALUES ('$a','$b');" >> sql_string.sql
done

gen_int.sh

#!/bin/sh

echo ' CREATE TABLE myTableInt ('
echo '  `id` mediumint(8) unsigned NOT NULL auto_increment, '
echo '  `address` varchar(255) default NULL, '
echo '  `city` varchar(50) default NULL, '
echo '  PRIMARY KEY (`id`) '
echo ' ) ENGINE=MyISAM AUTO_INCREMENT=1; '

rm sql_int.sql

for i in {1..5000}
do
        a="`pwgen 10` `pwgen 5` `pwgen 10`"
        b="`pwgen 8`"
        echo "step $i";
        echo "INSERT INTO \`myTableInt\` (\`address\`,\`city\`) VALUES ('$a','$b');" >> sql_int.sql
done