##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1-0-2_to_1-0-3.sql							#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2008-09-08															#
 # Updated:		2008-12-02															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2008 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.0.2 to 1.0.3														#
 #----------------------------------------------------------------------------------##

# Add Sender fields to `sites` table
ALTER TABLE `mm_admin`.`site`
  ADD COLUMN `email_sender` varchar(255) DEFAULT NULL AFTER `email_name`,
  ADD COLUMN `email_usender` varchar(255) DEFAULT NULL AFTER `email_sender`;

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