pca.zip_.sql文件_SQL文件资源-CSDN文库

共1个文件

sql：1个

版权申诉

.sql文件

sql文件

109 浏览量 2022-09-20 20:16:33 上传评论收藏 37KB ZIP 举报

资源详情

资源评论

资源推荐

收起资源包目录

pca.zip （1个子文件）

pca.sql 259KB

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50045 Source Host : localhost:3306 Source Database : xcqq Target Server Type : MYSQL Target Server Version : 50045 File Encoding : 65001 Date: 2013-03-20 13:52:58 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `tbl_area` -- ---------------------------- DROP TABLE IF EXISTS `tbl_area`; CREATE TABLE `tbl_area` ( `ar_id` int(11) NOT NULL auto_increment COMMENT '区编号', `ar_code` int(11) default NULL COMMENT '区条码', `ar_name` varchar(255) default NULL COMMENT '区名称', `ar_city` int(11) default NULL COMMENT '上级市', PRIMARY KEY (`ar_id`), KEY `area_city` (`ar_city`), CONSTRAINT `area_city` FOREIGN KEY (`ar_city`) REFERENCES `tbl_city` (`ct_code`) ) ENGINE=InnoDB AUTO_INCREMENT=3145 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of tbl_area -- ---------------------------- INSERT INTO `tbl_area` VALUES ('1', '110101', '东城区', '110100'); INSERT INTO `tbl_area` VALUES ('2', '110102', '西城区', '110100'); INSERT INTO `tbl_area` VALUES ('3', '110103', '崇文区', '110100'); INSERT INTO `tbl_area` VALUES ('4', '110104', '宣武区', '110100'); INSERT INTO `tbl_area` VALUES ('5', '110105', '朝阳区', '110100'); INSERT INTO `tbl_area` VALUES ('6', '110106', '丰台区', '110100'); INSERT INTO `tbl_area` VALUES ('7', '110107', '石景山区', '110100'); INSERT INTO `tbl_area` VALUES ('8', '110108', '海淀区', '110100'); INSERT INTO `tbl_area` VALUES ('9', '110109', '门头沟区', '110100'); INSERT INTO `tbl_area` VALUES ('10', '110111', '房山区', '110100'); INSERT INTO `tbl_area` VALUES ('11', '110112', '通州区', '110100'); INSERT INTO `tbl_area` VALUES ('12', '110113', '顺义区', '110100'); INSERT INTO `tbl_area` VALUES ('13', '110114', '昌平区', '110100'); INSERT INTO `tbl_area` VALUES ('14', '110115', '大兴区', '110100'); INSERT INTO `tbl_area` VALUES ('15', '110116', '怀柔区', '110100'); INSERT INTO `tbl_area` VALUES ('16', '110117', '平谷区', '110100'); INSERT INTO `tbl_area` VALUES ('17', '110228', '密云县', '110200'); INSERT INTO `tbl_area` VALUES ('18', '110229', '延庆县', '110200'); INSERT INTO `tbl_area` VALUES ('19', '120101', '和平区', '120100'); INSERT INTO `tbl_area` VALUES ('20', '120102', '河东区', '120100'); INSERT INTO `tbl_area` VALUES ('21', '120103', '河西区', '120100'); INSERT INTO `tbl_area` VALUES ('22', '120104', '南开区', '120100'); INSERT INTO `tbl_area` VALUES ('23', '120105', '河北区', '120100'); INSERT INTO `tbl_area` VALUES ('24', '120106', '红桥区', '120100'); INSERT INTO `tbl_area` VALUES ('25', '120107', '塘沽区', '120100'); INSERT INTO `tbl_area` VALUES ('26', '120108', '汉沽区', '120100'); INSERT INTO `tbl_area` VALUES ('27', '120109', '大港区', '120100'); INSERT INTO `tbl_area` VALUES ('28', '120110', '东丽区', '120100'); INSERT INTO `tbl_area` VALUES ('29', '120111', '西青区', '120100'); INSERT INTO `tbl_area` VALUES ('30', '120112', '津南区', '120100'); INSERT INTO `tbl_area` VALUES ('31', '120113', '北辰区', '120100'); INSERT INTO `tbl_area` VALUES ('32', '120114', '武清区', '120100'); INSERT INTO `tbl_area` VALUES ('33', '120115', '宝坻区', '120100'); INSERT INTO `tbl_area` VALUES ('34', '120221', '宁河县', '120200'); INSERT INTO `tbl_area` VALUES ('35', '120223', '静海县', '120200'); INSERT INTO `tbl_area` VALUES ('36', '120225', '蓟　县', '120200'); INSERT INTO `tbl_area` VALUES ('37', '130101', '市辖区', '130100'); INSERT INTO `tbl_area` VALUES ('38', '130102', '长安区', '130100'); INSERT INTO `tbl_area` VALUES ('39', '130103', '桥东区', '130100'); INSERT INTO `tbl_area` VALUES ('40', '130104', '桥西区', '130100'); INSERT INTO `tbl_area` VALUES ('41', '130105', '新华区', '130100'); INSERT INTO `tbl_area` VALUES ('42', '130107', '井陉矿区', '130100'); INSERT INTO `tbl_area` VALUES ('43', '130108', '裕华区', '130100'); INSERT INTO `tbl_area` VALUES ('44', '130121', '井陉县', '130100'); INSERT INTO `tbl_area` VALUES ('45', '130123', '正定县', '130100'); INSERT INTO `tbl_area` VALUES ('46', '130124', '栾城县', '130100'); INSERT INTO `tbl_area` VALUES ('47', '130125', '行唐县', '130100'); INSERT INTO `tbl_area` VALUES ('48', '130126', '灵寿县', '130100'); INSERT INTO `tbl_area` VALUES ('49', '130127', '高邑县', '130100'); INSERT INTO `tbl_area` VALUES ('50', '130128', '深泽县', '130100'); INSERT INTO `tbl_area` VALUES ('51', '130129', '赞皇县', '130100'); INSERT INTO `tbl_area` VALUES ('52', '130130', '无极县', '130100'); INSERT INTO `tbl_area` VALUES ('53', '130131', '平山县', '130100'); INSERT INTO `tbl_area` VALUES ('54', '130132', '元氏县', '130100'); INSERT INTO `tbl_area` VALUES ('55', '130133', '赵　县', '130100'); INSERT INTO `tbl_area` VALUES ('56', '130181', '辛集市', '130100'); INSERT INTO `tbl_area` VALUES ('57', '130182', '藁城市', '130100'); INSERT INTO `tbl_area` VALUES ('58', '130183', '晋州市', '130100'); INSERT INTO `tbl_area` VALUES ('59', '130184', '新乐市', '130100'); INSERT INTO `tbl_area` VALUES ('60', '130185', '鹿泉市', '130100'); INSERT INTO `tbl_area` VALUES ('61', '130201', '市辖区', '130200'); INSERT INTO `tbl_area` VALUES ('62', '130202', '路南区', '130200'); INSERT INTO `tbl_area` VALUES ('63', '130203', '路北区', '130200'); INSERT INTO `tbl_area` VALUES ('64', '130204', '古冶区', '130200'); INSERT INTO `tbl_area` VALUES ('65', '130205', '开平区', '130200'); INSERT INTO `tbl_area` VALUES ('66', '130207', '丰南区', '130200'); INSERT INTO `tbl_area` VALUES ('67', '130208', '丰润区', '130200'); INSERT INTO `tbl_area` VALUES ('68', '130223', '滦　县', '130200'); INSERT INTO `tbl_area` VALUES ('69', '130224', '滦南县', '130200'); INSERT INTO `tbl_area` VALUES ('70', '130225', '乐亭县', '130200'); INSERT INTO `tbl_area` VALUES ('71', '130227', '迁西县', '130200'); INSERT INTO `tbl_area` VALUES ('72', '130229', '玉田县', '130200'); INSERT INTO `tbl_area` VALUES ('73', '130230', '唐海县', '130200'); INSERT INTO `tbl_area` VALUES ('74', '130281', '遵化市', '130200'); INSERT INTO `tbl_area` VALUES ('75', '130283', '迁安市', '130200'); INSERT INTO `tbl_area` VALUES ('76', '130301', '市辖区', '130300'); INSERT INTO `tbl_area` VALUES ('77', '130302', '海港区', '130300'); INSERT INTO `tbl_area` VALUES ('78', '130303', '山海关区', '130300'); INSERT INTO `tbl_area` VALUES ('79', '130304', '北戴河区', '130300'); INSERT INTO `tbl_area` VALUES ('80', '130321', '青龙满族自治县', '130300'); INSERT INTO `tbl_area` VALUES ('81', '130322', '昌黎县', '130300'); INSERT INTO `tbl_area` VALUES ('82', '130323', '抚宁县', '130300'); INSERT INTO `tbl_area` VALUES ('83', '130324', '卢龙县', '130300'); INSERT INTO `tbl_area` VALUES ('84', '130401', '市辖区', '130400'); INSERT INTO `tbl_area` VALUES ('85', '130402', '邯山区', '130400'); INSERT INTO `tbl_area` VALUES ('86', '130403', '丛台区', '130400'); INSERT INTO `tbl_area` VALUES ('87', '130404', '复兴区', '130400'); INSERT INTO `tbl_area` VALUES ('88', '130406', '峰峰矿区', '130400'); INSERT INTO `tbl_area` VALUES ('89', '130421', '邯郸县', '130400'); INSERT INTO `tbl_area` VALUES ('90', '130423', '临漳县', '130400'); INSERT INTO `tbl_area` VALUES ('91', '130424', '成安县', '130400'); INSERT INTO `tbl_area` VALUES ('92', '130425', '大名县', '130400'); INSERT INTO `tbl_area` VALUES ('93', '130426', '涉　县', '130400'); INSERT INTO `tbl_area` VALUES ('94', '130427', '磁　县', '130400'); INSERT INTO `tbl_area` VALUES ('95', '130428', '肥乡县', '130400'); INSERT INTO `tbl_area` VALUES ('96', '130429', '永年县', '130400'); INSERT INTO `tbl_area` VALUES ('97', '130430',