表结构如下,如果是你们想要的,记得给个好评哟,不过不是你们想要的结构,不推荐你们下载哟,喜欢就给个好评把。
CREATE TABLE `city_table` (
`id` int(5) NOT NULL COMMENT '主键',
`name` varchar(16) DEFAULT NULL COMMENT '名称',
`parent_id` int(8) DEFAULT NULL,
`initial` varchar(16) DEFAULT NULL,
`initials` varchar(16) DEFAULT NULL,
`pinyin` varchar(16) DEFAULT NULL,
`extra` varchar(32) DEFAULT NULL,
`code` varchar(16) DEFAULT NULL,
`area_code` varchar(12) DEFAULT NULL,
`order_tb` varchar(8) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `city_table` */
insert into `city_table`(`id`,`name`,`parent_id`,`initial`,`initials`,`pinyin`,`extra`,`code`,`area_code`,`order_tb`) values
(1,'北京市',0,'0','bj','beijing',NULL,'110000','010','1'),
(2,'天津市',0,'0','tj','tianjin',NULL,'120000','022','2'),
(3,'上海市',0,'0','sh','shanghai',NULL,'310000','021','3'),
(4,'重庆市',0,'0','cq','chongqing',NULL,'500000','023','4'),
(5,'河北省',0,'0','hb','hebei',NULL,'130000',NULL,'5'),
(6,'山西省',0,'0','sx','shanxi',NULL,'140000',NULL,'6'),
1