/*
Navicat MySQL Data Transfer

Source Server         : 恭逸官网
Source Server Version : 50642
Source Host           : 47.105.189.191:3306
Source Database       : platform

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

Date: 2019-04-10 09:38:52
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for car_info
-- ----------------------------
DROP TABLE IF EXISTS `car_info`;
CREATE TABLE `car_info` (
  `plate_num` varchar(255) NOT NULL,
  `car_desc` varchar(255) DEFAULT NULL,
  `car_pic` varchar(255) DEFAULT NULL,
  `car_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`plate_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of car_info
-- ----------------------------
INSERT INTO `car_info` VALUES ('SS', '111', 'ss', '21');
INSERT INTO `car_info` VALUES ('string', 'string', 'string', '0');

-- ----------------------------
-- Table structure for car_place
-- ----------------------------
DROP TABLE IF EXISTS `car_place`;
CREATE TABLE `car_place` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `car_place_code` varchar(255) DEFAULT NULL,
  `car_place_status` int(11) DEFAULT NULL,
  `car_place_type` int(11) DEFAULT NULL,
  `parking_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of car_place
-- ----------------------------
INSERT INTO `car_place` VALUES ('1', '2019-03-21 07:13:04', '2019-03-21 07:13:05', 'a001', '25', '23', '1');
INSERT INTO `car_place` VALUES ('2', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a002', '25', '23', '1');
INSERT INTO `car_place` VALUES ('3', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a003', '25', '24', '1');
INSERT INTO `car_place` VALUES ('4', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a004', '25', '23', '1');
INSERT INTO `car_place` VALUES ('5', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a005', '25', '23', '1');
INSERT INTO `car_place` VALUES ('6', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a006', '25', '23', '1');
INSERT INTO `car_place` VALUES ('7', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a007', '25', '23', '1');
INSERT INTO `car_place` VALUES ('8', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a008', '25', '23', '1');
INSERT INTO `car_place` VALUES ('9', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a009', '25', '23', '1');
INSERT INTO `car_place` VALUES ('10', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'a010', '25', '23', '1');
INSERT INTO `car_place` VALUES ('11', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'b001', '25', '23', '2');
INSERT INTO `car_place` VALUES ('12', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'b002', '25', '23', '2');
INSERT INTO `car_place` VALUES ('13', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'b003', '25', '23', '2');
INSERT INTO `car_place` VALUES ('14', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'b004', '25', '23', '2');
INSERT INTO `car_place` VALUES ('15', '2019-03-21 15:16:51', '2019-03-21 15:16:51', 'b005', '25', '23', '2');

-- ----------------------------
-- Table structure for coder
-- ----------------------------
DROP TABLE IF EXISTS `coder`;
CREATE TABLE `coder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `code_desc` varchar(255) DEFAULT NULL,
  `code_key` varchar(255) DEFAULT NULL,
  `code_value` varchar(255) DEFAULT NULL,
  `key_desc` varchar(255) DEFAULT NULL,
  `value_desc` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of coder
-- ----------------------------
INSERT INTO `coder` VALUES ('1', '2019-03-20 15:15:31', '2019-03-20 15:15:32', 'a0001', '车库相关', null, null, null, null, null);
INSERT INTO `coder` VALUES ('2', '2019-03-20 15:16:11', '2019-03-20 15:16:13', 'b0001', '车辆相关', null, null, null, null, null);
INSERT INTO `coder` VALUES ('3', '2019-03-20 15:16:48', '2019-03-20 15:16:51', 'c0001', '订单相关', null, null, null, null, null);
INSERT INTO `coder` VALUES ('4', '2019-03-20 15:17:20', '2019-03-20 15:17:24', 'x0001', '系统相关', null, null, null, null, null);
INSERT INTO `coder` VALUES ('5', '2019-03-20 15:33:48', '2019-03-20 15:59:46', 'a0001', '车库相关', 'parkingSortCode', 'overground', '车库类型', '地上', '1');
INSERT INTO `coder` VALUES ('6', '2019-03-20 15:34:18', '2019-03-20 15:59:50', 'a0001', '车库相关', 'parkingSortCode', 'underground', '车库类型', '地下', '1');
INSERT INTO `coder` VALUES ('7', '2019-03-20 15:35:53', '2019-03-20 15:59:53', 'a0001', '车库相关', 'parkingSortCode', 'roadside', '车库类型', '路侧', '1');
INSERT INTO `coder` VALUES ('8', '2019-03-20 15:38:46', '2019-03-20 15:59:57', 'a0001', '车库相关', 'parkingSortCode', 'indoor', '车库相关', '停车楼', '1');
INSERT INTO `coder` VALUES ('9', '2019-03-20 15:40:30', '2019-03-20 16:00:42', 'b0001', '车辆相关', 'carSize', 'sc', '车辆类型', '小车', '2');
INSERT INTO `coder` VALUES ('10', '2019-03-20 15:40:49', '2019-03-20 16:00:46', 'b0001', '车辆相关', 'carSize', 'bc', '车辆类型', '大车', '2');
INSERT INTO `coder` VALUES ('11', '2019-03-20 15:41:58', '2019-03-20 16:01:19', 'c0001', '订单相关', 'orderStatus', 'succeed', '订单状态', '预订成功', '3');
INSERT INTO `coder` VALUES ('12', '2019-03-20 15:42:54', '2019-03-20 16:01:22', 'c0001', '订单相关', 'orderStatus', 'failure', '订单状态', '订单失效', '3');
INSERT INTO `coder` VALUES ('13', '2019-03-20 15:43:50', '2019-03-20 16:01:25', 'c0001', '订单相关', 'orderStatus', 'arrive', '订单状态', '停车中', '3');
INSERT INTO `coder` VALUES ('14', '2019-03-20 15:45:29', '2019-03-20 16:01:29', 'c0001', '订单相关', 'orderStatus', 'finish', '订单状态', '已完成', '3');
INSERT INTO `coder` VALUES ('15', '2019-03-20 15:46:01', '2019-03-20 16:01:06', 'c0001', '订单相关', 'payStatus', 'no', '支付状态', '待支付', '3');
INSERT INTO `coder` VALUES ('16', '2019-03-20 15:46:42', '2019-03-20 16:01:09', 'c0001', '订单相关', 'payStatus', 'yes', '支付状态', '已支付', '3');
INSERT INTO `coder` VALUES ('17', '2019-03-20 15:58:04', '2019-03-20 15:58:04', 'a0001', '车库相关', 'isBusiness', 'yes', '是否营业', '是', '1');
INSERT INTO `coder` VALUES ('18', '2019-03-20 15:58:27', '2019-03-20 15:58:27', 'a0001', '车库相关', 'isBusiness', 'no', '是否营业', '否', '1');
INSERT INTO `coder` VALUES ('27', '2019-04-02 15:23:59', '2019-04-02 15:23:59', 'a0001', '车库相关', 'parkingStatusCode', 'free', '车库状态', '空闲', '1');
INSERT INTO `coder` VALUES ('20', '2019-03-21 14:54:16', '2019-03-21 14:54:16', 'a0001', '车库相关', 'parkingStatusCode', 'normal', '车库状态', '正常', '1');
INSERT INTO `coder` VALUES ('21', '2019-03-21 14:55:01', '2019-03-21 14:55:01', 'a0001', '车库相关', 'parkingStatusCode', 'busy', '车库状态', '紧张', '1');
INSERT INTO `coder` VALUES ('22', '2019-03-21 14:59:28', '2019-03-21 14:59:28', 'w0001', '车位相关', null, null, null, null, null);
INSERT INTO `coder` VALUES ('23', '2019-03-21 15:00:29', '2019-03-21 15:01:26', 'w0001', '车位相关', 'carPlaceType', 'common', '车位类型', '普通型', '22');
INSERT INTO `coder` VALUES ('24', '2019-03-21 15:01:07', '2019-03-21 15:01:30', 'w0001', '车位相关', 'carPlaceType', 'vip', '车位类型', '会员型', '22');
INSERT INTO `coder` VALUES ('25', '2019-03-21 15:01:58', '2019-03-21 15:01:58', 'w0001', '车位相关', 'carPlaceStatus', 'free', '车位状态', '空闲', '22');
INSERT INTO `coder` VALUES ('26', '2019-03-21 15:02:21', '2019-03-21 15:02:21', 'w0001', '车位相关', 'carPlaceStatus', 'use', '车位状态', '占用', '22');

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `parking_id` int(11) DEFAULT NULL,
  `replay` varchar(255) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comment
-- ----------------------------

-- ----------------------------
-- Table structure for information
-- ----------------------------
DROP TABLE IF EXISTS `information`;
CREATE TABLE `information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `send_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of information
-- ----------------------------
INSERT INTO `information` VALUES ('1', '2019-04-08 19:01:21', '2019-04-08 19:01:24', '明天来上班', '0', 'boss通知', 'info', '2', '2');

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `log_level` varchar(255) DEFAULT NULL,
  `request_url` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES ('1', '2019-04-08 18:36:12', '2019-04-08 18:36:12', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('2', '2019-04-08 18:37:07', '2019-04-08 18:37:07', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('3', '2019-04-08 18:40:28', '2019-04-08 18:40:28', '用户: [测试员1] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '5');
INSERT INTO `log` VALUES ('4', '2019-04-08 18:40:28', '2019-04-08 18:40:28', '用户: [测试员1] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '5');
INSERT INTO `log` VALUES ('5', '2019-04-08 18:40:47', '2019-04-08 18:40:47', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('6', '2019-04-08 19:02:31', '2019-04-08 19:02:31', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('7', '2019-04-08 19:07:00', '2019-04-08 19:07:00', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('8', '2019-04-08 19:10:50', '2019-04-08 19:10:50', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('9', '2019-04-08 19:13:22', '2019-04-08 19:13:22', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('10', '2019-04-08 19:14:50', '2019-04-08 19:14:50', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('11', '2019-04-08 19:15:33', '2019-04-08 19:15:33', '用户: [测试员1] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '5');
INSERT INTO `log` VALUES ('12', '2019-04-08 19:17:36', '2019-04-08 19:17:36', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('13', '2019-04-08 19:17:38', '2019-04-08 19:17:38', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('14', '2019-04-08 19:17:40', '2019-04-08 19:17:40', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('15', '2019-04-08 19:17:45', '2019-04-08 19:17:45', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('16', '2019-04-08 19:20:33', '2019-04-08 19:20:33', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('17', '2019-04-08 19:23:40', '2019-04-08 19:23:40', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('18', '2019-04-08 19:25:16', '2019-04-08 19:25:16', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('19', '2019-04-09 10:53:37', '2019-04-09 10:53:37', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('20', '2019-04-09 10:53:37', '2019-04-09 10:53:37', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('21', '2019-04-09 10:59:44', '2019-04-09 10:59:44', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('22', '2019-04-09 10:59:49', '2019-04-09 10:59:49', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('23', '2019-04-09 12:03:08', '2019-04-09 12:03:08', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('24', '2019-04-09 13:37:04', '2019-04-09 13:37:04', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('25', '2019-04-09 13:37:11', '2019-04-09 13:37:11', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('26', '2019-04-09 13:44:01', '2019-04-09 13:44:01', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('27', '2019-04-09 13:53:55', '2019-04-09 13:53:55', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('28', '2019-04-09 13:53:58', '2019-04-09 13:53:58', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('29', '2019-04-09 21:18:50', '2019-04-09 21:18:50', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('30', '2019-04-09 22:06:27', '2019-04-09 22:06:27', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('31', '2019-04-09 22:38:13', '2019-04-09 22:38:13', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');
INSERT INTO `log` VALUES ('32', '2019-04-09 22:39:37', '2019-04-09 22:39:37', '用户: [彭哥] | 操作: 登录 | 参数: ', '127.0.0.1', 'info', '/api/user/login', 'SYSTEM', '2');

-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `car_place_num` int(11) DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `has_cheap` int(11) DEFAULT NULL,
  `is_business` int(11) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `max_time` int(11) DEFAULT NULL,
  `parking_name` varchar(255) NOT NULL,
  `parking_phone` varchar(15) DEFAULT NULL,
  `parking_sort_code` int(11) DEFAULT NULL,
  `parking_status_code` int(11) DEFAULT NULL,
  `pic_ids` varchar(255) DEFAULT NULL,
  `reservation_time` double DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `parking_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES ('1', '2019-03-21 14:55:57', '2019-03-21 14:55:59', '10', null, null, '17', null, '骑龙校区大门后', null, null, '骑龙停车场', '1326594856', '6', '20', null, null, '2', null);
INSERT INTO `parking` VALUES ('2', '2019-03-21 15:16:51', '2019-03-21 15:16:51', '5', null, null, '17', null, '重庆市江北区观影桥', null, null, '观音桥地下停车场', '135465984', '6', '20', '', null, '5', null);
INSERT INTO `parking` VALUES ('3', '2019-03-21 15:16:51', '2019-03-21 15:16:51', '5', null, null, '17', null, '重庆交通大学南岸校区', null, null, '交通大学停车场', '135465984', '6', '20', '', null, '6', null);

-- ----------------------------
-- Table structure for parking_order
-- ----------------------------
DROP TABLE IF EXISTS `parking_order`;
CREATE TABLE `parking_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `actual_pay` double DEFAULT NULL,
  `car_place_id` int(11) DEFAULT NULL,
  `comment_id` int(11) DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `order_status` int(11) DEFAULT NULL,
  `parking_id` int(11) DEFAULT NULL,
  `pay_status` int(11) DEFAULT NULL,
  `plate_num` varchar(255) DEFAULT NULL,
  `rule_code` varchar(255) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `total_pay` double DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_num` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of parking_order
-- ----------------------------
INSERT INTO `parking_order` VALUES ('1', '2019-03-22 03:50:55', '2019-03-22 03:50:57', null, '1', null, null, '11', '1', '15', null, null, '2019-03-22 03:53:47', null, '2', '2019032223610002', '彭哥');
INSERT INTO `parking_order` VALUES ('2', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '2', '0', null, '11', '1', '15', '', '', '2019-03-22 11:55:35', '0', '2', '2019023323650213', '彭哥');
INSERT INTO `parking_order` VALUES ('3', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '2', '0', null, '11', '1', '15', '', '', '2019-03-22 11:55:35', '0', '2', '2019023323650213', '彭哥');
INSERT INTO `parking_order` VALUES ('4', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '2', '0', null, '11', '1', '15', '', '', '2019-03-22 11:55:35', '0', '2', '2019023323650213', '彭哥');
INSERT INTO `parking_order` VALUES ('5', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '2', '0', null, '11', '1', '15', '', '', '2019-03-22 11:55:35', '0', '2', '2019023323650213', '彭哥');
INSERT INTO `parking_order` VALUES ('6', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '2', '0', null, '11', '1', '15', '', '', '2019-03-22 11:55:35', '0', '2', '2019023323650213', '彭哥');
INSERT INTO `parking_order` VALUES ('7', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '12', '0', null, '11', '2', '15', '', '', '2019-03-22 11:55:35', '0', '7', '2019023323650213', '测试员1');
INSERT INTO `parking_order` VALUES ('8', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '12', '0', null, '11', '2', '15', '', '', '2019-03-22 11:55:35', '0', '7', '2019023323650213', '测试员1');
INSERT INTO `parking_order` VALUES ('9', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '12', '0', null, '11', '2', '15', '', '', '2019-03-22 11:55:35', '0', '7', '2019023323650213', '测试员1');
INSERT INTO `parking_order` VALUES ('10', '2019-03-22 11:55:35', '2019-03-22 11:55:35', '0', '12', '0', null, '11', '2', '15', '', '', '2019-03-22 11:55:35', '0', '7', '2019023323650213', '测试员1');
INSERT INTO `parking_order` VALUES ('11', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314231', '彭哥');
INSERT INTO `parking_order` VALUES ('12', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');
INSERT INTO `parking_order` VALUES ('13', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');
INSERT INTO `parking_order` VALUES ('14', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');
INSERT INTO `parking_order` VALUES ('15', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');
INSERT INTO `parking_order` VALUES ('16', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');
INSERT INTO `parking_order` VALUES ('17', '2019-03-25 11:09:12', '2019-03-25 11:09:12', '0', '3', '0', '2019-03-25 11:09:12', '13', '1', '16', '', '', '2019-03-25 11:09:12', '0', '2', '201945612314', '彭哥');

-- ----------------------------
-- Table structure for parking_record
-- ----------------------------
DROP TABLE IF EXISTS `parking_record`;
CREATE TABLE `parking_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `car_place_id` int(11) DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `parking_id` int(11) DEFAULT NULL,
  `plate_num` varchar(255) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `user_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of parking_record
-- ----------------------------

-- ----------------------------
-- Table structure for pay_rule
-- ----------------------------
DROP TABLE IF EXISTS `pay_rule`;
CREATE TABLE `pay_rule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `code_desc` varchar(255) DEFAULT NULL,
  `code_key` varchar(255) DEFAULT NULL,
  `code_value` varchar(255) DEFAULT NULL,
  `key_desc` varchar(255) DEFAULT NULL,
  `parking_id` int(11) DEFAULT NULL,
  `value_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pay_rule
-- ----------------------------

-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `type` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `permission` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resource
-- ----------------------------
INSERT INTO `resource` VALUES ('1', '主页', '0', '0', '/home', null, '1');
INSERT INTO `resource` VALUES ('2', '停车场管理', '0', '0', '/parking', null, '2');
INSERT INTO `resource` VALUES ('3', '车库列表', '2', '0', '/parking/list', null, '3');
INSERT INTO `resource` VALUES ('4', '车库添加', '2', '0', '/parking/edit', null, '4');
INSERT INTO `resource` VALUES ('5', '订单管理', '0', '0', '/order', null, '5');
INSERT INTO `resource` VALUES ('6', '实时订单', '5', '0', '/order/now', null, '6');
INSERT INTO `resource` VALUES ('7', '历史订单', '5', '0', '/order/history', null, '7');
INSERT INTO `resource` VALUES ('8', '车库记录表', '0', '0', '/record', null, '8');
INSERT INTO `resource` VALUES ('9', '留言管理', '0', '0', '/message', null, '9');
INSERT INTO `resource` VALUES ('10', '最新留言', '9', '0', '/message/now', null, '10');
INSERT INTO `resource` VALUES ('11', '历史留言', '9', '0', '/message/history', null, '11');
INSERT INTO `resource` VALUES ('12', '个人信息', '0', '0', '/userInfo', null, '12');
INSERT INTO `resource` VALUES ('13', '我的车辆', '12', '0', '/userInfo/car', null, '13');
INSERT INTO `resource` VALUES ('14', '系统管理', '0', '0', '/system', null, '14');
INSERT INTO `resource` VALUES ('15', '用户管理', '14', '0', '/system/user', null, '15');
INSERT INTO `resource` VALUES ('16', '角色管理', '14', '0', '/system/role', null, '16');
INSERT INTO `resource` VALUES ('17', '权限管理', '14', '0', '/system/permission', null, '17');
INSERT INTO `resource` VALUES ('18', '文件管理', '14', '0', '/system/file', null, '18');
INSERT INTO `resource` VALUES ('19', '码表管理', '14', '0', '/system/code', null, '19');
INSERT INTO `resource` VALUES ('20', '添加用户', '15', '1', '/api/user/add', 'user:add', '20');
INSERT INTO `resource` VALUES ('21', '修改资源', '17', '1', null, 'resource:update', '21');
INSERT INTO `resource` VALUES ('22', '增加资源', '17', '1', null, 'resource:add', '22');
INSERT INTO `resource` VALUES ('23', '删除资源', '17', '1', null, 'resource:delete', '23');
INSERT INTO `resource` VALUES ('24', '修改用户', '15', '1', null, 'user:update', '2');
INSERT INTO `resource` VALUES ('25', '删除用户', '15', '1', null, 'user:delete', '1');
INSERT INTO `resource` VALUES ('28', '新增角色', '16', '1', null, 'role:add', null);
INSERT INTO `resource` VALUES ('27', '我的信息', '12', '0', '/userInfo/mine', null, '0');
INSERT INTO `resource` VALUES ('29', '通知', '0', '0', '/info', null, '5');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `role_name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '2019-03-02 20:51:28', '2019-03-02 20:51:28', '管理员', 'admin');
INSERT INTO `role` VALUES ('2', '2019-03-13 20:23:14', '2019-03-13 20:23:17', '测试员', 'test');
INSERT INTO `role` VALUES ('10', '2019-03-19 17:01:24', '2019-03-19 17:01:24', '普通用户', 'user');

-- ----------------------------
-- Table structure for role_resource_bind
-- ----------------------------
DROP TABLE IF EXISTS `role_resource_bind`;
CREATE TABLE `role_resource_bind` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resource_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_resource_bind
-- ----------------------------
INSERT INTO `role_resource_bind` VALUES ('44', '20', '1');
INSERT INTO `role_resource_bind` VALUES ('24', '2', '1');
INSERT INTO `role_resource_bind` VALUES ('26', '3', '1');
INSERT INTO `role_resource_bind` VALUES ('28', '4', '1');
INSERT INTO `role_resource_bind` VALUES ('49', '25', '2');
INSERT INTO `role_resource_bind` VALUES ('6', '6', '1');
INSERT INTO `role_resource_bind` VALUES ('7', '7', '1');
INSERT INTO `role_resource_bind` VALUES ('43', '24', '2');
INSERT INTO `role_resource_bind` VALUES ('9', '9', '1');
INSERT INTO `role_resource_bind` VALUES ('10', '10', '1');
INSERT INTO `role_resource_bind` VALUES ('11', '11', '1');
INSERT INTO `role_resource_bind` VALUES ('12', '12', '1');
INSERT INTO `role_resource_bind` VALUES ('13', '13', '1');
INSERT INTO `role_resource_bind` VALUES ('32', '14', '1');
INSERT INTO `role_resource_bind` VALUES ('34', '15', '1');
INSERT INTO `role_resource_bind` VALUES ('52', '16', '1');
INSERT INTO `role_resource_bind` VALUES ('17', '17', '1');
INSERT INTO `role_resource_bind` VALUES ('36', '18', '1');
INSERT INTO `role_resource_bind` VALUES ('19', '19', '1');
INSERT INTO `role_resource_bind` VALUES ('25', '2', '2');
INSERT INTO `role_resource_bind` VALUES ('21', '21', '1');
INSERT INTO `role_resource_bind` VALUES ('27', '3', '2');
INSERT INTO `role_resource_bind` VALUES ('29', '4', '2');
INSERT INTO `role_resource_bind` VALUES ('42', '8', '1');
INSERT INTO `role_resource_bind` VALUES ('33', '14', '2');
INSERT INTO `role_resource_bind` VALUES ('35', '15', '2');
INSERT INTO `role_resource_bind` VALUES ('37', '18', '2');
INSERT INTO `role_resource_bind` VALUES ('38', '22', '1');
INSERT INTO `role_resource_bind` VALUES ('39', '23', '1');
INSERT INTO `role_resource_bind` VALUES ('40', '5', '1');
INSERT INTO `role_resource_bind` VALUES ('45', '24', '1');
INSERT INTO `role_resource_bind` VALUES ('50', '1', '1');
INSERT INTO `role_resource_bind` VALUES ('51', '1', '2');
INSERT INTO `role_resource_bind` VALUES ('53', '16', '2');
INSERT INTO `role_resource_bind` VALUES ('54', '26', '1');
INSERT INTO `role_resource_bind` VALUES ('55', '27', '1');
INSERT INTO `role_resource_bind` VALUES ('56', '28', '1');
INSERT INTO `role_resource_bind` VALUES ('57', '25', '1');
INSERT INTO `role_resource_bind` VALUES ('58', '29', '1');

-- ----------------------------
-- Table structure for upload_file
-- ----------------------------
DROP TABLE IF EXISTS `upload_file`;
CREATE TABLE `upload_file` (
  `file_id` varchar(255) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `original_file_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of upload_file
-- ----------------------------
INSERT INTO `upload_file` VALUES ('201903181917166', 'http://pno0766j2.bkt.clouddn.com/201903181917166', 'timg (2).jpg');
INSERT INTO `upload_file` VALUES ('201903181916155', 'http://pno0766j2.bkt.clouddn.com/201903181916155', 'a7f140a4df6d40b4bced0852584dd414!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181915384', 'http://pno0766j2.bkt.clouddn.com/201903181915384', 'f124941fbf12408b9b32c0facce7594b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181915500', 'http://pno0766j2.bkt.clouddn.com/201903181915500', 'timg (1).jpg');
INSERT INTO `upload_file` VALUES ('201903181916003', 'http://pno0766j2.bkt.clouddn.com/201903181916003', 'u=2399164908,2374783155&fm=26&gp=0.jpg');
INSERT INTO `upload_file` VALUES ('201903181916079', 'http://pno0766j2.bkt.clouddn.com/201903181916079', '6a095ce095ed41708bdc0de843247f0b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907346', 'http://pno0766j2.bkt.clouddn.com/201903181907346', 'timg.jpg');
INSERT INTO `upload_file` VALUES ('201903181907250', 'http://pno0766j2.bkt.clouddn.com/201903181907250', 'f124941fbf12408b9b32c0facce7594b!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907124', 'http://pno0766j2.bkt.clouddn.com/201903181907124', 'f95af7b475a04567abf5455ab1f45fad!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181907023', 'http://pno0766j2.bkt.clouddn.com/201903181907023', 'bd78e6f5977041f08d9fffa51b99d09f!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181906544', 'http://pno0766j2.bkt.clouddn.com/201903181906544', 'timg (1).jpg');
INSERT INTO `upload_file` VALUES ('201903181906448', 'http://pno0766j2.bkt.clouddn.com/201903181906448', '90b216b1bb834501b9ebc3897c7087aa!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181906267', 'http://pno0766j2.bkt.clouddn.com/201903181906267', '05d85f468c034ed9b419b370c5bf6a1e!400x400.jpeg');
INSERT INTO `upload_file` VALUES ('201903181902075', 'http://pno0766j2.bkt.clouddn.com/201903181902075', '404.png');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `account` varchar(20) NOT NULL,
  `balance` double DEFAULT NULL,
  `credit` int(11) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `user_name` varchar(20) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('2', '2019-03-13 20:12:09', '2019-03-13 20:12:13', 'admin', '10', '3', '9edef2c5ae0ccfe27768637bb12f874c', '123', '201903181917166', '1', '男', '彭哥', null, null);
INSERT INTO `user` VALUES ('5', null, null, 'test1', '10', '0', 'e8344c3c348e0e55fcd9c817e50af842', '122222', '201903181906267', '2', '女', '测试员1', null, null);
INSERT INTO `user` VALUES ('6', null, null, 'test2', '10', '0', '383d6d25f2b01c09e13cb75979ca72be', '122222', '201903181906448', '2', '女', '测试员2', null, null);
INSERT INTO `user` VALUES ('7', null, null, 'test3', '10', '2', '8587fe8b13283285e3d3cbcd7d83df3c', '12222255', '201903181906544', '2', '男', '测试员3', null, null);
INSERT INTO `user` VALUES ('8', null, null, 'test4', '10', '0', 'fa864a14fa6a3e08663671a8af1f06fd', '88888', '201903181907023', '2', '男', '测试员4', null, null);
INSERT INTO `user` VALUES ('9', null, null, 'test5', '10', '0', 'd6fbdf02bd8c25f626e90cf4b558f068', '122222', '201903181907124', '2', '男', '测试员5', null, null);
INSERT INTO `user` VALUES ('10', null, null, 'test6', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181907250', '2', '男', '测试员6', null, null);
INSERT INTO `user` VALUES ('12', null, null, 'test8', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181915500', '2', '男', '测试员8', null, null);
INSERT INTO `user` VALUES ('13', null, null, 'test9', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181916003', '2', '男', '测试员9', null, null);
INSERT INTO `user` VALUES ('14', null, null, 'test10', '10', '0', '7a752ec1721eccc128a24cdaff15bbb0', '122222', '201903181916079', '2', '男', '测试员10', null, null);

-- ----------------------------
-- Table structure for user_plate_bind
-- ----------------------------
DROP TABLE IF EXISTS `user_plate_bind`;
CREATE TABLE `user_plate_bind` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_datetime` datetime DEFAULT NULL,
  `update_datetime` datetime DEFAULT NULL,
  `plate_num` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_plate_bind
-- ----------------------------