ALTER TABLE `mn_Member` CHANGE `profile_update` `profile_update_year` INT( 11 ) NULL DEFAULT NULL;
ALTER TABLE `mn_Member` ADD `profile_update` DATETIME NULL AFTER `img` ;

UPDATE `mn_Member`
SET `profile_update` = CONCAT(`profile_update_year`, '-01-01 00:00:00')
WHERE `profile_update_year` IS NOT NULL
AND `profile_update_year` > 0;

UPDATE `mn_Member` SET profile_update  = NULL WHERE profile_update > NOW();

ALTER TABLE `mn_Member` DROP `profile_update_year`;

INSERT INTO `mn_zz_Settings` (`cat`, `name`, `label`, `value`, `type`, `options`, `sorter`, `added`, `changed`) VALUES
('settings', 'profile_how_used', 'Profile. How is this information used?', 'This information is used to populate your online profile and to help MNCAR staff understand the makeup of its membership. Sensitive information such as home address and birth date are not shared with the public.', 'html_editor', 'Basic', 890, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
