#!/bin/sh
API_DB_NAME=data_center

export THIS_DIR="$(cd "$( dirname "$0" )" && pwd )"
. $THIS_DIR/../../sysbase/tools/export_php_config_to_shell.sh

#create database
echo "create database IF NOT EXISTS $API_DB_NAME" | mysql -f -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD 2> /dev/null

#create table
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/create_tables.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ACL_GROUP_LIST_initial_data.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ACL_GROUP_PRIVILEGE_LIST_initial_data.sql" 2> /dev/null

#alter table
/usr/bin/php $THIS_DIR/mysql/alter_tables.php

sh "$THIS_DIR/make_symbolic_link.sh"