##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_0-7-4_to_0-7-5.sql							#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2007-08-31															#
 # Updated:		2007-08-31															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2007 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		0.7.4 to 0.7.5														#
 #----------------------------------------------------------------------------------##

# Add `hash` field to `site` table to accommodate temporary `home_categories` setting and future settings
ALTER TABLE `mm_admin`.`site` ADD COLUMN `hash` TEXT NOT NULL COMMENT 'Miscellaneous settings stored in a free-form JSON hash.' AFTER `zip_downloads`;
UPDATE `mm_admin`.`site` SET `hash` = '{\"home_categories\":0}';

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