#!/bin/bash

for i in 1 2 3 4 5 6 7 8 9 10; do
        msql -e "DROP TABLE IF EXISTS test$i;"
done

for i in 1 2 3 4 5 6 7 8 9 10; do
        echo testing $i
        msql -e "DROP TABLE IF EXISTS templatetable;"&
        msql -e "CREATE TABLE templatetable( DIM SMALLINT,LEVEL SMALLINT,NAME VARCHAR(255),PARENT_DIM SMALLINT,PARENT_LEVEL SMALLINT,OPTIONS VARCHAR(255) );" &
        msql -e "CREATE TABLE test$i AS SELECT * FROM templatetable;" &
done