详细的数据看附件
CREATE TABLE `dic_province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(10) DEFAULT '' COMMENT 'code值',
`name` varchar(50) DEFAULT '' COMMENT '名称',
`pid` varchar(10) DEFAULT '' COMMENT '父级ID',
`num` int(10) unsigned DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='省';
CREATE TABLE `dic_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(10) DEFAULT '' COMMENT 'code值',
`name` varchar(50) DEFAULT '' COMMENT '名称',
`pid` varchar(10) DEFAULT '' COMMENT '父级ID',
`num` int(10) unsigned DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8 COMMENT='市';
CREATE TABLE `dic_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(10) DEFAULT '' COMMENT 'code值',
`name` varchar(50) DEFAULT '' COMMENT '名称',
`pid` varchar(10) DEFAULT '' COMMENT '父级ID',
`num` int(10) unsigned DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3135 DEFAULT CHARSET=utf8 COMMENT='区/县';
02-20
06-21
7万+