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

# Add `zip_downloads` column to `site` table
ALTER TABLE `mm_admin`.`site` ADD COLUMN `zip_downloads` ENUM('never','folders','multiple','always') NOT NULL DEFAULT 'multiple' COMMENT 'Zip up multiple track downloads into a single zip file.' AFTER `player`;

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