ALTER TABLE `contacts` CHANGE `custom_var6` `custom_var6` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; ALTER TABLE `alc_test`.`contacts` ADD INDEX ( `custom_var6` ) ;