#!/usr/bin/env bash
# update_photodocs.sh
# A script file for OSCAR 15 that changes the contenttype
# of previously saved photoDocument documents from text/html
# to html/photoDocument. Use this script to make previously
# saved photoDocument files saved on OSCAR 12 viewable in
# OSCAR 15 with Firefox.
# This script may be run multiple times if necessary.
#
# Version 1.0
# Author: Zymbiotic Technologies Inc.
# https://www.zymbiotic.com
# January 27, 2017
#

echo When prompted, enter the OSCAR v15 database password.

echo Changing the type of all photo 'html' documents to type 'photoDocument'...

mysql -uroot -p -vvv -e "update document set contenttype = 'html/photoDocument' where doctype = 'photo' and contenttype = 'text/html' and docfilename like '%photoDocument%';" oscar_15

echo done.