CREATE TABLE `te_city_inf` (
  `tci_id` int(11) DEFAULT NULL COMMENT 'ID',
  `tci_code` varchar(6) NOT NULL COMMENT '编号',
  `tci_name` varchar(20) DEFAULT NULL COMMENT '城市名称',
  `tci_citycode` varchar(6) DEFAULT NULL COMMENT '上级编号',
  UNIQUE KEY `tci_code` (`tci_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全国城市表';