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

ALTER TABLE `mm_admin`.`users` DROP COLUMN `name`,
   ADD COLUMN `state` ENUM('enabled','disabled','deleted') NOT NULL DEFAULT 'enabled' AFTER `type`;




ALTER TABLE `mm_admin`.`perms` ADD COLUMN `sort_tracks` LONGTEXT DEFAULT NULL AFTER `columns`,
   ADD COLUMN `sort_albums` LONGTEXT DEFAULT NULL AFTER `sort_tracks`;

UPDATE `mm_admin`.`schema` SET `db_ver` = '0.5.6', `mm_ver` = '0.5.6';
UPDATE `mm_cache`.`schema` SET `mm_ver` = '0.5.6';
UPDATE `mm_logs`.`schema` SET `mm_ver` = '0.5.6';