##----------------------------------------------------------------------------------#
 # MusicMiner Web Server															#
 # Name:		source/app/sql/upgrade_1.2.3.1.sql									#
 # Author:		Jesse J Morrow	(jesse@jessejmorrow.com)							#
 # Created:		2010-05-12															#
 # Updated:		2010-05-18															#
 # Compat:		MySQL 5																#
 # Copyright:	Copyright 2010 Soundminer Inc.										#
 # Purpose:		Upgrade the installed MusicMiner databases.							#
 # Version:		1.2.3 to 1.2.3.1													#
 #----------------------------------------------------------------------------------##

TRUNCATE TABLE `mm_admin`.`onepages`;

ALTER TABLE `mm_admin`.`onepages` ADD COLUMN `created` DATETIME NOT NULL COMMENT 'Timestamp of the original creation of row.' AFTER `expires`,
 ADD COLUMN `updated` DATETIME NOT NULL COMMENT 'Timestamp of the last modification of row.' AFTER `created`;

UPDATE `mm_admin`.`onepages` SET `created` = NOW(), `updated` = NOW();

#-----------------------------------------------------------------------------
# Versions
#-----------------------------------------------------------------------------

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