#! /bin/sh

DB=$1
DBH=/home/onyx/database/$1

cd $DBH

shift

for x
do
	echo "Loading sql $x"
	echo

	(	echo "drop table $x;"

		echo "create table $x ("
		sed 's/^[^_]*_//' < $x@ |
		gawk "-F	" '
		{	if (NR != 1) printf ",\n";
			
			if ($3 == "int") {
				printf "\t%s integer",$1;
				}
			else
			if ($3 == "calc") {
				printf "\t%s float",$1;
				}
			else
			printf "\t%s varchar(%s)",$1,$2;
			} '
		echo
		echo "	);"
	
#		echo "copy $x ("
#		sed 's/^[^_]*_//' < $x@ |
#		gawk "-F	" '
#		{	if (NR != 1) printf "tab,\n";
#			printf "\t%s is c0",$1;
#			} ' 
#		echo "nl"
#		echo "	)"
#		echo "from \"/home/ingres/tmp/$x.unload\""
#		echo
#		echo '\p\g'
#
#		echo -n "modify $x to isam "
#		sed 's/^[^_]*_//' < $x@ |
#		gawk "-F	" '
#		$4 == "p" {	if (HH != 1) printf "on ";
#				else	printf ", ";
#				HH = 1;
#				printf "%s",$1;
#				} ' 
#		echo
#		echo '\p\g'
#
#		sed 's/^[^_]*_//' < $x@ |
#		gawk "-F	" "
#		\$4 == \"s\" {	printf \"index on $x is %s %s\\n\",\$5,\$1;
#				} " 
#		echo
#		echo '\p\g'
#
#		echo 
#		echo "define permit all on $x to all"
#		echo '\p\g'
		) | sqlmon $DB

	echo "done."
done
