ALTER TABLE `mn_Member` CHANGE `alternate_status_changed` `mncar_l_status_changed` DATETIME NULL DEFAULT NULL ;

ALTER TABLE `mn_Member` ADD `mncar_status_joined` DATETIME NULL AFTER `mncar_status_changed` ;
ALTER TABLE `mn_Member` ADD `mncar_l_status_joined` DATETIME NULL AFTER `mncar_l_status_changed` ;
ALTER TABLE `mn_Member` ADD `misc_status_joined` DATETIME NULL AFTER `misc_status_changed` ;


CREATE TABLE `mn_StatusHistory` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`memberId` INT NOT NULL ,
`oldDateJoined` DATETIME NOT NULL ,
`newDateJoined` DATETIME NOT NULL ,
`accountType` ENUM( 'mncar', 'mncar_l', 'misc' ) NOT NULL ,
`oldTypeId` INT( 255 ) UNSIGNED NOT NULL ,
`newTypeId` INT UNSIGNED NOT NULL ,
`oldStatusId` INT UNSIGNED NOT NULL ,
`newStatusId` INT UNSIGNED NOT NULL ,
`added` DATETIME NOT NULL
) ENGINE = MYISAM ;

ALTER TABLE `mn_StatusHistory` CHANGE `oldDateJoined` `oldDateJoined` DATETIME NULL DEFAULT '0000-00-00 00:00:00' ;
ALTER TABLE `mn_StatusHistory` CHANGE `newDateJoined` `newDateJoined` DATETIME NULL DEFAULT '0000-00-00 00:00:00' ;

ALTER TABLE `mn_StatusHistory` ADD INDEX `memberIdAdded` ( `memberId` , `added` ) ;