##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1.1.9.7.sql									#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2009-06-24															#
 # Updated:		2009-06-24															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2009 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.1.9.6 to 1.1.9.7													#
 #----------------------------------------------------------------------------------##

# Add <meta> tag customization fields to `site` table
ALTER TABLE `mm_admin`.`site` CHANGE COLUMN `name_site` `site_title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '<title></title>',
 ADD COLUMN `site_description` TEXT NOT NULL COMMENT '<meta name="description" content="" />' AFTER `site_title`,
 ADD COLUMN `site_keywords` TEXT NOT NULL COMMENT '<meta name="keywords" content="" />' AFTER `site_description`;

# Add default settings
UPDATE `mm_admin`.`site` SET
 `site_description` = 'Music and sound effects search engine based on Soundminer search technology.',
 `site_keywords` = 'search,music,sound effects,sfx,audio,wav,aif,aiff,mp3';

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