master

分支 (1)

管理

管理

master

ticket-booking-system
/
ticket_booking_system.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50727
Source Host           : localhost:3306
Source Database       : ticket_booking_system

Target Server Type    : MYSQL
Target Server Version : 50727
File Encoding         : 65001

Date: 2020-06-07 10:44:42
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for airplane
-- ----------------------------
DROP TABLE IF EXISTS `airplane`;
CREATE TABLE `airplane` (
  `airplane_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '飞机号',
  `airplane_name` varchar(255) NOT NULL COMMENT '飞机名',
  `airplane_type` varchar(255) NOT NULL COMMENT '飞机型号',
  `seat_number` int(11) NOT NULL,
  `manufacturer` varchar(255) NOT NULL COMMENT '生产商',
  `purchase_date` date NOT NULL COMMENT '购买时间',
  PRIMARY KEY (`airplane_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of airplane
-- ----------------------------
INSERT INTO `airplane` VALUES ('1', '空客319', '中型', '84', '空中客车公司', '2010-05-30');
INSERT INTO `airplane` VALUES ('2', '波音737', '中型', '72', '波音公司', '2013-05-26');
INSERT INTO `airplane` VALUES ('6', '波音777', '大型', '120', '波音公司', '2015-05-31');
INSERT INTO `airplane` VALUES ('7', '空客320', '中型', '72', '空中客车公司', '2017-07-28');
INSERT INTO `airplane` VALUES ('8', '新舟60', '小型', '60', '西安飞机集团', '2019-01-28');

-- ----------------------------
-- Table structure for bill_information
-- ----------------------------
DROP TABLE IF EXISTS `bill_information`;
CREATE TABLE `bill_information` (
  `bill_id` varchar(255) NOT NULL COMMENT '账单号',
  `booking_id` varchar(255) NOT NULL COMMENT '订单号',
  `child_ticket_price` double DEFAULT NULL COMMENT '孩童票',
  `adult_ticket_price` double DEFAULT NULL COMMENT '成人票价',
  `total_price` double DEFAULT NULL COMMENT '总价钱',
  PRIMARY KEY (`bill_id`),
  KEY `booking_id` (`booking_id`),
  CONSTRAINT `bill_information_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `booking_information` (`booking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of bill_information
-- ----------------------------

-- ----------------------------
-- Table structure for booking_information
-- ----------------------------
DROP TABLE IF EXISTS `booking_information`;
CREATE TABLE `booking_information` (
  `booking_id` varchar(255) NOT NULL COMMENT '订单号',
  `user_id_card` varchar(255) NOT NULL COMMENT '用户身份证',
  `user_name` varchar(255) NOT NULL COMMENT '用户名',
  `phone_number` varchar(255) NOT NULL COMMENT '用户电话号码',
  `is_bring_child` varchar(255) DEFAULT NULL COMMENT '是否携带孩子',
  `pay_status` varchar(255) NOT NULL COMMENT '订单支付状态（是否已经支付）',
  `is_refund` varchar(255) DEFAULT NULL COMMENT '标记该票是否退订',
  `passenger_id_card` varchar(255) NOT NULL COMMENT '该票的乘客的身份证',
  `passenger_name` varchar(255) NOT NULL COMMENT '该票乘客的名字',
  `baby_name` varchar(255) DEFAULT NULL,
  `baby_id_card` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`booking_id`),
  KEY `user_name` (`user_name`),
  KEY `phone_number` (`phone_number`),
  KEY `user_id_card` (`user_id_card`),
  CONSTRAINT `booking_information_ibfk_1` FOREIGN KEY (`user_name`) REFERENCES `user_information` (`user_name`),
  CONSTRAINT `booking_information_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `user_information` (`phone_number`),
  CONSTRAINT `booking_information_ibfk_3` FOREIGN KEY (`user_id_card`) REFERENCES `user_information` (`user_id_card`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of booking_information
-- ----------------------------
INSERT INTO `booking_information` VALUES ('1591496391130', '445121', '翁雯璇', '15622327783', null, '已支付', null, 'sdf', 'sasd', null, null);
INSERT INTO `booking_information` VALUES ('CD12345689', '445121', '翁雯璇', '15622327783', '是', '未支付', null, '4512356', '潘晓', null, null);
INSERT INTO `booking_information` VALUES ('CF12345678', '445121', '翁雯璇', '15622327783', '否', '已支付', null, '4454125', '潘雨萱', null, null);

-- ----------------------------
-- Table structure for city_information
-- ----------------------------
DROP TABLE IF EXISTS `city_information`;
CREATE TABLE `city_information` (
  `province` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  PRIMARY KEY (`province`,`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of city_information
-- ----------------------------
INSERT INTO `city_information` VALUES ('上海市', '上海市');
INSERT INTO `city_information` VALUES ('云南省', '个旧市');
INSERT INTO `city_information` VALUES ('云南省', '临沧市');
INSERT INTO `city_information` VALUES ('云南省', '丽江市');
INSERT INTO `city_information` VALUES ('云南省', '保山市');
INSERT INTO `city_information` VALUES ('云南省', '大理市');
INSERT INTO `city_information` VALUES ('云南省', '安宁市');
INSERT INTO `city_information` VALUES ('云南省', '宣威市');
INSERT INTO `city_information` VALUES ('云南省', '开远市');
INSERT INTO `city_information` VALUES ('云南省', '弥勒市');
INSERT INTO `city_information` VALUES ('云南省', '文山市');
INSERT INTO `city_information` VALUES ('云南省', '昆明市');
INSERT INTO `city_information` VALUES ('云南省', '昭通市');
INSERT INTO `city_information` VALUES ('云南省', '普洱市');
INSERT INTO `city_information` VALUES ('云南省', '景洪市');
INSERT INTO `city_information` VALUES ('云南省', '曲靖市');
INSERT INTO `city_information` VALUES ('云南省', '楚雄市');
INSERT INTO `city_information` VALUES ('云南省', '玉溪市');
INSERT INTO `city_information` VALUES ('云南省', '瑞丽市');
INSERT INTO `city_information` VALUES ('云南省', '腾冲市');
INSERT INTO `city_information` VALUES ('云南省', '芒市');
INSERT INTO `city_information` VALUES ('云南省', '蒙自市');
INSERT INTO `city_information` VALUES ('云南省', '香格里拉市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '丰镇市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '乌兰察布市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '乌兰浩特市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '乌海市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '二连浩特市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '包头市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '呼伦贝尔市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '呼和浩特市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '巴彦淖尔市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '扎兰屯市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '根河市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '满洲里市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '牙克石市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '赤峰市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '通辽市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '鄂尔多斯市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '锡林浩特市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '阿尔山市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '霍林郭勒市');
INSERT INTO `city_information` VALUES ('内蒙古自治区', '额尔古纳市');
INSERT INTO `city_information` VALUES ('北京市', '北京市');
INSERT INTO `city_information` VALUES ('台湾', '台中市');
INSERT INTO `city_information` VALUES ('台湾', '台北市');
INSERT INTO `city_information` VALUES ('台湾', '台南市');
INSERT INTO `city_information` VALUES ('台湾', '嘉义市');
INSERT INTO `city_information` VALUES ('台湾', '基隆市');
INSERT INTO `city_information` VALUES ('台湾', '新北市');
INSERT INTO `city_information` VALUES ('台湾', '新竹市');
INSERT INTO `city_information` VALUES ('台湾', '桃园市');
INSERT INTO `city_information` VALUES ('台湾', '高雄市');
INSERT INTO `city_information` VALUES ('吉林省', '临江市');
INSERT INTO `city_information` VALUES ('吉林省', '公主岭市');
INSERT INTO `city_information` VALUES ('吉林省', '双辽市');
INSERT INTO `city_information` VALUES ('吉林省', '吉林市');
INSERT INTO `city_information` VALUES ('吉林省', '和龙市');
INSERT INTO `city_information` VALUES ('吉林省', '四平市');
INSERT INTO `city_information` VALUES ('吉林省', '图们市');
INSERT INTO `city_information` VALUES ('吉林省', '大安市');
INSERT INTO `city_information` VALUES ('吉林省', '延吉市');
INSERT INTO `city_information` VALUES ('吉林省', '德惠市');
INSERT INTO `city_information` VALUES ('吉林省', '扶余市');
INSERT INTO `city_information` VALUES ('吉林省', '敦化市');
INSERT INTO `city_information` VALUES ('吉林省', '松原市');
INSERT INTO `city_information` VALUES ('吉林省', '桦甸市');
INSERT INTO `city_information` VALUES ('吉林省', '梅河口市');
INSERT INTO `city_information` VALUES ('吉林省', '榆树市');
INSERT INTO `city_information` VALUES ('吉林省', '洮南市');
INSERT INTO `city_information` VALUES ('吉林省', '珲春市');
INSERT INTO `city_information` VALUES ('吉林省', '白城市');
INSERT INTO `city_information` VALUES ('吉林省', '白山市');
INSERT INTO `city_information` VALUES ('吉林省', '磐石市');
INSERT INTO `city_information` VALUES ('吉林省', '舒兰市');
INSERT INTO `city_information` VALUES ('吉林省', '蛟河市');
INSERT INTO `city_information` VALUES ('吉林省', '辽源市');
INSERT INTO `city_information` VALUES ('吉林省', '通化市');
INSERT INTO `city_information` VALUES ('吉林省', '长春市');
INSERT INTO `city_information` VALUES ('吉林省', '集安市');
INSERT INTO `city_information` VALUES ('吉林省', '龙井市');
INSERT INTO `city_information` VALUES ('四川省', '万源市');
INSERT INTO `city_information` VALUES ('四川省', '乐山市');
INSERT INTO `city_information` VALUES ('四川省', '什邡市');
INSERT INTO `city_information` VALUES ('四川省', '内江市');
INSERT INTO `city_information` VALUES ('四川省', '华蓥市');
INSERT INTO `city_information` VALUES ('四川省', '南充市');
INSERT INTO `city_information` VALUES ('四川省', '宜宾市');
INSERT INTO `city_information` VALUES ('四川省', '峨眉山市');
INSERT INTO `city_information` VALUES ('四川省', '崇州市');
INSERT INTO `city_information` VALUES ('四川省', '巴中市');
INSERT INTO `city_information` VALUES ('四川省', '广元市');
INSERT INTO `city_information` VALUES ('四川省', '广安市');
INSERT INTO `city_information` VALUES ('四川省', '广汉市');
INSERT INTO `city_information` VALUES ('四川省', '康定市');
INSERT INTO `city_information` VALUES ('四川省', '彭州市');
INSERT INTO `city_information` VALUES ('四川省', '德阳市');
INSERT INTO `city_information` VALUES ('四川省', '成都市');
INSERT INTO `city_information` VALUES ('四川省', '攀枝花市');
INSERT INTO `city_information` VALUES ('四川省', '江油市');
INSERT INTO `city_information` VALUES ('四川省', '泸州市');
INSERT INTO `city_information` VALUES ('四川省', '眉山市');
INSERT INTO `city_information` VALUES ('四川省', '简阳市');
INSERT INTO `city_information` VALUES ('四川省', '绵竹市');
INSERT INTO `city_information` VALUES ('四川省', '绵阳市');
INSERT INTO `city_information` VALUES ('四川省', '自贡市');
INSERT INTO `city_information` VALUES ('四川省', '西昌市');
INSERT INTO `city_information` VALUES ('四川省', '资阳市');
INSERT INTO `city_information` VALUES ('四川省', '达州市');
INSERT INTO `city_information` VALUES ('四川省', '遂宁市');
INSERT INTO `city_information` VALUES ('四川省', '邛崃市');
INSERT INTO `city_information` VALUES ('四川省', '都江堰市');
INSERT INTO `city_information` VALUES ('四川省', '阆中市');
INSERT INTO `city_information` VALUES ('四川省', '雅安市');
INSERT INTO `city_information` VALUES ('四川省', '马尔康市');
INSERT INTO `city_information` VALUES ('天津市', '天津市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '中卫市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '吴忠市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '固原市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '灵武市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '石嘴山市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '银川市');
INSERT INTO `city_information` VALUES ('宁夏回族自治区', '青铜峡市');
INSERT INTO `city_information` VALUES ('安徽省', '亳州市');
INSERT INTO `city_information` VALUES ('安徽省', '六安市');
INSERT INTO `city_information` VALUES ('安徽省', '合肥市');
INSERT INTO `city_information` VALUES ('安徽省', '天长市');
INSERT INTO `city_information` VALUES ('安徽省', '宁国市');
INSERT INTO `city_information` VALUES ('安徽省', '安庆市');
INSERT INTO `city_information` VALUES ('安徽省', '宣城市');
INSERT INTO `city_information` VALUES ('安徽省', '宿州市');
INSERT INTO `city_information` VALUES ('安徽省', '巢湖市');
INSERT INTO `city_information` VALUES ('安徽省', '明光市');
INSERT INTO `city_information` VALUES ('安徽省', '桐城市');
INSERT INTO `city_information` VALUES ('安徽省', '池州市');
INSERT INTO `city_information` VALUES ('安徽省', '淮北市');
INSERT INTO `city_information` VALUES ('安徽省', '淮南市');
INSERT INTO `city_information` VALUES ('安徽省', '滁州市');
INSERT INTO `city_information` VALUES ('安徽省', '界首市');
INSERT INTO `city_information` VALUES ('安徽省', '芜湖市');
INSERT INTO `city_information` VALUES ('安徽省', '蚌埠市');
INSERT INTO `city_information` VALUES ('安徽省', '铜陵市');
INSERT INTO `city_information` VALUES ('安徽省', '阜阳市');
INSERT INTO `city_information` VALUES ('安徽省', '马鞍山市');
INSERT INTO `city_information` VALUES ('安徽省', '黄山市');
INSERT INTO `city_information` VALUES ('山东省', '东营市');
INSERT INTO `city_information` VALUES ('山东省', '临沂市');
INSERT INTO `city_information` VALUES ('山东省', '临清市');
INSERT INTO `city_information` VALUES ('山东省', '乐陵市');
INSERT INTO `city_information` VALUES ('山东省', '乳山市');
INSERT INTO `city_information` VALUES ('山东省', '即墨市');
INSERT INTO `city_information` VALUES ('山东省', '威海市');
INSERT INTO `city_information` VALUES ('山东省', '安丘市');
INSERT INTO `city_information` VALUES ('山东省', '寿光市');
INSERT INTO `city_information` VALUES ('山东省', '平度市');
INSERT INTO `city_information` VALUES ('山东省', '德州市');
INSERT INTO `city_information` VALUES ('山东省', '招远市');
INSERT INTO `city_information` VALUES ('山东省', '新泰市');
INSERT INTO `city_information` VALUES ('山东省', '日照市');
INSERT INTO `city_information` VALUES ('山东省', '昌邑市');
INSERT INTO `city_information` VALUES ('山东省', '曲阜市');
INSERT INTO `city_information` VALUES ('山东省', '枣庄市');
INSERT INTO `city_information` VALUES ('山东省', '栖霞市');
INSERT INTO `city_information` VALUES ('山东省', '泰安市');
INSERT INTO `city_information` VALUES ('山东省', '济南市');
INSERT INTO `city_information` VALUES ('山东省', '济宁市');
INSERT INTO `city_information` VALUES ('山东省', '海阳市');
INSERT INTO `city_information` VALUES ('山东省', '淄博市');
INSERT INTO `city_information` VALUES ('山东省', '滕州市');
INSERT INTO `city_information` VALUES ('山东省', '滨州市');
INSERT INTO `city_information` VALUES ('山东省', '潍坊市');
INSERT INTO `city_information` VALUES ('山东省', '烟台市');
INSERT INTO `city_information` VALUES ('山东省', '禹城市');
INSERT INTO `city_information` VALUES ('山东省', '聊城市');
INSERT INTO `city_information` VALUES ('山东省', '肥城市');
INSERT INTO `city_information` VALUES ('山东省', '胶州市');
INSERT INTO `city_information` VALUES ('山东省', '荣成市');
INSERT INTO `city_information` VALUES ('山东省', '莱州市');
INSERT INTO `city_information` VALUES ('山东省', '莱芜市');
INSERT INTO `city_information` VALUES ('山东省', '莱西市');
INSERT INTO `city_information` VALUES ('山东省', '莱阳市');
INSERT INTO `city_information` VALUES ('山东省', '菏泽市');
INSERT INTO `city_information` VALUES ('山东省', '蓬莱市');
INSERT INTO `city_information` VALUES ('山东省', '诸城市');
INSERT INTO `city_information` VALUES ('山东省', '邹城市');
INSERT INTO `city_information` VALUES ('山东省', '青岛市');
INSERT INTO `city_information` VALUES ('山东省', '青州市');
INSERT INTO `city_information` VALUES ('山东省', '高密市');
INSERT INTO `city_information` VALUES ('山东省', '龙口市');
INSERT INTO `city_information` VALUES ('山西省', '临汾市');
INSERT INTO `city_information` VALUES ('山西省', '介休市');
INSERT INTO `city_information` VALUES ('山西省', '侯马市');
INSERT INTO `city_information` VALUES ('山西省', '原平市');
INSERT INTO `city_information` VALUES ('山西省', '古交市');
INSERT INTO `city_information` VALUES ('山西省', '吕梁市');
INSERT INTO `city_information` VALUES ('山西省', '大同市');
INSERT INTO `city_information` VALUES ('山西省', '太原市');
INSERT INTO `city_information` VALUES ('山西省', '孝义市');
INSERT INTO `city_information` VALUES ('山西省', '忻州市');
INSERT INTO `city_information` VALUES ('山西省', '晋中市');
INSERT INTO `city_information` VALUES ('山西省', '晋城市');
INSERT INTO `city_information` VALUES ('山西省', '朔州市');
INSERT INTO `city_information` VALUES ('山西省', '永济市');
INSERT INTO `city_information` VALUES ('山西省', '汾阳市');
INSERT INTO `city_information` VALUES ('山西省', '河津市');
INSERT INTO `city_information` VALUES ('山西省', '潞城市');
INSERT INTO `city_information` VALUES ('山西省', '运城市');
INSERT INTO `city_information` VALUES ('山西省', '长治市');
INSERT INTO `city_information` VALUES ('山西省', '阳泉市');
INSERT INTO `city_information` VALUES ('山西省', '霍州市');
INSERT INTO `city_information` VALUES ('山西省', '高平市');
INSERT INTO `city_information` VALUES ('广东省', '东莞市');
INSERT INTO `city_information` VALUES ('广东省', '中山市');
INSERT INTO `city_information` VALUES ('广东省', '乐昌市');
INSERT INTO `city_information` VALUES ('广东省', '云浮市');
INSERT INTO `city_information` VALUES ('广东省', '佛山市');
INSERT INTO `city_information` VALUES ('广东省', '信宜市');
INSERT INTO `city_information` VALUES ('广东省', '兴宁市');
INSERT INTO `city_information` VALUES ('广东省', '化州市');
INSERT INTO `city_information` VALUES ('广东省', '南雄市');
INSERT INTO `city_information` VALUES ('广东省', '台山市');
INSERT INTO `city_information` VALUES ('广东省', '吴川市');
INSERT INTO `city_information` VALUES ('广东省', '四会市');
INSERT INTO `city_information` VALUES ('广东省', '广州市');
INSERT INTO `city_information` VALUES ('广东省', '廉江市');
INSERT INTO `city_information` VALUES ('广东省', '开平市');
INSERT INTO `city_information` VALUES ('广东省', '恩平市');
INSERT INTO `city_information` VALUES ('广东省', '惠州市');
INSERT INTO `city_information` VALUES ('广东省', '揭阳市');
INSERT INTO `city_information` VALUES ('广东省', '普宁市');
INSERT INTO `city_information` VALUES ('广东省', '梅州市');
INSERT INTO `city_information` VALUES ('广东省', '汕头市');
INSERT INTO `city_information` VALUES ('广东省', '汕尾市');
INSERT INTO `city_information` VALUES ('广东省', '江门市');
INSERT INTO `city_information` VALUES ('广东省', '河源市');
INSERT INTO `city_information` VALUES ('广东省', '深圳市');
INSERT INTO `city_information` VALUES ('广东省', '清远市');
INSERT INTO `city_information` VALUES ('广东省', '湛江市');
INSERT INTO `city_information` VALUES ('广东省', '潮州市');
INSERT INTO `city_information` VALUES ('广东省', '珠海市');
INSERT INTO `city_information` VALUES ('广东省', '罗定市');
INSERT INTO `city_information` VALUES ('广东省', '肇庆市');
INSERT INTO `city_information` VALUES ('广东省', '英德市');
INSERT INTO `city_information` VALUES ('广东省', '茂名市');
INSERT INTO `city_information` VALUES ('广东省', '连州市');
INSERT INTO `city_information` VALUES ('广东省', '阳春市');
INSERT INTO `city_information` VALUES ('广东省', '阳江市');
INSERT INTO `city_information` VALUES ('广东省', '陆丰市');
INSERT INTO `city_information` VALUES ('广东省', '雷州市');
INSERT INTO `city_information` VALUES ('广东省', '韶关市');
INSERT INTO `city_information` VALUES ('广东省', '高州市');
INSERT INTO `city_information` VALUES ('广东省', '鹤山市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '东兴市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '凭祥市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '北流市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '北海市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '南宁市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '合山市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '宜州市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '岑溪市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '崇左市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '来宾市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '柳州市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '桂平市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '桂林市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '梧州市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '河池市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '玉林市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '百色市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '贵港市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '贺州市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '钦州市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '防城港市');
INSERT INTO `city_information` VALUES ('广西壮族自治区', '靖西市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '乌苏市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '乌鲁木齐市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '五家渠市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '伊宁市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '克拉玛依市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '北屯市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '博乐市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '双河市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '可克达拉市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '吐鲁番市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '和田市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '哈密市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '喀什市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '图木舒克市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '塔城市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '奎屯市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '库尔勒市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '昆玉市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '昌吉市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '石河子市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '铁门关市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阜康市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阿克苏市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阿勒泰市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阿图什市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阿拉尔市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '阿拉山口市');
INSERT INTO `city_information` VALUES ('新疆维吾尔自治区', '霍尔果斯市');
INSERT INTO `city_information` VALUES ('江苏省', '东台市');
INSERT INTO `city_information` VALUES ('江苏省', '丹阳市');
INSERT INTO `city_information` VALUES ('江苏省', '仪征市');
INSERT INTO `city_information` VALUES ('江苏省', '兴化市');
INSERT INTO `city_information` VALUES ('江苏省', '南京市');
INSERT INTO `city_information` VALUES ('江苏省', '南通市');
INSERT INTO `city_information` VALUES ('江苏省', '句容市');
INSERT INTO `city_information` VALUES ('江苏省', '启东市');
INSERT INTO `city_information` VALUES ('江苏省', '太仓市');
INSERT INTO `city_information` VALUES ('江苏省', '如皋市');
INSERT INTO `city_information` VALUES ('江苏省', '宜兴市');
INSERT INTO `city_information` VALUES ('江苏省', '宿迁市');
INSERT INTO `city_information` VALUES ('江苏省', '常州市');
INSERT INTO `city_information` VALUES ('江苏省', '常熟市');
INSERT INTO `city_information` VALUES ('江苏省', '张家港市');
INSERT INTO `city_information` VALUES ('江苏省', '徐州市');
INSERT INTO `city_information` VALUES ('江苏省', '扬中市');
INSERT INTO `city_information` VALUES ('江苏省', '扬州市');
INSERT INTO `city_information` VALUES ('江苏省', '新沂市');
INSERT INTO `city_information` VALUES ('江苏省', '无锡市');
INSERT INTO `city_information` VALUES ('江苏省', '昆山市');
INSERT INTO `city_information` VALUES ('江苏省', '江阴市');
INSERT INTO `city_information` VALUES ('江苏省', '泰兴市');
INSERT INTO `city_information` VALUES ('江苏省', '泰州市');
INSERT INTO `city_information` VALUES ('江苏省', '海门市');
INSERT INTO `city_information` VALUES ('江苏省', '淮安市');
INSERT INTO `city_information` VALUES ('江苏省', '溧阳市');
INSERT INTO `city_information` VALUES ('江苏省', '盐城市');
INSERT INTO `city_information` VALUES ('江苏省', '苏州市');
INSERT INTO `city_information` VALUES ('江苏省', '连云港市');
INSERT INTO `city_information` VALUES ('江苏省', '邳州市');
INSERT INTO `city_information` VALUES ('江苏省', '镇江市');
INSERT INTO `city_information` VALUES ('江苏省', '靖江市');
INSERT INTO `city_information` VALUES ('江苏省', '高邮市');
INSERT INTO `city_information` VALUES ('江西省', '上饶市');
INSERT INTO `city_information` VALUES ('江西省', '丰城市');
INSERT INTO `city_information` VALUES ('江西省', '乐平市');
INSERT INTO `city_information` VALUES ('江西省', '九江市');
INSERT INTO `city_information` VALUES ('江西省', '井冈山市');
INSERT INTO `city_information` VALUES ('江西省', '共青城市');
INSERT INTO `city_information` VALUES ('江西省', '南昌市');
INSERT INTO `city_information` VALUES ('江西省', '吉安市');
INSERT INTO `city_information` VALUES ('江西省', '宜春市');
INSERT INTO `city_information` VALUES ('江西省', '德兴市');
INSERT INTO `city_information` VALUES ('江西省', '抚州市');
INSERT INTO `city_information` VALUES ('江西省', '新余市');
INSERT INTO `city_information` VALUES ('江西省', '景德镇市');
INSERT INTO `city_information` VALUES ('江西省', '樟树市');
INSERT INTO `city_information` VALUES ('江西省', '瑞昌市');
INSERT INTO `city_information` VALUES ('江西省', '瑞金市');
INSERT INTO `city_information` VALUES ('江西省', '萍乡市');
INSERT INTO `city_information` VALUES ('江西省', '贵溪市');
INSERT INTO `city_information` VALUES ('江西省', '赣州市');
INSERT INTO `city_information` VALUES ('江西省', '高安市');
INSERT INTO `city_information` VALUES ('江西省', '鹰潭市');
INSERT INTO `city_information` VALUES ('河北省', '三河市');
INSERT INTO `city_information` VALUES ('河北省', '任丘市');
INSERT INTO `city_information` VALUES ('河北省', '保定市');
INSERT INTO `city_information` VALUES ('河北省', '冀州市');
INSERT INTO `city_information` VALUES ('河北省', '南宫市');
INSERT INTO `city_information` VALUES ('河北省', '唐山市');
INSERT INTO `city_information` VALUES ('河北省', '安国市');
INSERT INTO `city_information` VALUES ('河北省', '定州市');
INSERT INTO `city_information` VALUES ('河北省', '廊坊市');
INSERT INTO `city_information` VALUES ('河北省', '张家口市');
INSERT INTO `city_information` VALUES ('河北省', '承德市');
INSERT INTO `city_information` VALUES ('河北省', '新乐市');
INSERT INTO `city_information` VALUES ('河北省', '晋州市');
INSERT INTO `city_information` VALUES ('河北省', '武安市');
INSERT INTO `city_information` VALUES ('河北省', '沙河市');
INSERT INTO `city_information` VALUES ('河北省', '沧州市');
INSERT INTO `city_information` VALUES ('河北省', '河间市');
INSERT INTO `city_information` VALUES ('河北省', '泊头市');
INSERT INTO `city_information` VALUES ('河北省', '涿州市');
INSERT INTO `city_information` VALUES ('河北省', '深州市');
INSERT INTO `city_information` VALUES ('河北省', '石家庄市');
INSERT INTO `city_information` VALUES ('河北省', '秦皇岛市');
INSERT INTO `city_information` VALUES ('河北省', '衡水市');
INSERT INTO `city_information` VALUES ('河北省', '辛集市');
INSERT INTO `city_information` VALUES ('河北省', '迁安市');
INSERT INTO `city_information` VALUES ('河北省', '遵化市');
INSERT INTO `city_information` VALUES ('河北省', '邢台市');
INSERT INTO `city_information` VALUES ('河北省', '邯郸市');
INSERT INTO `city_information` VALUES ('河北省', '霸州市');
INSERT INTO `city_information` VALUES ('河北省', '高碑店市');
INSERT INTO `city_information` VALUES ('河北省', '黄骅市');
INSERT INTO `city_information` VALUES ('河南省', '三门峡市');
INSERT INTO `city_information` VALUES ('河南省', '义马市');
INSERT INTO `city_information` VALUES ('河南省', '信阳市');
INSERT INTO `city_information` VALUES ('河南省', '偃师市');
INSERT INTO `city_information` VALUES ('河南省', '南阳市');
INSERT INTO `city_information` VALUES ('河南省', '卫辉市');
INSERT INTO `city_information` VALUES ('河南省', '周口市');
INSERT INTO `city_information` VALUES ('河南省', '商丘市');
INSERT INTO `city_information` VALUES ('河南省', '孟州市');
INSERT INTO `city_information` VALUES ('河南省', '安阳市');
INSERT INTO `city_information` VALUES ('河南省', '巩义市');
INSERT INTO `city_information` VALUES ('河南省', '平顶山市');
INSERT INTO `city_information` VALUES ('河南省', '开封市');
INSERT INTO `city_information` VALUES ('河南省', '新乡市');
INSERT INTO `city_information` VALUES ('河南省', '新密市');
INSERT INTO `city_information` VALUES ('河南省', '新郑市');
INSERT INTO `city_information` VALUES ('河南省', '林州市');
INSERT INTO `city_information` VALUES ('河南省', '永城市');
INSERT INTO `city_information` VALUES ('河南省', '汝州市');
INSERT INTO `city_information` VALUES ('河南省', '沁阳市');
INSERT INTO `city_information` VALUES ('河南省', '洛阳市');
INSERT INTO `city_information` VALUES ('河南省', '济源市');
INSERT INTO `city_information` VALUES ('河南省', '漯河市');
INSERT INTO `city_information` VALUES ('河南省', '濮阳市');
INSERT INTO `city_information` VALUES ('河南省', '灵宝市');
INSERT INTO `city_information` VALUES ('河南省', '焦作市');
INSERT INTO `city_information` VALUES ('河南省', '登封市');
INSERT INTO `city_information` VALUES ('河南省', '禹州市');
INSERT INTO `city_information` VALUES ('河南省', '舞钢市');
INSERT INTO `city_information` VALUES ('河南省', '荥阳市');
INSERT INTO `city_information` VALUES ('河南省', '许昌市');
INSERT INTO `city_information` VALUES ('河南省', '辉县市');
INSERT INTO `city_information` VALUES ('河南省', '邓州市');
INSERT INTO `city_information` VALUES ('河南省', '郑州市');
INSERT INTO `city_information` VALUES ('河南省', '长葛市');
INSERT INTO `city_information` VALUES ('河南省', '项城市');
INSERT INTO `city_information` VALUES ('河南省', '驻马店市');
INSERT INTO `city_information` VALUES ('河南省', '鹤壁市');
INSERT INTO `city_information` VALUES ('浙江省', '东阳市');
INSERT INTO `city_information` VALUES ('浙江省', '临安市');
INSERT INTO `city_information` VALUES ('浙江省', '临海市');
INSERT INTO `city_information` VALUES ('浙江省', '丽水市');
INSERT INTO `city_information` VALUES ('浙江省', '义乌市');
INSERT INTO `city_information` VALUES ('浙江省', '乐清市');
INSERT INTO `city_information` VALUES ('浙江省', '余姚市');
INSERT INTO `city_information` VALUES ('浙江省', '兰溪市');
INSERT INTO `city_information` VALUES ('浙江省', '台州市');
INSERT INTO `city_information` VALUES ('浙江省', '嘉兴市');
INSERT INTO `city_information` VALUES ('浙江省', '宁波市');
INSERT INTO `city_information` VALUES ('浙江省', '嵊州市');
INSERT INTO `city_information` VALUES ('浙江省', '平湖市');
INSERT INTO `city_information` VALUES ('浙江省', '建德市');
INSERT INTO `city_information` VALUES ('浙江省', '慈溪市');
INSERT INTO `city_information` VALUES ('浙江省', '杭州市');
INSERT INTO `city_information` VALUES ('浙江省', '桐乡市');
INSERT INTO `city_information` VALUES ('浙江省', '永康市');
INSERT INTO `city_information` VALUES ('浙江省', '江山市');
INSERT INTO `city_information` VALUES ('浙江省', '海宁市');
INSERT INTO `city_information` VALUES ('浙江省', '温岭市');
INSERT INTO `city_information` VALUES ('浙江省', '温州市');
INSERT INTO `city_information` VALUES ('浙江省', '湖州市');
INSERT INTO `city_information` VALUES ('浙江省', '瑞安市');
INSERT INTO `city_information` VALUES ('浙江省', '绍兴市');
INSERT INTO `city_information` VALUES ('浙江省', '舟山市');
INSERT INTO `city_information` VALUES ('浙江省', '衢州市');
INSERT INTO `city_information` VALUES ('浙江省', '诸暨市');
INSERT INTO `city_information` VALUES ('浙江省', '金华市');
INSERT INTO `city_information` VALUES ('浙江省', '龙泉市');
INSERT INTO `city_information` VALUES ('海南省', '万宁市');
INSERT INTO `city_information` VALUES ('海南省', '三亚市');
INSERT INTO `city_information` VALUES ('海南省', '三沙市');
INSERT INTO `city_information` VALUES ('海南省', '东方市');
INSERT INTO `city_information` VALUES ('海南省', '五指山市');
INSERT INTO `city_information` VALUES ('海南省', '儋州市');
INSERT INTO `city_information` VALUES ('海南省', '文昌市');
INSERT INTO `city_information` VALUES ('海南省', '海口市');
INSERT INTO `city_information` VALUES ('海南省', '琼海市');
INSERT INTO `city_information` VALUES ('湖北省', '丹江口市');
INSERT INTO `city_information` VALUES ('湖北省', '仙桃市');
INSERT INTO `city_information` VALUES ('湖北省', '利川市');
INSERT INTO `city_information` VALUES ('湖北省', '十堰市');
INSERT INTO `city_information` VALUES ('湖北省', '咸宁市');
INSERT INTO `city_information` VALUES ('湖北省', '大冶市');
INSERT INTO `city_information` VALUES ('湖北省', '天门市');
INSERT INTO `city_information` VALUES ('湖北省', '孝感市');
INSERT INTO `city_information` VALUES ('湖北省', '安陆市');
INSERT INTO `city_information` VALUES ('湖北省', '宜城市');
INSERT INTO `city_information` VALUES ('湖北省', '宜昌市');
INSERT INTO `city_information` VALUES ('湖北省', '宜都市');
INSERT INTO `city_information` VALUES ('湖北省', '广水市');
INSERT INTO `city_information` VALUES ('湖北省', '应城市');
INSERT INTO `city_information` VALUES ('湖北省', '当阳市');
INSERT INTO `city_information` VALUES ('湖北省', '恩施市');
INSERT INTO `city_information` VALUES ('湖北省', '松滋市');
INSERT INTO `city_information` VALUES ('湖北省', '枝江市');
INSERT INTO `city_information` VALUES ('湖北省', '枣阳市');
INSERT INTO `city_information` VALUES ('湖北省', '武汉市');
INSERT INTO `city_information` VALUES ('湖北省', '武穴市');
INSERT INTO `city_information` VALUES ('湖北省', '汉川市');
INSERT INTO `city_information` VALUES ('湖北省', '洪湖市');
INSERT INTO `city_information` VALUES ('湖北省', '潜江市');
INSERT INTO `city_information` VALUES ('湖北省', '石首市');
INSERT INTO `city_information` VALUES ('湖北省', '老河口市');
INSERT INTO `city_information` VALUES ('湖北省', '荆州市');
INSERT INTO `city_information` VALUES ('湖北省', '荆门市');
INSERT INTO `city_information` VALUES ('湖北省', '襄阳市');
INSERT INTO `city_information` VALUES ('湖北省', '赤壁市');
INSERT INTO `city_information` VALUES ('湖北省', '鄂州市');
INSERT INTO `city_information` VALUES ('湖北省', '钟祥市');
INSERT INTO `city_information` VALUES ('湖北省', '随州市');
INSERT INTO `city_information` VALUES ('湖北省', '麻城市');
INSERT INTO `city_information` VALUES ('湖北省', '黄冈市');
INSERT INTO `city_information` VALUES ('湖北省', '黄石市');
INSERT INTO `city_information` VALUES ('湖南省', '临湘市');
INSERT INTO `city_information` VALUES ('湖南省', '冷水江市');
INSERT INTO `city_information` VALUES ('湖南省', '吉首市');
INSERT INTO `city_information` VALUES ('湖南省', '娄底市');
INSERT INTO `city_information` VALUES ('湖南省', '岳阳市');
INSERT INTO `city_information` VALUES ('湖南省', '常宁市');
INSERT INTO `city_information` VALUES ('湖南省', '常德市');
INSERT INTO `city_information` VALUES ('湖南省', '张家界市');
INSERT INTO `city_information` VALUES ('湖南省', '怀化市');
INSERT INTO `city_information` VALUES ('湖南省', '株洲市');
INSERT INTO `city_information` VALUES ('湖南省', '武冈市');
INSERT INTO `city_information` VALUES ('湖南省', '永州市');
INSERT INTO `city_information` VALUES ('湖南省', '汨罗市');
INSERT INTO `city_information` VALUES ('湖南省', '沅江市');
INSERT INTO `city_information` VALUES ('湖南省', '津市市');
INSERT INTO `city_information` VALUES ('湖南省', '洪江市');
INSERT INTO `city_information` VALUES ('湖南省', '浏阳市');
INSERT INTO `city_information` VALUES ('湖南省', '涟源市');
INSERT INTO `city_information` VALUES ('湖南省', '湘乡市');
INSERT INTO `city_information` VALUES ('湖南省', '湘潭市');
INSERT INTO `city_information` VALUES ('湖南省', '益阳市');
INSERT INTO `city_information` VALUES ('湖南省', '耒阳市');
INSERT INTO `city_information` VALUES ('湖南省', '衡阳市');
INSERT INTO `city_information` VALUES ('湖南省', '资兴市');
INSERT INTO `city_information` VALUES ('湖南省', '邵阳市');
INSERT INTO `city_information` VALUES ('湖南省', '郴州市');
INSERT INTO `city_information` VALUES ('湖南省', '醴陵市');
INSERT INTO `city_information` VALUES ('湖南省', '长沙市');
INSERT INTO `city_information` VALUES ('湖南省', '韶山市');
INSERT INTO `city_information` VALUES ('澳门', '澳门特别行政区');
INSERT INTO `city_information` VALUES ('甘肃省', '临夏市');
INSERT INTO `city_information` VALUES ('甘肃省', '兰州市');
INSERT INTO `city_information` VALUES ('甘肃省', '合作市');
INSERT INTO `city_information` VALUES ('甘肃省', '嘉峪关市');
INSERT INTO `city_information` VALUES ('甘肃省', '天水市');
INSERT INTO `city_information` VALUES ('甘肃省', '定西市');
INSERT INTO `city_information` VALUES ('甘肃省', '平凉市');
INSERT INTO `city_information` VALUES ('甘肃省', '庆阳市');
INSERT INTO `city_information` VALUES ('甘肃省', '张掖市');
INSERT INTO `city_information` VALUES ('甘肃省', '敦煌市');
INSERT INTO `city_information` VALUES ('甘肃省', '武威市');
INSERT INTO `city_information` VALUES ('甘肃省', '玉门市');
INSERT INTO `city_information` VALUES ('甘肃省', '白银市');
INSERT INTO `city_information` VALUES ('甘肃省', '酒泉市');
INSERT INTO `city_information` VALUES ('甘肃省', '金昌市');
INSERT INTO `city_information` VALUES ('甘肃省', '陇南市');
INSERT INTO `city_information` VALUES ('福建省', '三明市');
INSERT INTO `city_information` VALUES ('福建省', '南安市');
INSERT INTO `city_information` VALUES ('福建省', '南平市');
INSERT INTO `city_information` VALUES ('福建省', '厦门市');
INSERT INTO `city_information` VALUES ('福建省', '宁德市');
INSERT INTO `city_information` VALUES ('福建省', '建瓯市');
INSERT INTO `city_information` VALUES ('福建省', '晋江市');
INSERT INTO `city_information` VALUES ('福建省', '武夷山市');
INSERT INTO `city_information` VALUES ('福建省', '永安市');
INSERT INTO `city_information` VALUES ('福建省', '泉州市');
INSERT INTO `city_information` VALUES ('福建省', '漳州市');
INSERT INTO `city_information` VALUES ('福建省', '漳平市');
INSERT INTO `city_information` VALUES ('福建省', '石狮市');
INSERT INTO `city_information` VALUES ('福建省', '福安市');
INSERT INTO `city_information` VALUES ('福建省', '福州市');
INSERT INTO `city_information` VALUES ('福建省', '福清市');
INSERT INTO `city_information` VALUES ('福建省', '福鼎市');
INSERT INTO `city_information` VALUES ('福建省', '莆田市');
INSERT INTO `city_information` VALUES ('福建省', '邵武市');
INSERT INTO `city_information` VALUES ('福建省', '长乐市');
INSERT INTO `city_information` VALUES ('福建省', '龙岩市');
INSERT INTO `city_information` VALUES ('福建省', '龙海市');
INSERT INTO `city_information` VALUES ('西藏自治区', '山南市');
INSERT INTO `city_information` VALUES ('西藏自治区', '拉萨市');
INSERT INTO `city_information` VALUES ('西藏自治区', '日喀则市');
INSERT INTO `city_information` VALUES ('西藏自治区', '昌都市');
INSERT INTO `city_information` VALUES ('西藏自治区', '林芝市');
INSERT INTO `city_information` VALUES ('贵州省', '仁怀市');
INSERT INTO `city_information` VALUES ('贵州省', '六盘水市');
INSERT INTO `city_information` VALUES ('贵州省', '兴义市');
INSERT INTO `city_information` VALUES ('贵州省', '凯里市');
INSERT INTO `city_information` VALUES ('贵州省', '安顺市');
INSERT INTO `city_information` VALUES ('贵州省', '毕节市');
INSERT INTO `city_information` VALUES ('贵州省', '清镇市');
INSERT INTO `city_information` VALUES ('贵州省', '福泉市');
INSERT INTO `city_information` VALUES ('贵州省', '贵阳市');
INSERT INTO `city_information` VALUES ('贵州省', '赤水市');
INSERT INTO `city_information` VALUES ('贵州省', '遵义市');
INSERT INTO `city_information` VALUES ('贵州省', '都匀市');
INSERT INTO `city_information` VALUES ('贵州省', '铜仁市');
INSERT INTO `city_information` VALUES ('辽宁省', '东港市');
INSERT INTO `city_information` VALUES ('辽宁省', '丹东市');
INSERT INTO `city_information` VALUES ('辽宁省', '兴城市');
INSERT INTO `city_information` VALUES ('辽宁省', '凌海市');
INSERT INTO `city_information` VALUES ('辽宁省', '凌源市');
INSERT INTO `city_information` VALUES ('辽宁省', '凤城市');
INSERT INTO `city_information` VALUES ('辽宁省', '北票市');
INSERT INTO `city_information` VALUES ('辽宁省', '北镇市');
INSERT INTO `city_information` VALUES ('辽宁省', '大石桥市');
INSERT INTO `city_information` VALUES ('辽宁省', '大连市');
INSERT INTO `city_information` VALUES ('辽宁省', '庄河市');
INSERT INTO `city_information` VALUES ('辽宁省', '开原市');
INSERT INTO `city_information` VALUES ('辽宁省', '抚顺市');
INSERT INTO `city_information` VALUES ('辽宁省', '新民市');
INSERT INTO `city_information` VALUES ('辽宁省', '朝阳市');
INSERT INTO `city_information` VALUES ('辽宁省', '本溪市');
INSERT INTO `city_information` VALUES ('辽宁省', '沈阳市');
INSERT INTO `city_information` VALUES ('辽宁省', '海城市');
INSERT INTO `city_information` VALUES ('辽宁省', '灯塔市');
INSERT INTO `city_information` VALUES ('辽宁省', '瓦房店市');
INSERT INTO `city_information` VALUES ('辽宁省', '盖州市');
INSERT INTO `city_information` VALUES ('辽宁省', '盘锦市');
INSERT INTO `city_information` VALUES ('辽宁省', '营口市');
INSERT INTO `city_information` VALUES ('辽宁省', '葫芦岛市');
INSERT INTO `city_information` VALUES ('辽宁省', '调兵山市');
INSERT INTO `city_information` VALUES ('辽宁省', '辽阳市');
INSERT INTO `city_information` VALUES ('辽宁省', '铁岭市');
INSERT INTO `city_information` VALUES ('辽宁省', '锦州市');
INSERT INTO `city_information` VALUES ('辽宁省', '阜新市');
INSERT INTO `city_information` VALUES ('辽宁省', '鞍山市');
INSERT INTO `city_information` VALUES ('重庆市', '重庆市');
INSERT INTO `city_information` VALUES ('陕西省', '兴平');
INSERT INTO `city_information` VALUES ('陕西省', '华阴');
INSERT INTO `city_information` VALUES ('陕西省', '咸阳市');
INSERT INTO `city_information` VALUES ('陕西省', '商洛市');
INSERT INTO `city_information` VALUES ('陕西省', '安康市');
INSERT INTO `city_information` VALUES ('陕西省', '宝鸡市');
INSERT INTO `city_information` VALUES ('陕西省', '延安市');
INSERT INTO `city_information` VALUES ('陕西省', '榆林市');
INSERT INTO `city_information` VALUES ('陕西省', '汉中市');
INSERT INTO `city_information` VALUES ('陕西省', '渭南市');
INSERT INTO `city_information` VALUES ('陕西省', '西安市');
INSERT INTO `city_information` VALUES ('陕西省', '铜川市');
INSERT INTO `city_information` VALUES ('陕西省', '韩城');
INSERT INTO `city_information` VALUES ('青海省', '德令哈市');
INSERT INTO `city_information` VALUES ('青海省', '格尔木市');
INSERT INTO `city_information` VALUES ('青海省', '海东市');
INSERT INTO `city_information` VALUES ('青海省', '玉树市');
INSERT INTO `city_information` VALUES ('青海省', '西宁市');
INSERT INTO `city_information` VALUES ('香港', '香港特别行政区');
INSERT INTO `city_information` VALUES ('黑龙江省', '七台河市');
INSERT INTO `city_information` VALUES ('黑龙江省', '东宁市');
INSERT INTO `city_information` VALUES ('黑龙江省', '五大连池市');
INSERT INTO `city_information` VALUES ('黑龙江省', '五常市');
INSERT INTO `city_information` VALUES ('黑龙江省', '伊春市');
INSERT INTO `city_information` VALUES ('黑龙江省', '佳木斯市');
INSERT INTO `city_information` VALUES ('黑龙江省', '北安市');
INSERT INTO `city_information` VALUES ('黑龙江省', '双鸭山市');
INSERT INTO `city_information` VALUES ('黑龙江省', '同江市');
INSERT INTO `city_information` VALUES ('黑龙江省', '哈尔滨市');
INSERT INTO `city_information` VALUES ('黑龙江省', '大庆市');
INSERT INTO `city_information` VALUES ('黑龙江省', '宁安市');
INSERT INTO `city_information` VALUES ('黑龙江省', '安达市');
INSERT INTO `city_information` VALUES ('黑龙江省', '密山市');
INSERT INTO `city_information` VALUES ('黑龙江省', '富锦市');
INSERT INTO `city_information` VALUES ('黑龙江省', '尚志市');
INSERT INTO `city_information` VALUES ('黑龙江省', '抚远市');
INSERT INTO `city_information` VALUES ('黑龙江省', '海伦市');
INSERT INTO `city_information` VALUES ('黑龙江省', '海林市');
INSERT INTO `city_information` VALUES ('黑龙江省', '牡丹江市');
INSERT INTO `city_information` VALUES ('黑龙江省', '穆棱市');
INSERT INTO `city_information` VALUES ('黑龙江省', '绥化市');
INSERT INTO `city_information` VALUES ('黑龙江省', '绥芬河市');
INSERT INTO `city_information` VALUES ('黑龙江省', '肇东市');
INSERT INTO `city_information` VALUES ('黑龙江省', '虎林市');
INSERT INTO `city_information` VALUES ('黑龙江省', '讷河市');
INSERT INTO `city_information` VALUES ('黑龙江省', '铁力市');
INSERT INTO `city_information` VALUES ('黑龙江省', '鸡西市');
INSERT INTO `city_information` VALUES ('黑龙江省', '鹤岗市');
INSERT INTO `city_information` VALUES ('黑龙江省', '黑河市');
INSERT INTO `city_information` VALUES ('黑龙江省', '齐齐哈尔市');

-- ----------------------------
-- Table structure for flight_information
-- ----------------------------
DROP TABLE IF EXISTS `flight_information`;
CREATE TABLE `flight_information` (
  `flight_number` varchar(255) NOT NULL COMMENT '航班号',
  `date` date NOT NULL COMMENT '当天日期',
  `flight_line_id` int(255) NOT NULL COMMENT '航线号',
  `airplane_id` int(11) NOT NULL COMMENT '飞机号',
  `departure_time` datetime NOT NULL COMMENT '起始时间',
  `boarding_time` datetime DEFAULT NULL COMMENT '中转时间',
  `arrival_time` datetime NOT NULL COMMENT '到达时间',
  PRIMARY KEY (`flight_number`,`date`),
  KEY `flight_number` (`flight_number`),
  KEY `date` (`date`),
  KEY `airplane_id` (`airplane_id`),
  KEY `flight_line_id` (`flight_line_id`),
  CONSTRAINT `flight_information_ibfk_1` FOREIGN KEY (`airplane_id`) REFERENCES `airplane` (`airplane_id`),
  CONSTRAINT `flight_information_ibfk_2` FOREIGN KEY (`flight_line_id`) REFERENCES `flight_line` (`flight_line_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of flight_information
-- ----------------------------
INSERT INTO `flight_information` VALUES ('CZ3256', '2020-06-04', '3', '8', '2020-06-04 16:03:46', null, '2020-06-04 21:04:18');
INSERT INTO `flight_information` VALUES ('MF3250', '2020-06-04', '3', '1', '2020-06-04 08:06:04', null, '2020-06-04 15:11:24');

-- ----------------------------
-- Table structure for flight_line
-- ----------------------------
DROP TABLE IF EXISTS `flight_line`;
CREATE TABLE `flight_line` (
  `flight_line_id` int(255) NOT NULL AUTO_INCREMENT COMMENT '航线id',
  `flight_line_type` varchar(255) NOT NULL,
  `from` varchar(255) NOT NULL COMMENT '起始点',
  `to` varchar(255) NOT NULL COMMENT '目的地',
  `stopover` varchar(255) DEFAULT NULL COMMENT '经停地点',
  `departure_airport` varchar(255) NOT NULL,
  `boarding_airport` varchar(255) DEFAULT NULL,
  `arrival_airport` varchar(255) NOT NULL,
  PRIMARY KEY (`flight_line_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of flight_line
-- ----------------------------
INSERT INTO `flight_line` VALUES ('1', '国内', '北京', '广州', '上海', '首都机场', '浦东机场', '白云机场');
INSERT INTO `flight_line` VALUES ('2', '国内', '北京', '上海', '天津', '首都机场', '滨海机场', '浦东机场');
INSERT INTO `flight_line` VALUES ('3', '国内', '北京市', '海口市', null, '首都机场', null, '美兰机场');
INSERT INTO `flight_line` VALUES ('4', '国内', '海口', '北京', null, '美兰机场', null, '首都机场');
INSERT INTO `flight_line` VALUES ('5', '国内', '广州', '北京', '上海', '白云机场', '浦东机场', '首都机场');
INSERT INTO `flight_line` VALUES ('6', '国内', '上海', '北京', '天津', '浦东机场', '首都机场', '首都机场');
INSERT INTO `flight_line` VALUES ('7', '国内', '郑州', '海口', null, '新郑机场', null, '美兰机场');

-- ----------------------------
-- Table structure for flight_price
-- ----------------------------
DROP TABLE IF EXISTS `flight_price`;
CREATE TABLE `flight_price` (
  `flight_number` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `type` varchar(255) NOT NULL COMMENT '舱位等级',
  `price` double DEFAULT NULL COMMENT '价格',
  PRIMARY KEY (`flight_number`,`date`,`type`),
  KEY `fk_flight_number` (`flight_number`) USING BTREE,
  KEY `flight_price_ibfk_1` (`date`),
  CONSTRAINT `fk_flight_number` FOREIGN KEY (`flight_number`) REFERENCES `flight_information` (`flight_number`),
  CONSTRAINT `flight_price_ibfk_1` FOREIGN KEY (`date`) REFERENCES `flight_information` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of flight_price
-- ----------------------------
INSERT INTO `flight_price` VALUES ('CZ3256', '2020-06-04', '头等舱', '1450');
INSERT INTO `flight_price` VALUES ('CZ3256', '2020-06-04', '经济舱', '1000');
INSERT INTO `flight_price` VALUES ('MF3250', '2020-06-04', '头等舱', '1560');
INSERT INTO `flight_price` VALUES ('MF3250', '2020-06-04', '经济舱', '1200');

-- ----------------------------
-- Table structure for flight_seat
-- ----------------------------
DROP TABLE IF EXISTS `flight_seat`;
CREATE TABLE `flight_seat` (
  `flight_number` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `type` varchar(255) NOT NULL COMMENT '舱位等级',
  `seat` varchar(255) NOT NULL COMMENT '座位号',
  `status` varchar(255) DEFAULT NULL,
  `airplane_id` int(11) DEFAULT NULL COMMENT '飞机号',
  `booking_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`flight_number`,`date`,`type`,`seat`),
  KEY `seat` (`seat`),
  KEY `fk_booking_id` (`booking_id`),
  KEY `airplane_id` (`airplane_id`),
  KEY `type` (`type`) USING BTREE,
  KEY `flight_seat_ibfk_2` (`date`),
  CONSTRAINT `fk_booking_id` FOREIGN KEY (`booking_id`) REFERENCES `booking_information` (`booking_id`),
  CONSTRAINT `flight_number` FOREIGN KEY (`flight_number`) REFERENCES `flight_information` (`flight_number`),
  CONSTRAINT `flight_seat_ibfk_1` FOREIGN KEY (`airplane_id`) REFERENCES `seat_information` (`airplane_id`),
  CONSTRAINT `flight_seat_ibfk_2` FOREIGN KEY (`date`) REFERENCES `flight_information` (`date`),
  CONSTRAINT `seat` FOREIGN KEY (`seat`) REFERENCES `seat_information` (`seat`),
  CONSTRAINT `type` FOREIGN KEY (`type`) REFERENCES `seat_information` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of flight_seat
-- ----------------------------
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1A', '是', '8', 'CF12345678');
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1B', '是', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1C', '是', '8', '1591496391130');
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '1F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '2F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '3F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '4F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '头等舱', '5F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '1F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '2F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '3F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '4F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5A', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5B', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5C', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5D', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5E', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('CZ3256', '2020-06-04', '经济舱', '5F', '否', '8', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1A', '否', '1', 'CD12345689');
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '1F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '2F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '3F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '4F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '头等舱', '5F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '1F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '2F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '3F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '4F', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5A', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5B', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5C', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5D', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5E', '否', '1', null);
INSERT INTO `flight_seat` VALUES ('MF3250', '2020-06-04', '经济舱', '5F', '否', '1', null);

-- ----------------------------
-- Table structure for notice_information
-- ----------------------------
DROP TABLE IF EXISTS `notice_information`;
CREATE TABLE `notice_information` (
  `notice_id` varchar(255) NOT NULL COMMENT '取票通知号',
  `booking_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`notice_id`),
  KEY `booking_id` (`booking_id`),
  CONSTRAINT `notice_information_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `booking_information` (`booking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notice_information
-- ----------------------------

-- ----------------------------
-- Table structure for pay_information
-- ----------------------------
DROP TABLE IF EXISTS `pay_information`;
CREATE TABLE `pay_information` (
  `pay_id` varchar(255) NOT NULL,
  `booking_id` varchar(255) NOT NULL,
  `pay_account` varchar(255) DEFAULT NULL COMMENT '支付账号',
  `pay_type` varchar(255) DEFAULT NULL COMMENT '支付类型',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  PRIMARY KEY (`pay_id`),
  KEY `booking_id` (`booking_id`),
  CONSTRAINT `pay_information_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `booking_information` (`booking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of pay_information
-- ----------------------------
INSERT INTO `pay_information` VALUES ('1', 'CF12345678', 'wx2398314304', '微信', '2020-05-27 00:00:00');
INSERT INTO `pay_information` VALUES ('2', 'CD12345689', null, null, null);

-- ----------------------------
-- Table structure for seat_information
-- ----------------------------
DROP TABLE IF EXISTS `seat_information`;
CREATE TABLE `seat_information` (
  `airplane_id` int(255) NOT NULL COMMENT '飞机id',
  `type` varchar(255) NOT NULL COMMENT '舱位等级',
  `seat` varchar(255) NOT NULL COMMENT '座位号',
  `row` int(255) NOT NULL COMMENT '行',
  `col` varchar(255) NOT NULL COMMENT '列',
  PRIMARY KEY (`airplane_id`,`type`,`seat`),
  KEY `seat` (`seat`) USING BTREE,
  KEY `airplane_id` (`airplane_id`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  CONSTRAINT `fk_airplane_id` FOREIGN KEY (`airplane_id`) REFERENCES `airplane` (`airplane_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of seat_information
-- ----------------------------
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('1', '头等舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('1', '经济舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('2', '头等舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('2', '经济舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('6', '商务舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('6', '头等舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('6', '经济舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('8', '头等舱', '5F', '5', 'F');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1A', '1', 'A');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1B', '1', 'B');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1C', '1', 'C');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1D', '1', 'D');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1E', '1', 'E');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '1F', '1', 'F');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2A', '2', 'A');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2B', '2', 'B');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2C', '2', 'C');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2D', '2', 'D');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2E', '2', 'E');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '2F', '2', 'F');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3A', '3', 'A');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3B', '3', 'B');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3C', '3', 'C');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3D', '3', 'D');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3E', '3', 'E');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '3F', '3', 'F');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4A', '4', 'A');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4B', '4', 'B');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4C', '4', 'C');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4D', '4', 'D');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4E', '4', 'E');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '4F', '4', 'F');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5A', '5', 'A');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5B', '5', 'B');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5C', '5', 'C');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5D', '5', 'D');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5E', '5', 'E');
INSERT INTO `seat_information` VALUES ('8', '经济舱', '5F', '5', 'F');

-- ----------------------------
-- Table structure for user_information
-- ----------------------------
DROP TABLE IF EXISTS `user_information`;
CREATE TABLE `user_information` (
  `phone_number` varchar(20) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_id_card` varchar(255) NOT NULL,
  `is_manager` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `eMail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`phone_number`),
  KEY `user_name` (`user_name`),
  KEY `user_id_card` (`user_id_card`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_information
-- ----------------------------
INSERT INTO `user_information` VALUES ('15622327783', '翁雯璇', '202cb962ac59075b964b07152d234b70', '445121', 'yes', 'female', '广东省潮州市', '2398314304@qq.com');
INSERT INTO `user_information` VALUES ('15622458863', '潘雨萱', '202cb962ac59075b964b07152d234b70', '4451211875', 'no', 'female', '广东潮州', '2098389423@qq.com');
INSERT INTO `user_information` VALUES ('15816522329', '潘华琐', '202cb962ac59075b964b07152d234b70', '4451211865', 'no', 'female', '广东', '2097601423@qq.com');
INSERT INTO `user_information` VALUES ('15816561669', '潘猪猪', '202cb962ac59075b964b07152d234b70', '4451211994', 'no', 'male', '广东省广州市', '2385641230@qq.com');
INSERT INTO `user_information` VALUES ('15913022345', '潘璇璇', '202cb962ac59075b964b07152d234b70', '4451211882', 'no', 'female', '广东省汕头市', '3456213782@163.com');
INSERT INTO `user_information` VALUES ('15913025648', '潘小妹', '202cb962ac59075b964b07152d234b70', '4451211890', 'no', 'female', '广东省茂名市', '2098301693@qq.com');