#!/bin/sh
# Copyright (c) 2000-2016 Synology Inc. All rights reserved.

SQLITE="/usr/syno/bin/sqlite3"
DB_NAME="synovpnplus.db"
PKG_DIR="/var/packages/VPNPlusServer"
PKG_TARGET_DIR="${PKG_DIR}/target"
PKG_USR_CONF_DIR="${PKG_DIR}/etc"
DB_SCHEMA_RELEASE="${PKG_TARGET_DIR}/etc/db/sqlite_schema-1.0.0-release.sql"
UPDATER="${PKG_TARGET_DIR}/scripts/updater.sh"
UPGRADE_FILE="/tmp/synovpnplus.upgrade"
OLD_VERSION=`get_key_value "${UPGRADE_FILE}" "old_version"`
NEW_VERSION=$SYNOPKG_PKGVER

is_db_existed()
{
	if [ -e "${PKG_USR_CONF_DIR}/db/${DB_NAME}" ]; then
		return 0
	fi

	return 1
}

# delete temp file
rm $UPGRADE_FILE

# exit if can't get old or new version
if [ -z "${OLD_VERSION}" ] || [ -z "${NEW_VERSION}" ]; then
	exit 1
fi

if ! is_db_existed; then
	# Create database
	${SQLITE} "${PKG_USR_CONF_DIR}/db/${DB_NAME}" < ${DB_SCHEMA_RELEASE}
fi

/bin/sh ${UPDATER} ${OLD_VERSION} ${NEW_VERSION}

exit 0
