##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1-1-1_to_1-1-2.sql							#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2008-10-27															#
 # Updated:		2008-12-02															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2008 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.1.1 to 1.1.2														#
 #----------------------------------------------------------------------------------##

# Add S3 columns to `proxies` table
ALTER TABLE `mm_admin`.`proxies` ADD COLUMN `type` ENUM('local','s3') NOT NULL DEFAULT 'local' COMMENT 'Type of protocol for file access.' AFTER `channel_layout`,
 ADD COLUMN `s3_host` varchar(255) AFTER `is_asset`,
 ADD COLUMN `s3_id` varchar(32) COMMENT 'S3 Access Key ID' AFTER `s3_host`,
 ADD COLUMN `s3_key` varchar(255) COMMENT 'S3 Secret Access Key' AFTER `s3_id`;

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