/*
Navicat MySQL Data Transfer

Source Server         : guo
Source Server Version : 50610
Source Host           : localhost:3306
Source Database       : my12306

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

Date: 2017-09-19 20:41:16
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `aid` int(255) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `roleid` int(11) DEFAULT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'lily1995', 'e3ceb5881a0a1fdaad01296d7554868d', '1');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `oid` int(11) NOT NULL AUTO_INCREMENT,
  `onumber` varchar(255) NOT NULL COMMENT '订单编号',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `trainno` varchar(255) NOT NULL COMMENT '车次',
  `departure_time` datetime NOT NULL COMMENT '列车出发日期',
  `sell_time` datetime NOT NULL COMMENT '购票日期',
  `arrival_time` datetime NOT NULL COMMENT '预计到达时间',
  `dstation` varchar(255) NOT NULL COMMENT '始发站',
  `terminal` varchar(255) NOT NULL COMMENT '终点站',
  `price` double NOT NULL COMMENT '车票',
  `carriage` int(11) NOT NULL COMMENT '车厢号',
  `seatno` varchar(255) NOT NULL COMMENT '座位号',
  `state` int(11) NOT NULL COMMENT '订单状态（1,未付款2，已付款3，已退款4，已取票）',
  `tid` int(11) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', '201709120916121', '1', 'G7023', '2017-09-12 09:17:15', '2017-09-10 09:17:30', '2017-09-12 10:20:44', '南京南', '苏州', '100', '1', '01A', '3', null, null);
INSERT INTO `orders` VALUES ('23', '201782016151241', '24', 'G111', '2017-09-23 15:29:06', '2017-09-19 16:15:12', '2017-09-23 16:29:12', '南京', '苏州', '100', '1', '1A', '4', '6', '452');
INSERT INTO `orders` VALUES ('24', '201782016205855', '24', 'G111', '2017-09-23 15:29:06', '2017-09-19 16:20:58', '2017-09-23 16:29:12', '南京', '苏州', '100', '1', '1B', '3', '6', '453');
INSERT INTO `orders` VALUES ('25', '20178201621245', '24', 'G111', '2017-09-23 15:29:06', '2017-09-19 16:21:02', '2017-09-23 16:29:12', '南京', '苏州', '100', '1', '1C', '1', '6', '454');

-- ----------------------------
-- Table structure for privileges
-- ----------------------------
DROP TABLE IF EXISTS `privileges`;
CREATE TABLE `privileges` (
  `pid` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `url` varchar(255) NOT NULL COMMENT '路径',
  `describe` varchar(255) DEFAULT NULL COMMENT '权限描述',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of privileges
-- ----------------------------
INSERT INTO `privileges` VALUES ('1', 'Orders/queryByOid', 'test');
INSERT INTO `privileges` VALUES ('2', 'Orders/getAll', null);
INSERT INTO `privileges` VALUES ('3', 'Orders/check', null);
INSERT INTO `privileges` VALUES ('4', 'Orders/doGet', null);
INSERT INTO `privileges` VALUES ('5', 'Orders/cancelOrder', null);
INSERT INTO `privileges` VALUES ('6', 'Orders/payOrder', null);
INSERT INTO `privileges` VALUES ('7', 'Orders/printOrder', null);
INSERT INTO `privileges` VALUES ('8', 'Train/add', null);
INSERT INTO `privileges` VALUES ('9', 'Train/cancelTrain', null);
INSERT INTO `privileges` VALUES ('10', 'Train/pageGatagrid', null);
INSERT INTO `privileges` VALUES ('11', 'Train/queryByTrainno', null);
INSERT INTO `privileges` VALUES ('12', 'Admin/doLogin', null);
INSERT INTO `privileges` VALUES ('13', 'Admin/addAdmin', null);
INSERT INTO `privileges` VALUES ('14', 'Admin/ValidateCode', null);
INSERT INTO `privileges` VALUES ('15', 'Admin/editPassword', null);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `rid` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `rname` varchar(255) NOT NULL COMMENT '角色描述',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', 'root');
INSERT INTO `role` VALUES ('2', 'manager');
INSERT INTO `role` VALUES ('3', 'user');

-- ----------------------------
-- Table structure for role_priv
-- ----------------------------
DROP TABLE IF EXISTS `role_priv`;
CREATE TABLE `role_priv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL COMMENT '角色id',
  `pid` int(11) NOT NULL COMMENT '权限id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_priv
-- ----------------------------
INSERT INTO `role_priv` VALUES ('1', '3', '1');
INSERT INTO `role_priv` VALUES ('2', '3', '2');
INSERT INTO `role_priv` VALUES ('3', '3', '3');
INSERT INTO `role_priv` VALUES ('4', '3', '4');
INSERT INTO `role_priv` VALUES ('5', '3', '5');
INSERT INTO `role_priv` VALUES ('6', '3', '6');
INSERT INTO `role_priv` VALUES ('7', '3', '7');
INSERT INTO `role_priv` VALUES ('8', '3', '10');

-- ----------------------------
-- Table structure for seat
-- ----------------------------
DROP TABLE IF EXISTS `seat`;
CREATE TABLE `seat` (
  `sid` int(11) NOT NULL AUTO_INCREMENT COMMENT '座位id',
  `tid` int(11) NOT NULL COMMENT '列车id',
  `carriage` int(11) NOT NULL COMMENT '车厢号',
  `seatno` varchar(255) NOT NULL COMMENT '座位号',
  `state` int(11) NOT NULL COMMENT '状态(1，未买2，已买)',
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=1052 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of seat
-- ----------------------------
INSERT INTO `seat` VALUES ('1', '1', '1', '01A', '2');
INSERT INTO `seat` VALUES ('2', '1', '1', '1A', '2');
INSERT INTO `seat` VALUES ('3', '1', '1', '1B', '2');
INSERT INTO `seat` VALUES ('4', '1', '1', '1C', '2');
INSERT INTO `seat` VALUES ('452', '6', '1', '1A', '2');
INSERT INTO `seat` VALUES ('453', '6', '1', '1B', '2');
INSERT INTO `seat` VALUES ('454', '6', '1', '1C', '2');
INSERT INTO `seat` VALUES ('455', '6', '1', '1D', '1');
INSERT INTO `seat` VALUES ('456', '6', '1', '1F', '1');
INSERT INTO `seat` VALUES ('457', '6', '1', '2A', '1');
INSERT INTO `seat` VALUES ('458', '6', '1', '2B', '1');
INSERT INTO `seat` VALUES ('459', '6', '1', '2C', '1');
INSERT INTO `seat` VALUES ('460', '6', '1', '2D', '1');
INSERT INTO `seat` VALUES ('461', '6', '1', '2F', '1');
INSERT INTO `seat` VALUES ('462', '6', '1', '3A', '1');
INSERT INTO `seat` VALUES ('463', '6', '1', '3B', '1');
INSERT INTO `seat` VALUES ('464', '6', '1', '3C', '1');
INSERT INTO `seat` VALUES ('465', '6', '1', '3D', '1');
INSERT INTO `seat` VALUES ('466', '6', '1', '3F', '1');
INSERT INTO `seat` VALUES ('467', '6', '1', '4A', '1');
INSERT INTO `seat` VALUES ('468', '6', '1', '4B', '1');
INSERT INTO `seat` VALUES ('469', '6', '1', '4C', '1');
INSERT INTO `seat` VALUES ('470', '6', '1', '4D', '1');
INSERT INTO `seat` VALUES ('471', '6', '1', '4F', '1');
INSERT INTO `seat` VALUES ('472', '6', '1', '5A', '1');
INSERT INTO `seat` VALUES ('473', '6', '1', '5B', '1');
INSERT INTO `seat` VALUES ('474', '6', '1', '5C', '1');
INSERT INTO `seat` VALUES ('475', '6', '1', '5D', '1');
INSERT INTO `seat` VALUES ('476', '6', '1', '5F', '1');
INSERT INTO `seat` VALUES ('477', '6', '1', '6A', '1');
INSERT INTO `seat` VALUES ('478', '6', '1', '6B', '1');
INSERT INTO `seat` VALUES ('479', '6', '1', '6C', '1');
INSERT INTO `seat` VALUES ('480', '6', '1', '6D', '1');
INSERT INTO `seat` VALUES ('481', '6', '1', '6F', '1');
INSERT INTO `seat` VALUES ('482', '6', '1', '7A', '1');
INSERT INTO `seat` VALUES ('483', '6', '1', '7B', '1');
INSERT INTO `seat` VALUES ('484', '6', '1', '7C', '1');
INSERT INTO `seat` VALUES ('485', '6', '1', '7D', '1');
INSERT INTO `seat` VALUES ('486', '6', '1', '7F', '1');
INSERT INTO `seat` VALUES ('487', '6', '1', '8A', '1');
INSERT INTO `seat` VALUES ('488', '6', '1', '8B', '1');
INSERT INTO `seat` VALUES ('489', '6', '1', '8C', '1');
INSERT INTO `seat` VALUES ('490', '6', '1', '8D', '1');
INSERT INTO `seat` VALUES ('491', '6', '1', '8F', '1');
INSERT INTO `seat` VALUES ('492', '6', '1', '9A', '1');
INSERT INTO `seat` VALUES ('493', '6', '1', '9B', '1');
INSERT INTO `seat` VALUES ('494', '6', '1', '9C', '1');
INSERT INTO `seat` VALUES ('495', '6', '1', '9D', '1');
INSERT INTO `seat` VALUES ('496', '6', '1', '9F', '1');
INSERT INTO `seat` VALUES ('497', '6', '1', '10A', '1');
INSERT INTO `seat` VALUES ('498', '6', '1', '10B', '1');
INSERT INTO `seat` VALUES ('499', '6', '1', '10C', '1');
INSERT INTO `seat` VALUES ('500', '6', '1', '10D', '1');
INSERT INTO `seat` VALUES ('501', '6', '1', '10F', '1');
INSERT INTO `seat` VALUES ('502', '6', '1', '11A', '1');
INSERT INTO `seat` VALUES ('503', '6', '1', '11B', '1');
INSERT INTO `seat` VALUES ('504', '6', '1', '11C', '1');
INSERT INTO `seat` VALUES ('505', '6', '1', '11D', '1');
INSERT INTO `seat` VALUES ('506', '6', '1', '11F', '1');
INSERT INTO `seat` VALUES ('507', '6', '1', '12A', '1');
INSERT INTO `seat` VALUES ('508', '6', '1', '12B', '1');
INSERT INTO `seat` VALUES ('509', '6', '1', '12C', '1');
INSERT INTO `seat` VALUES ('510', '6', '1', '12D', '1');
INSERT INTO `seat` VALUES ('511', '6', '1', '12F', '1');
INSERT INTO `seat` VALUES ('512', '6', '1', '13A', '1');
INSERT INTO `seat` VALUES ('513', '6', '1', '13B', '1');
INSERT INTO `seat` VALUES ('514', '6', '1', '13C', '1');
INSERT INTO `seat` VALUES ('515', '6', '1', '13D', '1');
INSERT INTO `seat` VALUES ('516', '6', '1', '13F', '1');
INSERT INTO `seat` VALUES ('517', '6', '1', '14A', '1');
INSERT INTO `seat` VALUES ('518', '6', '1', '14B', '1');
INSERT INTO `seat` VALUES ('519', '6', '1', '14C', '1');
INSERT INTO `seat` VALUES ('520', '6', '1', '14D', '1');
INSERT INTO `seat` VALUES ('521', '6', '1', '14F', '1');
INSERT INTO `seat` VALUES ('522', '6', '1', '15A', '1');
INSERT INTO `seat` VALUES ('523', '6', '1', '15B', '1');
INSERT INTO `seat` VALUES ('524', '6', '1', '15C', '1');
INSERT INTO `seat` VALUES ('525', '6', '1', '15D', '1');
INSERT INTO `seat` VALUES ('526', '6', '1', '15F', '1');
INSERT INTO `seat` VALUES ('527', '6', '2', '1A', '1');
INSERT INTO `seat` VALUES ('528', '6', '2', '1B', '1');
INSERT INTO `seat` VALUES ('529', '6', '2', '1C', '1');
INSERT INTO `seat` VALUES ('530', '6', '2', '1D', '1');
INSERT INTO `seat` VALUES ('531', '6', '2', '1F', '1');
INSERT INTO `seat` VALUES ('532', '6', '2', '2A', '1');
INSERT INTO `seat` VALUES ('533', '6', '2', '2B', '1');
INSERT INTO `seat` VALUES ('534', '6', '2', '2C', '1');
INSERT INTO `seat` VALUES ('535', '6', '2', '2D', '1');
INSERT INTO `seat` VALUES ('536', '6', '2', '2F', '1');
INSERT INTO `seat` VALUES ('537', '6', '2', '3A', '1');
INSERT INTO `seat` VALUES ('538', '6', '2', '3B', '1');
INSERT INTO `seat` VALUES ('539', '6', '2', '3C', '1');
INSERT INTO `seat` VALUES ('540', '6', '2', '3D', '1');
INSERT INTO `seat` VALUES ('541', '6', '2', '3F', '1');
INSERT INTO `seat` VALUES ('542', '6', '2', '4A', '1');
INSERT INTO `seat` VALUES ('543', '6', '2', '4B', '1');
INSERT INTO `seat` VALUES ('544', '6', '2', '4C', '1');
INSERT INTO `seat` VALUES ('545', '6', '2', '4D', '1');
INSERT INTO `seat` VALUES ('546', '6', '2', '4F', '1');
INSERT INTO `seat` VALUES ('547', '6', '2', '5A', '1');
INSERT INTO `seat` VALUES ('548', '6', '2', '5B', '1');
INSERT INTO `seat` VALUES ('549', '6', '2', '5C', '1');
INSERT INTO `seat` VALUES ('550', '6', '2', '5D', '1');
INSERT INTO `seat` VALUES ('551', '6', '2', '5F', '1');
INSERT INTO `seat` VALUES ('552', '6', '2', '6A', '1');
INSERT INTO `seat` VALUES ('553', '6', '2', '6B', '1');
INSERT INTO `seat` VALUES ('554', '6', '2', '6C', '1');
INSERT INTO `seat` VALUES ('555', '6', '2', '6D', '1');
INSERT INTO `seat` VALUES ('556', '6', '2', '6F', '1');
INSERT INTO `seat` VALUES ('557', '6', '2', '7A', '1');
INSERT INTO `seat` VALUES ('558', '6', '2', '7B', '1');
INSERT INTO `seat` VALUES ('559', '6', '2', '7C', '1');
INSERT INTO `seat` VALUES ('560', '6', '2', '7D', '1');
INSERT INTO `seat` VALUES ('561', '6', '2', '7F', '1');
INSERT INTO `seat` VALUES ('562', '6', '2', '8A', '1');
INSERT INTO `seat` VALUES ('563', '6', '2', '8B', '1');
INSERT INTO `seat` VALUES ('564', '6', '2', '8C', '1');
INSERT INTO `seat` VALUES ('565', '6', '2', '8D', '1');
INSERT INTO `seat` VALUES ('566', '6', '2', '8F', '1');
INSERT INTO `seat` VALUES ('567', '6', '2', '9A', '1');
INSERT INTO `seat` VALUES ('568', '6', '2', '9B', '1');
INSERT INTO `seat` VALUES ('569', '6', '2', '9C', '1');
INSERT INTO `seat` VALUES ('570', '6', '2', '9D', '1');
INSERT INTO `seat` VALUES ('571', '6', '2', '9F', '1');
INSERT INTO `seat` VALUES ('572', '6', '2', '10A', '1');
INSERT INTO `seat` VALUES ('573', '6', '2', '10B', '1');
INSERT INTO `seat` VALUES ('574', '6', '2', '10C', '1');
INSERT INTO `seat` VALUES ('575', '6', '2', '10D', '1');
INSERT INTO `seat` VALUES ('576', '6', '2', '10F', '1');
INSERT INTO `seat` VALUES ('577', '6', '2', '11A', '1');
INSERT INTO `seat` VALUES ('578', '6', '2', '11B', '1');
INSERT INTO `seat` VALUES ('579', '6', '2', '11C', '1');
INSERT INTO `seat` VALUES ('580', '6', '2', '11D', '1');
INSERT INTO `seat` VALUES ('581', '6', '2', '11F', '1');
INSERT INTO `seat` VALUES ('582', '6', '2', '12A', '1');
INSERT INTO `seat` VALUES ('583', '6', '2', '12B', '1');
INSERT INTO `seat` VALUES ('584', '6', '2', '12C', '1');
INSERT INTO `seat` VALUES ('585', '6', '2', '12D', '1');
INSERT INTO `seat` VALUES ('586', '6', '2', '12F', '1');
INSERT INTO `seat` VALUES ('587', '6', '2', '13A', '1');
INSERT INTO `seat` VALUES ('588', '6', '2', '13B', '1');
INSERT INTO `seat` VALUES ('589', '6', '2', '13C', '1');
INSERT INTO `seat` VALUES ('590', '6', '2', '13D', '1');
INSERT INTO `seat` VALUES ('591', '6', '2', '13F', '1');
INSERT INTO `seat` VALUES ('592', '6', '2', '14A', '1');
INSERT INTO `seat` VALUES ('593', '6', '2', '14B', '1');
INSERT INTO `seat` VALUES ('594', '6', '2', '14C', '1');
INSERT INTO `seat` VALUES ('595', '6', '2', '14D', '1');
INSERT INTO `seat` VALUES ('596', '6', '2', '14F', '1');
INSERT INTO `seat` VALUES ('597', '6', '2', '15A', '1');
INSERT INTO `seat` VALUES ('598', '6', '2', '15B', '1');
INSERT INTO `seat` VALUES ('599', '6', '2', '15C', '1');
INSERT INTO `seat` VALUES ('600', '6', '2', '15D', '1');
INSERT INTO `seat` VALUES ('601', '6', '2', '15F', '1');
INSERT INTO `seat` VALUES ('602', '6', '3', '1A', '1');
INSERT INTO `seat` VALUES ('603', '6', '3', '1B', '1');
INSERT INTO `seat` VALUES ('604', '6', '3', '1C', '1');
INSERT INTO `seat` VALUES ('605', '6', '3', '1D', '1');
INSERT INTO `seat` VALUES ('606', '6', '3', '1F', '1');
INSERT INTO `seat` VALUES ('607', '6', '3', '2A', '1');
INSERT INTO `seat` VALUES ('608', '6', '3', '2B', '1');
INSERT INTO `seat` VALUES ('609', '6', '3', '2C', '1');
INSERT INTO `seat` VALUES ('610', '6', '3', '2D', '1');
INSERT INTO `seat` VALUES ('611', '6', '3', '2F', '1');
INSERT INTO `seat` VALUES ('612', '6', '3', '3A', '1');
INSERT INTO `seat` VALUES ('613', '6', '3', '3B', '1');
INSERT INTO `seat` VALUES ('614', '6', '3', '3C', '1');
INSERT INTO `seat` VALUES ('615', '6', '3', '3D', '1');
INSERT INTO `seat` VALUES ('616', '6', '3', '3F', '1');
INSERT INTO `seat` VALUES ('617', '6', '3', '4A', '1');
INSERT INTO `seat` VALUES ('618', '6', '3', '4B', '1');
INSERT INTO `seat` VALUES ('619', '6', '3', '4C', '1');
INSERT INTO `seat` VALUES ('620', '6', '3', '4D', '1');
INSERT INTO `seat` VALUES ('621', '6', '3', '4F', '1');
INSERT INTO `seat` VALUES ('622', '6', '3', '5A', '1');
INSERT INTO `seat` VALUES ('623', '6', '3', '5B', '1');
INSERT INTO `seat` VALUES ('624', '6', '3', '5C', '1');
INSERT INTO `seat` VALUES ('625', '6', '3', '5D', '1');
INSERT INTO `seat` VALUES ('626', '6', '3', '5F', '1');
INSERT INTO `seat` VALUES ('627', '6', '3', '6A', '1');
INSERT INTO `seat` VALUES ('628', '6', '3', '6B', '1');
INSERT INTO `seat` VALUES ('629', '6', '3', '6C', '1');
INSERT INTO `seat` VALUES ('630', '6', '3', '6D', '1');
INSERT INTO `seat` VALUES ('631', '6', '3', '6F', '1');
INSERT INTO `seat` VALUES ('632', '6', '3', '7A', '1');
INSERT INTO `seat` VALUES ('633', '6', '3', '7B', '1');
INSERT INTO `seat` VALUES ('634', '6', '3', '7C', '1');
INSERT INTO `seat` VALUES ('635', '6', '3', '7D', '1');
INSERT INTO `seat` VALUES ('636', '6', '3', '7F', '1');
INSERT INTO `seat` VALUES ('637', '6', '3', '8A', '1');
INSERT INTO `seat` VALUES ('638', '6', '3', '8B', '1');
INSERT INTO `seat` VALUES ('639', '6', '3', '8C', '1');
INSERT INTO `seat` VALUES ('640', '6', '3', '8D', '1');
INSERT INTO `seat` VALUES ('641', '6', '3', '8F', '1');
INSERT INTO `seat` VALUES ('642', '6', '3', '9A', '1');
INSERT INTO `seat` VALUES ('643', '6', '3', '9B', '1');
INSERT INTO `seat` VALUES ('644', '6', '3', '9C', '1');
INSERT INTO `seat` VALUES ('645', '6', '3', '9D', '1');
INSERT INTO `seat` VALUES ('646', '6', '3', '9F', '1');
INSERT INTO `seat` VALUES ('647', '6', '3', '10A', '1');
INSERT INTO `seat` VALUES ('648', '6', '3', '10B', '1');
INSERT INTO `seat` VALUES ('649', '6', '3', '10C', '1');
INSERT INTO `seat` VALUES ('650', '6', '3', '10D', '1');
INSERT INTO `seat` VALUES ('651', '6', '3', '10F', '1');
INSERT INTO `seat` VALUES ('652', '6', '3', '11A', '1');
INSERT INTO `seat` VALUES ('653', '6', '3', '11B', '1');
INSERT INTO `seat` VALUES ('654', '6', '3', '11C', '1');
INSERT INTO `seat` VALUES ('655', '6', '3', '11D', '1');
INSERT INTO `seat` VALUES ('656', '6', '3', '11F', '1');
INSERT INTO `seat` VALUES ('657', '6', '3', '12A', '1');
INSERT INTO `seat` VALUES ('658', '6', '3', '12B', '1');
INSERT INTO `seat` VALUES ('659', '6', '3', '12C', '1');
INSERT INTO `seat` VALUES ('660', '6', '3', '12D', '1');
INSERT INTO `seat` VALUES ('661', '6', '3', '12F', '1');
INSERT INTO `seat` VALUES ('662', '6', '3', '13A', '1');
INSERT INTO `seat` VALUES ('663', '6', '3', '13B', '1');
INSERT INTO `seat` VALUES ('664', '6', '3', '13C', '1');
INSERT INTO `seat` VALUES ('665', '6', '3', '13D', '1');
INSERT INTO `seat` VALUES ('666', '6', '3', '13F', '1');
INSERT INTO `seat` VALUES ('667', '6', '3', '14A', '1');
INSERT INTO `seat` VALUES ('668', '6', '3', '14B', '1');
INSERT INTO `seat` VALUES ('669', '6', '3', '14C', '1');
INSERT INTO `seat` VALUES ('670', '6', '3', '14D', '1');
INSERT INTO `seat` VALUES ('671', '6', '3', '14F', '1');
INSERT INTO `seat` VALUES ('672', '6', '3', '15A', '1');
INSERT INTO `seat` VALUES ('673', '6', '3', '15B', '1');
INSERT INTO `seat` VALUES ('674', '6', '3', '15C', '1');
INSERT INTO `seat` VALUES ('675', '6', '3', '15D', '1');
INSERT INTO `seat` VALUES ('676', '6', '3', '15F', '1');
INSERT INTO `seat` VALUES ('677', '6', '4', '1A', '1');
INSERT INTO `seat` VALUES ('678', '6', '4', '1B', '1');
INSERT INTO `seat` VALUES ('679', '6', '4', '1C', '1');
INSERT INTO `seat` VALUES ('680', '6', '4', '1D', '1');
INSERT INTO `seat` VALUES ('681', '6', '4', '1F', '1');
INSERT INTO `seat` VALUES ('682', '6', '4', '2A', '1');
INSERT INTO `seat` VALUES ('683', '6', '4', '2B', '1');
INSERT INTO `seat` VALUES ('684', '6', '4', '2C', '1');
INSERT INTO `seat` VALUES ('685', '6', '4', '2D', '1');
INSERT INTO `seat` VALUES ('686', '6', '4', '2F', '1');
INSERT INTO `seat` VALUES ('687', '6', '4', '3A', '1');
INSERT INTO `seat` VALUES ('688', '6', '4', '3B', '1');
INSERT INTO `seat` VALUES ('689', '6', '4', '3C', '1');
INSERT INTO `seat` VALUES ('690', '6', '4', '3D', '1');
INSERT INTO `seat` VALUES ('691', '6', '4', '3F', '1');
INSERT INTO `seat` VALUES ('692', '6', '4', '4A', '1');
INSERT INTO `seat` VALUES ('693', '6', '4', '4B', '1');
INSERT INTO `seat` VALUES ('694', '6', '4', '4C', '1');
INSERT INTO `seat` VALUES ('695', '6', '4', '4D', '1');
INSERT INTO `seat` VALUES ('696', '6', '4', '4F', '1');
INSERT INTO `seat` VALUES ('697', '6', '4', '5A', '1');
INSERT INTO `seat` VALUES ('698', '6', '4', '5B', '1');
INSERT INTO `seat` VALUES ('699', '6', '4', '5C', '1');
INSERT INTO `seat` VALUES ('700', '6', '4', '5D', '1');
INSERT INTO `seat` VALUES ('701', '6', '4', '5F', '1');
INSERT INTO `seat` VALUES ('702', '6', '4', '6A', '1');
INSERT INTO `seat` VALUES ('703', '6', '4', '6B', '1');
INSERT INTO `seat` VALUES ('704', '6', '4', '6C', '1');
INSERT INTO `seat` VALUES ('705', '6', '4', '6D', '1');
INSERT INTO `seat` VALUES ('706', '6', '4', '6F', '1');
INSERT INTO `seat` VALUES ('707', '6', '4', '7A', '1');
INSERT INTO `seat` VALUES ('708', '6', '4', '7B', '1');
INSERT INTO `seat` VALUES ('709', '6', '4', '7C', '1');
INSERT INTO `seat` VALUES ('710', '6', '4', '7D', '1');
INSERT INTO `seat` VALUES ('711', '6', '4', '7F', '1');
INSERT INTO `seat` VALUES ('712', '6', '4', '8A', '1');
INSERT INTO `seat` VALUES ('713', '6', '4', '8B', '1');
INSERT INTO `seat` VALUES ('714', '6', '4', '8C', '1');
INSERT INTO `seat` VALUES ('715', '6', '4', '8D', '1');
INSERT INTO `seat` VALUES ('716', '6', '4', '8F', '1');
INSERT INTO `seat` VALUES ('717', '6', '4', '9A', '1');
INSERT INTO `seat` VALUES ('718', '6', '4', '9B', '1');
INSERT INTO `seat` VALUES ('719', '6', '4', '9C', '1');
INSERT INTO `seat` VALUES ('720', '6', '4', '9D', '1');
INSERT INTO `seat` VALUES ('721', '6', '4', '9F', '1');
INSERT INTO `seat` VALUES ('722', '6', '4', '10A', '1');
INSERT INTO `seat` VALUES ('723', '6', '4', '10B', '1');
INSERT INTO `seat` VALUES ('724', '6', '4', '10C', '1');
INSERT INTO `seat` VALUES ('725', '6', '4', '10D', '1');
INSERT INTO `seat` VALUES ('726', '6', '4', '10F', '1');
INSERT INTO `seat` VALUES ('727', '6', '4', '11A', '1');
INSERT INTO `seat` VALUES ('728', '6', '4', '11B', '1');
INSERT INTO `seat` VALUES ('729', '6', '4', '11C', '1');
INSERT INTO `seat` VALUES ('730', '6', '4', '11D', '1');
INSERT INTO `seat` VALUES ('731', '6', '4', '11F', '1');
INSERT INTO `seat` VALUES ('732', '6', '4', '12A', '1');
INSERT INTO `seat` VALUES ('733', '6', '4', '12B', '1');
INSERT INTO `seat` VALUES ('734', '6', '4', '12C', '1');
INSERT INTO `seat` VALUES ('735', '6', '4', '12D', '1');
INSERT INTO `seat` VALUES ('736', '6', '4', '12F', '1');
INSERT INTO `seat` VALUES ('737', '6', '4', '13A', '1');
INSERT INTO `seat` VALUES ('738', '6', '4', '13B', '1');
INSERT INTO `seat` VALUES ('739', '6', '4', '13C', '1');
INSERT INTO `seat` VALUES ('740', '6', '4', '13D', '1');
INSERT INTO `seat` VALUES ('741', '6', '4', '13F', '1');
INSERT INTO `seat` VALUES ('742', '6', '4', '14A', '1');
INSERT INTO `seat` VALUES ('743', '6', '4', '14B', '1');
INSERT INTO `seat` VALUES ('744', '6', '4', '14C', '1');
INSERT INTO `seat` VALUES ('745', '6', '4', '14D', '1');
INSERT INTO `seat` VALUES ('746', '6', '4', '14F', '1');
INSERT INTO `seat` VALUES ('747', '6', '4', '15A', '1');
INSERT INTO `seat` VALUES ('748', '6', '4', '15B', '1');
INSERT INTO `seat` VALUES ('749', '6', '4', '15C', '1');
INSERT INTO `seat` VALUES ('750', '6', '4', '15D', '1');
INSERT INTO `seat` VALUES ('751', '6', '4', '15F', '1');
INSERT INTO `seat` VALUES ('752', '6', '5', '1A', '1');
INSERT INTO `seat` VALUES ('753', '6', '5', '1B', '1');
INSERT INTO `seat` VALUES ('754', '6', '5', '1C', '1');
INSERT INTO `seat` VALUES ('755', '6', '5', '1D', '1');
INSERT INTO `seat` VALUES ('756', '6', '5', '1F', '1');
INSERT INTO `seat` VALUES ('757', '6', '5', '2A', '1');
INSERT INTO `seat` VALUES ('758', '6', '5', '2B', '1');
INSERT INTO `seat` VALUES ('759', '6', '5', '2C', '1');
INSERT INTO `seat` VALUES ('760', '6', '5', '2D', '1');
INSERT INTO `seat` VALUES ('761', '6', '5', '2F', '1');
INSERT INTO `seat` VALUES ('762', '6', '5', '3A', '1');
INSERT INTO `seat` VALUES ('763', '6', '5', '3B', '1');
INSERT INTO `seat` VALUES ('764', '6', '5', '3C', '1');
INSERT INTO `seat` VALUES ('765', '6', '5', '3D', '1');
INSERT INTO `seat` VALUES ('766', '6', '5', '3F', '1');
INSERT INTO `seat` VALUES ('767', '6', '5', '4A', '1');
INSERT INTO `seat` VALUES ('768', '6', '5', '4B', '1');
INSERT INTO `seat` VALUES ('769', '6', '5', '4C', '1');
INSERT INTO `seat` VALUES ('770', '6', '5', '4D', '1');
INSERT INTO `seat` VALUES ('771', '6', '5', '4F', '1');
INSERT INTO `seat` VALUES ('772', '6', '5', '5A', '1');
INSERT INTO `seat` VALUES ('773', '6', '5', '5B', '1');
INSERT INTO `seat` VALUES ('774', '6', '5', '5C', '1');
INSERT INTO `seat` VALUES ('775', '6', '5', '5D', '1');
INSERT INTO `seat` VALUES ('776', '6', '5', '5F', '1');
INSERT INTO `seat` VALUES ('777', '6', '5', '6A', '1');
INSERT INTO `seat` VALUES ('778', '6', '5', '6B', '1');
INSERT INTO `seat` VALUES ('779', '6', '5', '6C', '1');
INSERT INTO `seat` VALUES ('780', '6', '5', '6D', '1');
INSERT INTO `seat` VALUES ('781', '6', '5', '6F', '1');
INSERT INTO `seat` VALUES ('782', '6', '5', '7A', '1');
INSERT INTO `seat` VALUES ('783', '6', '5', '7B', '1');
INSERT INTO `seat` VALUES ('784', '6', '5', '7C', '1');
INSERT INTO `seat` VALUES ('785', '6', '5', '7D', '1');
INSERT INTO `seat` VALUES ('786', '6', '5', '7F', '1');
INSERT INTO `seat` VALUES ('787', '6', '5', '8A', '1');
INSERT INTO `seat` VALUES ('788', '6', '5', '8B', '1');
INSERT INTO `seat` VALUES ('789', '6', '5', '8C', '1');
INSERT INTO `seat` VALUES ('790', '6', '5', '8D', '1');
INSERT INTO `seat` VALUES ('791', '6', '5', '8F', '1');
INSERT INTO `seat` VALUES ('792', '6', '5', '9A', '1');
INSERT INTO `seat` VALUES ('793', '6', '5', '9B', '1');
INSERT INTO `seat` VALUES ('794', '6', '5', '9C', '1');
INSERT INTO `seat` VALUES ('795', '6', '5', '9D', '1');
INSERT INTO `seat` VALUES ('796', '6', '5', '9F', '1');
INSERT INTO `seat` VALUES ('797', '6', '5', '10A', '1');
INSERT INTO `seat` VALUES ('798', '6', '5', '10B', '1');
INSERT INTO `seat` VALUES ('799', '6', '5', '10C', '1');
INSERT INTO `seat` VALUES ('800', '6', '5', '10D', '1');
INSERT INTO `seat` VALUES ('801', '6', '5', '10F', '1');
INSERT INTO `seat` VALUES ('802', '6', '5', '11A', '1');
INSERT INTO `seat` VALUES ('803', '6', '5', '11B', '1');
INSERT INTO `seat` VALUES ('804', '6', '5', '11C', '1');
INSERT INTO `seat` VALUES ('805', '6', '5', '11D', '1');
INSERT INTO `seat` VALUES ('806', '6', '5', '11F', '1');
INSERT INTO `seat` VALUES ('807', '6', '5', '12A', '1');
INSERT INTO `seat` VALUES ('808', '6', '5', '12B', '1');
INSERT INTO `seat` VALUES ('809', '6', '5', '12C', '1');
INSERT INTO `seat` VALUES ('810', '6', '5', '12D', '1');
INSERT INTO `seat` VALUES ('811', '6', '5', '12F', '1');
INSERT INTO `seat` VALUES ('812', '6', '5', '13A', '1');
INSERT INTO `seat` VALUES ('813', '6', '5', '13B', '1');
INSERT INTO `seat` VALUES ('814', '6', '5', '13C', '1');
INSERT INTO `seat` VALUES ('815', '6', '5', '13D', '1');
INSERT INTO `seat` VALUES ('816', '6', '5', '13F', '1');
INSERT INTO `seat` VALUES ('817', '6', '5', '14A', '1');
INSERT INTO `seat` VALUES ('818', '6', '5', '14B', '1');
INSERT INTO `seat` VALUES ('819', '6', '5', '14C', '1');
INSERT INTO `seat` VALUES ('820', '6', '5', '14D', '1');
INSERT INTO `seat` VALUES ('821', '6', '5', '14F', '1');
INSERT INTO `seat` VALUES ('822', '6', '5', '15A', '1');
INSERT INTO `seat` VALUES ('823', '6', '5', '15B', '1');
INSERT INTO `seat` VALUES ('824', '6', '5', '15C', '1');
INSERT INTO `seat` VALUES ('825', '6', '5', '15D', '1');
INSERT INTO `seat` VALUES ('826', '6', '5', '15F', '1');
INSERT INTO `seat` VALUES ('827', '6', '6', '1A', '1');
INSERT INTO `seat` VALUES ('828', '6', '6', '1B', '1');
INSERT INTO `seat` VALUES ('829', '6', '6', '1C', '1');
INSERT INTO `seat` VALUES ('830', '6', '6', '1D', '1');
INSERT INTO `seat` VALUES ('831', '6', '6', '1F', '1');
INSERT INTO `seat` VALUES ('832', '6', '6', '2A', '1');
INSERT INTO `seat` VALUES ('833', '6', '6', '2B', '1');
INSERT INTO `seat` VALUES ('834', '6', '6', '2C', '1');
INSERT INTO `seat` VALUES ('835', '6', '6', '2D', '1');
INSERT INTO `seat` VALUES ('836', '6', '6', '2F', '1');
INSERT INTO `seat` VALUES ('837', '6', '6', '3A', '1');
INSERT INTO `seat` VALUES ('838', '6', '6', '3B', '1');
INSERT INTO `seat` VALUES ('839', '6', '6', '3C', '1');
INSERT INTO `seat` VALUES ('840', '6', '6', '3D', '1');
INSERT INTO `seat` VALUES ('841', '6', '6', '3F', '1');
INSERT INTO `seat` VALUES ('842', '6', '6', '4A', '1');
INSERT INTO `seat` VALUES ('843', '6', '6', '4B', '1');
INSERT INTO `seat` VALUES ('844', '6', '6', '4C', '1');
INSERT INTO `seat` VALUES ('845', '6', '6', '4D', '1');
INSERT INTO `seat` VALUES ('846', '6', '6', '4F', '1');
INSERT INTO `seat` VALUES ('847', '6', '6', '5A', '1');
INSERT INTO `seat` VALUES ('848', '6', '6', '5B', '1');
INSERT INTO `seat` VALUES ('849', '6', '6', '5C', '1');
INSERT INTO `seat` VALUES ('850', '6', '6', '5D', '1');
INSERT INTO `seat` VALUES ('851', '6', '6', '5F', '1');
INSERT INTO `seat` VALUES ('852', '6', '6', '6A', '1');
INSERT INTO `seat` VALUES ('853', '6', '6', '6B', '1');
INSERT INTO `seat` VALUES ('854', '6', '6', '6C', '1');
INSERT INTO `seat` VALUES ('855', '6', '6', '6D', '1');
INSERT INTO `seat` VALUES ('856', '6', '6', '6F', '1');
INSERT INTO `seat` VALUES ('857', '6', '6', '7A', '1');
INSERT INTO `seat` VALUES ('858', '6', '6', '7B', '1');
INSERT INTO `seat` VALUES ('859', '6', '6', '7C', '1');
INSERT INTO `seat` VALUES ('860', '6', '6', '7D', '1');
INSERT INTO `seat` VALUES ('861', '6', '6', '7F', '1');
INSERT INTO `seat` VALUES ('862', '6', '6', '8A', '1');
INSERT INTO `seat` VALUES ('863', '6', '6', '8B', '1');
INSERT INTO `seat` VALUES ('864', '6', '6', '8C', '1');
INSERT INTO `seat` VALUES ('865', '6', '6', '8D', '1');
INSERT INTO `seat` VALUES ('866', '6', '6', '8F', '1');
INSERT INTO `seat` VALUES ('867', '6', '6', '9A', '1');
INSERT INTO `seat` VALUES ('868', '6', '6', '9B', '1');
INSERT INTO `seat` VALUES ('869', '6', '6', '9C', '1');
INSERT INTO `seat` VALUES ('870', '6', '6', '9D', '1');
INSERT INTO `seat` VALUES ('871', '6', '6', '9F', '1');
INSERT INTO `seat` VALUES ('872', '6', '6', '10A', '1');
INSERT INTO `seat` VALUES ('873', '6', '6', '10B', '1');
INSERT INTO `seat` VALUES ('874', '6', '6', '10C', '1');
INSERT INTO `seat` VALUES ('875', '6', '6', '10D', '1');
INSERT INTO `seat` VALUES ('876', '6', '6', '10F', '1');
INSERT INTO `seat` VALUES ('877', '6', '6', '11A', '1');
INSERT INTO `seat` VALUES ('878', '6', '6', '11B', '1');
INSERT INTO `seat` VALUES ('879', '6', '6', '11C', '1');
INSERT INTO `seat` VALUES ('880', '6', '6', '11D', '1');
INSERT INTO `seat` VALUES ('881', '6', '6', '11F', '1');
INSERT INTO `seat` VALUES ('882', '6', '6', '12A', '1');
INSERT INTO `seat` VALUES ('883', '6', '6', '12B', '1');
INSERT INTO `seat` VALUES ('884', '6', '6', '12C', '1');
INSERT INTO `seat` VALUES ('885', '6', '6', '12D', '1');
INSERT INTO `seat` VALUES ('886', '6', '6', '12F', '1');
INSERT INTO `seat` VALUES ('887', '6', '6', '13A', '1');
INSERT INTO `seat` VALUES ('888', '6', '6', '13B', '1');
INSERT INTO `seat` VALUES ('889', '6', '6', '13C', '1');
INSERT INTO `seat` VALUES ('890', '6', '6', '13D', '1');
INSERT INTO `seat` VALUES ('891', '6', '6', '13F', '1');
INSERT INTO `seat` VALUES ('892', '6', '6', '14A', '1');
INSERT INTO `seat` VALUES ('893', '6', '6', '14B', '1');
INSERT INTO `seat` VALUES ('894', '6', '6', '14C', '1');
INSERT INTO `seat` VALUES ('895', '6', '6', '14D', '1');
INSERT INTO `seat` VALUES ('896', '6', '6', '14F', '1');
INSERT INTO `seat` VALUES ('897', '6', '6', '15A', '1');
INSERT INTO `seat` VALUES ('898', '6', '6', '15B', '1');
INSERT INTO `seat` VALUES ('899', '6', '6', '15C', '1');
INSERT INTO `seat` VALUES ('900', '6', '6', '15D', '1');
INSERT INTO `seat` VALUES ('901', '6', '6', '15F', '1');
INSERT INTO `seat` VALUES ('902', '6', '7', '1A', '1');
INSERT INTO `seat` VALUES ('903', '6', '7', '1B', '1');
INSERT INTO `seat` VALUES ('904', '6', '7', '1C', '1');
INSERT INTO `seat` VALUES ('905', '6', '7', '1D', '1');
INSERT INTO `seat` VALUES ('906', '6', '7', '1F', '1');
INSERT INTO `seat` VALUES ('907', '6', '7', '2A', '1');
INSERT INTO `seat` VALUES ('908', '6', '7', '2B', '1');
INSERT INTO `seat` VALUES ('909', '6', '7', '2C', '1');
INSERT INTO `seat` VALUES ('910', '6', '7', '2D', '1');
INSERT INTO `seat` VALUES ('911', '6', '7', '2F', '1');
INSERT INTO `seat` VALUES ('912', '6', '7', '3A', '1');
INSERT INTO `seat` VALUES ('913', '6', '7', '3B', '1');
INSERT INTO `seat` VALUES ('914', '6', '7', '3C', '1');
INSERT INTO `seat` VALUES ('915', '6', '7', '3D', '1');
INSERT INTO `seat` VALUES ('916', '6', '7', '3F', '1');
INSERT INTO `seat` VALUES ('917', '6', '7', '4A', '1');
INSERT INTO `seat` VALUES ('918', '6', '7', '4B', '1');
INSERT INTO `seat` VALUES ('919', '6', '7', '4C', '1');
INSERT INTO `seat` VALUES ('920', '6', '7', '4D', '1');
INSERT INTO `seat` VALUES ('921', '6', '7', '4F', '1');
INSERT INTO `seat` VALUES ('922', '6', '7', '5A', '1');
INSERT INTO `seat` VALUES ('923', '6', '7', '5B', '1');
INSERT INTO `seat` VALUES ('924', '6', '7', '5C', '1');
INSERT INTO `seat` VALUES ('925', '6', '7', '5D', '1');
INSERT INTO `seat` VALUES ('926', '6', '7', '5F', '1');
INSERT INTO `seat` VALUES ('927', '6', '7', '6A', '1');
INSERT INTO `seat` VALUES ('928', '6', '7', '6B', '1');
INSERT INTO `seat` VALUES ('929', '6', '7', '6C', '1');
INSERT INTO `seat` VALUES ('930', '6', '7', '6D', '1');
INSERT INTO `seat` VALUES ('931', '6', '7', '6F', '1');
INSERT INTO `seat` VALUES ('932', '6', '7', '7A', '1');
INSERT INTO `seat` VALUES ('933', '6', '7', '7B', '1');
INSERT INTO `seat` VALUES ('934', '6', '7', '7C', '1');
INSERT INTO `seat` VALUES ('935', '6', '7', '7D', '1');
INSERT INTO `seat` VALUES ('936', '6', '7', '7F', '1');
INSERT INTO `seat` VALUES ('937', '6', '7', '8A', '1');
INSERT INTO `seat` VALUES ('938', '6', '7', '8B', '1');
INSERT INTO `seat` VALUES ('939', '6', '7', '8C', '1');
INSERT INTO `seat` VALUES ('940', '6', '7', '8D', '1');
INSERT INTO `seat` VALUES ('941', '6', '7', '8F', '1');
INSERT INTO `seat` VALUES ('942', '6', '7', '9A', '1');
INSERT INTO `seat` VALUES ('943', '6', '7', '9B', '1');
INSERT INTO `seat` VALUES ('944', '6', '7', '9C', '1');
INSERT INTO `seat` VALUES ('945', '6', '7', '9D', '1');
INSERT INTO `seat` VALUES ('946', '6', '7', '9F', '1');
INSERT INTO `seat` VALUES ('947', '6', '7', '10A', '1');
INSERT INTO `seat` VALUES ('948', '6', '7', '10B', '1');
INSERT INTO `seat` VALUES ('949', '6', '7', '10C', '1');
INSERT INTO `seat` VALUES ('950', '6', '7', '10D', '1');
INSERT INTO `seat` VALUES ('951', '6', '7', '10F', '1');
INSERT INTO `seat` VALUES ('952', '6', '7', '11A', '1');
INSERT INTO `seat` VALUES ('953', '6', '7', '11B', '1');
INSERT INTO `seat` VALUES ('954', '6', '7', '11C', '1');
INSERT INTO `seat` VALUES ('955', '6', '7', '11D', '1');
INSERT INTO `seat` VALUES ('956', '6', '7', '11F', '1');
INSERT INTO `seat` VALUES ('957', '6', '7', '12A', '1');
INSERT INTO `seat` VALUES ('958', '6', '7', '12B', '1');
INSERT INTO `seat` VALUES ('959', '6', '7', '12C', '1');
INSERT INTO `seat` VALUES ('960', '6', '7', '12D', '1');
INSERT INTO `seat` VALUES ('961', '6', '7', '12F', '1');
INSERT INTO `seat` VALUES ('962', '6', '7', '13A', '1');
INSERT INTO `seat` VALUES ('963', '6', '7', '13B', '1');
INSERT INTO `seat` VALUES ('964', '6', '7', '13C', '1');
INSERT INTO `seat` VALUES ('965', '6', '7', '13D', '1');
INSERT INTO `seat` VALUES ('966', '6', '7', '13F', '1');
INSERT INTO `seat` VALUES ('967', '6', '7', '14A', '1');
INSERT INTO `seat` VALUES ('968', '6', '7', '14B', '1');
INSERT INTO `seat` VALUES ('969', '6', '7', '14C', '1');
INSERT INTO `seat` VALUES ('970', '6', '7', '14D', '1');
INSERT INTO `seat` VALUES ('971', '6', '7', '14F', '1');
INSERT INTO `seat` VALUES ('972', '6', '7', '15A', '1');
INSERT INTO `seat` VALUES ('973', '6', '7', '15B', '1');
INSERT INTO `seat` VALUES ('974', '6', '7', '15C', '1');
INSERT INTO `seat` VALUES ('975', '6', '7', '15D', '1');
INSERT INTO `seat` VALUES ('976', '6', '7', '15F', '1');
INSERT INTO `seat` VALUES ('977', '6', '8', '1A', '1');
INSERT INTO `seat` VALUES ('978', '6', '8', '1B', '1');
INSERT INTO `seat` VALUES ('979', '6', '8', '1C', '1');
INSERT INTO `seat` VALUES ('980', '6', '8', '1D', '1');
INSERT INTO `seat` VALUES ('981', '6', '8', '1F', '1');
INSERT INTO `seat` VALUES ('982', '6', '8', '2A', '1');
INSERT INTO `seat` VALUES ('983', '6', '8', '2B', '1');
INSERT INTO `seat` VALUES ('984', '6', '8', '2C', '1');
INSERT INTO `seat` VALUES ('985', '6', '8', '2D', '1');
INSERT INTO `seat` VALUES ('986', '6', '8', '2F', '1');
INSERT INTO `seat` VALUES ('987', '6', '8', '3A', '1');
INSERT INTO `seat` VALUES ('988', '6', '8', '3B', '1');
INSERT INTO `seat` VALUES ('989', '6', '8', '3C', '1');
INSERT INTO `seat` VALUES ('990', '6', '8', '3D', '1');
INSERT INTO `seat` VALUES ('991', '6', '8', '3F', '1');
INSERT INTO `seat` VALUES ('992', '6', '8', '4A', '1');
INSERT INTO `seat` VALUES ('993', '6', '8', '4B', '1');
INSERT INTO `seat` VALUES ('994', '6', '8', '4C', '1');
INSERT INTO `seat` VALUES ('995', '6', '8', '4D', '1');
INSERT INTO `seat` VALUES ('996', '6', '8', '4F', '1');
INSERT INTO `seat` VALUES ('997', '6', '8', '5A', '1');
INSERT INTO `seat` VALUES ('998', '6', '8', '5B', '1');
INSERT INTO `seat` VALUES ('999', '6', '8', '5C', '1');
INSERT INTO `seat` VALUES ('1000', '6', '8', '5D', '1');
INSERT INTO `seat` VALUES ('1001', '6', '8', '5F', '1');
INSERT INTO `seat` VALUES ('1002', '6', '8', '6A', '1');
INSERT INTO `seat` VALUES ('1003', '6', '8', '6B', '1');
INSERT INTO `seat` VALUES ('1004', '6', '8', '6C', '1');
INSERT INTO `seat` VALUES ('1005', '6', '8', '6D', '1');
INSERT INTO `seat` VALUES ('1006', '6', '8', '6F', '1');
INSERT INTO `seat` VALUES ('1007', '6', '8', '7A', '1');
INSERT INTO `seat` VALUES ('1008', '6', '8', '7B', '1');
INSERT INTO `seat` VALUES ('1009', '6', '8', '7C', '1');
INSERT INTO `seat` VALUES ('1010', '6', '8', '7D', '1');
INSERT INTO `seat` VALUES ('1011', '6', '8', '7F', '1');
INSERT INTO `seat` VALUES ('1012', '6', '8', '8A', '1');
INSERT INTO `seat` VALUES ('1013', '6', '8', '8B', '1');
INSERT INTO `seat` VALUES ('1014', '6', '8', '8C', '1');
INSERT INTO `seat` VALUES ('1015', '6', '8', '8D', '1');
INSERT INTO `seat` VALUES ('1016', '6', '8', '8F', '1');
INSERT INTO `seat` VALUES ('1017', '6', '8', '9A', '1');
INSERT INTO `seat` VALUES ('1018', '6', '8', '9B', '1');
INSERT INTO `seat` VALUES ('1019', '6', '8', '9C', '1');
INSERT INTO `seat` VALUES ('1020', '6', '8', '9D', '1');
INSERT INTO `seat` VALUES ('1021', '6', '8', '9F', '1');
INSERT INTO `seat` VALUES ('1022', '6', '8', '10A', '1');
INSERT INTO `seat` VALUES ('1023', '6', '8', '10B', '1');
INSERT INTO `seat` VALUES ('1024', '6', '8', '10C', '1');
INSERT INTO `seat` VALUES ('1025', '6', '8', '10D', '1');
INSERT INTO `seat` VALUES ('1026', '6', '8', '10F', '1');
INSERT INTO `seat` VALUES ('1027', '6', '8', '11A', '1');
INSERT INTO `seat` VALUES ('1028', '6', '8', '11B', '1');
INSERT INTO `seat` VALUES ('1029', '6', '8', '11C', '1');
INSERT INTO `seat` VALUES ('1030', '6', '8', '11D', '1');
INSERT INTO `seat` VALUES ('1031', '6', '8', '11F', '1');
INSERT INTO `seat` VALUES ('1032', '6', '8', '12A', '1');
INSERT INTO `seat` VALUES ('1033', '6', '8', '12B', '1');
INSERT INTO `seat` VALUES ('1034', '6', '8', '12C', '1');
INSERT INTO `seat` VALUES ('1035', '6', '8', '12D', '1');
INSERT INTO `seat` VALUES ('1036', '6', '8', '12F', '1');
INSERT INTO `seat` VALUES ('1037', '6', '8', '13A', '1');
INSERT INTO `seat` VALUES ('1038', '6', '8', '13B', '1');
INSERT INTO `seat` VALUES ('1039', '6', '8', '13C', '1');
INSERT INTO `seat` VALUES ('1040', '6', '8', '13D', '1');
INSERT INTO `seat` VALUES ('1041', '6', '8', '13F', '1');
INSERT INTO `seat` VALUES ('1042', '6', '8', '14A', '1');
INSERT INTO `seat` VALUES ('1043', '6', '8', '14B', '1');
INSERT INTO `seat` VALUES ('1044', '6', '8', '14C', '1');
INSERT INTO `seat` VALUES ('1045', '6', '8', '14D', '1');
INSERT INTO `seat` VALUES ('1046', '6', '8', '14F', '1');
INSERT INTO `seat` VALUES ('1047', '6', '8', '15A', '1');
INSERT INTO `seat` VALUES ('1048', '6', '8', '15B', '1');
INSERT INTO `seat` VALUES ('1049', '6', '8', '15C', '1');
INSERT INTO `seat` VALUES ('1050', '6', '8', '15D', '1');
INSERT INTO `seat` VALUES ('1051', '6', '8', '15F', '1');

-- ----------------------------
-- Table structure for train
-- ----------------------------
DROP TABLE IF EXISTS `train`;
CREATE TABLE `train` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `trainno` varchar(255) NOT NULL COMMENT '车次',
  `departure_time` datetime NOT NULL COMMENT '出发时间',
  `arrival_time` datetime NOT NULL COMMENT '到达时间',
  `dstation` varchar(255) NOT NULL COMMENT '始发站',
  `terminal` varchar(255) NOT NULL COMMENT '终点站',
  `price` double NOT NULL,
  `state` int(11) NOT NULL COMMENT '列车状态（1，正在出售2，未到出售时间3，停止出售4，取消车次）',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of train
-- ----------------------------
INSERT INTO `train` VALUES ('1', 'G7023', '2017-09-12 09:17:15', '2017-09-12 10:20:44', '南京市', '苏州市', '100', '1');
INSERT INTO `train` VALUES ('6', 'G111', '2017-09-23 15:29:06', '2017-09-23 16:29:12', '南京', '苏州', '100', '1');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `passwordold` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `prov` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `cardtype` varchar(255) NOT NULL,
  `cardid` varchar(255) NOT NULL DEFAULT '',
  `tel` varchar(255) NOT NULL,
  `utype` varchar(255) DEFAULT NULL,
  `beizhu` varchar(255) DEFAULT NULL,
  `state` int(11) NOT NULL COMMENT '证件状态，由管理员验证（1，白名单2，黑名单）',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('21', 'testicon123', 'dbae6ba3a9e5e93d31bd138211c4be12', null, 'icons/1505699612100.jpg', '郭', 'woman', '11', '苏州', '居民二代身份证', '111111111111111111', '13111111111', '成年人', '', '1');
INSERT INTO `user` VALUES ('22', 'qf1111', 'd5a1d65918b69425005578ff5534c07b', null, '', '吴青峰', 'man', '34', '台北', '居民二代身份证', '320582199608304822', '13455324566', '成年人', '', '1');
INSERT INTO `user` VALUES ('24', 'guo1996', '318e7a9375ce05bfdea7e6b13595fca5', null, 'icons/1505804456170.jpg', '郭明亮', 'woman', '11', '苏州', '居民二代身份证', '111111111111111111', '13111111111', '成年人', '', '1');