##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1.2.5.sql									#
 # Author:		Matthew Wright	(matt@soundminer.com)								#
 # Created:		2011-02-13															#
 # Compat:		MySQL 5.x															#
 # Copyright:	Copyright Soundminer Inc.											#
 # Purpose:		Upgrade the installed MusicMiner player and fix bugs.				#
 # Version:		1.2.5																#
 #----------------------------------------------------------------------------------#

# ********** Adds new player types. **********

use `mm_admin`;


ALTER TABLE `mm_admin`.`site` MODIFY COLUMN `player` ENUM('waveformPlayer', 'flash','quicktime','universal','qtSimple','flowPlayer','flashMp3Player','xspfPlayerSlim','originalSingle','jwPlayer') NOT NULL DEFAULT 'quicktime' COMMENT 'The embedded media player to use for audition playback.';
ALTER TABLE `mm_admin`.`users` MODIFY COLUMN `player` ENUM('waveformPlayer', 'flash','quicktime','universal','qtSimple','flowPlayer','flashMp3Player','xspfPlayerSlim','originalSingle','jwPlayer') NOT NULL DEFAULT 'quicktime' COMMENT 'The embedded media player to use for audition playback per user.';

CREATE TABLE `quick_search_options` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `search_criteria` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;