##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/mlib/sql/shares.sql											#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2009-09-11															#
 # Updated:		2009-09-13															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2009 Soundminer Inc.										#
 # Purpose:		InnoDB, row locking, shared memory and semaphore table.				#
 #----------------------------------------------------------------------------------##

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.';