ALTER TABLE `suppliers`
MODIFY `id`
int(11),
  DROP PRIMARY KEY;