#!/bin/bash

DBUSER=sysmt
DBPWD=sysmt
DBNAME=sysmt

MYSQLCMD="/usr/local/mysql/bin/mysql -u $DBUSER --password=$DBPWD --database=$DBNAME"

echo "Creating tables ..."
${MYSQLCMD} < sysmt_mysql_tab.sql
echo "Creating procedure ..."
${MYSQLCMD} < sysmt_mysql_proc.sql
echo "Creating views ..."
${MYSQLCMD} < sysmt_mysql_view.sql
echo "Creating base data ..."
${MYSQLCMD} < sysmt_mysql_base.sql
