ALTER TABLE `ports` DROP `ifHardType`;