全球机场数据.rar

/* Navicat Premium Data Transfer Source Server : 192.168.10.240 Source Server Type : MySQL Source Server Version : 50721 Source Host : 192.168.10.240:3306 Source Schema : ykb_flight Target Server Type : MySQL Target Server Version : 50721 File Encoding : 65001 Date: 03/09/2018 20:28:15 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for flight_airport_base_china -- ---------------------------- DROP TABLE IF EXISTS `flight_airport_base_china`; CREATE TABLE `flight_airport_base_china` ( `AirportCode` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机场三字代码', `AirportName` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市中文全称', `AirportEnName` char(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CityName` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市中文全称', `CityEnName` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市英文名称', `CountryCode` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家二字代码', `CountryName` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家中文全称' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of flight_airport_base_china -- ---------------------------- INSERT INTO `flight_airport_base_china` VALUES ('AAT', '阿尔泰机场', 'Altay Airport', '阿勒泰', 'Altay', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('ACX', '兴义万峰林机场', 'Xingyi Wanfenglin Airport', '兴义', 'Xingyi', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AEB', '百色巴马机场', 'Baise Bama Airport', '百色', 'Baise', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AHJ', '阿坝红原机场', 'Aba Hongyuan Airport', '红原', 'Aba Hongyuan', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AKA', '安康富强机场', 'Ankang Wulipu Airport', '安康', 'Ankang', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AKU', '阿克苏机场', 'Aksu Airport', '阿克苏', 'Aksu', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AOG', '鞍山腾鳌机场', 'Anshan Teng\'ao Airport', '鞍山', 'Anshan', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AQG', '安庆天柱山机场', 'Anqing Tianzhushan Airport', '安庆', 'Anqing', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AVA', '安顺黄果树机场', 'Anshun Huangguoshu Airport', '安顺', 'Anshun', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AXF', '阿拉善左旗巴彦浩特机场', 'Alxa Left Banner Bayanhot Airport', '阿拉善左旗', 'Alxa Left Banner', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('AYN', '安阳豫东北机场', 'Anyang Airport of northeast of Henan', '安阳', 'Anyang', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BAR', '琼海博鳌国际机场', 'Qionghai Bo\'ao Airport', '贝克岛', 'Qionghai', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BAV', '包头东河机场', 'Baotou Erliban Airport', '包头', 'Baotou', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BFJ', '毕节飞雄机场', 'Bijie Feixiong Airport', '毕节', 'Bijie', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BFU', '蚌埠滕湖机场', 'Bengbu Tenghu Airport', '蚌埠', 'Bengbu', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BHY', '北海福成机场', 'Beihai Fucheng Airport', '北海', 'Beihai', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BPE', '秦皇岛北戴河机场', 'Qinhuangdao Beidaihe Airport', '秦皇岛', 'QINHUANGDAO', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BPL', '博乐阿拉山口机场', 'Bole Alashankou Airport', '博乐', 'Bole', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BPX', '昌都邦达机场', 'Qamdo Bamda Airport', '昌都', 'Changdu/Qamdo', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('BSD', '保山云瑞机场', 'Baoshan Yunduan Airport', '保山', 'Baoshan', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CAN', '广州白云国际机场', 'Guangzhou Baiyun International Airport', '广州', 'Guangzhou', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CDE', '承德普宁机场', 'Chengde Puning Airport', '承德', 'Chengde', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CGD', '常德桃花源机场', 'Changde Taohuayuan Airport', '常德', 'Changde', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CGO', '郑州新郑国际机场', 'Zhengzhou Xinzheng International Airport', '郑州', 'Zhengzhou', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CGQ', '长春龙嘉国际机场', 'Changchun Longjia International Airport', '长春', 'Changchun', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CHG', '朝阳机场', 'Chaoyang Airport', '朝阳', 'Chaoyang', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CIF', '赤峰玉龙机场', 'Chifeng Yulong Airport', '赤峰', 'Chifeng', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CIH', '长治王村机场', 'Changzhi Wangcun Airport', '长治', 'Changzhi', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CKG', '重庆江北国际机场', 'Chongqing Jiangbei International Airport', '重庆', 'Chongqing', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CNI', '长海大长山岛机场', 'Changhai Airport', '长海', 'CHANGHAI', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CSX', '长沙黄花国际机场', 'Changsha Huanghua International Airport', '长沙', 'Changsha', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CTU', '成都双流国际机场', 'Chengdu Shuangliu International Airport', '成都', 'Chengdu', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CWJ', '沧源佤山机场', 'Cangyuan Washan Airport', '沧源', 'Cangyuan', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('CZX', '常州奔牛国际机场', 'Changzhou Benniu Airport', '常州', 'Changzhou', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DAT', '大同云冈机场', 'Datong Yungang Airport', '大同', 'Datong', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DAX', '达州河市机场', 'Dazhou Heshi Airport', '达县', 'Dazhou', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DBC', '白城长安机场', 'Baicheng Chang\'an Airport', '白城', 'Baicheng', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DCY', '稻城亚丁机场', 'Daocheng Yading Airport', '稻城', 'Daocheng', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DDG', '丹东浪头国际机场', 'Dandong Langtou Airport', '丹东', 'Dandong', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DIG', '迪庆香格里拉机场', 'Diqing Shangri-la Airport', '迪庆', 'Deqen', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DLC', '大连周水子国际机场', 'Dalian Zhoushuizi International Airport', '大连', 'Dalian', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DLU', '大理机场', 'Dali Airport', '大理', 'Dali', 'CN', '中国'); INSERT INTO `flight_airport_base_china` VALUES ('DNH', '敦煌机场', 'Dunhuang Internation Airport', '敦煌', 'Dunhuang', 'CN', '中国'); INSERT INTO `flight_