#!/bin/sh
API_DB_NAME=file_center

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

echo "create database IF NOT EXISTS $API_DB_NAME" | mysql -f -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD >/dev/null 2>&1
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

if [ ! -d /var/log/file_center/ ];then
    mkdir -p /var/log/file_center/
    chown apache:apache -R /var/log/file_center/
fi

if [ ! -d /file_center/ ];then
    mkdir -p /file_center/
    chown apache:apache -R /file_center/
fi

#強制清除pdfsign.pl執行過程會產生的暫存檔案，不清除可能導致web service無法正常運作
rm -rf /tmp/plaintext.pdf
rm -rf /tmp/signature.p1