##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1.1.9.10.sql									#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2009-09-13															#
 # Updated:		2009-09-13															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2009 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.1.9.9 to 1.1.9.10													#
 #----------------------------------------------------------------------------------##

# Create the core shared volatile memory table `share`
CREATE TABLE `mm_admin`.`share` (
  `name` VARCHAR(255) NOT NULL COMMENT 'Unique shared memory key.',
  `value` VARCHAR(20000) NOT NULL DEFAULT '' COMMENT 'Shared memory value.',
  PRIMARY KEY(`name`)
)
ENGINE = InnoDB
CHARACTER SET utf8
COMMENT = 'InnoDB, row locking, shared memory and semaphore table.';

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