ALTER TABLE `apw_User` ADD `leadershipSorter` INT NULL DEFAULT NULL AFTER `recoverCodeExpirationDate` ,
ADD INDEX ( `leadershipSorter` );
ALTER TABLE `apw_User` DROP `showOnContact`;


ALTER TABLE  `apw_User` CHANGE  `title`  `title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
CHANGE  `company`  `company` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;