RENAME TABLE `mn_DVolunteer` TO `mn_Volunteer` ;

ALTER TABLE `mn_Volunteer` ADD `type` ENUM( 'committee', 'taskforce', 'board' ) NOT NULL DEFAULT 'committee' AFTER `title` ;

ALTER TABLE `mn_Volunteer` ADD `added` DATETIME NOT NULL AFTER `sorter` ,
ADD `changed` DATETIME NOT NULL AFTER `added` ;

ALTER TABLE `mn_Volunteer` ADD `mission` TEXT NOT NULL AFTER `type` ;

CREATE TABLE `mn_VolunteerGoal` (
`id_volunteer` INT UNSIGNED NOT NULL ,
`goal` VARCHAR( 255 ) NOT NULL ,
`sorter` INT NOT NULL ,
`added` DATETIME NOT NULL
) ENGINE = MYISAM ;

ALTER TABLE `mn_Member2Volunteer` ADD `type` ENUM( 'chairs', 'staff-liaison', 'president', 'past-president', 'treasurer', 'director', 'member' ) NOT NULL DEFAULT 'member',
ADD `added` DATETIME NOT NULL ,
ADD `changed` DATETIME NOT NULL;

ALTER TABLE  `mn_Volunteer` CHANGE  `sorter`  `sorter` INT( 11 ) NULL DEFAULT NULL;


ALTER TABLE `mn_Member`
  DROP `id_member`,
  DROP `id_member_type`,
  DROP `id_status`;


INSERT INTO  `mn_zz_DocItemType` (
`name` ,
`title`
)
VALUES (
'Volunteer/Show',  'Volunteer'
);