##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_0-8-2_to_0-8-3.sql							#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2007-10-12															#
 # Updated:		2007-10-12															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2007 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		0.8.2 to 0.8.3														#
 #----------------------------------------------------------------------------------##

# Add HTML customizaion fields to `site` table
ALTER TABLE `mm_admin`.`site` ADD COLUMN `html_header` TEXT NOT NULL COMMENT 'Global page header customization HTML.' AFTER `hash`,
 ADD COLUMN `html_footer` TEXT NOT NULL COMMENT 'Global page footer customization HTML.' AFTER `html_header`,
 ADD COLUMN `html_header_height` INT NOT NULL DEFAULT 0 COMMENT 'Pixel height of global page header.' AFTER `html_footer`,
 ADD COLUMN `html_footer_height` INT NOT NULL DEFAULT 0 COMMENT 'Pixel height of global page header.' AFTER `html_header_height`;

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