##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1.1.9.sql									#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2009-03-07															#
 # Updated:		2009-03-11															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2009 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.1.8.1 to 1.1.9													#
 #----------------------------------------------------------------------------------##

# Add `help_url` to the `site` table for new Help URL feature
ALTER TABLE `mm_admin`.`site`
 ADD COLUMN `help_url` TEXT NOT NULL COMMENT 'URL to client supplied help page.' AFTER `reset_sort`,
 ADD COLUMN `home_skip` BOOL NOT NULL DEFAULT 0 COMMENT 'Skip Home Screen on login.' AFTER `home_url`;

# Update version fields
UPDATE `mm_admin`.`schema` SET `db_ver` = '1.1.9';