#!/bin/sh
# Copyright (c) 2000-2013 Synology Inc. All rights reserved.
VIDEO_METADATA_DB="video_metadata"

PSQL="/usr/bin/psql"
UPGRADE_DIR="/var/packages/MediaServer/target/scripts/sql/upgrade"

echo "Update video_file table where video id = 0 to test db existence"
su -l postgres -c "$PSQL $VIDEO_METADATA_DB -X -c \"update video_file set duration = 0 where id = 0\""
Ret=$?
if [ $Ret = 2 ]; then
	exit 0
fi

upgrades=`find $UPGRADE_DIR -name "*.sh" | sort`
for upgrade_script in $upgrades; do
	$upgrade_script
done