#!/bin/sh

# createtables.sh - run sql to create database tables for Oracle

if [ -z "$1" -o -z "$2" -o $# -gt 3 ]; then
    echo '-------------------------------------------------'
    echo 'Create Fiper tables for Oracle'
    echo '-------------------------------------------------'
    echo 'usage: createtables username password [ dbName ]'
    echo '-------------------------------------------------'
    exit 1
fi

if [ $# -eq 3 ]; then
    sqlplus -L "$1/$2@$3" < createtables.sql > createtables.log
else
    sqlplus -L "$1/$2" < createtables.sql > createtables.log
fi
