/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50542
Source Host : localhost:3306
Source Database : tour
Target Server Type : MYSQL
Target Server Version : 50542
File Encoding : 65001
Date: 2016-07-11 11:41:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `dy_city`
-- ----------------------------
DROP TABLE IF EXISTS `dy_city`;
CREATE TABLE `dy_city` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pid` int(10) NOT NULL COMMENT '父ID',
`cardcode` varchar(10) NOT NULL COMMENT '身份证前几位代码',
`name` varchar(200) DEFAULT NULL COMMENT '名称',
`pcardcode` varchar(10) DEFAULT NULL,
`shortname` varchar(200) DEFAULT NULL COMMENT '简称',
`leveltype` tinyint(4) DEFAULT NULL COMMENT '层级',
`citycode` varchar(10) DEFAULT NULL COMMENT '区号',
`zipcode` varchar(10) DEFAULT NULL COMMENT '邮编',
`mergername` varchar(500) DEFAULT NULL,
`lng` decimal(10,7) DEFAULT NULL,
`lat` decimal(10,7) DEFAULT NULL,
`pinyin` varchar(250) DEFAULT NULL COMMENT '拼音',
`firstpinyin` char(1) DEFAULT NULL COMMENT '首拼音',
PRIMARY KEY (`id`),
KEY `firstpinyin` (`firstpinyin`),
KEY `leveltype` (`leveltype`),
KEY `zipcode` (`zipcode`),
KEY `citycode` (`citycode`),
KEY `cardcode` (`cardcode`),
KEY `pcardcode` (`pcardcode`),
KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3751 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dy_city
-- ----------------------------
INSERT INTO `dy_city` VALUES ('1', '0', '100000', '中国', '0', '中国', '0', '', '', '中国', '116.3683244', '39.9150850', 'China', 'C');
INSERT INTO `dy_city` VALUES ('2', '1', '110000', '北京', '100000', '北京', '1', '', '', '中国,北京', '116.4052850', '39.9049890', 'Beijing', 'B');
INSERT INTO `dy_city` VALUES ('3', '2', '110100', '北京市', '110000', '北京', '2', '010', '100000', '中国,北京,北京市', '116.4052850', '39.9049890', 'Beijing', 'B');
INSERT INTO `dy_city` VALUES ('4', '3', '110101', '东城区', '110100', '东城', '3', '010', '100010', '中国,北京,北京市,东城区', '116.4100500', '39.9315700', 'Dongcheng', 'D');
INSERT INTO `dy_city` VALUES ('5', '3', '110102', '西城区', '110100', '西城', '3', '010', '100032', '中国,北京,北京市,西城区', '116.3600300', '39.9305000', 'Xicheng', 'X');
INSERT INTO `dy_city` VALUES ('6', '3', '110105', '朝阳区', '110100', '朝阳', '3', '010', '100020', '中国,北京,北京市,朝阳区', '116.4854800', '39.9484000', 'Chaoyang', 'C');
INSERT INTO `dy_city` VALUES ('7', '3', '110106', '丰台区', '110100', '丰台', '3', '010', '100071', '中国,北京,北京市,丰台区', '116.2862500', '39.8585000', 'Fengtai', 'F');
INSERT INTO `dy_city` VALUES ('8', '3', '110107', '石景山区', '110100', '石景山', '3', '010', '100043', '中国,北京,北京市,石景山区', '116.2229000', '39.9056400', 'Shijingshan', 'S');
INSERT INTO `dy_city` VALUES ('9', '3', '110108', '海淀区', '110100', '海淀', '3', '010', '100089', '中国,北京,北京市,海淀区', '116.2981200', '39.9593100', 'Haidian', 'H');
INSERT INTO `dy_city` VALUES ('10', '3', '110109', '门头沟区', '110100', '门头沟', '3', '010', '102300', '中国,北京,北京市,门头沟区', '116.1013700', '39.9404300', 'Mentougou', 'M');
INSERT INTO `dy_city` VALUES ('11', '3', '110111', '房山区', '110100', '房山', '3', '010', '102488', '中国,北京,北京市,房山区', '116.1425700', '39.7478600', 'Fangshan', 'F');
INSERT INTO `dy_city` VALUES ('12', '3', '110112', '通州区', '110100', '通州', '3', '010', '101149', '中国,北京,北京市,通州区', '116.6571600', '39.9096600', 'Tongzhou', 'T');
INSERT INTO `dy_city` VALUES ('13', '3', '110113', '顺义区', '110100', '顺义', '3', '010', '101300', '中国,北京,北京市,顺义区', '116.6541700', '40.1302000', 'Shunyi', 'S');
INSERT INTO `dy_city` VALUES ('14', '3', '110114', '昌平区', '110100', '昌平', '3', '010', '102200', '中国,北京,北京市,昌平区', '116.2312000', '40.2207200', 'Changping', 'C');
INSERT INTO `dy_city` VALUES ('15', '3', '110115', '大兴区', '110100', '大兴', '3', '010', '102600', '中国,北京,北京市,大兴区', '116.3414900', '39.7266800', 'Daxing', 'D');
INSERT INTO `dy_city` VALUES ('16', '3', '110116', '怀柔区', '110100', '怀柔', '3', '010', '101400', '中国,北京,北京市,怀柔区', '116.6316800', '40.3160200', 'Huairou', 'H');
INSERT INTO `dy_city` VALUES ('17', '3', '110117', '平谷区', '110100', '平谷', '3', '010', '101200', '中国,北京,北京市,平谷区', '117.1213300', '40.1405600', 'Pinggu', 'P');
INSERT INTO `dy_city` VALUES ('18', '3', '110228', '密云县', '110100', '密云', '3', '010', '101500', '中国,北京,北京市,密云县', '116.8429500', '40.3761800', 'Miyun', 'M');
INSERT INTO `dy_city` VALUES ('19', '3', '110229', '延庆县', '110100', '延庆', '3', '010', '102100', '中国,北京,北京市,延庆县', '115.9749400', '40.4567200', 'Yanqing', 'Y');
INSERT INTO `dy_city` VALUES ('20', '1', '120000', '天津', '100000', '天津', '1', '', '', '中国,天津', '117.1901820', '39.1255960', 'Tianjin', 'T');
INSERT INTO `dy_city` VALUES ('21', '20', '120100', '天津市', '120000', '天津', '2', '022', '300000', '中国,天津,天津市', '117.1901820', '39.1255960', 'Tianjin', 'T');
INSERT INTO `dy_city` VALUES ('22', '21', '120101', '和平区', '120100', '和平', '3', '022', '300041', '中国,天津,天津市,和平区', '117.2145600', '39.1171800', 'Heping', 'H');
INSERT INTO `dy_city` VALUES ('23', '21', '120102', '河东区', '120100', '河东', '3', '022', '300171', '中国,天津,天津市,河东区', '117.2256200', '39.1231800', 'Hedong', 'H');
INSERT INTO `dy_city` VALUES ('24', '21', '120103', '河西区', '120100', '河西', '3', '022', '300202', '中国,天津,天津市,河西区', '117.2232700', '39.1095900', 'Hexi', 'H');
INSERT INTO `dy_city` VALUES ('25', '21', '120104', '南开区', '120100', '南开', '3', '022', '300110', '中国,天津,天津市,南开区', '117.1507400', '39.1382100', 'Nankai', 'N');
INSERT INTO `dy_city` VALUES ('26', '21', '120105', '河北区', '120100', '河北', '3', '022', '300143', '中国,天津,天津市,河北区', '117.1969700', '39.1481600', 'Hebei', 'H');
INSERT INTO `dy_city` VALUES ('27', '21', '120106', '红桥区', '120100', '红桥', '3', '022', '300131', '中国,天津,天津市,红桥区', '117.1514500', '39.1671500', 'Hongqiao', 'H');
INSERT INTO `dy_city` VALUES ('28', '21', '120110', '东丽区', '120100', '东丽', '3', '022', '300300', '中国,天津,天津市,东丽区', '117.3143600', '39.0863000', 'Dongli', 'D');
INSERT INTO `dy_city` VALUES ('29', '21', '120111', '西青区', '120100', '西青', '3', '022', '300380', '中国,天津,天津市,西青区', '117.0092700', '39.1412300', 'Xiqing', 'X');
INSERT INTO `dy_city` VALUES ('30', '21', '120112', '津南区', '120100', '津南', '3', '022', '300350', '中国,天津,天津市,津南区', '117.3853700', '38.9913900', 'Jinnan', 'J');
INSERT INTO `dy_city` VALUES ('31', '21', '120113', '北辰区', '120100', '北辰', '3', '022', '300400', '中国,天津,天津市,北辰区', '117.1321700', '39.2213100', 'Beichen', 'B');
INSERT INTO `dy_city` VALUES ('32', '21', '120114', '武清区', '120100', '武清', '3', '022', '301700', '中国,天津,天津市,武清区', '117.0444300', '39.3841500', 'Wuqing', 'W');
INSERT INTO `dy_city` VALUES ('33', '21', '120115', '宝坻区', '120100', '宝坻', '3', '022', '301800', '中国,天津,天津市,宝坻区', '117.3103000', '39.7176100', 'Baodi', 'B');
INSERT INTO `dy_city` VALUES ('34', '21', '120116', '滨海新区', '120100', '滨海新区', '3', '022', '300451', '中国,天津,天津市,滨海新区', '117.7016200', '39.0266800', 'Binhaixinqu', 'B');
INSERT INTO `dy_city` VALUES ('35', '21',