CREATE TABLE `towns` (
  `code` varchar(12) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `pid` varchar(12) DEFAULT NULL,
  `type` enum('province','city','district','town') DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8