/*
Navicat MySQL Data Transfer
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_city
-- ----------------------------
DROP TABLE IF EXISTS `t_city`;
CREATE TABLE `t_city` (
`sc_id` int(11) NOT NULL AUTO_INCREMENT,
`sc_name` varchar(32) NOT NULL,
`sc_pid` int(11) DEFAULT NULL,
PRIMARY KEY (`sc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=820001 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_city
-- ----------------------------
INSERT INTO `t_city` VALUES ('110000', '北京市', '0');
INSERT INTO `t_city` VALUES ('110100', '北京市', '110000');
INSERT INTO `t_city` VALUES ('110101', '东城区', '110100');
INSERT INTO `t_city` VALUES ('110102', '西城区', '110100');
INSERT INTO `t_city` VALUES ('110105', '朝阳区', '110100');
INSERT INTO `t_city` VALUES ('110106', '丰台区', '110100');
INSERT INTO `t_city` VALUES ('110107', '石景山区', '110100');
INSERT INTO `t_city` VALUES ('110108', '海淀区', '110100');
INSERT INTO `t_city` VALUES ('110109', '门头沟区', '110100');
INSERT INTO `t_city` VALUES ('110111', '房山区', '110100');
INSERT INTO `t_city` VALUES ('110112', '通州区', '110100');
INSERT INTO `t_city` VALUES ('110113', '顺义区', '110100');
INSERT INTO `t_city` VALUES ('110114', '昌平区', '110100');
INSERT INTO `t_city` VALUES ('110115', '大兴区', '110100');
INSERT INTO `t_city` VALUES ('110116', '怀柔区', '110100');
INSERT INTO `t_city` VALUES ('110117', '平谷区', '110100');
INSERT INTO `t_city` VALUES ('110118', '密云区', '110100');
INSERT INTO `t_city` VALUES ('110119', '延庆区', '110100');
INSERT INTO `t_city` VALUES ('120000', '天津市', '0');
INSERT INTO `t_city` VALUES ('120100', '天津市', '120000');
INSERT INTO `t_city` VALUES ('120101', '和平区', '120100');
INSERT INTO `t_city` VALUES ('120102', '河东区', '120100');
INSERT INTO `t_city` VALUES ('120103', '河西区', '120100');
INSERT INTO `t_city` VALUES ('120104', '南开区', '120100');
INSERT INTO `t_city` VALUES ('120105', '河北区', '120100');
INSERT INTO `t_city` VALUES ('120106', '红桥区', '120100');
INSERT INTO `t_city` VALUES ('120110', '东丽区', '120100');
INSERT INTO `t_city` VALUES ('120111', '西青区', '120100');
INSERT INTO `t_city` VALUES ('120112', '津南区', '120100');
INSERT INTO `t_city` VALUES ('120113', '北辰区', '120100');
INSERT INTO `t_city` VALUES ('120114', '武清区', '120100');
INSERT INTO `t_city` VALUES ('120115', '宝坻区', '120100');
INSERT INTO `t_city` VALUES ('120116', '滨海新区', '120100');
INSERT INTO `t_city` VALUES ('120117', '宁河区', '120100');
INSERT INTO `t_city` VALUES ('120118', '静海区', '120100');
INSERT INTO `t_city` VALUES ('120119', '蓟州区', '120100');
INSERT INTO `t_city` VALUES ('130000', '河北省', '0');
INSERT INTO `t_city` VALUES ('130100', '石家庄市', '130000');
INSERT INTO `t_city` VALUES ('130102', '长安区', '130100');
INSERT INTO `t_city` VALUES ('130104', '桥西区', '130100');
INSERT INTO `t_city` VALUES ('130105', '新华区', '130100');
INSERT INTO `t_city` VALUES ('130107', '井陉矿区', '130100');
INSERT INTO `t_city` VALUES ('130108', '裕华区', '130100');
INSERT INTO `t_city` VALUES ('130109', '藁城区', '130100');
INSERT INTO `t_city` VALUES ('130110', '鹿泉区', '130100');
INSERT INTO `t_city` VALUES ('130111', '栾城区', '130100');
INSERT INTO `t_city` VALUES ('130121', '井陉县', '130100');
INSERT INTO `t_city` VALUES ('130123', '正定县', '130100');
INSERT INTO `t_city` VALUES ('130125', '行唐县', '130100');
INSERT INTO `t_city` VALUES ('130126', '灵寿县', '130100');
INSERT INTO `t_city` VALUES ('130127', '高邑县', '130100');
INSERT INTO `t_city` VALUES ('130128', '深泽县', '130100');
INSERT INTO `t_city` VALUES ('130129', '赞皇县', '130100');
INSERT INTO `t_city` VALUES ('130130', '无极县', '130100');
INSERT INTO `t_city` VALUES ('130131', '平山县', '130100');
INSERT INTO `t_city` VALUES ('130132', '元氏县', '130100');
INSERT INTO `t_city` VALUES ('130133', '赵县', '130100');
INSERT INTO `t_city` VALUES ('130181', '辛集市', '130100');
INSERT INTO `t_city` VALUES ('130183', '晋州市', '130100');
INSERT INTO `t_city` VALUES ('130184', '新乐市', '130100');
INSERT INTO `t_city` VALUES ('130200', '唐山市', '130000');
INSERT INTO `t_city` VALUES ('130202', '路南区', '130200');
INSERT INTO `t_city` VALUES ('130203', '路北区', '130200');
INSERT INTO `t_city` VALUES ('130204', '古冶区', '130200');
INSERT INTO `t_city` VALUES ('130205', '开平区', '130200');
INSERT INTO `t_city` VALUES ('130207', '丰南区', '130200');
INSERT INTO `t_city` VALUES ('130208', '丰润区', '130200');
INSERT INTO `t_city` VALUES ('130209', '曹妃甸区', '130200');
INSERT INTO `t_city` VALUES ('130224', '滦南县', '130200');
INSERT INTO `t_city` VALUES ('130225', '乐亭县', '130200');
INSERT INTO `t_city` VALUES ('130227', '迁西县', '130200');
INSERT INTO `t_city` VALUES ('130229', '玉田县', '130200');
INSERT INTO `t_city` VALUES ('130281', '遵化市', '130200');
INSERT INTO `t_city` VALUES ('130283', '迁安市', '130200');
INSERT INTO `t_city` VALUES ('130284', '滦州市', '130200');
INSERT INTO `t_city` VALUES ('130300', '秦皇岛市', '130000');
INSERT INTO `t_city` VALUES ('130302', '海港区', '130300');
INSERT INTO `t_city` VALUES ('130303', '山海关区', '130300');
INSERT INTO `t_city` VALUES ('130304', '北戴河区', '130300');
INSERT INTO `t_city` VALUES ('130306', '抚宁区', '130300');
INSERT INTO `t_city` VALUES ('130321', '青龙满族自治县', '130300');
INSERT INTO `t_city` VALUES ('130322', '昌黎县', '130300');
INSERT INTO `t_city` VALUES ('130324', '卢龙县', '130300');
INSERT INTO `t_city` VALUES ('130400', '邯郸市', '130000');
INSERT INTO `t_city` VALUES ('130402', '邯山区', '130400');
INSERT INTO `t_city` VALUES ('130403', '丛台区', '130400');
INSERT INTO `t_city` VALUES ('130404', '复兴区', '130400');
INSERT INTO `t_city` VALUES ('130406', '峰峰矿区', '130400');
INSERT INTO `t_city` VALUES ('130407', '肥乡区', '130400');
INSERT INTO `t_city` VALUES ('130408', '永年区', '130400');
INSERT INTO `t_city` VALUES ('130423', '临漳县', '130400');
INSERT INTO `t_city` VALUES ('130424', '成安县', '130400');
INSERT INTO `t_city` VALUES ('130425', '大名县', '130400');
INSERT INTO `t_city` VALUES ('130426', '涉县', '130400');
INSERT INTO `t_city` VALUES ('130427', '磁县', '130400');
INSERT INTO `t_city` VALUES ('130430', '邱县', '130400');
INSERT INTO `t_city` VALUES ('130431', '鸡泽县', '130400');
INSERT INTO `t_city` VALUES ('130432', '广平县', '130400');
INSERT INTO `t_city` VALUES ('130433', '馆陶县', '130400');
INSERT INTO `t_city` VALUES ('130434', '魏县', '130400');
INSERT INTO `t_city` VALUES ('130435', '曲周县', '130400');
INSERT INTO `t_city` VALUES ('130481', '武安市', '130400');
INSERT INTO `t_city` VALUES ('130500', '邢台市', '130000');
INSERT INTO `t_city` VALUES ('130502', '桥东区', '130500');
INSERT INTO `t_city` VALUES ('130503', '桥西区', '130500');
INSERT INTO `t_city` VALUES ('130521', '邢台县', '130500');
INSERT INTO `t_city` VALUES ('130522', '临城县', '130500');
INSERT INTO `t_city` VALUES ('130523', '内丘县', '130500');
INSERT INTO `t_city` VALUES ('130524', '柏乡县', '130500');
INSERT INTO `t_city` VALUES ('130525', '隆尧县', '130500');
INSERT INTO `t_city` VALUES ('130526', '任县', '130500');
INSERT INTO `t_city` VALUES ('130527', '南和县', '130500');
INSERT INTO `t_city` VALUES ('130528', '宁晋县', '130500');
INSERT INTO `t_city` VALUES ('130529', '巨鹿县', '130500');
INSERT INTO `t_city` VALUES ('130530', '新河县', '130500');
INSERT INTO `t_city` VALUES ('130531', '广宗县', '130500');
INSERT INTO `t_city` VALUES ('130532', '平乡县', '1305