master

分支 (1)

管理

管理

master

gms-2.0
/
gms.sql

/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3306
 Source Schema         : gms

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 13/08/2020 23:50:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gms_admin
-- ----------------------------
DROP TABLE IF EXISTS `gms_admin`;
CREATE TABLE `gms_admin`  (
  `admin_username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `admin_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  PRIMARY KEY (`admin_username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_admin
-- ----------------------------
INSERT INTO `gms_admin` VALUES ('admin', '123456');

-- ----------------------------
-- Table structure for gms_notice
-- ----------------------------
DROP TABLE IF EXISTS `gms_notice`;
CREATE TABLE `gms_notice`  (
  `notice_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知编号',
  `notice_time` date NOT NULL COMMENT '通知日期',
  `notice_man` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知人',
  `notice_content` varchar(3072) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知内容',
  `notice_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知标题',
  `notice_state` int(11) NOT NULL DEFAULT 0 COMMENT '通知状态 为0代表通知未被删除,1代表通知被删除了',
  PRIMARY KEY (`notice_id`) USING BTREE,
  INDEX `引用通知人`(`notice_man`) USING BTREE,
  CONSTRAINT `引用通知人` FOREIGN KEY (`notice_man`) REFERENCES `gms_admin` (`admin_username`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_notice
-- ----------------------------
INSERT INTO `gms_notice` VALUES ('0279046b3a3a446f8fe2c42dac7b1468', '2020-05-17', 'admin', '体育馆场地管理系统用户登录界面和管理员模块登录界面搭建完成!!!   两个登陆界面，主要采用的是div+css+jquery完成设计，实现基本的校验功能以及在一个界面跳转的功能，给用户更好的体验，同时也给管理员更清晰，直观的界面感受。', '前后台登录界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('2adf4591ac594192b4ff51a23e655c59', '2020-05-20', 'admin', '体育馆场地管理系统用户预约订单和管理员模块情况分析界面搭建完成!!!  预约订单是通过bootstrap布局和表格展示具体所预约的信息，可以选择取消预约和提交订单两个选择。管理员情况分析是通过chart实现图片动态化和详情展示的功能。', '预约订单和情况分析界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('3688955e756f44c39d3e16eaa3425493', '2020-05-23', 'admin', '体育馆场地管理系统用户订单详情和管理员模块总览界面搭建完成!!!  用户个人中心是通过bootstrap的分页和模态框一起实现用户取消预约，信息查看和修改密码等功能。管理员通过Chart.bundle.min.js和ifream布局展示后台总体情况。', '个人中心和模块总览界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('839e3bd5b9a447b28e31932d4aa3ab77', '2020-05-25', 'admin', '体育馆场地管理系统用户场地信息和管理员通知发布界面搭建完成!!!  用户模块是通过整体bootstrap布局，用tab标签页列出所有场地信息并实现异步跳转功能，增加用户体验。管理员模块通过bootstrap布局，ifream实现跳转。通知栏展示通知信息和发布通知信息。', '场地信息和通知发布界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('89c0a6d29fed418380a50a4de73ad239', '2020-05-31', 'admin', '体育馆场地管理系统用户通知发布界面和管理员模块预约查询界面搭建完成!!!  用户通知界面是和产地信息一起布局在通过一个row里面，偏右侧。侧栏实现需要通知的消息。管理员的预约查询是通过同样的方式实现跳转功能。', '通知发布和预约查询界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('92cee889b2eb41c8b88ca508e210f2b7', '2020-06-05', 'admin', '体育馆场地管理系统用户场地展示和管理员模块场地管理界面搭建完成!!!  用户场地展示是展示每个标签页所对应的具体场馆类型一句场馆预约信息。管理员场地管理通过舔砖方式和表格展示实现对每个场馆进行增删改查。', '场地展示和场地管理界面搭建完成', 0);
INSERT INTO `gms_notice` VALUES ('b94a4c7752854b3c8bccf7a939df1d44', '2020-06-10', 'admin', '体育馆场地管理系统数据设计完成!!!    我们通过对场馆信息的具体分析和逻辑分析，设计好具体的数据库说明书和展示ER图，数据库关系图等。通过数据库的实现和前面的所有需求分析，概要设计等报告实现前后台编码。', '数据设计完成', 0);

-- ----------------------------
-- Table structure for gms_order
-- ----------------------------
DROP TABLE IF EXISTS `gms_order`;
CREATE TABLE `gms_order`  (
  `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号',
  `order_venue_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆编号',
  `order_user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号/学号',
  `order_date` date NOT NULL COMMENT '预约日期',
  `order_st` int(11) NOT NULL COMMENT '预约开始时间',
  `order_ed` int(11) NOT NULL COMMENT '预约结束时间',
  `order_state` int(11) NOT NULL COMMENT '预约状态',
  `order_mktime` datetime(0) NOT NULL COMMENT '订单生成时间',
  `order_price` decimal(32, 10) NOT NULL COMMENT '订单价格',
  PRIMARY KEY (`order_id`) USING BTREE,
  INDEX `订单引用场馆`(`order_venue_id`) USING BTREE,
  INDEX `订单引用用户`(`order_user_id`) USING BTREE,
  CONSTRAINT `订单引用场馆` FOREIGN KEY (`order_venue_id`) REFERENCES `gms_venue` (`venue_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `订单引用用户` FOREIGN KEY (`order_user_id`) REFERENCES `gms_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '预约订单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_order
-- ----------------------------
INSERT INTO `gms_order` VALUES ('0', '18', '2017055941', '2020-08-15', 15, 16, 1, '2020-08-15 10:39:45', 20.0000000000);
INSERT INTO `gms_order` VALUES ('1', '30', '2017099980', '2020-08-15', 17, 18, 1, '2020-08-15 21:46:18', 25.0000000000);
INSERT INTO `gms_order` VALUES ('10', '12', '2017053480', '2020-08-15', 16, 17, 1, '2020-08-15 13:58:38', 15.0000000000);
INSERT INTO `gms_order` VALUES ('100', '05', '2017057963', '2020-08-12', 10, 11, 0, '2020-08-12 19:47:52', 24.0000000000);
INSERT INTO `gms_order` VALUES ('101', '18', '2017098844', '2020-08-12', 14, 15, 0, '2020-08-12 18:39:51', 20.0000000000);
INSERT INTO `gms_order` VALUES ('102', '02', '2017051376', '2020-08-12', 15, 16, 0, '2020-08-12 15:42:35', 17.0000000000);
INSERT INTO `gms_order` VALUES ('103', '24', '2017055739', '2020-08-15', 16, 17, 0, '2020-08-15 22:46:26', 20.0000000000);
INSERT INTO `gms_order` VALUES ('104', '14', '2017053480', '2020-08-14', 13, 14, 0, '2020-08-14 23:37:16', 12.0000000000);
INSERT INTO `gms_order` VALUES ('105', '04', '2017059397', '2020-08-13', 15, 16, 0, '2020-08-13 19:41:24', 23.0000000000);
INSERT INTO `gms_order` VALUES ('106', '06', '2017099980', '2020-08-14', 15, 16, 0, '2020-08-14 12:37:28', 16.0000000000);
INSERT INTO `gms_order` VALUES ('107', '10', '2017056227', '2020-08-12', 12, 13, 0, '2020-08-12 15:31:31', 17.0000000000);
INSERT INTO `gms_order` VALUES ('108', '17', '2017099980', '2020-08-14', 16, 17, 1, '2020-08-14 19:10:18', 13.0000000000);
INSERT INTO `gms_order` VALUES ('109', '05', '2017057963', '2020-08-14', 12, 13, 0, '2020-08-14 14:46:15', 24.0000000000);
INSERT INTO `gms_order` VALUES ('11', '32', '2017099341', '2020-08-14', 14, 15, 0, '2020-08-14 16:54:54', 17.0000000000);
INSERT INTO `gms_order` VALUES ('110', '08', '2017053480', '2020-08-14', 13, 14, 0, '2020-08-14 22:50:35', 16.0000000000);
INSERT INTO `gms_order` VALUES ('111', '04', '2017055941', '2020-08-14', 17, 18, 1, '2020-08-14 11:56:56', 23.0000000000);
INSERT INTO `gms_order` VALUES ('112', '15', '2017056227', '2020-08-12', 12, 13, 0, '2020-08-12 12:36:42', 24.0000000000);
INSERT INTO `gms_order` VALUES ('113', '22', '2017052180', '2020-08-14', 10, 11, 0, '2020-08-14 22:10:26', 16.0000000000);
INSERT INTO `gms_order` VALUES ('114', '01', '2017058523', '2020-08-12', 15, 16, 0, '2020-08-12 11:26:47', 13.0000000000);
INSERT INTO `gms_order` VALUES ('115', '27', '2017058523', '2020-08-15', 15, 16, 0, '2020-08-15 21:25:27', 12.0000000000);
INSERT INTO `gms_order` VALUES ('116', '19', '2017058721', '2020-08-13', 15, 16, 0, '2020-08-13 12:42:39', 12.0000000000);
INSERT INTO `gms_order` VALUES ('117', '03', '2017058523', '2020-08-14', 15, 16, 0, '2020-08-14 17:53:24', 19.0000000000);
INSERT INTO `gms_order` VALUES ('118', '03', '2017092148', '2020-08-12', 10, 11, 0, '2020-08-12 21:59:54', 19.0000000000);
INSERT INTO `gms_order` VALUES ('119', '14', '2017099341', '2020-08-15', 18, 19, 0, '2020-08-15 19:21:10', 12.0000000000);
INSERT INTO `gms_order` VALUES ('12', '27', '2017058721', '2020-08-15', 17, 18, 0, '2020-08-15 20:14:27', 12.0000000000);
INSERT INTO `gms_order` VALUES ('120', '01', '2017092148', '2020-08-15', 15, 16, 0, '2020-08-15 20:10:43', 13.0000000000);
INSERT INTO `gms_order` VALUES ('121', '25', '2017056227', '2020-08-12', 13, 14, 0, '2020-08-12 14:21:20', 18.0000000000);
INSERT INTO `gms_order` VALUES ('122', '11', '2017058721', '2020-08-15', 13, 14, 0, '2020-08-15 11:24:52', 23.0000000000);
INSERT INTO `gms_order` VALUES ('123', '32', '2017056390', '2020-08-13', 15, 16, 1, '2020-08-13 16:17:41', 17.0000000000);
INSERT INTO `gms_order` VALUES ('124', '25', '2017092148', '2020-08-13', 16, 17, 1, '2020-08-13 17:34:40', 18.0000000000);
INSERT INTO `gms_order` VALUES ('125', '11', '2017051376', '2020-08-12', 14, 15, 0, '2020-08-12 16:10:43', 23.0000000000);
INSERT INTO `gms_order` VALUES ('126', '14', '2017052180', '2020-08-13', 17, 18, 0, '2020-08-13 15:31:28', 12.0000000000);
INSERT INTO `gms_order` VALUES ('127', '07', '2017093832', '2020-08-14', 17, 18, 0, '2020-08-14 15:40:57', 24.0000000000);
INSERT INTO `gms_order` VALUES ('128', '02', '2017093660', '2020-08-14', 16, 17, 0, '2020-08-14 21:33:15', 17.0000000000);
INSERT INTO `gms_order` VALUES ('129', '26', '2017059397', '2020-08-14', 13, 14, 0, '2020-08-14 23:10:58', 19.0000000000);
INSERT INTO `gms_order` VALUES ('13', '19', '2017098844', '2020-08-15', 16, 17, 0, '2020-08-15 18:49:27', 12.0000000000);
INSERT INTO `gms_order` VALUES ('130', '28', '2017058721', '2020-08-13', 12, 13, 1, '2020-08-13 21:30:55', 14.0000000000);
INSERT INTO `gms_order` VALUES ('131', '15', '2017053120', '2020-08-14', 14, 15, 0, '2020-08-14 19:51:57', 24.0000000000);
INSERT INTO `gms_order` VALUES ('132', '27', '2017052910', '2020-08-15', 14, 15, 0, '2020-08-15 17:23:33', 12.0000000000);
INSERT INTO `gms_order` VALUES ('133', '12', '2017098844', '2020-08-15', 14, 15, 0, '2020-08-15 16:28:33', 15.0000000000);
INSERT INTO `gms_order` VALUES ('134', '04', '2017052180', '2020-08-15', 18, 19, 0, '2020-08-15 12:36:24', 23.0000000000);
INSERT INTO `gms_order` VALUES ('135', '09', '2017093832', '2020-08-12', 14, 15, 0, '2020-08-12 12:17:31', 17.0000000000);
INSERT INTO `gms_order` VALUES ('136', '09', '2017053120', '2020-08-13', 15, 16, 0, '2020-08-13 17:31:59', 17.0000000000);
INSERT INTO `gms_order` VALUES ('137', '31', '2017053120', '2020-08-14', 14, 15, 1, '2020-08-14 22:42:35', 14.0000000000);
INSERT INTO `gms_order` VALUES ('138', '33', '2017052910', '2020-08-12', 14, 15, 0, '2020-08-12 23:23:46', 10.0000000000);
INSERT INTO `gms_order` VALUES ('139', '20', '2017092148', '2020-08-12', 11, 12, 0, '2020-08-12 11:39:38', 24.0000000000);
INSERT INTO `gms_order` VALUES ('14', '26', '2017099980', '2020-08-13', 17, 18, 0, '2020-08-13 18:13:45', 19.0000000000);
INSERT INTO `gms_order` VALUES ('140', '04', '2017058523', '2020-08-15', 17, 18, 0, '2020-08-15 23:10:55', 23.0000000000);
INSERT INTO `gms_order` VALUES ('141', '28', '2017051376', '2020-08-12', 12, 13, 0, '2020-08-12 10:17:38', 14.0000000000);
INSERT INTO `gms_order` VALUES ('142', '22', '2017055941', '2020-08-13', 13, 14, 1, '2020-08-13 15:32:10', 16.0000000000);
INSERT INTO `gms_order` VALUES ('143', '26', '2017053480', '2020-08-14', 17, 18, 1, '2020-08-14 15:57:14', 19.0000000000);
INSERT INTO `gms_order` VALUES ('144', '15', '2017099341', '2020-08-13', 14, 15, 0, '2020-08-13 13:33:22', 24.0000000000);
INSERT INTO `gms_order` VALUES ('145', '13', '2017099980', '2020-08-12', 15, 16, 0, '2020-08-12 13:13:35', 16.0000000000);
INSERT INTO `gms_order` VALUES ('146', '21', '2017058523', '2020-08-12', 15, 16, 0, '2020-08-12 10:17:57', 13.0000000000);
INSERT INTO `gms_order` VALUES ('147', '19', '2017057963', '2020-08-13', 14, 15, 0, '2020-08-13 15:51:34', 12.0000000000);
INSERT INTO `gms_order` VALUES ('148', '30', '2017098844', '2020-08-14', 17, 18, 0, '2020-08-14 20:22:49', 25.0000000000);
INSERT INTO `gms_order` VALUES ('149', '27', '2017053120', '2020-08-13', 14, 15, 0, '2020-08-13 11:38:44', 12.0000000000);
INSERT INTO `gms_order` VALUES ('15', '23', '2017054904', '2020-08-12', 14, 15, 0, '2020-08-12 12:47:39', 22.0000000000);
INSERT INTO `gms_order` VALUES ('150', '12', '2017057963', '2020-08-12', 15, 16, 0, '2020-08-12 15:31:10', 15.0000000000);
INSERT INTO `gms_order` VALUES ('151', '27', '2017058523', '2020-08-14', 16, 17, 0, '2020-08-14 14:45:14', 12.0000000000);
INSERT INTO `gms_order` VALUES ('152', '01', '2017051376', '2020-08-14', 12, 13, 0, '2020-08-14 14:23:18', 13.0000000000);
INSERT INTO `gms_order` VALUES ('153', '12', '2017052180', '2020-08-14', 14, 15, 0, '2020-08-14 16:53:37', 15.0000000000);
INSERT INTO `gms_order` VALUES ('154', '12', '2017056390', '2020-08-12', 12, 13, 0, '2020-08-12 21:49:29', 15.0000000000);
INSERT INTO `gms_order` VALUES ('155', '09', '2017093832', '2020-08-13', 14, 15, 0, '2020-08-13 16:48:44', 17.0000000000);
INSERT INTO `gms_order` VALUES ('156', '32', '2017059397', '2020-08-13', 16, 17, 0, '2020-08-13 22:51:14', 17.0000000000);
INSERT INTO `gms_order` VALUES ('157', '30', '2017093660', '2020-08-12', 14, 15, 0, '2020-08-12 17:51:37', 25.0000000000);
INSERT INTO `gms_order` VALUES ('158', '26', '2017055941', '2020-08-14', 15, 16, 0, '2020-08-14 16:28:47', 19.0000000000);
INSERT INTO `gms_order` VALUES ('159', '21', '2017058721', '2020-08-13', 15, 16, 1, '2020-08-13 21:54:29', 13.0000000000);
INSERT INTO `gms_order` VALUES ('16', '31', '2017053480', '2020-08-12', 16, 17, 0, '2020-08-12 16:33:29', 14.0000000000);
INSERT INTO `gms_order` VALUES ('160', '23', '2017099341', '2020-08-15', 14, 15, 0, '2020-08-15 23:56:10', 22.0000000000);
INSERT INTO `gms_order` VALUES ('161', '20', '2017054904', '2020-08-15', 14, 15, 0, '2020-08-15 15:37:32', 24.0000000000);
INSERT INTO `gms_order` VALUES ('162', '33', '2017053120', '2020-08-12', 13, 14, 0, '2020-08-12 18:20:42', 10.0000000000);
INSERT INTO `gms_order` VALUES ('163', '10', '2017098844', '2020-08-13', 13, 14, 1, '2020-08-13 20:25:41', 17.0000000000);
INSERT INTO `gms_order` VALUES ('164', '27', '2017057963', '2020-08-14', 14, 15, 0, '2020-08-14 18:28:17', 12.0000000000);
INSERT INTO `gms_order` VALUES ('165', '11', '2017057963', '2020-08-15', 15, 16, 0, '2020-08-15 22:31:43', 23.0000000000);
INSERT INTO `gms_order` VALUES ('166', '04', '2017052180', '2020-08-12', 15, 16, 0, '2020-08-12 11:42:41', 23.0000000000);
INSERT INTO `gms_order` VALUES ('167', '02', '2017058523', '2020-08-15', 16, 17, 1, '2020-08-15 13:20:17', 17.0000000000);
INSERT INTO `gms_order` VALUES ('168', '31', '2017052180', '2020-08-14', 16, 17, 0, '2020-08-14 12:47:36', 14.0000000000);
INSERT INTO `gms_order` VALUES ('169', '27', '2017099980', '2020-08-14', 13, 14, 1, '2020-08-14 20:38:12', 12.0000000000);
INSERT INTO `gms_order` VALUES ('17', '05', '2017058523', '2020-08-13', 15, 16, 1, '2020-08-13 13:16:26', 24.0000000000);
INSERT INTO `gms_order` VALUES ('170', '07', '2017058523', '2020-08-14', 12, 13, 0, '2020-08-14 18:19:42', 24.0000000000);
INSERT INTO `gms_order` VALUES ('171', '24', '2017099341', '2020-08-14', 16, 17, 0, '2020-08-14 16:18:44', 20.0000000000);
INSERT INTO `gms_order` VALUES ('172', '13', '2017093832', '2020-08-12', 14, 15, 0, '2020-08-12 15:45:20', 16.0000000000);
INSERT INTO `gms_order` VALUES ('173', '08', '2017098844', '2020-08-12', 16, 17, 0, '2020-08-12 15:36:13', 16.0000000000);
INSERT INTO `gms_order` VALUES ('174', '15', '2017058721', '2020-08-12', 16, 17, 0, '2020-08-12 19:22:38', 24.0000000000);
INSERT INTO `gms_order` VALUES ('175', '14', '2017055739', '2020-08-15', 17, 18, 0, '2020-08-15 13:20:27', 12.0000000000);
INSERT INTO `gms_order` VALUES ('176', '19', '2017056390', '2020-08-14', 15, 16, 0, '2020-08-14 14:10:48', 12.0000000000);
INSERT INTO `gms_order` VALUES ('177', '28', '2017052180', '2020-08-12', 14, 15, 1, '2020-08-12 15:34:15', 14.0000000000);
INSERT INTO `gms_order` VALUES ('178', '18', '2017098844', '2020-08-14', 15, 16, 1, '2020-08-14 19:52:31', 20.0000000000);
INSERT INTO `gms_order` VALUES ('179', '04', '2017055739', '2020-08-14', 13, 14, 0, '2020-08-14 13:25:13', 23.0000000000);
INSERT INTO `gms_order` VALUES ('18', '11', '2017052910', '2020-08-14', 16, 17, 0, '2020-08-14 20:52:57', 23.0000000000);
INSERT INTO `gms_order` VALUES ('180', '31', '2017092148', '2020-08-12', 14, 15, 0, '2020-08-12 18:33:19', 14.0000000000);
INSERT INTO `gms_order` VALUES ('181', '30', '2017098844', '2020-08-12', 16, 17, 0, '2020-08-12 21:48:50', 25.0000000000);
INSERT INTO `gms_order` VALUES ('182', '03', '2017099980', '2020-08-13', 14, 15, 0, '2020-08-13 14:20:12', 19.0000000000);
INSERT INTO `gms_order` VALUES ('183', '20', '2017052910', '2020-08-13', 13, 14, 0, '2020-08-13 19:37:14', 24.0000000000);
INSERT INTO `gms_order` VALUES ('184', '08', '2017093660', '2020-08-13', 16, 17, 1, '2020-08-13 12:40:53', 16.0000000000);
INSERT INTO `gms_order` VALUES ('185', '17', '2017058523', '2020-08-14', 14, 15, 1, '2020-08-14 19:49:16', 13.0000000000);
INSERT INTO `gms_order` VALUES ('186', '21', '2017099341', '2020-08-13', 18, 19, 0, '2020-08-13 14:11:19', 13.0000000000);
INSERT INTO `gms_order` VALUES ('187', '10', '2017055739', '2020-08-14', 16, 17, 0, '2020-08-14 22:56:49', 17.0000000000);
INSERT INTO `gms_order` VALUES ('188', '16', '2017098844', '2020-08-14', 13, 14, 0, '2020-08-14 19:21:39', 16.0000000000);
INSERT INTO `gms_order` VALUES ('189', '25', '2017052180', '2020-08-15', 15, 16, 0, '2020-08-15 16:32:17', 18.0000000000);
INSERT INTO `gms_order` VALUES ('19', '28', '2017093660', '2020-08-14', 16, 17, 0, '2020-08-14 20:31:46', 14.0000000000);
INSERT INTO `gms_order` VALUES ('190', '30', '2017051376', '2020-08-15', 18, 19, 0, '2020-08-15 20:15:41', 25.0000000000);
INSERT INTO `gms_order` VALUES ('191', '31', '2017099980', '2020-08-12', 12, 13, 0, '2020-08-12 16:15:31', 14.0000000000);
INSERT INTO `gms_order` VALUES ('192', '10', '2017099980', '2020-08-12', 18, 19, 1, '2020-08-12 14:45:12', 17.0000000000);
INSERT INTO `gms_order` VALUES ('193', '13', '2017055941', '2020-08-13', 17, 18, 0, '2020-08-13 17:32:17', 16.0000000000);
INSERT INTO `gms_order` VALUES ('194', '22', '2017053120', '2020-08-13', 17, 18, 0, '2020-08-13 23:38:40', 16.0000000000);
INSERT INTO `gms_order` VALUES ('195', '32', '2017052910', '2020-08-12', 13, 14, 0, '2020-08-12 15:18:53', 17.0000000000);
INSERT INTO `gms_order` VALUES ('196', '15', '2017055739', '2020-08-15', 11, 12, 0, '2020-08-15 15:47:21', 24.0000000000);
INSERT INTO `gms_order` VALUES ('197', '10', '2017099980', '2020-08-15', 18, 19, 0, '2020-08-15 20:26:49', 17.0000000000);
INSERT INTO `gms_order` VALUES ('198', '17', '2017092148', '2020-08-13', 14, 15, 0, '2020-08-13 16:27:44', 13.0000000000);
INSERT INTO `gms_order` VALUES ('199', '11', '2017093660', '2020-08-13', 13, 14, 0, '2020-08-13 10:36:27', 23.0000000000);
INSERT INTO `gms_order` VALUES ('2', '02', '2017099341', '2020-08-13', 13, 14, 0, '2020-08-13 10:41:30', 17.0000000000);
INSERT INTO `gms_order` VALUES ('20', '08', '2017055739', '2020-08-15', 18, 19, 0, '2020-08-15 14:29:43', 16.0000000000);
INSERT INTO `gms_order` VALUES ('200', '01', '2017057963', '2020-08-14', 18, 19, 0, '2020-08-14 12:15:47', 13.0000000000);
INSERT INTO `gms_order` VALUES ('201', '23', '2017099341', '2020-08-15', 12, 13, 0, '2020-08-15 12:37:23', 22.0000000000);
INSERT INTO `gms_order` VALUES ('202', '18', '2017099980', '2020-08-14', 17, 18, 1, '2020-08-14 18:26:26', 20.0000000000);
INSERT INTO `gms_order` VALUES ('203', '30', '2017058721', '2020-08-14', 16, 17, 0, '2020-08-14 10:28:33', 25.0000000000);
INSERT INTO `gms_order` VALUES ('204', '02', '2017057963', '2020-08-12', 14, 15, 0, '2020-08-12 15:50:21', 17.0000000000);
INSERT INTO `gms_order` VALUES ('205', '11', '2017052180', '2020-08-14', 12, 13, 0, '2020-08-14 11:22:43', 23.0000000000);
INSERT INTO `gms_order` VALUES ('206', '26', '2017053120', '2020-08-12', 14, 15, 1, '2020-08-12 15:58:47', 19.0000000000);
INSERT INTO `gms_order` VALUES ('207', '32', '2017055739', '2020-08-14', 18, 19, 1, '2020-08-14 16:36:16', 17.0000000000);
INSERT INTO `gms_order` VALUES ('208', '29', '2017052910', '2020-08-13', 14, 15, 0, '2020-08-13 21:46:26', 25.0000000000);
INSERT INTO `gms_order` VALUES ('209', '14', '2017058523', '2020-08-12', 17, 18, 0, '2020-08-12 19:58:13', 12.0000000000);
INSERT INTO `gms_order` VALUES ('21', '07', '2017093660', '2020-08-12', 16, 17, 0, '2020-08-12 12:12:19', 24.0000000000);
INSERT INTO `gms_order` VALUES ('210', '33', '2017056227', '2020-08-14', 14, 15, 0, '2020-08-14 14:21:40', 10.0000000000);
INSERT INTO `gms_order` VALUES ('211', '19', '2017055739', '2020-08-14', 16, 17, 0, '2020-08-14 18:16:22', 12.0000000000);
INSERT INTO `gms_order` VALUES ('212', '22', '2017093832', '2020-08-14', 18, 19, 0, '2020-08-14 11:51:42', 16.0000000000);
INSERT INTO `gms_order` VALUES ('213', '21', '2017093832', '2020-08-13', 11, 12, 0, '2020-08-13 14:56:26', 13.0000000000);
INSERT INTO `gms_order` VALUES ('214', '23', '2017055739', '2020-08-14', 12, 13, 0, '2020-08-14 13:16:55', 22.0000000000);
INSERT INTO `gms_order` VALUES ('215', '21', '2017053480', '2020-08-12', 17, 18, 0, '2020-08-12 12:49:43', 13.0000000000);
INSERT INTO `gms_order` VALUES ('216', '21', '2017053480', '2020-08-15', 15, 16, 0, '2020-08-15 20:21:26', 13.0000000000);
INSERT INTO `gms_order` VALUES ('217', '28', '2017093660', '2020-08-13', 17, 18, 0, '2020-08-13 15:49:12', 14.0000000000);
INSERT INTO `gms_order` VALUES ('218', '05', '2017099980', '2020-08-12', 14, 15, 1, '2020-08-12 17:58:40', 24.0000000000);
INSERT INTO `gms_order` VALUES ('219', '21', '2017099980', '2020-08-15', 16, 17, 1, '2020-08-15 13:35:32', 13.0000000000);
INSERT INTO `gms_order` VALUES ('22', '33', '2017099341', '2020-08-14', 13, 14, 0, '2020-08-14 13:27:41', 10.0000000000);
INSERT INTO `gms_order` VALUES ('220', '25', '2017093660', '2020-08-12', 14, 15, 0, '2020-08-12 11:28:46', 18.0000000000);
INSERT INTO `gms_order` VALUES ('221', '01', '2017093660', '2020-08-13', 15, 16, 0, '2020-08-13 12:18:22', 13.0000000000);
INSERT INTO `gms_order` VALUES ('222', '11', '2017052180', '2020-08-13', 16, 17, 0, '2020-08-13 11:25:24', 23.0000000000);
INSERT INTO `gms_order` VALUES ('223', '28', '2017093832', '2020-08-14', 13, 14, 0, '2020-08-14 12:52:21', 14.0000000000);
INSERT INTO `gms_order` VALUES ('224', '04', '2017055739', '2020-08-13', 14, 15, 0, '2020-08-13 22:44:36', 23.0000000000);
INSERT INTO `gms_order` VALUES ('225', '29', '2017099341', '2020-08-14', 12, 13, 0, '2020-08-14 16:33:49', 25.0000000000);
INSERT INTO `gms_order` VALUES ('226', '14', '2017053480', '2020-08-13', 14, 15, 0, '2020-08-13 13:24:18', 12.0000000000);
INSERT INTO `gms_order` VALUES ('227', '28', '2017058721', '2020-08-15', 14, 15, 0, '2020-08-15 20:52:25', 14.0000000000);
INSERT INTO `gms_order` VALUES ('228', '07', '2017057963', '2020-08-14', 15, 16, 0, '2020-08-14 16:28:47', 24.0000000000);
INSERT INTO `gms_order` VALUES ('229', '23', '2017056227', '2020-08-15', 16, 17, 0, '2020-08-15 10:46:43', 22.0000000000);
INSERT INTO `gms_order` VALUES ('23', '25', '2017059397', '2020-08-15', 10, 11, 0, '2020-08-15 23:46:18', 18.0000000000);
INSERT INTO `gms_order` VALUES ('230', '22', '2017058721', '2020-08-14', 17, 18, 1, '2020-08-14 23:32:52', 16.0000000000);
INSERT INTO `gms_order` VALUES ('231', '17', '2017051376', '2020-08-12', 16, 17, 0, '2020-08-12 11:55:34', 13.0000000000);
INSERT INTO `gms_order` VALUES ('232', '06', '2017057963', '2020-08-13', 14, 15, 0, '2020-08-13 11:25:46', 16.0000000000);
INSERT INTO `gms_order` VALUES ('233', '11', '2017099980', '2020-08-15', 14, 15, 1, '2020-08-15 16:17:56', 23.0000000000);
INSERT INTO `gms_order` VALUES ('234', '29', '2017057963', '2020-08-12', 14, 15, 0, '2020-08-12 12:53:57', 25.0000000000);
INSERT INTO `gms_order` VALUES ('235', '18', '2017056227', '2020-08-12', 11, 12, 0, '2020-08-12 14:58:22', 20.0000000000);
INSERT INTO `gms_order` VALUES ('236', '03', '2017052180', '2020-08-13', 15, 16, 0, '2020-08-13 10:23:57', 19.0000000000);
INSERT INTO `gms_order` VALUES ('237', '28', '2017098844', '2020-08-15', 13, 14, 0, '2020-08-15 16:55:58', 14.0000000000);
INSERT INTO `gms_order` VALUES ('238', '18', '2017093660', '2020-08-15', 11, 12, 0, '2020-08-15 17:27:59', 20.0000000000);
INSERT INTO `gms_order` VALUES ('239', '10', '2017092148', '2020-08-13', 16, 17, 0, '2020-08-13 13:51:56', 17.0000000000);
INSERT INTO `gms_order` VALUES ('24', '16', '2017098844', '2020-08-13', 16, 17, 1, '2020-08-13 21:56:36', 16.0000000000);
INSERT INTO `gms_order` VALUES ('240', '03', '2017099980', '2020-08-15', 14, 15, 0, '2020-08-15 14:41:34', 19.0000000000);
INSERT INTO `gms_order` VALUES ('241', '17', '2017052910', '2020-08-13', 16, 17, 0, '2020-08-13 15:48:35', 13.0000000000);
INSERT INTO `gms_order` VALUES ('242', '12', '2017093660', '2020-08-15', 12, 13, 0, '2020-08-15 13:33:27', 15.0000000000);
INSERT INTO `gms_order` VALUES ('243', '29', '2017056227', '2020-08-12', 10, 11, 0, '2020-08-12 12:34:37', 25.0000000000);
INSERT INTO `gms_order` VALUES ('244', '13', '2017051376', '2020-08-14', 16, 17, 0, '2020-08-14 16:14:10', 16.0000000000);
INSERT INTO `gms_order` VALUES ('245', '21', '2017052910', '2020-08-15', 18, 19, 1, '2020-08-15 21:46:31', 13.0000000000);
INSERT INTO `gms_order` VALUES ('246', '08', '2017052910', '2020-08-13', 18, 19, 0, '2020-08-13 12:23:58', 16.0000000000);
INSERT INTO `gms_order` VALUES ('247', '03', '2017053480', '2020-08-14', 17, 18, 1, '2020-08-14 14:50:24', 19.0000000000);
INSERT INTO `gms_order` VALUES ('248', '33', '2017052910', '2020-08-14', 15, 16, 0, '2020-08-14 10:43:40', 10.0000000000);
INSERT INTO `gms_order` VALUES ('249', '01', '2017053480', '2020-08-15', 17, 18, 0, '2020-08-15 13:33:46', 13.0000000000);
INSERT INTO `gms_order` VALUES ('25', '21', '2017054904', '2020-08-12', 12, 13, 0, '2020-08-12 20:14:35', 13.0000000000);
INSERT INTO `gms_order` VALUES ('250', '11', '2017056390', '2020-08-13', 17, 18, 0, '2020-08-13 12:30:54', 23.0000000000);
INSERT INTO `gms_order` VALUES ('251', '05', '2017055941', '2020-08-14', 11, 12, 1, '2020-08-14 23:26:23', 24.0000000000);
INSERT INTO `gms_order` VALUES ('252', '23', '2017055941', '2020-08-15', 17, 18, 1, '2020-08-15 22:26:48', 22.0000000000);
INSERT INTO `gms_order` VALUES ('253', '32', '2017056227', '2020-08-14', 12, 13, 0, '2020-08-14 18:59:14', 17.0000000000);
INSERT INTO `gms_order` VALUES ('254', '24', '2017099341', '2020-08-12', 16, 17, 0, '2020-08-12 15:37:28', 20.0000000000);
INSERT INTO `gms_order` VALUES ('255', '24', '2017059397', '2020-08-13', 16, 17, 0, '2020-08-13 15:32:20', 20.0000000000);
INSERT INTO `gms_order` VALUES ('256', '32', '2017098844', '2020-08-12', 15, 16, 0, '2020-08-12 12:53:26', 17.0000000000);
INSERT INTO `gms_order` VALUES ('257', '07', '2017057963', '2020-08-13', 15, 16, 0, '2020-08-13 19:53:42', 24.0000000000);
INSERT INTO `gms_order` VALUES ('258', '18', '2017099341', '2020-08-12', 13, 14, 1, '2020-08-12 22:27:13', 20.0000000000);
INSERT INTO `gms_order` VALUES ('259', '04', '2017055739', '2020-08-14', 16, 17, 0, '2020-08-14 20:58:56', 23.0000000000);
INSERT INTO `gms_order` VALUES ('26', '26', '2017093832', '2020-08-14', 18, 19, 0, '2020-08-14 10:32:26', 19.0000000000);
INSERT INTO `gms_order` VALUES ('260', '20', '2017058523', '2020-08-15', 10, 11, 0, '2020-08-15 22:14:45', 24.0000000000);
INSERT INTO `gms_order` VALUES ('261', '13', '2017092148', '2020-08-15', 16, 17, 0, '2020-08-15 17:47:53', 16.0000000000);
INSERT INTO `gms_order` VALUES ('262', '28', '2017052180', '2020-08-15', 16, 17, 1, '2020-08-15 22:30:10', 14.0000000000);
INSERT INTO `gms_order` VALUES ('263', '32', '2017099980', '2020-08-12', 14, 15, 0, '2020-08-12 17:39:46', 17.0000000000);
INSERT INTO `gms_order` VALUES ('264', '22', '2017058721', '2020-08-15', 15, 16, 0, '2020-08-15 22:52:15', 16.0000000000);
INSERT INTO `gms_order` VALUES ('265', '27', '2017059397', '2020-08-15', 13, 14, 0, '2020-08-15 15:55:43', 12.0000000000);
INSERT INTO `gms_order` VALUES ('266', '30', '2017093660', '2020-08-14', 14, 15, 0, '2020-08-14 21:46:52', 25.0000000000);
INSERT INTO `gms_order` VALUES ('267', '31', '2017054904', '2020-08-13', 11, 12, 0, '2020-08-13 21:23:22', 14.0000000000);
INSERT INTO `gms_order` VALUES ('268', '24', '2017056390', '2020-08-14', 14, 15, 0, '2020-08-14 21:13:16', 20.0000000000);
INSERT INTO `gms_order` VALUES ('269', '25', '2017055739', '2020-08-15', 13, 14, 0, '2020-08-15 15:35:48', 18.0000000000);
INSERT INTO `gms_order` VALUES ('27', '21', '2017055739', '2020-08-15', 12, 13, 0, '2020-08-15 18:17:26', 13.0000000000);
INSERT INTO `gms_order` VALUES ('270', '30', '2017093832', '2020-08-12', 17, 18, 0, '2020-08-12 20:40:59', 25.0000000000);
INSERT INTO `gms_order` VALUES ('271', '21', '2017058721', '2020-08-13', 14, 15, 0, '2020-08-13 13:43:59', 13.0000000000);
INSERT INTO `gms_order` VALUES ('272', '20', '2017057963', '2020-08-14', 14, 15, 1, '2020-08-14 15:48:19', 24.0000000000);
INSERT INTO `gms_order` VALUES ('273', '19', '2017099341', '2020-08-14', 12, 13, 0, '2020-08-14 21:36:47', 12.0000000000);
INSERT INTO `gms_order` VALUES ('274', '14', '2017055941', '2020-08-14', 15, 16, 1, '2020-08-14 20:29:21', 12.0000000000);
INSERT INTO `gms_order` VALUES ('275', '17', '2017053480', '2020-08-14', 13, 14, 0, '2020-08-14 21:45:57', 13.0000000000);
INSERT INTO `gms_order` VALUES ('276', '21', '2017092148', '2020-08-13', 17, 18, 0, '2020-08-13 21:47:16', 13.0000000000);
INSERT INTO `gms_order` VALUES ('277', '28', '2017093832', '2020-08-12', 13, 14, 0, '2020-08-12 10:37:15', 14.0000000000);
INSERT INTO `gms_order` VALUES ('278', '20', '2017098844', '2020-08-12', 12, 13, 0, '2020-08-12 23:49:28', 24.0000000000);
INSERT INTO `gms_order` VALUES ('279', '30', '2017057963', '2020-08-15', 13, 14, 0, '2020-08-15 14:32:35', 25.0000000000);
INSERT INTO `gms_order` VALUES ('28', '06', '2017051376', '2020-08-14', 14, 15, 0, '2020-08-14 21:37:10', 16.0000000000);
INSERT INTO `gms_order` VALUES ('280', '23', '2017093660', '2020-08-14', 13, 14, 1, '2020-08-14 12:33:49', 22.0000000000);
INSERT INTO `gms_order` VALUES ('281', '09', '2017055941', '2020-08-13', 13, 14, 0, '2020-08-13 15:29:20', 17.0000000000);
INSERT INTO `gms_order` VALUES ('282', '10', '2017052910', '2020-08-12', 15, 16, 0, '2020-08-12 13:58:50', 17.0000000000);
INSERT INTO `gms_order` VALUES ('283', '32', '2017055941', '2020-08-15', 10, 11, 0, '2020-08-15 13:26:46', 17.0000000000);
INSERT INTO `gms_order` VALUES ('284', '03', '2017092148', '2020-08-14', 10, 11, 0, '2020-08-14 16:39:22', 19.0000000000);
INSERT INTO `gms_order` VALUES ('285', '18', '2017099341', '2020-08-15', 17, 18, 0, '2020-08-15 11:23:31', 20.0000000000);
INSERT INTO `gms_order` VALUES ('286', '08', '2017051376', '2020-08-15', 15, 16, 0, '2020-08-15 16:44:42', 16.0000000000);
INSERT INTO `gms_order` VALUES ('287', '18', '2017056227', '2020-08-13', 14, 15, 0, '2020-08-13 15:17:42', 20.0000000000);
INSERT INTO `gms_order` VALUES ('288', '22', '2017092148', '2020-08-15', 17, 18, 1, '2020-08-15 16:36:32', 16.0000000000);
INSERT INTO `gms_order` VALUES ('289', '20', '2017053480', '2020-08-15', 15, 16, 1, '2020-08-15 22:50:50', 24.0000000000);
INSERT INTO `gms_order` VALUES ('29', '32', '2017053120', '2020-08-14', 13, 14, 0, '2020-08-14 17:32:21', 17.0000000000);
INSERT INTO `gms_order` VALUES ('290', '02', '2017058721', '2020-08-14', 13, 14, 0, '2020-08-14 20:16:33', 17.0000000000);
INSERT INTO `gms_order` VALUES ('291', '09', '2017055941', '2020-08-12', 16, 17, 0, '2020-08-12 11:43:13', 17.0000000000);
INSERT INTO `gms_order` VALUES ('292', '19', '2017053480', '2020-08-15', 11, 12, 0, '2020-08-15 23:40:19', 12.0000000000);
INSERT INTO `gms_order` VALUES ('293', '07', '2017056390', '2020-08-15', 18, 19, 1, '2020-08-15 11:19:56', 24.0000000000);
INSERT INTO `gms_order` VALUES ('294', '29', '2017099341', '2020-08-14', 13, 14, 0, '2020-08-14 10:35:52', 25.0000000000);
INSERT INTO `gms_order` VALUES ('295', '11', '2017098844', '2020-08-12', 13, 14, 1, '2020-08-12 14:30:51', 23.0000000000);
INSERT INTO `gms_order` VALUES ('296', '26', '2017092148', '2020-08-13', 12, 13, 1, '2020-08-13 11:21:47', 19.0000000000);
INSERT INTO `gms_order` VALUES ('297', '31', '2017052180', '2020-08-15', 13, 14, 0, '2020-08-15 13:21:39', 14.0000000000);
INSERT INTO `gms_order` VALUES ('298', '28', '2017052910', '2020-08-15', 17, 18, 0, '2020-08-15 20:28:11', 14.0000000000);
INSERT INTO `gms_order` VALUES ('299', '05', '2017099980', '2020-08-13', 10, 11, 0, '2020-08-13 15:24:25', 24.0000000000);
INSERT INTO `gms_order` VALUES ('3', '05', '2017099341', '2020-08-14', 10, 11, 0, '2020-08-14 18:38:39', 24.0000000000);
INSERT INTO `gms_order` VALUES ('30', '11', '2017099980', '2020-08-13', 12, 13, 0, '2020-08-13 13:57:40', 23.0000000000);
INSERT INTO `gms_order` VALUES ('300', '10', '2017051376', '2020-08-15', 15, 16, 0, '2020-08-15 20:26:15', 17.0000000000);
INSERT INTO `gms_order` VALUES ('301', '18', '2017093660', '2020-08-13', 13, 14, 1, '2020-08-13 11:20:34', 20.0000000000);
INSERT INTO `gms_order` VALUES ('302', '27', '2017057963', '2020-08-13', 17, 18, 0, '2020-08-13 17:59:33', 12.0000000000);
INSERT INTO `gms_order` VALUES ('303', '10', '2017092148', '2020-08-12', 14, 15, 1, '2020-08-12 14:36:45', 17.0000000000);
INSERT INTO `gms_order` VALUES ('304', '22', '2017058523', '2020-08-12', 15, 16, 0, '2020-08-12 12:11:37', 16.0000000000);
INSERT INTO `gms_order` VALUES ('305', '14', '2017055941', '2020-08-12', 16, 17, 0, '2020-08-12 15:56:24', 12.0000000000);
INSERT INTO `gms_order` VALUES ('306', '01', '2017092148', '2020-08-12', 18, 19, 0, '2020-08-12 21:54:27', 13.0000000000);
INSERT INTO `gms_order` VALUES ('307', '29', '2017059397', '2020-08-14', 16, 17, 0, '2020-08-14 17:34:38', 25.0000000000);
INSERT INTO `gms_order` VALUES ('308', '08', '2017055941', '2020-08-15', 11, 12, 0, '2020-08-15 13:59:27', 16.0000000000);
INSERT INTO `gms_order` VALUES ('309', '18', '2017053120', '2020-08-13', 17, 18, 0, '2020-08-13 12:16:54', 20.0000000000);
INSERT INTO `gms_order` VALUES ('31', '15', '2017099980', '2020-08-12', 13, 14, 0, '2020-08-12 20:18:42', 24.0000000000);
INSERT INTO `gms_order` VALUES ('310', '28', '2017059397', '2020-08-14', 11, 12, 1, '2020-08-14 13:26:51', 14.0000000000);
INSERT INTO `gms_order` VALUES ('311', '16', '2017093832', '2020-08-14', 15, 16, 0, '2020-08-14 21:13:42', 16.0000000000);
INSERT INTO `gms_order` VALUES ('312', '13', '2017099341', '2020-08-13', 13, 14, 1, '2020-08-13 17:18:53', 16.0000000000);
INSERT INTO `gms_order` VALUES ('313', '32', '2017053120', '2020-08-13', 10, 11, 1, '2020-08-13 10:23:31', 17.0000000000);
INSERT INTO `gms_order` VALUES ('314', '02', '2017055739', '2020-08-14', 11, 12, 0, '2020-08-14 21:38:38', 17.0000000000);
INSERT INTO `gms_order` VALUES ('315', '18', '2017052910', '2020-08-13', 15, 16, 0, '2020-08-13 19:12:15', 20.0000000000);
INSERT INTO `gms_order` VALUES ('316', '14', '2017056390', '2020-08-15', 15, 16, 0, '2020-08-15 13:48:49', 12.0000000000);
INSERT INTO `gms_order` VALUES ('317', '01', '2017058721', '2020-08-14', 17, 18, 0, '2020-08-14 17:21:49', 13.0000000000);
INSERT INTO `gms_order` VALUES ('318', '29', '2017098844', '2020-08-14', 15, 16, 0, '2020-08-14 19:26:11', 25.0000000000);
INSERT INTO `gms_order` VALUES ('319', '21', '2017055739', '2020-08-12', 11, 12, 0, '2020-08-12 21:11:49', 13.0000000000);
INSERT INTO `gms_order` VALUES ('32', '13', '2017055739', '2020-08-14', 13, 14, 0, '2020-08-14 17:35:19', 16.0000000000);
INSERT INTO `gms_order` VALUES ('320', '26', '2017098844', '2020-08-13', 14, 15, 0, '2020-08-13 23:36:51', 19.0000000000);
INSERT INTO `gms_order` VALUES ('321', '19', '2017051376', '2020-08-14', 14, 15, 0, '2020-08-14 10:56:46', 12.0000000000);
INSERT INTO `gms_order` VALUES ('322', '16', '2017054904', '2020-08-12', 16, 17, 0, '2020-08-12 18:18:39', 16.0000000000);
INSERT INTO `gms_order` VALUES ('323', '33', '2017052180', '2020-08-15', 15, 16, 0, '2020-08-15 19:12:16', 10.0000000000);
INSERT INTO `gms_order` VALUES ('324', '03', '2017093660', '2020-08-15', 17, 18, 0, '2020-08-15 11:46:51', 19.0000000000);
INSERT INTO `gms_order` VALUES ('325', '22', '2017051376', '2020-08-12', 14, 15, 0, '2020-08-12 16:48:24', 16.0000000000);
INSERT INTO `gms_order` VALUES ('326', '23', '2017053480', '2020-08-12', 16, 17, 0, '2020-08-12 15:39:56', 22.0000000000);
INSERT INTO `gms_order` VALUES ('327', '31', '2017057963', '2020-08-12', 15, 16, 1, '2020-08-12 22:48:35', 14.0000000000);
INSERT INTO `gms_order` VALUES ('328', '25', '2017053120', '2020-08-15', 12, 13, 0, '2020-08-15 14:20:35', 18.0000000000);
INSERT INTO `gms_order` VALUES ('329', '22', '2017053120', '2020-08-13', 18, 19, 0, '2020-08-13 20:38:42', 16.0000000000);
INSERT INTO `gms_order` VALUES ('33', '22', '2017093660', '2020-08-13', 12, 13, 0, '2020-08-13 15:51:39', 16.0000000000);
INSERT INTO `gms_order` VALUES ('330', '21', '2017098844', '2020-08-14', 13, 14, 0, '2020-08-14 19:19:47', 13.0000000000);
INSERT INTO `gms_order` VALUES ('331', '22', '2017099341', '2020-08-13', 10, 11, 0, '2020-08-13 22:24:21', 16.0000000000);
INSERT INTO `gms_order` VALUES ('332', '05', '2017058523', '2020-08-14', 16, 17, 0, '2020-08-14 12:12:23', 24.0000000000);
INSERT INTO `gms_order` VALUES ('333', '12', '2017058523', '2020-08-13', 15, 16, 0, '2020-08-13 10:51:39', 15.0000000000);
INSERT INTO `gms_order` VALUES ('334', '32', '2017057963', '2020-08-14', 15, 16, 0, '2020-08-14 15:44:49', 17.0000000000);
INSERT INTO `gms_order` VALUES ('335', '33', '2017098844', '2020-08-15', 16, 17, 0, '2020-08-15 20:16:55', 10.0000000000);
INSERT INTO `gms_order` VALUES ('336', '29', '2017055739', '2020-08-15', 12, 13, 1, '2020-08-15 17:42:18', 25.0000000000);
INSERT INTO `gms_order` VALUES ('337', '17', '2017099980', '2020-08-15', 16, 17, 0, '2020-08-15 10:48:43', 13.0000000000);
INSERT INTO `gms_order` VALUES ('338', '01', '2017098844', '2020-08-13', 13, 14, 0, '2020-08-13 14:48:54', 13.0000000000);
INSERT INTO `gms_order` VALUES ('339', '28', '2017093832', '2020-08-13', 13, 14, 0, '2020-08-13 21:55:18', 14.0000000000);
INSERT INTO `gms_order` VALUES ('34', '25', '2017099980', '2020-08-12', 11, 12, 0, '2020-08-12 17:28:27', 18.0000000000);
INSERT INTO `gms_order` VALUES ('340', '24', '2017058721', '2020-08-12', 13, 14, 0, '2020-08-12 20:30:13', 20.0000000000);
INSERT INTO `gms_order` VALUES ('341', '01', '2017052910', '2020-08-15', 16, 17, 0, '2020-08-15 14:13:26', 13.0000000000);
INSERT INTO `gms_order` VALUES ('342', '03', '2017055941', '2020-08-12', 11, 12, 0, '2020-08-12 12:59:35', 19.0000000000);
INSERT INTO `gms_order` VALUES ('343', '29', '2017058721', '2020-08-13', 15, 16, 0, '2020-08-13 13:35:27', 25.0000000000);
INSERT INTO `gms_order` VALUES ('344', '21', '2017057963', '2020-08-14', 15, 16, 0, '2020-08-14 23:39:24', 13.0000000000);
INSERT INTO `gms_order` VALUES ('345', '12', '2017055739', '2020-08-12', 13, 14, 0, '2020-08-12 20:22:37', 15.0000000000);
INSERT INTO `gms_order` VALUES ('346', '13', '2017093832', '2020-08-15', 12, 13, 0, '2020-08-15 10:56:33', 16.0000000000);
INSERT INTO `gms_order` VALUES ('347', '21', '2017058721', '2020-08-15', 14, 15, 0, '2020-08-15 12:39:20', 13.0000000000);
INSERT INTO `gms_order` VALUES ('348', '24', '2017058523', '2020-08-13', 12, 13, 0, '2020-08-13 21:12:10', 20.0000000000);
INSERT INTO `gms_order` VALUES ('349', '05', '2017058523', '2020-08-13', 13, 14, 0, '2020-08-13 11:30:19', 24.0000000000);
INSERT INTO `gms_order` VALUES ('35', '13', '2017057963', '2020-08-14', 17, 18, 0, '2020-08-14 22:47:33', 16.0000000000);
INSERT INTO `gms_order` VALUES ('350', '25', '2017059397', '2020-08-15', 17, 18, 1, '2020-08-15 14:45:54', 18.0000000000);
INSERT INTO `gms_order` VALUES ('351', '29', '2017053480', '2020-08-12', 15, 16, 1, '2020-08-12 21:23:40', 25.0000000000);
INSERT INTO `gms_order` VALUES ('352', '02', '2017056390', '2020-08-14', 14, 15, 0, '2020-08-14 16:45:30', 17.0000000000);
INSERT INTO `gms_order` VALUES ('353', '26', '2017056227', '2020-08-13', 15, 16, 0, '2020-08-13 23:27:16', 19.0000000000);
INSERT INTO `gms_order` VALUES ('354', '32', '2017055739', '2020-08-15', 18, 19, 0, '2020-08-15 21:22:11', 17.0000000000);
INSERT INTO `gms_order` VALUES ('355', '13', '2017053480', '2020-08-13', 15, 16, 0, '2020-08-13 21:50:25', 16.0000000000);
INSERT INTO `gms_order` VALUES ('356', '14', '2017093660', '2020-08-14', 17, 18, 0, '2020-08-14 22:47:23', 12.0000000000);
INSERT INTO `gms_order` VALUES ('357', '08', '2017053120', '2020-08-13', 13, 14, 0, '2020-08-13 23:12:11', 16.0000000000);
INSERT INTO `gms_order` VALUES ('358', '02', '2017099980', '2020-08-15', 13, 14, 0, '2020-08-15 18:52:46', 17.0000000000);
INSERT INTO `gms_order` VALUES ('359', '31', '2017056390', '2020-08-14', 15, 16, 0, '2020-08-14 20:48:53', 14.0000000000);
INSERT INTO `gms_order` VALUES ('36', '02', '2017059397', '2020-08-13', 15, 16, 0, '2020-08-13 12:27:18', 17.0000000000);
INSERT INTO `gms_order` VALUES ('360', '04', '2017059397', '2020-08-15', 15, 16, 0, '2020-08-15 10:52:56', 23.0000000000);
INSERT INTO `gms_order` VALUES ('361', '26', '2017051376', '2020-08-12', 17, 18, 1, '2020-08-12 23:33:41', 19.0000000000);
INSERT INTO `gms_order` VALUES ('362', '07', '2017054904', '2020-08-14', 16, 17, 0, '2020-08-14 14:14:18', 24.0000000000);
INSERT INTO `gms_order` VALUES ('363', '29', '2017058721', '2020-08-15', 16, 17, 0, '2020-08-15 11:51:14', 25.0000000000);
INSERT INTO `gms_order` VALUES ('364', '07', '2017051376', '2020-08-12', 13, 14, 1, '2020-08-12 14:32:37', 24.0000000000);
INSERT INTO `gms_order` VALUES ('365', '22', '2017056227', '2020-08-13', 14, 15, 0, '2020-08-13 22:28:19', 16.0000000000);
INSERT INTO `gms_order` VALUES ('366', '14', '2017051376', '2020-08-13', 12, 13, 0, '2020-08-13 12:57:56', 12.0000000000);
INSERT INTO `gms_order` VALUES ('367', '16', '2017054904', '2020-08-14', 16, 17, 0, '2020-08-14 10:35:56', 16.0000000000);
INSERT INTO `gms_order` VALUES ('368', '28', '2017092148', '2020-08-15', 10, 11, 1, '2020-08-15 12:38:20', 14.0000000000);
INSERT INTO `gms_order` VALUES ('369', '27', '2017055941', '2020-08-15', 16, 17, 0, '2020-08-15 10:27:47', 12.0000000000);
INSERT INTO `gms_order` VALUES ('37', '25', '2017053480', '2020-08-14', 16, 17, 0, '2020-08-14 12:17:24', 18.0000000000);
INSERT INTO `gms_order` VALUES ('370', '07', '2017055739', '2020-08-15', 16, 17, 0, '2020-08-15 12:12:30', 24.0000000000);
INSERT INTO `gms_order` VALUES ('371', '33', '2017052180', '2020-08-13', 15, 16, 0, '2020-08-13 15:36:48', 10.0000000000);
INSERT INTO `gms_order` VALUES ('372', '25', '2017057963', '2020-08-14', 10, 11, 0, '2020-08-14 18:12:24', 18.0000000000);
INSERT INTO `gms_order` VALUES ('373', '05', '2017099980', '2020-08-12', 15, 16, 1, '2020-08-12 20:19:32', 24.0000000000);
INSERT INTO `gms_order` VALUES ('374', '04', '2017057963', '2020-08-13', 18, 19, 0, '2020-08-13 10:13:25', 23.0000000000);
INSERT INTO `gms_order` VALUES ('375', '32', '2017098844', '2020-08-15', 15, 16, 1, '2020-08-15 22:15:14', 17.0000000000);
INSERT INTO `gms_order` VALUES ('376', '33', '2017053480', '2020-08-12', 16, 17, 1, '2020-08-12 18:38:14', 10.0000000000);
INSERT INTO `gms_order` VALUES ('377', '06', '2017056227', '2020-08-14', 13, 14, 0, '2020-08-14 10:54:40', 16.0000000000);
INSERT INTO `gms_order` VALUES ('378', '09', '2017057963', '2020-08-15', 16, 17, 0, '2020-08-15 15:32:41', 17.0000000000);
INSERT INTO `gms_order` VALUES ('379', '22', '2017052180', '2020-08-15', 18, 19, 0, '2020-08-15 18:17:16', 16.0000000000);
INSERT INTO `gms_order` VALUES ('38', '03', '2017053480', '2020-08-12', 15, 16, 0, '2020-08-12 21:59:10', 19.0000000000);
INSERT INTO `gms_order` VALUES ('380', '20', '2017051376', '2020-08-13', 15, 16, 0, '2020-08-13 19:47:32', 24.0000000000);
INSERT INTO `gms_order` VALUES ('381', '09', '2017052180', '2020-08-12', 17, 18, 0, '2020-08-12 13:45:39', 17.0000000000);
INSERT INTO `gms_order` VALUES ('382', '30', '2017056390', '2020-08-12', 15, 16, 0, '2020-08-12 11:31:54', 25.0000000000);
INSERT INTO `gms_order` VALUES ('383', '12', '2017056227', '2020-08-12', 14, 15, 0, '2020-08-12 13:37:24', 15.0000000000);
INSERT INTO `gms_order` VALUES ('384', '09', '2017059397', '2020-08-15', 17, 18, 0, '2020-08-15 14:59:56', 17.0000000000);
INSERT INTO `gms_order` VALUES ('385', '16', '2017053120', '2020-08-15', 13, 14, 0, '2020-08-15 13:21:16', 16.0000000000);
INSERT INTO `gms_order` VALUES ('386', '23', '2017099980', '2020-08-12', 15, 16, 0, '2020-08-12 18:14:50', 22.0000000000);
INSERT INTO `gms_order` VALUES ('387', '16', '2017093832', '2020-08-15', 14, 15, 0, '2020-08-15 11:31:18', 16.0000000000);
INSERT INTO `gms_order` VALUES ('388', '05', '2017053480', '2020-08-13', 16, 17, 0, '2020-08-13 13:56:38', 24.0000000000);
INSERT INTO `gms_order` VALUES ('389', '21', '2017056390', '2020-08-14', 17, 18, 0, '2020-08-14 23:13:32', 13.0000000000);
INSERT INTO `gms_order` VALUES ('39', '29', '2017055941', '2020-08-15', 13, 14, 0, '2020-08-15 15:59:16', 25.0000000000);
INSERT INTO `gms_order` VALUES ('390', '03', '2017058523', '2020-08-14', 12, 13, 0, '2020-08-14 15:23:36', 19.0000000000);
INSERT INTO `gms_order` VALUES ('391', '22', '2017055739', '2020-08-14', 11, 12, 0, '2020-08-14 11:52:37', 16.0000000000);
INSERT INTO `gms_order` VALUES ('392', '24', '2017056390', '2020-08-13', 14, 15, 0, '2020-08-13 20:12:57', 20.0000000000);
INSERT INTO `gms_order` VALUES ('393', '25', '2017093660', '2020-08-13', 17, 18, 0, '2020-08-13 20:30:46', 18.0000000000);
INSERT INTO `gms_order` VALUES ('394', '07', '2017058721', '2020-08-15', 17, 18, 1, '2020-08-15 10:39:20', 24.0000000000);
INSERT INTO `gms_order` VALUES ('395', '10', '2017053120', '2020-08-14', 15, 16, 0, '2020-08-14 10:49:33', 17.0000000000);
INSERT INTO `gms_order` VALUES ('396', '17', '2017056227', '2020-08-12', 15, 16, 0, '2020-08-12 16:27:53', 13.0000000000);
INSERT INTO `gms_order` VALUES ('397', '18', '2017051376', '2020-08-15', 16, 17, 0, '2020-08-15 21:44:39', 20.0000000000);
INSERT INTO `gms_order` VALUES ('398', '30', '2017056390', '2020-08-13', 18, 19, 0, '2020-08-13 14:49:24', 25.0000000000);
INSERT INTO `gms_order` VALUES ('399', '24', '2017098844', '2020-08-13', 15, 16, 0, '2020-08-13 19:58:23', 20.0000000000);
INSERT INTO `gms_order` VALUES ('4', '28', '2017093832', '2020-08-13', 14, 15, 1, '2020-08-13 14:39:52', 14.0000000000);
INSERT INTO `gms_order` VALUES ('40', '15', '2017059397', '2020-08-14', 13, 14, 0, '2020-08-14 23:47:19', 24.0000000000);
INSERT INTO `gms_order` VALUES ('400', '25', '2017058523', '2020-08-13', 14, 15, 0, '2020-08-13 12:56:14', 18.0000000000);
INSERT INTO `gms_order` VALUES ('401', '26', '2017055739', '2020-08-14', 14, 15, 1, '2020-08-14 22:54:18', 19.0000000000);
INSERT INTO `gms_order` VALUES ('402', '28', '2017053480', '2020-08-14', 10, 11, 0, '2020-08-14 15:38:54', 14.0000000000);
INSERT INTO `gms_order` VALUES ('403', '22', '2017052180', '2020-08-12', 10, 11, 0, '2020-08-12 17:29:15', 16.0000000000);
INSERT INTO `gms_order` VALUES ('404', '27', '2017098844', '2020-08-15', 18, 19, 0, '2020-08-15 15:13:22', 12.0000000000);
INSERT INTO `gms_order` VALUES ('405', '07', '2017099980', '2020-08-15', 13, 14, 0, '2020-08-15 15:52:45', 24.0000000000);
INSERT INTO `gms_order` VALUES ('406', '22', '2017051376', '2020-08-12', 17, 18, 0, '2020-08-12 19:34:32', 16.0000000000);
INSERT INTO `gms_order` VALUES ('407', '08', '2017059397', '2020-08-14', 16, 17, 1, '2020-08-14 17:59:50', 16.0000000000);
INSERT INTO `gms_order` VALUES ('408', '26', '2017059397', '2020-08-13', 18, 19, 0, '2020-08-13 16:58:44', 19.0000000000);
INSERT INTO `gms_order` VALUES ('409', '32', '2017093832', '2020-08-13', 18, 19, 0, '2020-08-13 15:55:28', 17.0000000000);
INSERT INTO `gms_order` VALUES ('41', '22', '2017051376', '2020-08-12', 13, 14, 1, '2020-08-12 12:47:33', 16.0000000000);
INSERT INTO `gms_order` VALUES ('410', '10', '2017055941', '2020-08-14', 17, 18, 1, '2020-08-14 20:40:22', 17.0000000000);
INSERT INTO `gms_order` VALUES ('411', '11', '2017057963', '2020-08-15', 17, 18, 0, '2020-08-15 17:39:29', 23.0000000000);
INSERT INTO `gms_order` VALUES ('412', '01', '2017099341', '2020-08-14', 15, 16, 1, '2020-08-14 16:50:44', 13.0000000000);
INSERT INTO `gms_order` VALUES ('413', '33', '2017057963', '2020-08-13', 14, 15, 0, '2020-08-13 19:32:33', 10.0000000000);
INSERT INTO `gms_order` VALUES ('414', '10', '2017053120', '2020-08-15', 13, 14, 0, '2020-08-15 16:23:16', 17.0000000000);
INSERT INTO `gms_order` VALUES ('415', '05', '2017054904', '2020-08-14', 13, 14, 0, '2020-08-14 20:56:48', 24.0000000000);
INSERT INTO `gms_order` VALUES ('416', '32', '2017055941', '2020-08-15', 16, 17, 0, '2020-08-15 16:50:10', 17.0000000000);
INSERT INTO `gms_order` VALUES ('417', '11', '2017053120', '2020-08-13', 15, 16, 0, '2020-08-13 17:39:42', 23.0000000000);
INSERT INTO `gms_order` VALUES ('418', '05', '2017053480', '2020-08-12', 16, 17, 0, '2020-08-12 18:30:15', 24.0000000000);
INSERT INTO `gms_order` VALUES ('419', '16', '2017052180', '2020-08-12', 15, 16, 0, '2020-08-12 18:52:58', 16.0000000000);
INSERT INTO `gms_order` VALUES ('42', '17', '2017056227', '2020-08-15', 15, 16, 1, '2020-08-15 20:57:30', 13.0000000000);
INSERT INTO `gms_order` VALUES ('420', '01', '2017056390', '2020-08-12', 13, 14, 0, '2020-08-12 15:23:44', 13.0000000000);
INSERT INTO `gms_order` VALUES ('421', '26', '2017056227', '2020-08-15', 14, 15, 0, '2020-08-15 16:42:14', 19.0000000000);
INSERT INTO `gms_order` VALUES ('422', '21', '2017055739', '2020-08-12', 16, 17, 0, '2020-08-12 17:55:36', 13.0000000000);
INSERT INTO `gms_order` VALUES ('423', '08', '2017099341', '2020-08-13', 17, 18, 0, '2020-08-13 17:47:34', 16.0000000000);
INSERT INTO `gms_order` VALUES ('424', '24', '2017053480', '2020-08-15', 15, 16, 1, '2020-08-15 10:34:22', 20.0000000000);
INSERT INTO `gms_order` VALUES ('425', '03', '2017057963', '2020-08-14', 11, 12, 0, '2020-08-14 17:55:29', 19.0000000000);
INSERT INTO `gms_order` VALUES ('426', '14', '2017058721', '2020-08-12', 13, 14, 0, '2020-08-12 20:39:36', 12.0000000000);
INSERT INTO `gms_order` VALUES ('427', '15', '2017093660', '2020-08-15', 13, 14, 0, '2020-08-15 22:19:10', 24.0000000000);
INSERT INTO `gms_order` VALUES ('428', '24', '2017052910', '2020-08-12', 15, 16, 0, '2020-08-12 21:10:19', 20.0000000000);
INSERT INTO `gms_order` VALUES ('429', '07', '2017053120', '2020-08-13', 17, 18, 1, '2020-08-13 16:41:44', 24.0000000000);
INSERT INTO `gms_order` VALUES ('43', '15', '2017053480', '2020-08-13', 13, 14, 0, '2020-08-13 18:46:43', 24.0000000000);
INSERT INTO `gms_order` VALUES ('430', '18', '2017056227', '2020-08-14', 16, 17, 0, '2020-08-14 20:34:26', 20.0000000000);
INSERT INTO `gms_order` VALUES ('431', '27', '2017098844', '2020-08-13', 15, 16, 1, '2020-08-13 15:47:15', 12.0000000000);
INSERT INTO `gms_order` VALUES ('432', '01', '2017099341', '2020-08-14', 13, 14, 0, '2020-08-14 14:33:56', 13.0000000000);
INSERT INTO `gms_order` VALUES ('433', '10', '2017055739', '2020-08-13', 12, 13, 0, '2020-08-13 17:20:32', 17.0000000000);
INSERT INTO `gms_order` VALUES ('434', '05', '2017056227', '2020-08-12', 11, 12, 1, '2020-08-12 20:54:57', 24.0000000000);
INSERT INTO `gms_order` VALUES ('435', '25', '2017053480', '2020-08-14', 17, 18, 0, '2020-08-14 21:19:15', 18.0000000000);
INSERT INTO `gms_order` VALUES ('436', '18', '2017055739', '2020-08-12', 17, 18, 0, '2020-08-12 12:33:18', 20.0000000000);
INSERT INTO `gms_order` VALUES ('437', '28', '2017055739', '2020-08-14', 12, 13, 0, '2020-08-14 16:55:10', 14.0000000000);
INSERT INTO `gms_order` VALUES ('438', '32', '2017093832', '2020-08-12', 11, 12, 0, '2020-08-12 16:35:41', 17.0000000000);
INSERT INTO `gms_order` VALUES ('439', '22', '2017055739', '2020-08-13', 11, 12, 0, '2020-08-13 22:16:49', 16.0000000000);
INSERT INTO `gms_order` VALUES ('44', '32', '2017053480', '2020-08-13', 13, 14, 1, '2020-08-13 10:56:30', 17.0000000000);
INSERT INTO `gms_order` VALUES ('440', '22', '2017093660', '2020-08-14', 16, 17, 0, '2020-08-14 16:35:50', 16.0000000000);
INSERT INTO `gms_order` VALUES ('441', '22', '2017052180', '2020-08-15', 13, 14, 0, '2020-08-15 11:40:23', 16.0000000000);
INSERT INTO `gms_order` VALUES ('442', '12', '2017092148', '2020-08-13', 14, 15, 0, '2020-08-13 22:17:14', 15.0000000000);
INSERT INTO `gms_order` VALUES ('443', '02', '2017099980', '2020-08-12', 13, 14, 0, '2020-08-12 23:23:54', 17.0000000000);
INSERT INTO `gms_order` VALUES ('444', '31', '2017099341', '2020-08-14', 13, 14, 0, '2020-08-14 11:11:57', 14.0000000000);
INSERT INTO `gms_order` VALUES ('445', '03', '2017099341', '2020-08-12', 14, 15, 0, '2020-08-12 19:16:59', 19.0000000000);
INSERT INTO `gms_order` VALUES ('446', '07', '2017099980', '2020-08-13', 18, 19, 0, '2020-08-13 23:14:58', 24.0000000000);
INSERT INTO `gms_order` VALUES ('447', '27', '2017056227', '2020-08-13', 18, 19, 0, '2020-08-13 10:33:11', 12.0000000000);
INSERT INTO `gms_order` VALUES ('448', '26', '2017054904', '2020-08-15', 11, 12, 0, '2020-08-15 12:23:49', 19.0000000000);
INSERT INTO `gms_order` VALUES ('449', '24', '2017099341', '2020-08-14', 13, 14, 1, '2020-08-14 15:21:48', 20.0000000000);
INSERT INTO `gms_order` VALUES ('45', '12', '2017056227', '2020-08-15', 15, 16, 0, '2020-08-15 11:30:45', 15.0000000000);
INSERT INTO `gms_order` VALUES ('450', '11', '2017055941', '2020-08-15', 16, 17, 0, '2020-08-15 11:47:53', 23.0000000000);
INSERT INTO `gms_order` VALUES ('451', '02', '2017099341', '2020-08-13', 11, 12, 1, '2020-08-13 21:10:49', 17.0000000000);
INSERT INTO `gms_order` VALUES ('452', '14', '2017053120', '2020-08-15', 14, 15, 1, '2020-08-15 21:37:59', 12.0000000000);
INSERT INTO `gms_order` VALUES ('453', '06', '2017053120', '2020-08-15', 14, 15, 0, '2020-08-15 20:56:37', 16.0000000000);
INSERT INTO `gms_order` VALUES ('454', '15', '2017099341', '2020-08-14', 12, 13, 0, '2020-08-14 13:57:40', 24.0000000000);
INSERT INTO `gms_order` VALUES ('455', '28', '2017053120', '2020-08-12', 16, 17, 0, '2020-08-12 19:27:32', 14.0000000000);
INSERT INTO `gms_order` VALUES ('456', '08', '2017052910', '2020-08-15', 16, 17, 0, '2020-08-15 11:34:25', 16.0000000000);
INSERT INTO `gms_order` VALUES ('457', '14', '2017058721', '2020-08-14', 14, 15, 0, '2020-08-14 23:36:12', 12.0000000000);
INSERT INTO `gms_order` VALUES ('458', '26', '2017055941', '2020-08-12', 18, 19, 0, '2020-08-12 14:40:49', 19.0000000000);
INSERT INTO `gms_order` VALUES ('459', '09', '2017055941', '2020-08-13', 17, 18, 0, '2020-08-13 10:56:56', 17.0000000000);
INSERT INTO `gms_order` VALUES ('46', '17', '2017053120', '2020-08-13', 13, 14, 0, '2020-08-13 19:20:42', 13.0000000000);
INSERT INTO `gms_order` VALUES ('460', '08', '2017058721', '2020-08-12', 15, 16, 0, '2020-08-12 14:14:42', 16.0000000000);
INSERT INTO `gms_order` VALUES ('461', '22', '2017051376', '2020-08-14', 14, 15, 0, '2020-08-14 13:17:31', 16.0000000000);
INSERT INTO `gms_order` VALUES ('462', '27', '2017093660', '2020-08-12', 15, 16, 0, '2020-08-12 18:43:50', 12.0000000000);
INSERT INTO `gms_order` VALUES ('463', '03', '2017092148', '2020-08-13', 13, 14, 0, '2020-08-13 15:34:42', 19.0000000000);
INSERT INTO `gms_order` VALUES ('464', '14', '2017099980', '2020-08-15', 16, 17, 0, '2020-08-15 15:12:55', 12.0000000000);
INSERT INTO `gms_order` VALUES ('465', '33', '2017093660', '2020-08-13', 13, 14, 0, '2020-08-13 22:11:43', 10.0000000000);
INSERT INTO `gms_order` VALUES ('466', '14', '2017093832', '2020-08-12', 18, 19, 1, '2020-08-12 10:35:39', 12.0000000000);
INSERT INTO `gms_order` VALUES ('467', '15', '2017053120', '2020-08-13', 16, 17, 0, '2020-08-13 23:15:30', 24.0000000000);
INSERT INTO `gms_order` VALUES ('468', '06', '2017057963', '2020-08-15', 16, 17, 0, '2020-08-15 16:18:43', 16.0000000000);
INSERT INTO `gms_order` VALUES ('469', '02', '2017057963', '2020-08-13', 14, 15, 0, '2020-08-13 10:21:33', 17.0000000000);
INSERT INTO `gms_order` VALUES ('47', '26', '2017056390', '2020-08-14', 11, 12, 0, '2020-08-14 15:36:27', 19.0000000000);
INSERT INTO `gms_order` VALUES ('470', '10', '2017055941', '2020-08-12', 13, 14, 0, '2020-08-12 21:12:54', 17.0000000000);
INSERT INTO `gms_order` VALUES ('471', '29', '2017053480', '2020-08-14', 10, 11, 0, '2020-08-14 22:20:28', 25.0000000000);
INSERT INTO `gms_order` VALUES ('472', '03', '2017056227', '2020-08-12', 13, 14, 0, '2020-08-12 15:18:19', 19.0000000000);
INSERT INTO `gms_order` VALUES ('473', '02', '2017058523', '2020-08-15', 14, 15, 0, '2020-08-15 19:50:41', 17.0000000000);
INSERT INTO `gms_order` VALUES ('474', '13', '2017052910', '2020-08-13', 16, 17, 0, '2020-08-13 10:20:56', 16.0000000000);
INSERT INTO `gms_order` VALUES ('475', '12', '2017093832', '2020-08-14', 15, 16, 0, '2020-08-14 22:41:15', 15.0000000000);
INSERT INTO `gms_order` VALUES ('476', '11', '2017056390', '2020-08-14', 18, 19, 0, '2020-08-14 17:34:15', 23.0000000000);
INSERT INTO `gms_order` VALUES ('477', '02', '2017059397', '2020-08-13', 12, 13, 0, '2020-08-13 16:18:54', 17.0000000000);
INSERT INTO `gms_order` VALUES ('478', '15', '2017093832', '2020-08-15', 14, 15, 1, '2020-08-15 15:34:37', 24.0000000000);
INSERT INTO `gms_order` VALUES ('479', '29', '2017092148', '2020-08-14', 14, 15, 0, '2020-08-14 17:32:42', 25.0000000000);
INSERT INTO `gms_order` VALUES ('48', '23', '2017055739', '2020-08-15', 11, 12, 0, '2020-08-15 21:35:43', 22.0000000000);
INSERT INTO `gms_order` VALUES ('480', '12', '2017098844', '2020-08-15', 11, 12, 0, '2020-08-15 21:34:16', 15.0000000000);
INSERT INTO `gms_order` VALUES ('481', '23', '2017056390', '2020-08-14', 14, 15, 1, '2020-08-14 18:20:14', 22.0000000000);
INSERT INTO `gms_order` VALUES ('482', '08', '2017055941', '2020-08-12', 14, 15, 0, '2020-08-12 13:24:15', 16.0000000000);
INSERT INTO `gms_order` VALUES ('483', '20', '2017098844', '2020-08-15', 13, 14, 0, '2020-08-15 13:56:57', 24.0000000000);
INSERT INTO `gms_order` VALUES ('484', '31', '2017058523', '2020-08-15', 12, 13, 0, '2020-08-15 10:50:19', 14.0000000000);
INSERT INTO `gms_order` VALUES ('485', '27', '2017099341', '2020-08-12', 14, 15, 0, '2020-08-12 22:29:33', 12.0000000000);
INSERT INTO `gms_order` VALUES ('486', '22', '2017056390', '2020-08-15', 12, 13, 1, '2020-08-15 20:30:14', 16.0000000000);
INSERT INTO `gms_order` VALUES ('487', '29', '2017055941', '2020-08-12', 16, 17, 1, '2020-08-12 19:47:34', 25.0000000000);
INSERT INTO `gms_order` VALUES ('488', '07', '2017058721', '2020-08-12', 18, 19, 0, '2020-08-12 12:59:52', 24.0000000000);
INSERT INTO `gms_order` VALUES ('489', '19', '2017058721', '2020-08-12', 11, 12, 0, '2020-08-12 16:45:30', 12.0000000000);
INSERT INTO `gms_order` VALUES ('49', '17', '2017058523', '2020-08-13', 15, 16, 1, '2020-08-13 17:28:14', 13.0000000000);
INSERT INTO `gms_order` VALUES ('490', '11', '2017056227', '2020-08-13', 18, 19, 0, '2020-08-13 16:45:24', 23.0000000000);
INSERT INTO `gms_order` VALUES ('491', '28', '2017059397', '2020-08-14', 14, 15, 0, '2020-08-14 12:11:40', 14.0000000000);
INSERT INTO `gms_order` VALUES ('492', '22', '2017058721', '2020-08-14', 15, 16, 0, '2020-08-14 11:39:24', 16.0000000000);
INSERT INTO `gms_order` VALUES ('493', '06', '2017057963', '2020-08-15', 13, 14, 0, '2020-08-15 12:41:34', 16.0000000000);
INSERT INTO `gms_order` VALUES ('494', '06', '2017051376', '2020-08-12', 15, 16, 0, '2020-08-12 12:31:13', 16.0000000000);
INSERT INTO `gms_order` VALUES ('495', '09', '2017051376', '2020-08-14', 14, 15, 1, '2020-08-14 20:36:14', 17.0000000000);
INSERT INTO `gms_order` VALUES ('496', '20', '2017058523', '2020-08-15', 12, 13, 0, '2020-08-15 19:14:32', 24.0000000000);
INSERT INTO `gms_order` VALUES ('497', '26', '2017052910', '2020-08-15', 17, 18, 0, '2020-08-15 18:12:12', 19.0000000000);
INSERT INTO `gms_order` VALUES ('498', '10', '2017059397', '2020-08-15', 17, 18, 0, '2020-08-15 22:13:21', 17.0000000000);
INSERT INTO `gms_order` VALUES ('499', '21', '2017058721', '2020-08-15', 13, 14, 1, '2020-08-15 12:59:41', 13.0000000000);
INSERT INTO `gms_order` VALUES ('5', '23', '2017093832', '2020-08-15', 13, 14, 0, '2020-08-15 11:59:22', 22.0000000000);
INSERT INTO `gms_order` VALUES ('50', '20', '2017055739', '2020-08-15', 11, 12, 0, '2020-08-15 16:47:41', 24.0000000000);
INSERT INTO `gms_order` VALUES ('500', '23', '2017099980', '2020-08-14', 16, 17, 0, '2020-08-14 15:55:56', 22.0000000000);
INSERT INTO `gms_order` VALUES ('501', '09', '2017055941', '2020-08-14', 13, 14, 0, '2020-08-14 15:26:35', 17.0000000000);
INSERT INTO `gms_order` VALUES ('502', '05', '2017099980', '2020-08-13', 14, 15, 0, '2020-08-13 13:26:50', 24.0000000000);
INSERT INTO `gms_order` VALUES ('503', '30', '2017056227', '2020-08-15', 16, 17, 0, '2020-08-15 20:42:27', 25.0000000000);
INSERT INTO `gms_order` VALUES ('504', '22', '2017093660', '2020-08-12', 16, 17, 0, '2020-08-12 10:48:19', 16.0000000000);
INSERT INTO `gms_order` VALUES ('505', '27', '2017099341', '2020-08-14', 17, 18, 0, '2020-08-14 11:24:54', 12.0000000000);
INSERT INTO `gms_order` VALUES ('506', '02', '2017052180', '2020-08-14', 12, 13, 0, '2020-08-14 10:18:59', 17.0000000000);
INSERT INTO `gms_order` VALUES ('507', '02', '2017055941', '2020-08-12', 16, 17, 0, '2020-08-12 21:28:32', 17.0000000000);
INSERT INTO `gms_order` VALUES ('508', '10', '2017059397', '2020-08-12', 17, 18, 0, '2020-08-12 13:54:11', 17.0000000000);
INSERT INTO `gms_order` VALUES ('509', '20', '2017092148', '2020-08-12', 10, 11, 0, '2020-08-12 17:25:38', 24.0000000000);
INSERT INTO `gms_order` VALUES ('51', '30', '2017052910', '2020-08-13', 16, 17, 1, '2020-08-13 17:12:34', 25.0000000000);
INSERT INTO `gms_order` VALUES ('510', '22', '2017053120', '2020-08-13', 15, 16, 0, '2020-08-13 19:29:36', 16.0000000000);
INSERT INTO `gms_order` VALUES ('511', '04', '2017059397', '2020-08-14', 18, 19, 0, '2020-08-14 14:56:26', 23.0000000000);
INSERT INTO `gms_order` VALUES ('512', '30', '2017099341', '2020-08-12', 13, 14, 0, '2020-08-12 14:48:48', 25.0000000000);
INSERT INTO `gms_order` VALUES ('513', '07', '2017052910', '2020-08-12', 15, 16, 0, '2020-08-12 23:25:53', 24.0000000000);
INSERT INTO `gms_order` VALUES ('514', '02', '2017053120', '2020-08-13', 16, 17, 0, '2020-08-13 23:19:36', 17.0000000000);
INSERT INTO `gms_order` VALUES ('515', '11', '2017093660', '2020-08-14', 15, 16, 1, '2020-08-14 15:43:13', 23.0000000000);
INSERT INTO `gms_order` VALUES ('516', '10', '2017053480', '2020-08-12', 11, 12, 0, '2020-08-12 17:47:15', 17.0000000000);
INSERT INTO `gms_order` VALUES ('517', '23', '2017053120', '2020-08-12', 17, 18, 0, '2020-08-12 14:57:34', 22.0000000000);
INSERT INTO `gms_order` VALUES ('518', '18', '2017056227', '2020-08-14', 14, 15, 0, '2020-08-14 22:41:24', 20.0000000000);
INSERT INTO `gms_order` VALUES ('519', '06', '2017058523', '2020-08-12', 14, 15, 0, '2020-08-12 18:51:48', 16.0000000000);
INSERT INTO `gms_order` VALUES ('52', '15', '2017056390', '2020-08-14', 16, 17, 0, '2020-08-14 23:35:26', 24.0000000000);
INSERT INTO `gms_order` VALUES ('520', '12', '2017099980', '2020-08-13', 13, 14, 1, '2020-08-13 13:20:14', 15.0000000000);
INSERT INTO `gms_order` VALUES ('521', '22', '2017093660', '2020-08-14', 12, 13, 0, '2020-08-14 10:57:31', 16.0000000000);
INSERT INTO `gms_order` VALUES ('522', '28', '2017055941', '2020-08-12', 11, 12, 1, '2020-08-12 16:18:31', 14.0000000000);
INSERT INTO `gms_order` VALUES ('523', '20', '2017059397', '2020-08-14', 13, 14, 0, '2020-08-14 15:30:16', 24.0000000000);
INSERT INTO `gms_order` VALUES ('524', '01', '2017053480', '2020-08-14', 16, 17, 0, '2020-08-14 16:11:31', 13.0000000000);
INSERT INTO `gms_order` VALUES ('525', '13', '2017055739', '2020-08-12', 16, 17, 0, '2020-08-12 22:44:53', 16.0000000000);
INSERT INTO `gms_order` VALUES ('526', '29', '2017093832', '2020-08-12', 11, 12, 0, '2020-08-12 17:22:59', 25.0000000000);
INSERT INTO `gms_order` VALUES ('527', '30', '2017052180', '2020-08-15', 15, 16, 0, '2020-08-15 14:17:28', 25.0000000000);
INSERT INTO `gms_order` VALUES ('528', '08', '2017052910', '2020-08-12', 13, 14, 0, '2020-08-12 11:25:59', 16.0000000000);
INSERT INTO `gms_order` VALUES ('529', '27', '2017054904', '2020-08-12', 16, 17, 0, '2020-08-12 13:45:22', 12.0000000000);
INSERT INTO `gms_order` VALUES ('53', '29', '2017057963', '2020-08-12', 12, 13, 0, '2020-08-12 23:43:25', 25.0000000000);
INSERT INTO `gms_order` VALUES ('530', '16', '2017092148', '2020-08-14', 14, 15, 0, '2020-08-14 19:52:36', 16.0000000000);
INSERT INTO `gms_order` VALUES ('531', '22', '2017052910', '2020-08-15', 16, 17, 0, '2020-08-15 11:57:55', 16.0000000000);
INSERT INTO `gms_order` VALUES ('532', '19', '2017098844', '2020-08-15', 13, 14, 0, '2020-08-15 13:41:31', 12.0000000000);
INSERT INTO `gms_order` VALUES ('533', '01', '2017058721', '2020-08-12', 14, 15, 0, '2020-08-12 12:20:55', 13.0000000000);
INSERT INTO `gms_order` VALUES ('534', '29', '2017055739', '2020-08-13', 16, 17, 1, '2020-08-13 18:50:43', 25.0000000000);
INSERT INTO `gms_order` VALUES ('535', '09', '2017057963', '2020-08-14', 16, 17, 0, '2020-08-14 20:24:55', 17.0000000000);
INSERT INTO `gms_order` VALUES ('536', '25', '2017093832', '2020-08-14', 13, 14, 1, '2020-08-14 18:49:30', 18.0000000000);
INSERT INTO `gms_order` VALUES ('537', '09', '2017055941', '2020-08-15', 15, 16, 0, '2020-08-15 22:49:18', 17.0000000000);
INSERT INTO `gms_order` VALUES ('538', '05', '2017053120', '2020-08-15', 15, 16, 1, '2020-08-15 10:23:53', 24.0000000000);
INSERT INTO `gms_order` VALUES ('539', '23', '2017099341', '2020-08-12', 12, 13, 0, '2020-08-12 23:48:57', 22.0000000000);
INSERT INTO `gms_order` VALUES ('54', '24', '2017053480', '2020-08-13', 13, 14, 1, '2020-08-13 11:26:34', 20.0000000000);
INSERT INTO `gms_order` VALUES ('540', '22', '2017056390', '2020-08-13', 16, 17, 0, '2020-08-13 16:16:16', 16.0000000000);
INSERT INTO `gms_order` VALUES ('541', '31', '2017056390', '2020-08-13', 12, 13, 0, '2020-08-13 15:15:22', 14.0000000000);
INSERT INTO `gms_order` VALUES ('542', '03', '2017058523', '2020-08-14', 16, 17, 0, '2020-08-14 20:43:12', 19.0000000000);
INSERT INTO `gms_order` VALUES ('543', '24', '2017053480', '2020-08-15', 12, 13, 0, '2020-08-15 14:19:26', 20.0000000000);
INSERT INTO `gms_order` VALUES ('544', '12', '2017054904', '2020-08-14', 10, 11, 0, '2020-08-14 18:32:52', 15.0000000000);
INSERT INTO `gms_order` VALUES ('545', '05', '2017055941', '2020-08-15', 14, 15, 1, '2020-08-15 14:41:59', 24.0000000000);
INSERT INTO `gms_order` VALUES ('546', '28', '2017058523', '2020-08-15', 15, 16, 0, '2020-08-15 20:40:13', 14.0000000000);
INSERT INTO `gms_order` VALUES ('547', '09', '2017099980', '2020-08-14', 17, 18, 0, '2020-08-14 11:10:55', 17.0000000000);
INSERT INTO `gms_order` VALUES ('548', '03', '2017093832', '2020-08-12', 16, 17, 0, '2020-08-12 23:37:12', 19.0000000000);
INSERT INTO `gms_order` VALUES ('549', '14', '2017099341', '2020-08-12', 14, 15, 1, '2020-08-12 12:50:15', 12.0000000000);
INSERT INTO `gms_order` VALUES ('55', '14', '2017053480', '2020-08-14', 18, 19, 0, '2020-08-14 23:43:29', 12.0000000000);
INSERT INTO `gms_order` VALUES ('550', '02', '2017056390', '2020-08-14', 15, 16, 0, '2020-08-14 13:27:17', 17.0000000000);
INSERT INTO `gms_order` VALUES ('551', '08', '2017055941', '2020-08-13', 15, 16, 0, '2020-08-13 10:45:33', 16.0000000000);
INSERT INTO `gms_order` VALUES ('552', '32', '2017053120', '2020-08-12', 12, 13, 0, '2020-08-12 16:43:59', 17.0000000000);
INSERT INTO `gms_order` VALUES ('553', '10', '2017056390', '2020-08-13', 14, 15, 0, '2020-08-13 14:17:35', 17.0000000000);
INSERT INTO `gms_order` VALUES ('554', '11', '2017099341', '2020-08-12', 12, 13, 0, '2020-08-12 17:35:24', 23.0000000000);
INSERT INTO `gms_order` VALUES ('555', '21', '2017098844', '2020-08-15', 11, 12, 0, '2020-08-15 13:23:15', 13.0000000000);
INSERT INTO `gms_order` VALUES ('556', '16', '2017093660', '2020-08-13', 15, 16, 0, '2020-08-13 23:40:24', 16.0000000000);
INSERT INTO `gms_order` VALUES ('557', '26', '2017093660', '2020-08-15', 13, 14, 0, '2020-08-15 15:59:46', 19.0000000000);
INSERT INTO `gms_order` VALUES ('558', '07', '2017052910', '2020-08-13', 14, 15, 0, '2020-08-13 23:11:56', 24.0000000000);
INSERT INTO `gms_order` VALUES ('559', '01', '2017051376', '2020-08-12', 16, 17, 1, '2020-08-12 13:34:29', 13.0000000000);
INSERT INTO `gms_order` VALUES ('56', '25', '2017059397', '2020-08-15', 14, 15, 0, '2020-08-15 10:39:12', 18.0000000000);
INSERT INTO `gms_order` VALUES ('560', '16', '2017093660', '2020-08-13', 14, 15, 1, '2020-08-13 23:42:10', 16.0000000000);
INSERT INTO `gms_order` VALUES ('561', '26', '2017093832', '2020-08-15', 18, 19, 0, '2020-08-15 23:19:57', 19.0000000000);
INSERT INTO `gms_order` VALUES ('562', '14', '2017092148', '2020-08-13', 13, 14, 0, '2020-08-13 14:33:41', 12.0000000000);
INSERT INTO `gms_order` VALUES ('563', '12', '2017056390', '2020-08-15', 13, 14, 0, '2020-08-15 23:15:36', 15.0000000000);
INSERT INTO `gms_order` VALUES ('564', '28', '2017053120', '2020-08-13', 11, 12, 1, '2020-08-13 17:10:30', 14.0000000000);
INSERT INTO `gms_order` VALUES ('565', '12', '2017055941', '2020-08-13', 16, 17, 1, '2020-08-13 21:47:22', 15.0000000000);
INSERT INTO `gms_order` VALUES ('566', '04', '2017092148', '2020-08-14', 15, 16, 0, '2020-08-14 18:42:17', 23.0000000000);
INSERT INTO `gms_order` VALUES ('567', '31', '2017052910', '2020-08-13', 13, 14, 0, '2020-08-13 11:51:18', 14.0000000000);
INSERT INTO `gms_order` VALUES ('568', '15', '2017053120', '2020-08-15', 16, 17, 0, '2020-08-15 14:28:10', 24.0000000000);
INSERT INTO `gms_order` VALUES ('569', '19', '2017055739', '2020-08-15', 12, 13, 0, '2020-08-15 13:17:56', 12.0000000000);
INSERT INTO `gms_order` VALUES ('57', '08', '2017055941', '2020-08-15', 17, 18, 0, '2020-08-15 20:31:55', 16.0000000000);
INSERT INTO `gms_order` VALUES ('570', '04', '2017056227', '2020-08-13', 16, 17, 0, '2020-08-13 10:52:41', 23.0000000000);
INSERT INTO `gms_order` VALUES ('571', '11', '2017057963', '2020-08-14', 14, 15, 0, '2020-08-14 14:26:37', 23.0000000000);
INSERT INTO `gms_order` VALUES ('572', '07', '2017056390', '2020-08-13', 13, 14, 0, '2020-08-13 22:15:49', 24.0000000000);
INSERT INTO `gms_order` VALUES ('573', '27', '2017099341', '2020-08-13', 16, 17, 0, '2020-08-13 23:35:12', 12.0000000000);
INSERT INTO `gms_order` VALUES ('574', '04', '2017099341', '2020-08-12', 14, 15, 0, '2020-08-12 19:59:55', 23.0000000000);
INSERT INTO `gms_order` VALUES ('575', '28', '2017059397', '2020-08-15', 12, 13, 0, '2020-08-15 21:21:32', 14.0000000000);
INSERT INTO `gms_order` VALUES ('576', '26', '2017055941', '2020-08-15', 16, 17, 0, '2020-08-15 17:25:45', 19.0000000000);
INSERT INTO `gms_order` VALUES ('577', '25', '2017093832', '2020-08-14', 11, 12, 0, '2020-08-14 18:37:48', 18.0000000000);
INSERT INTO `gms_order` VALUES ('578', '25', '2017099980', '2020-08-13', 15, 16, 0, '2020-08-13 18:28:31', 18.0000000000);
INSERT INTO `gms_order` VALUES ('579', '01', '2017054904', '2020-08-15', 13, 14, 0, '2020-08-15 20:49:34', 13.0000000000);
INSERT INTO `gms_order` VALUES ('58', '09', '2017099341', '2020-08-14', 15, 16, 1, '2020-08-14 22:25:35', 17.0000000000);
INSERT INTO `gms_order` VALUES ('580', '31', '2017093832', '2020-08-15', 15, 16, 0, '2020-08-15 21:40:17', 14.0000000000);
INSERT INTO `gms_order` VALUES ('581', '03', '2017058721', '2020-08-14', 13, 14, 0, '2020-08-14 19:21:22', 19.0000000000);
INSERT INTO `gms_order` VALUES ('582', '06', '2017055941', '2020-08-13', 16, 17, 0, '2020-08-13 14:58:13', 16.0000000000);
INSERT INTO `gms_order` VALUES ('583', '18', '2017098844', '2020-08-15', 14, 15, 0, '2020-08-15 13:46:28', 20.0000000000);
INSERT INTO `gms_order` VALUES ('584', '13', '2017055739', '2020-08-14', 14, 15, 1, '2020-08-14 19:45:59', 16.0000000000);
INSERT INTO `gms_order` VALUES ('585', '25', '2017058721', '2020-08-13', 10, 11, 0, '2020-08-13 22:14:54', 18.0000000000);
INSERT INTO `gms_order` VALUES ('586', '25', '2017054904', '2020-08-12', 10, 11, 0, '2020-08-12 21:55:10', 18.0000000000);
INSERT INTO `gms_order` VALUES ('587', '30', '2017053480', '2020-08-12', 18, 19, 0, '2020-08-12 20:20:43', 25.0000000000);
INSERT INTO `gms_order` VALUES ('588', '07', '2017092148', '2020-08-12', 14, 15, 0, '2020-08-12 10:52:23', 24.0000000000);
INSERT INTO `gms_order` VALUES ('589', '13', '2017099980', '2020-08-15', 14, 15, 1, '2020-08-15 18:23:28', 16.0000000000);
INSERT INTO `gms_order` VALUES ('59', '08', '2017053120', '2020-08-12', 17, 18, 0, '2020-08-12 18:42:22', 16.0000000000);
INSERT INTO `gms_order` VALUES ('590', '23', '2017058523', '2020-08-14', 15, 16, 0, '2020-08-14 12:47:56', 22.0000000000);
INSERT INTO `gms_order` VALUES ('591', '30', '2017051376', '2020-08-13', 15, 16, 0, '2020-08-13 18:42:52', 25.0000000000);
INSERT INTO `gms_order` VALUES ('592', '12', '2017055739', '2020-08-13', 12, 13, 0, '2020-08-13 12:57:30', 15.0000000000);
INSERT INTO `gms_order` VALUES ('593', '26', '2017098844', '2020-08-12', 12, 13, 0, '2020-08-12 17:31:42', 19.0000000000);
INSERT INTO `gms_order` VALUES ('594', '28', '2017058523', '2020-08-12', 15, 16, 1, '2020-08-12 23:48:14', 14.0000000000);
INSERT INTO `gms_order` VALUES ('595', '19', '2017058721', '2020-08-13', 13, 14, 1, '2020-08-13 22:43:27', 12.0000000000);
INSERT INTO `gms_order` VALUES ('596', '12', '2017052910', '2020-08-12', 11, 12, 0, '2020-08-12 21:42:35', 15.0000000000);
INSERT INTO `gms_order` VALUES ('597', '23', '2017056227', '2020-08-14', 17, 18, 0, '2020-08-14 11:29:42', 22.0000000000);
INSERT INTO `gms_order` VALUES ('598', '21', '2017058721', '2020-08-14', 14, 15, 1, '2020-08-14 22:54:18', 13.0000000000);
INSERT INTO `gms_order` VALUES ('599', '24', '2017056390', '2020-08-14', 12, 13, 0, '2020-08-14 13:51:10', 20.0000000000);
INSERT INTO `gms_order` VALUES ('6', '17', '2017093660', '2020-08-15', 14, 15, 0, '2020-08-15 10:53:20', 13.0000000000);
INSERT INTO `gms_order` VALUES ('60', '02', '2017051376', '2020-08-15', 15, 16, 0, '2020-08-15 11:57:44', 17.0000000000);
INSERT INTO `gms_order` VALUES ('61', '08', '2017052910', '2020-08-15', 12, 13, 0, '2020-08-15 22:19:51', 16.0000000000);
INSERT INTO `gms_order` VALUES ('62', '15', '2017093660', '2020-08-13', 15, 16, 0, '2020-08-13 20:28:24', 24.0000000000);
INSERT INTO `gms_order` VALUES ('63', '05', '2017051376', '2020-08-12', 13, 14, 1, '2020-08-12 12:36:50', 24.0000000000);
INSERT INTO `gms_order` VALUES ('64', '21', '2017093832', '2020-08-15', 17, 18, 0, '2020-08-15 22:20:56', 13.0000000000);
INSERT INTO `gms_order` VALUES ('65', '20', '2017093660', '2020-08-13', 10, 11, 0, '2020-08-13 11:52:49', 24.0000000000);
INSERT INTO `gms_order` VALUES ('66', '06', '2017054904', '2020-08-13', 15, 16, 0, '2020-08-13 20:26:12', 16.0000000000);
INSERT INTO `gms_order` VALUES ('67', '25', '2017055739', '2020-08-12', 12, 13, 0, '2020-08-12 16:34:31', 18.0000000000);
INSERT INTO `gms_order` VALUES ('68', '04', '2017058721', '2020-08-15', 14, 15, 1, '2020-08-15 22:52:27', 23.0000000000);
INSERT INTO `gms_order` VALUES ('69', '20', '2017099980', '2020-08-15', 16, 17, 0, '2020-08-15 11:25:25', 24.0000000000);
INSERT INTO `gms_order` VALUES ('7', '23', '2017092148', '2020-08-13', 16, 17, 0, '2020-08-13 10:36:34', 22.0000000000);
INSERT INTO `gms_order` VALUES ('70', '28', '2017092148', '2020-08-13', 15, 16, 0, '2020-08-13 15:10:29', 14.0000000000);
INSERT INTO `gms_order` VALUES ('71', '20', '2017056227', '2020-08-13', 14, 15, 1, '2020-08-13 20:57:56', 24.0000000000);
INSERT INTO `gms_order` VALUES ('72', '23', '2017055941', '2020-08-13', 13, 14, 0, '2020-08-13 19:21:20', 22.0000000000);
INSERT INTO `gms_order` VALUES ('73', '09', '2017057963', '2020-08-12', 13, 14, 0, '2020-08-12 11:37:17', 17.0000000000);
INSERT INTO `gms_order` VALUES ('74', '21', '2017098844', '2020-08-12', 14, 15, 0, '2020-08-12 10:28:11', 13.0000000000);
INSERT INTO `gms_order` VALUES ('75', '15', '2017056390', '2020-08-13', 12, 13, 1, '2020-08-13 16:12:14', 24.0000000000);
INSERT INTO `gms_order` VALUES ('76', '05', '2017052180', '2020-08-15', 12, 13, 1, '2020-08-15 12:33:38', 24.0000000000);
INSERT INTO `gms_order` VALUES ('77', '02', '2017052910', '2020-08-12', 11, 12, 0, '2020-08-12 20:33:37', 17.0000000000);
INSERT INTO `gms_order` VALUES ('78', '04', '2017098844', '2020-08-15', 16, 17, 0, '2020-08-15 10:58:35', 23.0000000000);
INSERT INTO `gms_order` VALUES ('79', '15', '2017099980', '2020-08-14', 15, 16, 0, '2020-08-14 17:17:51', 24.0000000000);
INSERT INTO `gms_order` VALUES ('8', '29', '2017053480', '2020-08-12', 13, 14, 0, '2020-08-12 15:24:27', 25.0000000000);
INSERT INTO `gms_order` VALUES ('80', '01', '2017054904', '2020-08-13', 16, 17, 0, '2020-08-13 11:49:45', 13.0000000000);
INSERT INTO `gms_order` VALUES ('81', '11', '2017099980', '2020-08-12', 17, 18, 0, '2020-08-12 20:12:42', 23.0000000000);
INSERT INTO `gms_order` VALUES ('82', '08', '2017053480', '2020-08-15', 14, 15, 0, '2020-08-15 18:10:30', 16.0000000000);
INSERT INTO `gms_order` VALUES ('83', '21', '2017098844', '2020-08-14', 16, 17, 0, '2020-08-14 21:41:19', 13.0000000000);
INSERT INTO `gms_order` VALUES ('84', '33', '2017055739', '2020-08-12', 15, 16, 0, '2020-08-12 14:21:59', 10.0000000000);
INSERT INTO `gms_order` VALUES ('85', '30', '2017099980', '2020-08-14', 15, 16, 1, '2020-08-14 17:20:57', 25.0000000000);
INSERT INTO `gms_order` VALUES ('86', '29', '2017055739', '2020-08-15', 15, 16, 0, '2020-08-15 10:37:20', 25.0000000000);
INSERT INTO `gms_order` VALUES ('87', '19', '2017093660', '2020-08-12', 15, 16, 0, '2020-08-12 14:19:39', 12.0000000000);
INSERT INTO `gms_order` VALUES ('88', '08', '2017057963', '2020-08-14', 15, 16, 0, '2020-08-14 19:19:45', 16.0000000000);
INSERT INTO `gms_order` VALUES ('89', '25', '2017051376', '2020-08-13', 11, 12, 0, '2020-08-13 16:29:36', 18.0000000000);
INSERT INTO `gms_order` VALUES ('9', '11', '2017092148', '2020-08-15', 18, 19, 0, '2020-08-15 16:47:44', 23.0000000000);
INSERT INTO `gms_order` VALUES ('90', '31', '2017098844', '2020-08-15', 14, 15, 0, '2020-08-15 20:44:17', 14.0000000000);
INSERT INTO `gms_order` VALUES ('91', '10', '2017055739', '2020-08-14', 18, 19, 1, '2020-08-14 14:50:39', 17.0000000000);
INSERT INTO `gms_order` VALUES ('92', '05', '2017099980', '2020-08-14', 14, 15, 0, '2020-08-14 12:24:42', 24.0000000000);
INSERT INTO `gms_order` VALUES ('93', '17', '2017092148', '2020-08-14', 15, 16, 1, '2020-08-14 10:39:11', 13.0000000000);
INSERT INTO `gms_order` VALUES ('94', '15', '2017093660', '2020-08-14', 11, 12, 0, '2020-08-14 22:45:18', 24.0000000000);
INSERT INTO `gms_order` VALUES ('95', '15', '2017056227', '2020-08-15', 12, 13, 0, '2020-08-15 22:19:46', 24.0000000000);
INSERT INTO `gms_order` VALUES ('96', '20', '2017099980', '2020-08-12', 14, 15, 0, '2020-08-12 15:11:14', 24.0000000000);
INSERT INTO `gms_order` VALUES ('97', '07', '2017052180', '2020-08-14', 18, 19, 0, '2020-08-14 20:54:22', 24.0000000000);
INSERT INTO `gms_order` VALUES ('98', '01', '2017052910', '2020-08-15', 12, 13, 0, '2020-08-15 21:50:32', 13.0000000000);
INSERT INTO `gms_order` VALUES ('99', '19', '2017056227', '2020-08-13', 11, 12, 0, '2020-08-13 21:10:49', 12.0000000000);

-- ----------------------------
-- Table structure for gms_type
-- ----------------------------
DROP TABLE IF EXISTS `gms_type`;
CREATE TABLE `gms_type`  (
  `type_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆类型名',
  `type_linkman` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系人',
  `type_address` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆地址',
  `type_introduction` varchar(3072) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆简介',
  PRIMARY KEY (`type_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场馆类别' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_type
-- ----------------------------
INSERT INTO `gms_type` VALUES ('乒乓球场', 'admin', '航空港西北运动区乒乓球场地', '学校西北运动区乒乓球场地覆盖面积有四分之一个足球场，和羽毛球场地公用同一个场地，是最靠近学校情人坡的场地...');
INSERT INTO `gms_type` VALUES ('排球场', 'admin', '航空港西北运动区排球场地', '学校西北运动区排球场地覆盖面积和乒乓球场地大小相当，位于网球场和篮球场中间，运动氛围很足，环境很棒...');
INSERT INTO `gms_type` VALUES ('篮球场', 'admin', '航空港西北运动区篮球场地', '学校西北运动区篮球球场地覆盖面积和田径场相当，有两个场地，位于银杏大道两侧，冬季还可以有银杏作伴...');
INSERT INTO `gms_type` VALUES ('网球场', 'admin', '航空港西北运动区网球场地', '学校西北运动区网球场地覆盖面积和乒乓球场相当，位于羽毛球场地和排球场之间，由于平时访问量少，所以平时都很安静...');
INSERT INTO `gms_type` VALUES ('羽毛球场', 'admin', '航空港西北运动区羽毛球场地', '学校西北运动区羽毛球球场地和乒乓球场地在一起，虽然不是最靠近情人坡的地方，但是离吃狗粮也不远了...');

-- ----------------------------
-- Table structure for gms_user
-- ----------------------------
DROP TABLE IF EXISTS `gms_user`;
CREATE TABLE `gms_user`  (
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号/学号',
  `user_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `user_sex` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
  `user_age` int(11) NOT NULL COMMENT '年龄',
  `user_email` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_user
-- ----------------------------
INSERT INTO `gms_user` VALUES ('2017051376', '123456', '女', 21, '4188844235@qq.com');
INSERT INTO `gms_user` VALUES ('2017052180', '123456', '男', 18, '1716502644@qq.com');
INSERT INTO `gms_user` VALUES ('2017052910', '123456', '女', 23, '5163693166@qq.com');
INSERT INTO `gms_user` VALUES ('2017053120', '123456', '男', 20, '2430572247@qq.com');
INSERT INTO `gms_user` VALUES ('2017053480', '123456', '女', 24, '2375264572@qq.com');
INSERT INTO `gms_user` VALUES ('2017054904', '123456', '男', 23, '4167610012@qq.com');
INSERT INTO `gms_user` VALUES ('2017055739', '123456', '女', 20, '4879765415@qq.com');
INSERT INTO `gms_user` VALUES ('2017055941', '123456', '女', 22, '1091957161@qq.com');
INSERT INTO `gms_user` VALUES ('2017056227', '123456', '男', 21, '8038777786@qq.com');
INSERT INTO `gms_user` VALUES ('2017056390', '123456', '男', 24, '6614087450@qq.com');
INSERT INTO `gms_user` VALUES ('2017057963', '123456', '女', 18, '2077910026@qq.com');
INSERT INTO `gms_user` VALUES ('2017058523', '123456', '男', 22, '7816935318@qq.com');
INSERT INTO `gms_user` VALUES ('2017058721', '123456', '男', 19, '4890423300@qq.com');
INSERT INTO `gms_user` VALUES ('2017059397', '123456', '女', 19, '2930448391@qq.com');
INSERT INTO `gms_user` VALUES ('2017092148', '123456', '女', 66, '9705184369@qq.com');
INSERT INTO `gms_user` VALUES ('2017093660', '123456', '男', 28, '9225810075@qq.com');
INSERT INTO `gms_user` VALUES ('2017093832', '123456', '女', 41, '3079529119@qq.com');
INSERT INTO `gms_user` VALUES ('2017098844', '123456', '女', 33, '1579708372@qq.com');
INSERT INTO `gms_user` VALUES ('2017099341', '123456', '男', 55, '9920207118@qq.com');
INSERT INTO `gms_user` VALUES ('2017099980', '123456', '男', 37, '8102763569@qq.com');

-- ----------------------------
-- Table structure for gms_vdstate
-- ----------------------------
DROP TABLE IF EXISTS `gms_vdstate`;
CREATE TABLE `gms_vdstate`  (
  `vdstate_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆编号',
  `vdstate_date` date NOT NULL COMMENT '日期',
  `vdstate_st` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '00000000000000000000000' COMMENT '分时状态 第i位代表第i~i+1小时的场馆状态0代表不可用1代表可用2代表已经被预约',
  PRIMARY KEY (`vdstate_id`, `vdstate_date`) USING BTREE,
  CONSTRAINT `场馆分时状态引用场馆` FOREIGN KEY (`vdstate_id`) REFERENCES `gms_venue` (`venue_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场馆分时状态' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_vdstate
-- ----------------------------
INSERT INTO `gms_vdstate` VALUES ('01', '2020-08-12', '00000000000012222120000');
INSERT INTO `gms_vdstate` VALUES ('01', '2020-08-13', '00000000000012122110000');
INSERT INTO `gms_vdstate` VALUES ('01', '2020-08-14', '00000000000022122220000');
INSERT INTO `gms_vdstate` VALUES ('01', '2020-08-15', '00000000000022122210000');
INSERT INTO `gms_vdstate` VALUES ('02', '2020-08-12', '00000000000212222000000');
INSERT INTO `gms_vdstate` VALUES ('02', '2020-08-13', '00000000000222222000000');
INSERT INTO `gms_vdstate` VALUES ('02', '2020-08-14', '00000000000222222000000');
INSERT INTO `gms_vdstate` VALUES ('02', '2020-08-15', '00000000000112222000000');
INSERT INTO `gms_vdstate` VALUES ('03', '2020-08-12', '00000000002212222100000');
INSERT INTO `gms_vdstate` VALUES ('03', '2020-08-13', '00000000001112221100000');
INSERT INTO `gms_vdstate` VALUES ('03', '2020-08-14', '00000000002222122200000');
INSERT INTO `gms_vdstate` VALUES ('03', '2020-08-15', '00000000001111211200000');
INSERT INTO `gms_vdstate` VALUES ('04', '2020-08-12', '00000000000001221110000');
INSERT INTO `gms_vdstate` VALUES ('04', '2020-08-13', '00000000000001222120000');
INSERT INTO `gms_vdstate` VALUES ('04', '2020-08-14', '00000000000002122220000');
INSERT INTO `gms_vdstate` VALUES ('04', '2020-08-15', '00000000000001222220000');
INSERT INTO `gms_vdstate` VALUES ('05', '2020-08-12', '00000000002212222000000');
INSERT INTO `gms_vdstate` VALUES ('05', '2020-08-13', '00000000002112222000000');
INSERT INTO `gms_vdstate` VALUES ('05', '2020-08-14', '00000000002222212000000');
INSERT INTO `gms_vdstate` VALUES ('05', '2020-08-15', '00000000001121221000000');
INSERT INTO `gms_vdstate` VALUES ('06', '2020-08-12', '00000000000001221000000');
INSERT INTO `gms_vdstate` VALUES ('06', '2020-08-13', '00000000000001222000000');
INSERT INTO `gms_vdstate` VALUES ('06', '2020-08-14', '00000000000002221000000');
INSERT INTO `gms_vdstate` VALUES ('06', '2020-08-15', '00000000000002212000000');
INSERT INTO `gms_vdstate` VALUES ('07', '2020-08-12', '00000000000012222120000');
INSERT INTO `gms_vdstate` VALUES ('07', '2020-08-13', '00000000000012221220000');
INSERT INTO `gms_vdstate` VALUES ('07', '2020-08-14', '00000000000021122220000');
INSERT INTO `gms_vdstate` VALUES ('07', '2020-08-15', '00000000000012112220000');
INSERT INTO `gms_vdstate` VALUES ('08', '2020-08-12', '00000000000112222210000');
INSERT INTO `gms_vdstate` VALUES ('08', '2020-08-13', '00000000000112122220000');
INSERT INTO `gms_vdstate` VALUES ('08', '2020-08-14', '00000000000112122110000');
INSERT INTO `gms_vdstate` VALUES ('08', '2020-08-15', '00000000000221222220000');
INSERT INTO `gms_vdstate` VALUES ('09', '2020-08-12', '00000000000002212200000');
INSERT INTO `gms_vdstate` VALUES ('09', '2020-08-13', '00000000000002221200000');
INSERT INTO `gms_vdstate` VALUES ('09', '2020-08-14', '00000000000002222200000');
INSERT INTO `gms_vdstate` VALUES ('09', '2020-08-15', '00000000000001122200000');
INSERT INTO `gms_vdstate` VALUES ('10', '2020-08-12', '00000000000222221220000');
INSERT INTO `gms_vdstate` VALUES ('10', '2020-08-13', '00000000000122212110000');
INSERT INTO `gms_vdstate` VALUES ('10', '2020-08-14', '00000000000111122220000');
INSERT INTO `gms_vdstate` VALUES ('10', '2020-08-15', '00000000000112121220000');
INSERT INTO `gms_vdstate` VALUES ('11', '2020-08-12', '00000000000022211210000');
INSERT INTO `gms_vdstate` VALUES ('11', '2020-08-13', '00000000000022122220000');
INSERT INTO `gms_vdstate` VALUES ('11', '2020-08-14', '00000000000021222120000');
INSERT INTO `gms_vdstate` VALUES ('11', '2020-08-15', '00000000000012222220000');
INSERT INTO `gms_vdstate` VALUES ('12', '2020-08-12', '00000000001222221000000');
INSERT INTO `gms_vdstate` VALUES ('12', '2020-08-13', '00000000001122222000000');
INSERT INTO `gms_vdstate` VALUES ('12', '2020-08-14', '00000000002111221000000');
INSERT INTO `gms_vdstate` VALUES ('12', '2020-08-15', '00000000001222222000000');
INSERT INTO `gms_vdstate` VALUES ('13', '2020-08-12', '00000000000011222100000');
INSERT INTO `gms_vdstate` VALUES ('13', '2020-08-13', '00000000000012122200000');
INSERT INTO `gms_vdstate` VALUES ('13', '2020-08-14', '00000000000012212200000');
INSERT INTO `gms_vdstate` VALUES ('13', '2020-08-15', '00000000000021212100000');
INSERT INTO `gms_vdstate` VALUES ('14', '2020-08-12', '00000000000012212220000');
INSERT INTO `gms_vdstate` VALUES ('14', '2020-08-13', '00000000000022211210000');
INSERT INTO `gms_vdstate` VALUES ('14', '2020-08-14', '00000000000012221220000');
INSERT INTO `gms_vdstate` VALUES ('14', '2020-08-15', '00000000000011222220000');
INSERT INTO `gms_vdstate` VALUES ('15', '2020-08-12', '00000000000122112000000');
INSERT INTO `gms_vdstate` VALUES ('15', '2020-08-13', '00000000000122222000000');
INSERT INTO `gms_vdstate` VALUES ('15', '2020-08-14', '00000000000222222000000');
INSERT INTO `gms_vdstate` VALUES ('15', '2020-08-15', '00000000000222212000000');
INSERT INTO `gms_vdstate` VALUES ('16', '2020-08-12', '00000000000001122000000');
INSERT INTO `gms_vdstate` VALUES ('16', '2020-08-13', '00000000000001222000000');
INSERT INTO `gms_vdstate` VALUES ('16', '2020-08-14', '00000000000002222000000');
INSERT INTO `gms_vdstate` VALUES ('16', '2020-08-15', '00000000000002211000000');
INSERT INTO `gms_vdstate` VALUES ('17', '2020-08-12', '00000000000001122000000');
INSERT INTO `gms_vdstate` VALUES ('17', '2020-08-13', '00000000000002222000000');
INSERT INTO `gms_vdstate` VALUES ('17', '2020-08-14', '00000000000002222000000');
INSERT INTO `gms_vdstate` VALUES ('17', '2020-08-15', '00000000000001222000000');
INSERT INTO `gms_vdstate` VALUES ('18', '2020-08-12', '00000000000212211200000');
INSERT INTO `gms_vdstate` VALUES ('18', '2020-08-13', '00000000000112221200000');
INSERT INTO `gms_vdstate` VALUES ('18', '2020-08-14', '00000000000111222200000');
INSERT INTO `gms_vdstate` VALUES ('18', '2020-08-15', '00000000000211222200000');
INSERT INTO `gms_vdstate` VALUES ('19', '2020-08-12', '00000000000211121000000');
INSERT INTO `gms_vdstate` VALUES ('19', '2020-08-13', '00000000000212221000000');
INSERT INTO `gms_vdstate` VALUES ('19', '2020-08-14', '00000000000121222000000');
INSERT INTO `gms_vdstate` VALUES ('19', '2020-08-15', '00000000000222112000000');
INSERT INTO `gms_vdstate` VALUES ('20', '2020-08-12', '00000000002221211000000');
INSERT INTO `gms_vdstate` VALUES ('20', '2020-08-13', '00000000002112221000000');
INSERT INTO `gms_vdstate` VALUES ('20', '2020-08-14', '00000000001112211000000');
INSERT INTO `gms_vdstate` VALUES ('20', '2020-08-15', '00000000002222222000000');
INSERT INTO `gms_vdstate` VALUES ('21', '2020-08-12', '00000000000221222210000');
INSERT INTO `gms_vdstate` VALUES ('21', '2020-08-13', '00000000000211221220000');
INSERT INTO `gms_vdstate` VALUES ('21', '2020-08-14', '00000000000112222210000');
INSERT INTO `gms_vdstate` VALUES ('21', '2020-08-15', '00000000000222222220000');
INSERT INTO `gms_vdstate` VALUES ('22', '2020-08-12', '00000000002112222210000');
INSERT INTO `gms_vdstate` VALUES ('22', '2020-08-13', '00000000002222222220000');
INSERT INTO `gms_vdstate` VALUES ('22', '2020-08-14', '00000000002221222220000');
INSERT INTO `gms_vdstate` VALUES ('22', '2020-08-15', '00000000001122122220000');
INSERT INTO `gms_vdstate` VALUES ('23', '2020-08-12', '00000000000121222200000');
INSERT INTO `gms_vdstate` VALUES ('23', '2020-08-13', '00000000000112112100000');
INSERT INTO `gms_vdstate` VALUES ('23', '2020-08-14', '00000000000122222200000');
INSERT INTO `gms_vdstate` VALUES ('23', '2020-08-15', '00000000000222212200000');
INSERT INTO `gms_vdstate` VALUES ('24', '2020-08-12', '00000000000012122000000');
INSERT INTO `gms_vdstate` VALUES ('24', '2020-08-13', '00000000000022222000000');
INSERT INTO `gms_vdstate` VALUES ('24', '2020-08-14', '00000000000022212000000');
INSERT INTO `gms_vdstate` VALUES ('24', '2020-08-15', '00000000000021122000000');
INSERT INTO `gms_vdstate` VALUES ('25', '2020-08-12', '00000000002222211100000');
INSERT INTO `gms_vdstate` VALUES ('25', '2020-08-13', '00000000002211222200000');
INSERT INTO `gms_vdstate` VALUES ('25', '2020-08-14', '00000000002212112200000');
INSERT INTO `gms_vdstate` VALUES ('25', '2020-08-15', '00000000002122221200000');
INSERT INTO `gms_vdstate` VALUES ('26', '2020-08-12', '00000000000121211220000');
INSERT INTO `gms_vdstate` VALUES ('26', '2020-08-13', '00000000000121221220000');
INSERT INTO `gms_vdstate` VALUES ('26', '2020-08-14', '00000000000212221220000');
INSERT INTO `gms_vdstate` VALUES ('26', '2020-08-15', '00000000000212212220000');
INSERT INTO `gms_vdstate` VALUES ('27', '2020-08-12', '00000000000001222110000');
INSERT INTO `gms_vdstate` VALUES ('27', '2020-08-13', '00000000000001222220000');
INSERT INTO `gms_vdstate` VALUES ('27', '2020-08-14', '00000000000002212210000');
INSERT INTO `gms_vdstate` VALUES ('27', '2020-08-15', '00000000000002222220000');
INSERT INTO `gms_vdstate` VALUES ('28', '2020-08-12', '00000000001222222100000');
INSERT INTO `gms_vdstate` VALUES ('28', '2020-08-13', '00000000001222221200000');
INSERT INTO `gms_vdstate` VALUES ('28', '2020-08-14', '00000000002222212100000');
INSERT INTO `gms_vdstate` VALUES ('28', '2020-08-15', '00000000002122222200000');
INSERT INTO `gms_vdstate` VALUES ('29', '2020-08-12', '00000000002222222000000');
INSERT INTO `gms_vdstate` VALUES ('29', '2020-08-13', '00000000001111222000000');
INSERT INTO `gms_vdstate` VALUES ('29', '2020-08-14', '00000000002122222000000');
INSERT INTO `gms_vdstate` VALUES ('29', '2020-08-15', '00000000001122122000000');
INSERT INTO `gms_vdstate` VALUES ('30', '2020-08-12', '00000000000002222220000');
INSERT INTO `gms_vdstate` VALUES ('30', '2020-08-13', '00000000000001122120000');
INSERT INTO `gms_vdstate` VALUES ('30', '2020-08-14', '00000000000001222210000');
INSERT INTO `gms_vdstate` VALUES ('30', '2020-08-15', '00000000000002122220000');
INSERT INTO `gms_vdstate` VALUES ('31', '2020-08-12', '00000000000121222000000');
INSERT INTO `gms_vdstate` VALUES ('31', '2020-08-13', '00000000000222111000000');
INSERT INTO `gms_vdstate` VALUES ('31', '2020-08-14', '00000000000112222000000');
INSERT INTO `gms_vdstate` VALUES ('31', '2020-08-15', '00000000000122221000000');
INSERT INTO `gms_vdstate` VALUES ('32', '2020-08-12', '00000000001222221110000');
INSERT INTO `gms_vdstate` VALUES ('32', '2020-08-13', '00000000002112122120000');
INSERT INTO `gms_vdstate` VALUES ('32', '2020-08-14', '00000000001122221120000');
INSERT INTO `gms_vdstate` VALUES ('32', '2020-08-15', '00000000002111122120000');
INSERT INTO `gms_vdstate` VALUES ('33', '2020-08-12', '00000000000002222000000');
INSERT INTO `gms_vdstate` VALUES ('33', '2020-08-13', '00000000000002221000000');
INSERT INTO `gms_vdstate` VALUES ('33', '2020-08-14', '00000000000002221000000');
INSERT INTO `gms_vdstate` VALUES ('33', '2020-08-15', '00000000000001122000000');

-- ----------------------------
-- Table structure for gms_venue
-- ----------------------------
DROP TABLE IF EXISTS `gms_venue`;
CREATE TABLE `gms_venue`  (
  `venue_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆编号',
  `venue_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆类别',
  `venue_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场馆名字',
  `venue_price` decimal(32, 10) NOT NULL COMMENT '场馆价格',
  `venue_capacity` int(11) NOT NULL COMMENT '场馆接待能力',
  `venue_open` int(11) NOT NULL COMMENT '开始时间',
  `venue_close` int(11) NOT NULL COMMENT '关闭时间',
  `venue_is_del` int(11) NOT NULL DEFAULT 0 COMMENT '场馆是否被删除 为0代表场馆未被删除,1代表场馆被删除了',
  PRIMARY KEY (`venue_id`) USING BTREE,
  INDEX `场馆引用类别`(`venue_type`) USING BTREE,
  CONSTRAINT `场馆引用类别` FOREIGN KEY (`venue_type`) REFERENCES `gms_type` (`type_name`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场馆' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gms_venue
-- ----------------------------
INSERT INTO `gms_venue` VALUES ('01', '篮球场', '篮球场1号', 13.0000000000, 15, 12, 19, 0);
INSERT INTO `gms_venue` VALUES ('02', '篮球场', '篮球场2号', 17.0000000000, 15, 11, 17, 0);
INSERT INTO `gms_venue` VALUES ('03', '篮球场', '篮球场3号', 19.0000000000, 12, 10, 18, 0);
INSERT INTO `gms_venue` VALUES ('04', '篮球场', '篮球场4号', 23.0000000000, 13, 13, 19, 0);
INSERT INTO `gms_venue` VALUES ('05', '篮球场', '篮球场5号', 24.0000000000, 15, 10, 17, 0);
INSERT INTO `gms_venue` VALUES ('06', '篮球场', '篮球场6号', 16.0000000000, 15, 13, 17, 0);
INSERT INTO `gms_venue` VALUES ('07', '篮球场', '篮球场7号', 24.0000000000, 12, 12, 19, 0);
INSERT INTO `gms_venue` VALUES ('08', '篮球场', '篮球场8号', 16.0000000000, 14, 11, 19, 0);
INSERT INTO `gms_venue` VALUES ('09', '羽毛球场', '羽毛球场1号', 17.0000000000, 6, 13, 18, 0);
INSERT INTO `gms_venue` VALUES ('10', '羽毛球场', '羽毛球场2号', 17.0000000000, 4, 11, 19, 0);
INSERT INTO `gms_venue` VALUES ('11', '羽毛球场', '羽毛球场3号', 23.0000000000, 6, 12, 19, 0);
INSERT INTO `gms_venue` VALUES ('12', '羽毛球场', '羽毛球场4号', 15.0000000000, 6, 10, 17, 0);
INSERT INTO `gms_venue` VALUES ('13', '羽毛球场', '羽毛球场5号', 16.0000000000, 6, 12, 18, 0);
INSERT INTO `gms_venue` VALUES ('14', '羽毛球场', '羽毛球场6号', 12.0000000000, 4, 12, 19, 0);
INSERT INTO `gms_venue` VALUES ('15', '羽毛球场', '羽毛球场7号', 24.0000000000, 4, 11, 17, 0);
INSERT INTO `gms_venue` VALUES ('16', '乒乓球场', '乒乓球场1号', 16.0000000000, 2, 13, 17, 0);
INSERT INTO `gms_venue` VALUES ('17', '乒乓球场', '乒乓球场2号', 13.0000000000, 2, 13, 17, 0);
INSERT INTO `gms_venue` VALUES ('18', '乒乓球场', '乒乓球场3号', 20.0000000000, 2, 11, 18, 0);
INSERT INTO `gms_venue` VALUES ('19', '乒乓球场', '乒乓球场4号', 12.0000000000, 2, 11, 17, 0);
INSERT INTO `gms_venue` VALUES ('20', '乒乓球场', '乒乓球场5号', 24.0000000000, 2, 10, 17, 0);
INSERT INTO `gms_venue` VALUES ('21', '乒乓球场', '乒乓球场6号', 13.0000000000, 2, 11, 19, 0);
INSERT INTO `gms_venue` VALUES ('22', '排球场', '排球场1号', 16.0000000000, 2, 10, 19, 0);
INSERT INTO `gms_venue` VALUES ('23', '排球场', '排球场2号', 22.0000000000, 2, 11, 18, 0);
INSERT INTO `gms_venue` VALUES ('24', '排球场', '排球场3号', 20.0000000000, 2, 12, 17, 0);
INSERT INTO `gms_venue` VALUES ('25', '排球场', '排球场4号', 18.0000000000, 2, 10, 18, 0);
INSERT INTO `gms_venue` VALUES ('26', '排球场', '排球场5号', 19.0000000000, 2, 11, 19, 0);
INSERT INTO `gms_venue` VALUES ('27', '排球场', '排球场6号', 12.0000000000, 2, 13, 19, 0);
INSERT INTO `gms_venue` VALUES ('28', '网球场', '网球场1号', 14.0000000000, 4, 10, 18, 0);
INSERT INTO `gms_venue` VALUES ('29', '网球场', '网球场2号', 25.0000000000, 6, 10, 17, 0);
INSERT INTO `gms_venue` VALUES ('30', '网球场', '网球场3号', 25.0000000000, 5, 13, 19, 0);
INSERT INTO `gms_venue` VALUES ('31', '网球场', '网球场4号', 14.0000000000, 6, 11, 17, 0);
INSERT INTO `gms_venue` VALUES ('32', '网球场', '网球场5号', 17.0000000000, 7, 10, 19, 0);
INSERT INTO `gms_venue` VALUES ('33', '网球场', '网球场6号', 10.0000000000, 7, 13, 17, 0);

SET FOREIGN_KEY_CHECKS = 1;