Bike-sharingmanagementsystem/bikeshare.sql

/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50639
 Source Host           : localhost:3306
 Source Schema         : bikeshare

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

 Date: 16/04/2022 11:49:07
*/

drop database if exists bikeshare;
create database bikeshare charset utf8;
use bikeshare;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_bike
-- ----------------------------
DROP TABLE IF EXISTS `t_bike`;
CREATE TABLE `t_bike` (
  `bike_id` int(20) NOT NULL AUTO_INCREMENT,
  `bike_generationNum` int(10) DEFAULT NULL,
  `bike_password` int(10) DEFAULT NULL,
  `bike_useNum` int(20) DEFAULT NULL,
  `bike_isUsing` int(5) DEFAULT NULL,
  `bike_area` varchar(20) DEFAULT NULL,
  `bike_isUse` int(5) DEFAULT NULL,
  PRIMARY KEY (`bike_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_bike
-- ----------------------------
BEGIN;
INSERT INTO `t_bike` VALUES (1, 1, 1421, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (2, 1, 1524, NULL, 1, '南昌', 1);
INSERT INTO `t_bike` VALUES (3, 1, 2456, NULL, 1, '南昌', 1);
INSERT INTO `t_bike` VALUES (4, 1, 2564, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (5, 3, 2568, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (6, 2, 5689, NULL, 0, '扬州', 1);
INSERT INTO `t_bike` VALUES (7, 1, 5692, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (8, 1, 5698, NULL, 0, '徐州', 1);
INSERT INTO `t_bike` VALUES (9, 3, 8595, NULL, 0, '扬州', 1);
INSERT INTO `t_bike` VALUES (10, 1, 5210, NULL, 0, '徐州', 1);
INSERT INTO `t_bike` VALUES (11, 1, 2563, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (12, 1, 2562, NULL, 0, '扬州', 1);
INSERT INTO `t_bike` VALUES (13, 1, 2565, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (14, 3, 5692, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (15, 2, 9630, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (16, 2, 1010, NULL, 0, '扬州', 1);
INSERT INTO `t_bike` VALUES (17, 2, 1012, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (18, 1, 1013, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (19, 2, 2563, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (20, 1, 5693, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (21, 2, 8695, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (22, 3, 8520, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (23, 2, 8521, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (24, 3, 8520, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (25, 3, 5410, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (26, 3, 3012, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (27, 3, 7412, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (28, 3, 8547, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (29, 3, 8563, NULL, 0, '徐州', 1);
INSERT INTO `t_bike` VALUES (30, 3, 6541, NULL, 0, '徐州', 1);
INSERT INTO `t_bike` VALUES (31, 1, 6935, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (32, 1, 3210, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (33, 3, 8541, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (34, 3, 1234, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (35, 3, 1456, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (36, 1, 1111, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (37, 1, 1111, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (38, 3, 9999, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (39, 2, 8888, NULL, 0, '镇江', 1);
INSERT INTO `t_bike` VALUES (40, 2, 6666, NULL, 0, '南京', 1);
INSERT INTO `t_bike` VALUES (41, 3, 1234, NULL, 0, '南昌', 1);
INSERT INTO `t_bike` VALUES (42, 3, 1234, NULL, 0, '北京', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_column
-- ----------------------------
DROP TABLE IF EXISTS `t_column`;
CREATE TABLE `t_column` (
  `column_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '栏目权限id',
  `column_name` varchar(30) DEFAULT NULL COMMENT '权限的名称',
  `column_firstId` int(5) DEFAULT NULL COMMENT '一级栏目1',
  `column_url` varchar(20) DEFAULT NULL COMMENT 'url',
  `column_permissionId` int(5) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`column_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_column
-- ----------------------------
BEGIN;
INSERT INTO `t_column` VALUES (1, '位置', 1, 'map.jsp', 1);
INSERT INTO `t_column` VALUES (2, '骑行', 1, NULL, 2);
INSERT INTO `t_column` VALUES (3, '选车', 2, 'selectbike.jsp', 2);
INSERT INTO `t_column` VALUES (4, '还车', 2, 'returnbike.jsp', 2);
INSERT INTO `t_column` VALUES (5, '查看', 1, NULL, 5);
INSERT INTO `t_column` VALUES (6, '查看余额', 2, 'userpay.jsp', 5);
INSERT INTO `t_column` VALUES (7, '查看订单', 2, 'userrecord.jsp', 5);
INSERT INTO `t_column` VALUES (8, '反馈', 1, NULL, 8);
INSERT INTO `t_column` VALUES (9, '报修', 2, 'userrepair.jsp', 8);
INSERT INTO `t_column` VALUES (11, '申诉', 2, 'userservice.jsp', 8);
INSERT INTO `t_column` VALUES (12, '内容管理', 1, NULL, 12);
INSERT INTO `t_column` VALUES (13, '新增单车', 2, 'adminaddbike.jsp', 12);
INSERT INTO `t_column` VALUES (14, '单车管理', 2, 'adminbikelist.jsp', 12);
INSERT INTO `t_column` VALUES (15, '查看', 1, NULL, 15);
INSERT INTO `t_column` VALUES (16, '查看统计', 2, 'adminstatistics.jsp', 15);
INSERT INTO `t_column` VALUES (17, '维修管理', 1, NULL, 17);
INSERT INTO `t_column` VALUES (18, '查看维修订单', 2, 'complainlist.jsp', 17);
INSERT INTO `t_column` VALUES (19, '处理维修订单', 2, 'complainmanager.jsp', 17);
INSERT INTO `t_column` VALUES (20, '客服管理', 1, NULL, 20);
INSERT INTO `t_column` VALUES (21, '查看投诉订单', 2, 'servicelist.jsp', 20);
INSERT INTO `t_column` VALUES (22, '处理投诉订单', 2, 'servicemanger.jsp', 20);
INSERT INTO `t_column` VALUES (23, '当前位置', 2, 'map.jsp', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_complain
-- ----------------------------
DROP TABLE IF EXISTS `t_complain`;
CREATE TABLE `t_complain` (
  `complain_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '客服处理订单id',
  `complain_user_id` int(20) NOT NULL COMMENT '用户id',
  `complain_bike_id` int(20) NOT NULL COMMENT '单车id',
  `complain_bike_area` varchar(20) NOT NULL COMMENT '单车的区域',
  `complain_info` varchar(20) NOT NULL COMMENT '投诉理由',
  `complain_flag` int(5) NOT NULL COMMENT '标记是否处理',
  PRIMARY KEY (`complain_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_complain
-- ----------------------------
BEGIN;
INSERT INTO `t_complain` VALUES (9, 1, 1, '南京', '账户被冻结', 1);
INSERT INTO `t_complain` VALUES (10, 1, 5, '南京', '无故扣费', 0);
INSERT INTO `t_complain` VALUES (11, 1, 3, '南京', '无法开锁', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_employee
-- ----------------------------
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE `t_employee` (
  `employee_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '员工id',
  `employee_rank` int(5) DEFAULT NULL COMMENT '员工职务级别',
  `employee_name` varchar(20) DEFAULT NULL COMMENT '员工职务名称',
  `employee_sysName` varchar(20) DEFAULT NULL COMMENT '系统名称',
  `employee_phone` varchar(20) DEFAULT NULL COMMENT '电话',
  `employee_email` varchar(20) DEFAULT NULL COMMENT '邮箱',
  `employee_idCard` varchar(20) DEFAULT NULL COMMENT '身份证号码',
  `employee_password` varchar(50) DEFAULT NULL COMMENT '系统登录密码',
  `employee_isJob` int(5) DEFAULT NULL COMMENT '是否在职',
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_employee
-- ----------------------------
BEGIN;
INSERT INTO `t_employee` VALUES (1, 1, 'admin', NULL, '13207001362', 'admin@qq.com', '123456789123456789', '123', 1);
INSERT INTO `t_employee` VALUES (2, 2, 'service', NULL, '12345678912', 'service@qq.com', '147852369789456123', '123456', 1);
INSERT INTO `t_employee` VALUES (3, 3, 'complain', NULL, '14785965232', 'complain@qq.com', '123789456963852741', '123456', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_limite_role
-- ----------------------------
DROP TABLE IF EXISTS `t_limite_role`;
CREATE TABLE `t_limite_role` (
  `limite_role_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '权限角色id',
  `column_id` int(20) DEFAULT NULL COMMENT '栏目id',
  `employee_rank` int(5) DEFAULT NULL COMMENT '员工职务级别',
  `user_rank` int(5) DEFAULT NULL COMMENT '用户标识',
  PRIMARY KEY (`limite_role_id`),
  KEY `FK_t_limite_role` (`user_rank`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_limite_role
-- ----------------------------
BEGIN;
INSERT INTO `t_limite_role` VALUES (1, 1, NULL, 0);
INSERT INTO `t_limite_role` VALUES (2, 2, NULL, 0);
INSERT INTO `t_limite_role` VALUES (3, 5, NULL, 0);
INSERT INTO `t_limite_role` VALUES (4, 8, NULL, 0);
INSERT INTO `t_limite_role` VALUES (5, 12, 1, NULL);
INSERT INTO `t_limite_role` VALUES (6, 15, 1, NULL);
INSERT INTO `t_limite_role` VALUES (7, 17, 2, NULL);
INSERT INTO `t_limite_role` VALUES (8, 20, 3, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_record
-- ----------------------------
DROP TABLE IF EXISTS `t_record`;
CREATE TABLE `t_record` (
  `record_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `user_id` int(20) DEFAULT NULL COMMENT '用户id',
  `bike_id` int(20) DEFAULT NULL COMMENT '单车id',
  `start_date` varchar(20) DEFAULT NULL COMMENT '骑行开始时间',
  `return_date` varchar(20) DEFAULT NULL COMMENT '关锁时间',
  `payment` bigint(20) DEFAULT NULL COMMENT '支付金额',
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_record
-- ----------------------------
BEGIN;
INSERT INTO `t_record` VALUES (31, 1, 1, '2024-10-05-15-55-37', '2024-10-05-16-00-31', 1);
INSERT INTO `t_record` VALUES (32, 1, 1, '2024-10-05-16-00-37', '2024-10-05-16-08-43', 1);
INSERT INTO `t_record` VALUES (33, 1, 1, '2024-10-05-16-08-47', '2024-10-05-16-16-51', 1);
INSERT INTO `t_record` VALUES (34, 1, 1, '2024-10-05-16-18-00', '2024-10-05-16-18-26', 1);
INSERT INTO `t_record` VALUES (35, 1, 3, '2024-10-05-16-18-35', '2024-10-05-16-23-45', 1);
INSERT INTO `t_record` VALUES (36, 1, 1, '2024-10-05-16-23-51', '2024-10-05-16-23-57', 1);
INSERT INTO `t_record` VALUES (37, 1, 1, '2024-10-05-16-24-01', '2024-10-05-16-26-57', 1);
INSERT INTO `t_record` VALUES (38, 1, 1, '2024-10-05-16-27-01', '2024-10-05-16-27-31', 1);
INSERT INTO `t_record` VALUES (39, 1, 1, '2024-10-05-16-27-37', '2024-10-05-17-28-49', 2);
INSERT INTO `t_record` VALUES (40, 1, 1, '2024-10-06-09-32-42', '2024-10-06-09-52-13', 1);
INSERT INTO `t_record` VALUES (41, 1, 1, '2024-10-06-09-52-19', '2024-10-06-09-52-36', 1);
INSERT INTO `t_record` VALUES (42, 1, 1, '2024-10-06-10-06-05', '2024-10-06-11-05-02', 1);
INSERT INTO `t_record` VALUES (43, 1, 1, '2024-10-06-11-05-16', '2024-10-06-11-05-28', 1);
INSERT INTO `t_record` VALUES (44, 1, 1, '2024-10-06-11-06-38', '2024-10-06-11-08-52', 1);
INSERT INTO `t_record` VALUES (45, 1, 1, '2024-10-06-11-10-14', '2024-10-06-11-11-00', 1);
INSERT INTO `t_record` VALUES (46, 1, 1, '2024-10-06-11-11-04', '2024-10-06-11-11-36', 1);
INSERT INTO `t_record` VALUES (47, 1, 2, '2024-10-06-11-11-46', '2024-10-06-11-18-39', 1);
INSERT INTO `t_record` VALUES (48, 1, 1, '2024-10-06-11-18-45', '2024-10-06-11-19-26', 1);
INSERT INTO `t_record` VALUES (49, 1, 1, '2024-10-06-11-19-40', '2024-10-06-11-49-00', 1);
INSERT INTO `t_record` VALUES (50, 1, 2, '2024-10-06-11-49-15', '2024-10-06-11-49-19', 1);
INSERT INTO `t_record` VALUES (51, 1, 1, '2024-10-06-11-51-50', '2024-10-06-11-51-59', 1);
INSERT INTO `t_record` VALUES (52, 1, 1, '2024-10-06-11-52-03', '2024-10-06-11-52-25', 1);
INSERT INTO `t_record` VALUES (53, 1, 1, '2024-10-06-13-23-04', '2024-10-06-13-23-21', 1);
INSERT INTO `t_record` VALUES (54, 1, 2, '2024-10-06-13-23-32', '2024-10-08 11:11:00', 1);
INSERT INTO `t_record` VALUES (55, 1, 3, '2024-10-06-15-23-07', '2024-10-06-15-23-20', 1);
INSERT INTO `t_record` VALUES (56, 1, 4, '2024-10-06-15-23-25', '2024-10-07-16-59-51', 26);
INSERT INTO `t_record` VALUES (57, 1, 3, '2024-10-07-17-00-19', '2024-10-08-09-40-06', 17);
INSERT INTO `t_record` VALUES (58, 1, 1, '2024-10-08-09-40-12', '2024-10-08-09-40-52', 1);
INSERT INTO `t_record` VALUES (59, 1, 1, '2024-10-08-09-41-05', '2024-10-08-09-41-19', 1);
INSERT INTO `t_record` VALUES (60, 1, 1, '2024-10-08-17-54-05', '2024-10-08-17-54-29', 1);
INSERT INTO `t_record` VALUES (61, 1, 1, '2024-10-08-17-54-34', '2024-10-08-18-14-11', 1);
INSERT INTO `t_record` VALUES (62, 1, 1, '2024-10-08-18-14-16', '2024-10-09-08-39-34', 15);
INSERT INTO `t_record` VALUES (63, 1, 2, '2024-10-09-08-40-08', '2024-10-09-08-40-15', 1);
INSERT INTO `t_record` VALUES (64, 1, 2, '2024-10-09-09-13-44', '2024-10-09-09-17-19', 1);
INSERT INTO `t_record` VALUES (65, 1, 1, '2024-10-09-09-29-55', '2024-10-09-09-30-39', 1);
INSERT INTO `t_record` VALUES (66, 1, 1, '2024-10-09-09-35-12', '2024-10-09-09-36-30', 1);
INSERT INTO `t_record` VALUES (67, 1, 1, '2024-10-09-09-36-34', '2024-10-09-09-46-26', 1);
INSERT INTO `t_record` VALUES (68, 1, 1, '2024-10-09-09-47-58', '2024-10-09-09-48-10', 1);
INSERT INTO `t_record` VALUES (69, 1, 2, '2024-10-09-10-13-06', '2024-10-09-10-14-18', 1);
INSERT INTO `t_record` VALUES (70, 1, 1, '2024-10-09-10-21-03', '2024-10-09-11-04-26', 1);
INSERT INTO `t_record` VALUES (71, 1, 3, '2024-10-09-11-04-50', '2024-10-09-11-05-09', 1);
INSERT INTO `t_record` VALUES (72, 1, 1, '2024-10-09-11-10-45', '2024-10-09-11-11-51', 1);
INSERT INTO `t_record` VALUES (73, 1, 2, '2024-10-09-11-11-59', '2024-10-09-11-19-16', 1);
INSERT INTO `t_record` VALUES (74, 1, 1, '2024-10-09-11-19-21', '2024-10-09-11-20-40', 1);
INSERT INTO `t_record` VALUES (75, 1, 1, '2024-10-09-11-20-45', '2024-10-09-11-21-21', 1);
INSERT INTO `t_record` VALUES (76, 1, 1, '2024-10-09-11-21-25', '2024-10-09-11-27-26', 1);
INSERT INTO `t_record` VALUES (77, 1, 2, '2024-10-09-11-27-31', '2024-10-09-11-27-49', 1);
INSERT INTO `t_record` VALUES (78, 1, 3, '2024-10-09-11-27-55', '2024-10-09-11-29-39', 1);
INSERT INTO `t_record` VALUES (79, 1, 1, '2024-10-09-11-29-43', '2024-10-09-11-29-58', 1);
INSERT INTO `t_record` VALUES (80, 1, 2, '2024-10-09-11-30-04', '2024-10-09-11-31-49', 1);
INSERT INTO `t_record` VALUES (81, 1, 2, '2024-10-09-11-32-03', '2024-10-09-11-33-29', 1);
INSERT INTO `t_record` VALUES (82, 1, 2, '2024-10-09-11-33-34', '2024-10-09-11-35-29', 1);
INSERT INTO `t_record` VALUES (83, 1, 3, '2024-10-09-11-35-36', '2024-10-09-11-44-23', 1);
INSERT INTO `t_record` VALUES (84, 1, 1, '2024-10-09-11-44-27', '2024-10-09-11-44-58', 1);
INSERT INTO `t_record` VALUES (85, 1, 2, '2024-10-09-11-45-03', '2024-10-09-11-47-15', 1);
INSERT INTO `t_record` VALUES (86, 1, 1, '2024-10-09-11-47-23', '2024-10-09-11-49-56', 1);
INSERT INTO `t_record` VALUES (87, 1, 2, '2024-10-09-11-50-01', '2024-10-09-11-55-47', 1);
INSERT INTO `t_record` VALUES (88, 1, 2, '2024-10-09-11-55-54', '2024-10-09-11-56-28', 1);
INSERT INTO `t_record` VALUES (89, 1, 2, '2024-10-09-11-56-34', '2024-10-09-12-06-27', 1);
INSERT INTO `t_record` VALUES (90, 1, 1, '2024-10-09-12-06-32', '2024-10-09-12-08-22', 1);
INSERT INTO `t_record` VALUES (91, 1, 1, '2024-10-09-12-08-26', '2024-10-09-13-05-51', 1);
INSERT INTO `t_record` VALUES (92, 1, 1, '2024-10-09-13-05-55', '2024-10-09-13-06-26', 1);
INSERT INTO `t_record` VALUES (93, 1, 2, '2024-10-09-13-06-33', '2024-10-09-13-23-07', 1);
INSERT INTO `t_record` VALUES (94, 1, 2, '2024-10-09-13-23-12', '2024-10-09-14-13-13', 1);
INSERT INTO `t_record` VALUES (95, 1, 2, '2024-10-09-14-13-16', '2024-10-09-14-16-55', 1);
INSERT INTO `t_record` VALUES (96, 1, 1, '2024-10-09-14-16-59', '2024-10-09-14-20-29', 1);
INSERT INTO `t_record` VALUES (97, 1, 1, '2024-10-09-14-20-33', '2024-10-09-14-21-09', 1);
INSERT INTO `t_record` VALUES (98, 1, 1, '2024-10-09-14-21-14', '2024-10-09-14-21-33', 1);
INSERT INTO `t_record` VALUES (99, 1, 1, '2024-10-09-14-23-43', '2024-10-09-14-25-53', 1);
INSERT INTO `t_record` VALUES (100, 1, 1, '2024-10-09-14-25-57', '2024-10-09-14-26-22', 1);
INSERT INTO `t_record` VALUES (101, 1, 2, '2024-10-09-14-26-27', '2024-10-09-14-27-02', 1);
INSERT INTO `t_record` VALUES (102, 1, 1, '2024-10-09-14-29-05', '2024-10-09-14-30-10', 1);
INSERT INTO `t_record` VALUES (103, 1, 1, '2024-10-09-14-30-47', '2024-10-09-14-30-58', 1);
INSERT INTO `t_record` VALUES (104, 1, 1, '2024-10-09-14-40-17', '2024-10-09-14-46-35', 1);
INSERT INTO `t_record` VALUES (105, 1, 5, '2024-10-09-14-46-39', '2024-10-09-15-01-03', 1);
INSERT INTO `t_record` VALUES (106, 1, 1, '2024-10-10-18-36-57', '2024-10-10-18-42-18', 1);
INSERT INTO `t_record` VALUES (107, 1, 1, '2021-05-01-21-03-19', '2021-05-01-21-05-07', 1);
INSERT INTO `t_record` VALUES (108, 1, 1, '2021-05-20-23-37-44', '2021-05-20-23-38-26', 1);
INSERT INTO `t_record` VALUES (109, 1, 1, '2024-10-30-00-17-51', '2024-10-31-16-14-36', 40);
INSERT INTO `t_record` VALUES (110, 1, 5, '2024-10-31-16-14-43', '2024-10-31-16-15-51', 1);
INSERT INTO `t_record` VALUES (111, 1, 7, '2024-10-31-16-16-03', '2024-10-31-16-16-58', 1);
INSERT INTO `t_record` VALUES (112, 1, 5, '2024-10-31-16-22-01', '2022-04-16-10-30-49', 379);
COMMIT;

-- ----------------------------
-- Table structure for t_service
-- ----------------------------
DROP TABLE IF EXISTS `t_service`;
CREATE TABLE `t_service` (
  `service_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '维修id',
  `service_user_id` int(20) NOT NULL COMMENT '用户id',
  `service_bike_id` int(20) NOT NULL COMMENT '单车id',
  `service_bike_area` varchar(20) NOT NULL COMMENT '单车区域',
  `service_info` varchar(50) NOT NULL COMMENT '单车故障信息',
  `service_flag` int(5) NOT NULL COMMENT '标记是否处理',
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_service
-- ----------------------------
BEGIN;
INSERT INTO `t_service` VALUES (2, 1, 2, '南京', '无法开锁', 1);
INSERT INTO `t_service` VALUES (3, 1, 2, '南京', '链条损坏', 1);
INSERT INTO `t_service` VALUES (6, 1, 2, '南京', '脚踏损坏', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_name` varchar(20) DEFAULT NULL COMMENT '用户名',
  `user_password` varchar(50) DEFAULT NULL COMMENT '用户密码',
  `user_phoneNum` varchar(20) DEFAULT NULL COMMENT '用户手机号码',
  `user_email` varchar(20) DEFAULT NULL COMMENT '用户邮箱',
  `user_idCard` varchar(20) DEFAULT NULL COMMENT '用户身份证号码',
  `user_balance` bigint(10) DEFAULT NULL COMMENT '账户余额',
  `user_deposit` int(10) DEFAULT NULL COMMENT '押金',
  `user_comment` varchar(20) DEFAULT NULL COMMENT '备注',
  `user_rank` int(5) DEFAULT NULL COMMENT '员工级别（固定为0）',
  KEY `NewIndex1` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (1, '张三', '123', '13912345678', 'zhangsan@163.com', '123456789123456789', 229, 199, NULL, 0);
INSERT INTO `t_user` VALUES (2, '杰克', '123456', '123456', 'jack@qq.com', '147852369987456123', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (37, '花花', '123', '13207001362', '123456@qq.com', '123456789741852963', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (39, '伟大', '123', '123456', '11@qq.com', '123456789741258369', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (40, '晓天', '123', '123456', '123456@qq.com', '147852963123456789', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (41, '新春', '123', '123456', '123456@qq.com', '123456789789456123', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (42, '梦想', '111', '123456', '11@qq.com', '145632987741258963', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (43, '力量', '111', '123456', '11@qq.com', '111111111111111111', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (44, '奋斗', '111', '123456', '123456@qq.com', '147852369741258963', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (45, '你好啊 ', '111', '123456', '123456789@qq.com', '123456789789456123', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (48, '原子', '123', '13207001362', '123456@qq.com', '123456789785412369', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (49, '分子', '123', '123456', '123456@qq.com', '147852369789456123', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (54, '天空', '111', '123456', '1026938865@qq.com', '123456789789789789', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (55, '小米', '111', '123456', '123456@qq.com', '123456789789789789', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (56, '爱好', '123', '123456', '123456@qq.com', '123456789741852963', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (57, '中学', '1', '11', '123456789@qq.com', '147852369123456788', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (60, '中心', '123', '123456', '11@qq.com', '147852369123456788', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (61, '梦想', '111111', '123456', '123456@qq.com', '123456789456456456', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (62, '膜拜', '111', '13207001362', '11@qq.com', '222222222222222222', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (63, '小蓝', '11', '123456', '123456@qq.com', '111111111123456789', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (84, '天蓝蓝', '111111', '13207001362', '123456@qq.com', '123456789789456789', 0, 199, NULL, 0);
INSERT INTO `t_user` VALUES (85, 'aaa', 'EFG@AB', '13951712332', 'aaa@qq.com', '32038119870103383x', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (86, 'bbb', 'EFG@AB', '13951683475', 'bbb@qq.com', '320381198701033833', NULL, NULL, NULL, 0);
INSERT INTO `t_user` VALUES (87, 'ccc', '123456', '13951683475', 'ccc@qq.com', '320381198701033834', NULL, NULL, NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;