##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_0-9-10_to_0-9-11.sql							#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2008-02-05															#
 # Updated:		2008-02-11															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2007 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		0.9.10 to 0.9.11													#
 #----------------------------------------------------------------------------------##

# Add indices to `cues` table to speed up complex SELECT's
ALTER TABLE `mm_admin`.`cues` ADD INDEX `cuesheet_index`(`cuesheet_id`),
 ADD INDEX `asset_index`(`asset_id`);

# Add indices to `tracks` table to speed up complex SELECT's
ALTER TABLE `mm_admin`.`tracks` ADD INDEX `folder_index`(`folder_id`),
 ADD INDEX `asset_index`(`asset_id`);

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