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;