master

分支 (1)

管理

管理

master

speed
/
speed.sql

/*
Navicat MySQL Data Transfer

Source Server         : 180.76.119.18
Source Server Version : 50529
Source Host           : localhost:3306
Source Database       : speed

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

Date: 2020-10-05 22:40:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT '女',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin', 'http://127.0.0.1:3000/public/img/admin/admin/1601689076078-405.jpg', '女');
INSERT INTO `admin` VALUES ('3', '1', '1', 'http://127.0.0.1:3000/public/img/admin/admin/1601689092566-102.jpg', '男');
INSERT INTO `admin` VALUES ('5', '2', '2', 'http://127.0.0.1:3000/public/img/admin/admin/1601689484703-b98448a0-ea6b-485d-b434-cf11be399a7d.jpg', '女');

-- ----------------------------
-- Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `orderId` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `speedId` int(11) DEFAULT NULL,
  `pollNum` int(11) DEFAULT NULL,
  `allPrice` double DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `passenger` varchar(255) DEFAULT NULL,
  `seatList` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`orderId`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('24', '29', '5', '1', '22', '222', '[{\"name\":\"2\",\"idNumber\":\"2\",\"type\":\"成人\",\"isHolder\":true}]', '[[0,0,0]]');

-- ----------------------------
-- Table structure for `speed`
-- ----------------------------
DROP TABLE IF EXISTS `speed`;
CREATE TABLE `speed` (
  `speedId` int(11) NOT NULL AUTO_INCREMENT,
  `startRegion` varchar(255) DEFAULT NULL,
  `endRegion` varchar(255) DEFAULT NULL,
  `speedDate` date DEFAULT NULL,
  `speedTime` time DEFAULT NULL,
  `speedMon` double(11,0) DEFAULT NULL,
  `speedPollall` int(11) DEFAULT NULL,
  `speedPolleave` int(11) DEFAULT NULL,
  `speedSection` int(11) DEFAULT NULL,
  `speedRow` int(11) DEFAULT NULL,
  `speedSeat` text,
  PRIMARY KEY (`speedId`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of speed
-- ----------------------------
INSERT INTO `speed` VALUES ('1', '北京', '上海', '2020-10-06', '11:35:00', '20', '16', '16', '2', '2', '[[[0,0,0,0],[0,0,0,0]],[[0,0,0,0],[0,0,0,0]]]');
INSERT INTO `speed` VALUES ('5', '北京', '上海', '2020-10-05', '21:17:00', '22', '16', '15', '2', '2', '[[[1,0,0,0],[0,0,0,0]],[[0,0,0,0],[0,0,0,0]]]');
INSERT INTO `speed` VALUES ('6', '北京', '上海', '2020-10-05', '03:25:00', '20', '16', '14', '2', '2', '[[[0,0,0,0],[0,0,0,0]],[[0,0,0,0],[0,0,0,0]]]');
INSERT INTO `speed` VALUES ('4', '成都', '广东', '2020-10-03', '14:01:00', '3', '16', '16', '2', '2', '[[[0,0,0,0],[0,0,0,0]],[[0,0,0,0],[0,0,0,0]]]');

-- ----------------------------
-- Table structure for `swiper`
-- ----------------------------
DROP TABLE IF EXISTS `swiper`;
CREATE TABLE `swiper` (
  `swiperId` int(11) NOT NULL AUTO_INCREMENT,
  `swiperurl` varchar(255) NOT NULL,
  `swiperIndex` int(11) DEFAULT '0',
  `swipertime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`swiperId`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of swiper
-- ----------------------------
INSERT INTO `swiper` VALUES ('22', 'http://127.0.0.1:3000/public/img/admin/swiper/1601689778294-gu-feng05.jpg', '0', '2020-10-03 09:49:38');
INSERT INTO `swiper` VALUES ('23', 'http://127.0.0.1:3000/public/img/admin/swiper/1601689846473-1601689846000.jpeg', '0', '2020-10-03 09:50:46');
INSERT INTO `swiper` VALUES ('24', 'http://127.0.0.1:3000/public/img/admin/swiper/1601689791744-gu-feng03.jpg', '24', '2020-10-03 09:49:51');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) DEFAULT NULL,
  `userUrl` varchar(255) DEFAULT NULL,
  `userSex` varchar(255) DEFAULT NULL,
  `beginMoney` varchar(255) DEFAULT '0',
  `openid` varchar(255) DEFAULT NULL,
  `userTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '110', null, '2020-10-06 17:35:11');
INSERT INTO `user` VALUES ('4', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '110', null, '2020-10-05 17:35:14');
INSERT INTO `user` VALUES ('5', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '110', null, '2020-10-07 17:35:17');
INSERT INTO `user` VALUES ('13', '李白', null, '男', '110', null, '2020-10-08 17:35:21');
INSERT INTO `user` VALUES ('29', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/arlSoIh2szwic8rsFjfQh7Vq3gffFo7yTOV79heY1fPeYAZsDFvM3wAC6ocLf5G2kRHCoWzAq2KfYcrPxbicW5vg/132', '未知', '99787', 'obt995TUKes91H6qGLsCC96JP324', '2020-10-05 18:09:14');
INSERT INTO `user` VALUES ('15', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('16', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('17', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('18', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('19', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('20', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('21', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('22', '李白', null, '男', '110', null, null);
INSERT INTO `user` VALUES ('27', '非干病酒，不是悲秋。', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', '35801', 'omiwO5CUdC1CeXVAoxvcBbLFkYb8', '2020-10-07 17:35:25');