-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql.sql
More file actions
190 lines (144 loc) · 43.3 KB
/
Copy pathsql.sql
File metadata and controls
190 lines (144 loc) · 43.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 8.0.31 : Database - guigu-auth
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`guigu-auth` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `guigu-auth`;
/*Table structure for table `classmates` */
DROP TABLE IF EXISTS `classmates`;
CREATE TABLE `classmates` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '同学的id',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '用户的姓名',
`grade` varchar(50) DEFAULT NULL COMMENT '班级',
`group` tinyint(1) DEFAULT NULL COMMENT '小组',
`nickName` varchar(50) DEFAULT NULL COMMENT '昵称',
`phone` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机号',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记(0:不可用 1:可用)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16865620831372 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `classmates` */
/*Table structure for table `homework` */
DROP TABLE IF EXISTS `homework`;
CREATE TABLE `homework` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '作业的id',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '作业的名称',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='作业表';
/*Data for the table `homework` */
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`parent_id` bigint NOT NULL DEFAULT '0' COMMENT '所属上级',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
`type` tinyint NOT NULL DEFAULT '0' COMMENT '类型(0:目录,1:菜单,2:按钮)',
`path` varchar(100) DEFAULT NULL COMMENT '路由地址',
`component` varchar(100) DEFAULT NULL COMMENT '组件路径',
`perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
`icon` varchar(100) DEFAULT NULL COMMENT '图标',
`sort_value` int DEFAULT NULL COMMENT '排序',
`status` tinyint DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单表';
/*Data for the table `sys_menu` */
insert into `sys_menu`(`id`,`parent_id`,`name`,`type`,`path`,`component`,`perms`,`icon`,`sort_value`,`status`,`create_time`,`update_time`,`is_deleted`) values (2,0,'系统管理',0,'system','Layout',NULL,'el-icon-s-tools',1,1,'2021-05-31 18:05:37','2022-06-09 09:23:24',0),(3,2,'用户管理',1,'sysUser','system/sysUser/list','','el-icon-s-custom',1,1,'2021-05-31 18:05:37','2022-06-09 09:22:47',0),(4,2,'角色管理',1,'sysRole','system/sysRole/list','','el-icon-user-solid',2,1,'2021-05-31 18:05:37','2022-06-09 09:37:18',0),(5,2,'菜单管理',1,'sysMenu','system/sysMenu/list','','el-icon-s-unfold',3,1,'2021-05-31 18:05:37','2022-06-09 09:37:21',0),(6,3,'查看',2,NULL,NULL,'bnt.sysUser.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(7,3,'添加',2,NULL,NULL,'bnt.sysUser.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(8,3,'修改',2,NULL,NULL,'bnt.sysUser.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(9,3,'删除',2,NULL,NULL,'bnt.sysUser.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(10,4,'查看',2,NULL,NULL,'bnt.sysRole.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(11,4,'添加',2,NULL,NULL,'bnt.sysRole.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(12,4,'修改',2,NULL,NULL,'bnt.sysRole.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(13,4,'删除',2,NULL,NULL,'bnt.sysRole.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(14,5,'查看',2,NULL,NULL,'bnt.sysMenu.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(15,5,'添加',2,NULL,NULL,'bnt.sysMenu.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(16,5,'修改',2,NULL,NULL,'bnt.sysMenu.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(17,5,'删除',2,NULL,NULL,'bnt.sysMenu.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(18,3,'分配角色',2,NULL,NULL,'bnt.sysUser.assignRole',NULL,1,1,'2022-05-23 17:14:32','2022-06-09 09:22:38',0),(19,4,'分配权限',2,'assignAuth','system/sysRole/assignAuth','bnt.sysRole.assignAuth',NULL,1,1,'2022-05-23 17:18:14','2022-06-09 09:22:38',0),(20,2,'部门管理',1,'sysDept','system/sysDept/list','','el-icon-s-operation',4,1,'2022-05-24 10:07:05','2022-06-09 09:38:12',0),(21,20,'查看',2,NULL,NULL,'bnt.sysDept.list',NULL,1,1,'2022-05-24 10:07:44','2022-06-09 09:22:38',0),(22,2,'岗位管理',1,'sysPost','system/sysPost/list','','el-icon-more-outline',5,1,'2022-05-24 10:25:30','2022-06-09 09:38:13',0),(23,22,'查看',2,NULL,NULL,'bnt.sysPost.list',NULL,1,1,'2022-05-24 10:25:45','2022-06-09 09:22:38',0),(24,20,'添加',2,NULL,NULL,'bnt.sysDept.add',NULL,1,1,'2022-05-25 15:31:27','2022-06-09 09:22:38',0),(25,20,'修改',2,NULL,NULL,'bnt.sysDept.update',NULL,1,1,'2022-05-25 15:31:41','2022-06-09 09:22:38',0),(26,20,'删除',2,NULL,NULL,'bnt.sysDept.remove',NULL,1,1,'2022-05-25 15:31:59','2022-06-09 09:22:38',0),(27,22,'添加',2,NULL,NULL,'bnt.sysPost.add',NULL,1,1,'2022-05-25 15:32:44','2022-06-09 09:22:38',0),(28,22,'修改',2,NULL,NULL,'bnt.sysPost.update',NULL,1,1,'2022-05-25 15:32:58','2022-06-09 09:22:38',0),(29,22,'删除',2,NULL,NULL,'bnt.sysPost.remove',NULL,1,1,'2022-05-25 15:33:11','2022-06-09 09:22:38',0),(31,30,'查看',2,NULL,NULL,'bnt.sysOperLog.list',NULL,1,1,'2022-05-26 16:10:17','2022-06-09 09:22:38',0),(33,32,'查看',2,NULL,NULL,'bnt.sysLoginLog.list',NULL,1,1,'2022-05-26 16:36:31','2022-06-09 09:36:36',0),(35,2,'测试管理',1,'sysTest3','system/sysTest3/list',NULL,'el-icon-s-tools',1,1,'2023-06-12 21:03:27','2023-06-15 14:41:27',1),(36,2,'测试管理2',1,'sysTest','system/sysTest/list',NULL,'el-icon-s-tools',1,1,'2023-06-12 21:14:18','2023-06-12 21:17:59',1),(37,2,'测试管理3',1,'sysTest','system/sysTest/list','','el-icon-tickets',1,1,'2023-06-12 21:15:14','2023-06-12 21:17:55',1),(38,35,'查看',2,'','','bnt.sysMenu.list','',1,1,'2023-06-12 21:21:11','2023-06-15 14:41:25',1),(39,0,'测试系统管理',0,'systemTest','Layout','','el-icon-s-check',1,1,'2023-06-12 21:22:50','2023-06-12 21:47:55',1),(40,0,'作业上传',0,'system/sysUpload/list','Layout','','el-icon-s-custom',1,1,'2023-09-07 03:43:03','2023-09-07 03:43:20',1),(41,2,'作业上传',1,'sysUpload','system/sysUpload/list','','el-icon-s-tools',1,1,'2023-09-07 03:44:11','2023-09-07 03:44:11',0),(42,41,'查看',2,'','','bnt.sysUser.list','',1,1,'2023-09-07 03:45:46','2023-09-07 03:45:46',0),(43,41,'添加',2,'','','bnt.sysUser.add','',1,1,'2023-09-07 03:46:05','2023-09-07 03:46:05',0),(44,41,'修改',2,'','','bnt.sysUser.update','',1,1,'2023-09-07 03:46:24','2023-09-07 03:46:24',0),(45,41,'删除',2,'','','bnt.sysUser.remove','',1,1,'2023-09-07 03:46:35','2023-09-07 03:46:35',0),(46,2,'作业提交情况',1,'sysShow','system/sysShow/list','','el-icon-s-custom',1,1,'2023-09-10 16:05:25','2023-09-10 16:05:25',0),(47,46,'查看',2,'','','bnt.sysUser.list','',1,1,'2023-09-10 16:08:05','2023-09-10 16:08:05',0);
/*Table structure for table `sys_role` */
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色id',
`role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称',
`role_code` varchar(20) DEFAULT NULL COMMENT '角色编码',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COMMENT='角色';
/*Data for the table `sys_role` */
insert into `sys_role`(`id`,`role_name`,`role_code`,`description`,`create_time`,`update_time`,`is_deleted`) values (1,'系统管理员','SYSTEM','系统管理员666','2021-05-31 18:09:18','2023-06-15 15:42:05',0),(2,'普通管理员','COMMON','普通管理员','2021-06-01 08:38:40','2023-06-10 16:12:00',0),(8,'用户管理员','123',NULL,'2022-06-08 17:39:04','2023-06-10 18:38:28',0),(9,'裘千尺','vip','这是一个超级管理员','2023-06-06 16:39:47','2023-06-11 18:11:58',1),(10,'乔峰222','vip','超级管理员222','2023-06-06 19:13:43','2023-06-11 18:11:58',1),(11,'段誉','vvip','超级管理员','2023-06-06 19:14:22','2023-06-11 18:11:58',1),(12,'段誉','vvip','超级管理员','2023-06-06 19:14:29','2023-06-11 18:11:58',1),(13,'张三丰','vvvip','武当派','2023-06-06 19:14:57','2023-06-11 18:11:58',1),(14,'谢逊9','vvip','金毛狮王','2023-06-06 19:15:16','2023-06-11 18:11:58',1),(15,'马钰','射雕英雄传','全真剑法','2023-06-06 19:56:19','2023-06-11 18:11:58',1),(16,'一灯','射雕英雄传','一阳指','2023-06-06 19:56:33','2023-06-11 18:11:58',1),(17,'无崖子','天龙八部','北冥神功','2023-06-06 19:56:54','2023-06-11 18:11:58',1),(18,'慕容博','天龙八部','斗转星移','2023-06-06 19:57:17','2023-06-11 18:11:58',1),(19,'林朝英','神雕侠侣','玉女心经','2023-06-06 19:57:48','2023-06-11 18:11:58',1),(20,'测试管理员','testAdministor',NULL,'2023-06-10 16:16:14','2023-06-11 18:11:58',1),(21,'1616管理员','1616',NULL,'2023-06-10 16:17:00','2023-06-11 18:11:58',1),(22,'1617管理员','1617',NULL,'2023-06-10 16:17:41','2023-06-11 18:11:58',1),(23,'1618管理员','1618',NULL,'2023-06-10 16:18:17','2023-06-11 18:11:58',1),(24,'456管理员','456',NULL,'2023-06-10 16:56:38','2023-06-11 18:11:58',1),(25,'曹操','dd',NULL,'2023-06-10 18:32:38','2023-06-11 18:11:58',1),(26,'dfdfdfd11','dfd11',NULL,'2023-06-10 18:32:50','2023-06-11 18:11:58',1),(27,'扽1','扽1',NULL,'2023-06-10 18:38:39','2023-06-11 18:11:58',1),(28,'测试222','测试2222',NULL,'2023-06-10 18:43:38','2023-06-11 18:11:58',1),(29,'超级管理员','001',NULL,'2023-06-12 08:26:15','2023-06-12 08:26:15',0),(30,'测试角色','test00',NULL,'2023-06-13 08:32:02','2023-06-15 10:32:08',1),(31,'学生','STUDENT',NULL,'2023-06-14 08:25:48','2023-09-07 01:53:15',0);
/*Table structure for table `sys_role_menu` */
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`role_id` bigint NOT NULL DEFAULT '0',
`menu_id` bigint NOT NULL DEFAULT '0',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=329 DEFAULT CHARSET=utf8mb3 COMMENT='角色菜单';
/*Data for the table `sys_role_menu` */
insert into `sys_role_menu`(`id`,`role_id`,`menu_id`,`create_time`,`update_time`,`is_deleted`) values (1,2,2,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(2,2,3,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(3,2,6,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(4,2,7,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(5,2,8,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(6,2,9,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(7,2,18,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(8,2,4,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(9,2,10,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(10,2,11,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(11,2,12,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(12,2,13,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(13,2,19,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(14,2,5,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(15,2,14,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(16,2,15,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(17,2,16,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(18,2,17,'2022-06-02 16:11:27','2022-06-02 16:16:10',1),(19,2,2,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(20,2,3,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(21,2,6,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(22,2,7,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(23,2,8,'2022-06-02 16:16:10','2022-06-09 09:26:34',1),(24,2,2,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(25,2,3,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(26,2,6,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(27,2,7,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(28,2,8,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(29,2,5,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(30,2,14,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(31,2,20,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(32,2,21,'2022-06-09 09:26:34','2023-06-13 18:20:31',1),(33,30,2,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(34,30,3,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(35,30,6,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(36,30,7,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(37,30,8,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(38,30,9,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(39,30,18,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(40,30,5,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(41,30,14,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(42,30,15,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(43,30,16,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(44,30,17,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(45,30,22,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(46,30,23,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(47,30,27,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(48,30,28,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(49,30,29,'2023-06-13 08:32:40','2023-06-13 08:32:53',1),(50,30,2,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(51,30,3,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(52,30,6,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(53,30,7,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(54,30,8,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(55,30,9,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(56,30,18,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(57,30,5,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(58,30,14,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(59,30,15,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(60,30,16,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(61,30,17,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(62,30,22,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(63,30,28,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(64,30,29,'2023-06-13 08:32:53','2023-06-15 10:31:49',1),(65,1,2,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(66,1,3,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(67,1,6,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(68,1,7,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(69,1,8,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(70,1,9,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(71,1,18,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(72,1,4,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(73,1,10,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(74,1,11,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(75,1,12,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(76,1,13,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(77,1,19,'2023-06-13 18:20:22','2023-09-10 16:08:53',1),(78,1,5,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(79,1,14,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(80,1,15,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(81,1,16,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(82,1,17,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(83,1,20,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(84,1,21,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(85,1,24,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(86,1,25,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(87,1,26,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(88,1,22,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(89,1,23,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(90,1,27,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(91,1,28,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(92,1,29,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(93,1,35,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(94,1,38,'2023-06-13 18:20:23','2023-09-10 16:08:53',1),(95,2,2,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(96,2,3,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(97,2,6,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(98,2,7,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(99,2,8,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(100,2,9,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(101,2,18,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(102,2,4,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(103,2,10,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(104,2,11,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(105,2,12,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(106,2,13,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(107,2,19,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(108,2,5,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(109,2,14,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(110,2,15,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(111,2,16,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(112,2,20,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(113,2,21,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(114,2,24,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(115,2,25,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(116,2,22,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(117,2,23,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(118,2,27,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(119,2,28,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(120,2,29,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(121,2,35,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(122,2,38,'2023-06-13 18:20:31','2023-06-13 18:20:31',0),(123,8,2,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(124,8,3,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(125,8,6,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(126,8,7,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(127,8,8,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(128,8,9,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(129,8,18,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(130,8,4,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(131,8,10,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(132,8,11,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(133,8,12,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(134,8,13,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(135,8,19,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(136,8,5,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(137,8,14,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(138,8,15,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(139,8,16,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(140,8,17,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(141,8,35,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(142,8,38,'2023-06-13 18:20:43','2023-06-13 18:20:43',0),(143,31,2,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(144,31,3,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(145,31,6,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(146,31,8,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(147,31,9,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(148,31,18,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(149,31,4,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(150,31,10,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(151,31,12,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(152,31,13,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(153,31,19,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(154,31,5,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(155,31,14,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(156,31,15,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(157,31,16,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(158,31,17,'2023-06-14 08:27:23','2023-06-14 21:11:49',1),(159,31,2,'2023-06-14 21:11:49','2023-06-14 21:17:25',1),(160,31,3,'2023-06-14 21:11:49','2023-06-14 21:17:25',1),(161,31,6,'2023-06-14 21:11:49','2023-06-14 21:17:25',1),(162,31,4,'2023-06-14 21:11:49','2023-06-14 21:17:25',1),(163,31,10,'2023-06-14 21:11:49','2023-06-14 21:17:25',1),(164,31,2,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(165,31,3,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(166,31,6,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(167,31,7,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(168,31,8,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(169,31,9,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(170,31,18,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(171,31,4,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(172,31,10,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(173,31,11,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(174,31,12,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(175,31,13,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(176,31,19,'2023-06-14 21:17:25','2023-06-15 10:32:16',1),(177,30,2,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(178,30,3,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(179,30,6,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(180,30,7,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(181,30,8,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(182,30,9,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(183,30,4,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(184,30,10,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(185,30,11,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(186,30,12,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(187,30,13,'2023-06-15 10:31:49','2023-06-15 10:31:49',0),(188,31,2,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(189,31,3,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(190,31,6,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(191,31,7,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(192,31,8,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(193,31,9,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(194,31,4,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(195,31,10,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(196,31,11,'2023-06-15 10:32:16','2023-06-15 10:38:28',1),(197,31,12,'2023-06-15 10:32:17','2023-06-15 10:38:28',1),(198,31,13,'2023-06-15 10:32:17','2023-06-15 10:38:28',1),(199,31,2,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(200,31,3,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(201,31,6,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(202,31,7,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(203,31,9,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(204,31,4,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(205,31,10,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(206,31,11,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(207,31,13,'2023-06-15 10:38:28','2023-06-15 10:45:17',1),(208,31,2,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(209,31,3,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(210,31,6,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(211,31,7,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(212,31,9,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(213,31,18,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(214,31,4,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(215,31,10,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(216,31,11,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(217,31,13,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(218,31,19,'2023-06-15 10:45:17','2023-06-15 10:57:53',1),(219,31,2,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(220,31,3,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(221,31,6,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(222,31,7,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(223,31,9,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(224,31,18,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(225,31,4,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(226,31,10,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(227,31,11,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(228,31,13,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(229,31,19,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(230,31,5,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(231,31,14,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(232,31,15,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(233,31,16,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(234,31,17,'2023-06-15 10:57:53','2023-06-15 10:58:44',1),(235,31,2,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(236,31,3,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(237,31,6,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(238,31,7,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(239,31,8,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(240,31,9,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(241,31,18,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(242,31,4,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(243,31,10,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(244,31,11,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(245,31,12,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(246,31,13,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(247,31,19,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(248,31,5,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(249,31,14,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(250,31,15,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(251,31,16,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(252,31,17,'2023-06-15 10:58:44','2023-06-15 19:11:38',1),(253,31,2,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(254,31,3,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(255,31,6,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(256,31,7,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(257,31,8,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(258,31,9,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(259,31,18,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(260,31,4,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(261,31,10,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(262,31,11,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(263,31,12,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(264,31,13,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(265,31,19,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(266,31,5,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(267,31,14,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(268,31,15,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(269,31,16,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(270,31,17,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(271,31,20,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(272,31,21,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(273,31,22,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(274,31,23,'2023-06-15 19:11:38','2023-09-07 01:55:12',1),(275,31,2,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(276,31,3,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(277,31,6,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(278,31,7,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(279,31,8,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(280,31,9,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(281,31,18,'2023-09-07 01:55:12','2023-09-07 14:00:08',1),(282,31,2,'2023-09-07 14:00:08','2023-09-11 02:05:39',1),(283,31,3,'2023-09-07 14:00:08','2023-09-11 02:05:39',1),(284,31,6,'2023-09-07 14:00:08','2023-09-11 02:05:39',1),(285,31,41,'2023-09-07 14:00:08','2023-09-11 02:05:39',1),(286,31,42,'2023-09-07 14:00:08','2023-09-11 02:05:39',1),(287,1,2,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(288,1,3,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(289,1,6,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(290,1,7,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(291,1,8,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(292,1,9,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(293,1,18,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(294,1,4,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(295,1,10,'2023-09-10 16:08:53','2023-09-10 16:08:53',0),(296,1,11,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(297,1,12,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(298,1,13,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(299,1,19,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(300,1,5,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(301,1,14,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(302,1,15,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(303,1,16,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(304,1,17,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(305,1,20,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(306,1,21,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(307,1,24,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(308,1,25,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(309,1,26,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(310,1,22,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(311,1,23,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(312,1,27,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(313,1,28,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(314,1,29,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(315,1,41,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(316,1,42,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(317,1,43,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(318,1,44,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(319,1,45,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(320,1,46,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(321,1,47,'2023-09-10 16:08:54','2023-09-10 16:08:54',0),(322,31,2,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(323,31,3,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(324,31,6,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(325,31,41,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(326,31,42,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(327,31,46,'2023-09-11 02:05:39','2023-09-11 02:05:39',0),(328,31,47,'2023-09-11 02:05:39','2023-09-11 02:05:39',0);
/*Table structure for table `sys_user` */
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '会员id',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`name` varchar(50) DEFAULT NULL COMMENT '姓名',
`phone` varchar(11) DEFAULT NULL COMMENT '手机',
`head_url` varchar(200) DEFAULT NULL COMMENT '头像地址',
`dept_id` bigint DEFAULT NULL COMMENT '部门id',
`post_id` bigint DEFAULT NULL COMMENT '岗位id',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`status` tinyint DEFAULT NULL COMMENT '状态（1：正常 0：停用）',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';
/*Data for the table `sys_user` */
insert into `sys_user`(`id`,`username`,`password`,`name`,`phone`,`head_url`,`dept_id`,`post_id`,`description`,`status`,`create_time`,`update_time`,`is_deleted`) values (1,'admin','e10adc3949ba59abbe56e057f20f883e','admin','0','https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif',1021,5,NULL,1,'2021-05-31 18:08:43','2023-09-07 15:16:43',0);
/*Table structure for table `sys_user_role` */
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
`role_id` bigint NOT NULL DEFAULT '0' COMMENT '角色id',
`user_id` bigint NOT NULL DEFAULT '0' COMMENT '用户id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_admin_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb3 COMMENT='用户角色';
/*Data for the table `sys_user_role` */
insert into `sys_user_role`(`id`,`role_id`,`user_id`,`create_time`,`update_time`,`is_deleted`) values (51,2,1,'2023-06-11 20:23:19','2023-06-12 18:11:36',1),(52,8,1,'2023-06-11 20:23:19','2023-06-12 18:11:36',1),(53,1,2,'2023-06-11 20:23:26','2023-06-12 18:11:19',1),(54,2,2,'2023-06-11 20:23:26','2023-06-12 18:11:19',1),(55,8,2,'2023-06-11 20:23:26','2023-06-12 18:11:19',1),(56,2,3,'2023-06-11 20:23:32','2023-06-12 18:11:22',1),(57,1,3,'2023-06-11 20:23:32','2023-06-12 18:11:22',1),(58,1,4,'2023-06-11 20:23:36','2023-06-12 18:11:26',1),(59,2,5,'2023-06-11 20:23:52','2023-06-11 20:23:52',0),(60,2,26,'2023-06-11 20:23:55','2023-06-11 20:23:55',0),(61,1,28,'2023-06-11 20:23:59','2023-06-11 20:23:59',0),(62,2,28,'2023-06-11 20:23:59','2023-06-11 20:23:59',0),(63,8,28,'2023-06-11 20:23:59','2023-06-11 20:23:59',0),(64,1,29,'2023-06-11 20:24:02','2023-06-11 20:24:02',0),(65,8,29,'2023-06-11 20:24:02','2023-06-11 20:24:02',0),(66,1,2,'2023-06-12 18:11:19','2023-09-07 01:54:59',1),(67,2,2,'2023-06-12 18:11:19','2023-09-07 01:54:59',1),(68,8,2,'2023-06-12 18:11:19','2023-09-07 01:54:59',1),(69,29,2,'2023-06-12 18:11:19','2023-09-07 01:54:59',1),(70,1,3,'2023-06-12 18:11:22','2023-06-12 18:11:22',0),(71,2,3,'2023-06-12 18:11:22','2023-06-12 18:11:22',0),(72,8,3,'2023-06-12 18:11:22','2023-06-12 18:11:22',0),(73,29,3,'2023-06-12 18:11:22','2023-06-12 18:11:22',0),(74,2,1,'2023-06-12 18:11:36','2023-06-12 18:11:36',0),(75,1,1,'2023-06-12 18:11:36','2023-06-12 18:11:36',0),(76,31,33,'2023-06-14 08:27:03','2023-06-14 08:27:03',0),(77,31,32,'2023-06-14 21:11:28','2023-06-15 10:56:15',1),(78,31,32,'2023-06-15 10:56:15','2023-06-15 10:56:47',1),(79,1,32,'2023-06-15 10:56:15','2023-06-15 10:56:47',1),(80,31,32,'2023-06-15 10:56:47','2023-06-15 10:57:35',1),(81,2,32,'2023-06-15 10:56:47','2023-06-15 10:57:35',1),(82,31,32,'2023-06-15 10:57:35','2023-06-15 10:57:35',0),(83,31,2,'2023-09-07 01:54:59','2023-09-07 01:54:59',0),(84,31,34,'2023-09-07 11:53:22','2023-09-07 11:53:22',0),(85,31,35,'2023-09-07 11:58:34','2023-09-07 11:58:34',0),(86,31,40,'2023-09-07 12:00:53','2023-09-07 12:00:53',0),(87,31,41,'2023-09-07 13:55:24','2023-09-07 13:55:24',0),(88,31,42,'2023-09-07 14:57:47','2023-09-07 14:57:47',0),(89,31,43,'2023-09-07 15:09:48','2023-09-07 15:09:48',0),(90,31,44,'2023-09-07 15:27:35','2023-09-07 15:27:35',0),(91,31,63,'2023-09-08 00:01:09','2023-09-08 00:01:09',0),(92,31,64,'2023-09-08 00:02:52','2023-09-08 00:02:52',0),(93,31,65,'2023-09-08 00:03:54','2023-09-08 00:03:54',0),(94,31,66,'2023-09-08 00:49:57','2023-09-08 00:49:57',0),(95,31,68,'2023-09-08 00:50:37','2023-09-08 00:50:37',0),(96,31,69,'2023-09-08 00:51:23','2023-09-08 00:51:23',0),(97,31,71,'2023-09-08 05:56:15','2023-09-08 05:56:15',0),(98,31,72,'2023-09-08 08:49:14','2023-09-08 08:49:14',0),(99,31,73,'2023-09-08 09:49:09','2023-09-08 09:49:09',0),(100,31,74,'2023-09-08 09:49:35','2023-09-08 09:49:35',0),(101,31,75,'2023-09-08 09:51:04','2023-09-08 09:51:04',0),(102,31,76,'2023-09-08 09:51:47','2023-09-08 09:51:47',0),(103,31,77,'2023-09-08 09:51:57','2023-09-08 09:51:57',0),(104,31,78,'2023-09-08 09:52:50','2023-09-08 09:52:50',0),(105,31,79,'2023-09-08 10:04:14','2023-09-08 10:04:14',0),(106,31,80,'2023-09-08 10:20:01','2023-09-08 10:20:01',0),(107,31,81,'2023-09-08 10:21:31','2023-09-08 10:21:31',0),(108,31,82,'2023-09-08 10:21:43','2023-09-08 10:21:43',0),(109,31,84,'2023-09-08 10:23:04','2023-09-08 10:23:04',0),(110,31,85,'2023-09-08 10:30:39','2023-09-08 10:30:39',0),(111,31,86,'2023-09-08 10:31:56','2023-09-08 10:31:56',0),(112,31,87,'2023-09-08 10:32:21','2023-09-08 10:32:21',0),(113,31,88,'2023-09-08 10:32:38','2023-09-08 10:32:38',0),(114,31,89,'2023-09-08 10:36:43','2023-09-08 10:36:43',0),(115,31,90,'2023-09-08 10:42:38','2023-09-08 10:42:38',0),(116,31,92,'2023-09-08 10:44:34','2023-09-08 10:44:34',0),(117,31,93,'2023-09-08 10:45:58','2023-09-08 10:45:58',0),(118,31,94,'2023-09-08 10:46:07','2023-09-08 10:46:07',0),(119,31,95,'2023-09-08 10:47:29','2023-09-08 10:47:29',0),(120,31,96,'2023-09-08 10:48:36','2023-09-08 10:48:36',0),(121,31,99,'2023-09-08 10:49:10','2023-09-08 10:49:10',0),(122,31,100,'2023-09-08 10:51:16','2023-09-08 10:51:16',0),(123,31,101,'2023-09-08 10:51:46','2023-09-08 10:51:46',0),(124,31,102,'2023-09-08 11:07:20','2023-09-08 11:07:20',0),(125,31,103,'2023-09-08 11:24:03','2023-09-08 11:24:03',0),(126,31,104,'2023-09-08 11:34:07','2023-09-08 11:34:07',0),(127,31,105,'2023-09-08 11:41:31','2023-09-08 11:41:31',0),(128,31,106,'2023-09-08 11:42:11','2023-09-08 11:42:11',0),(129,31,109,'2023-09-08 11:43:53','2023-09-08 11:43:53',0),(130,31,110,'2023-09-08 11:53:24','2023-09-08 11:53:24',0),(131,31,111,'2023-09-08 11:53:57','2023-09-08 11:53:57',0),(132,31,112,'2023-09-08 11:54:12','2023-09-08 11:54:12',0),(133,31,113,'2023-09-08 11:54:31','2023-09-08 11:54:31',0),(134,31,114,'2023-09-08 11:54:46','2023-09-08 11:54:46',0),(135,31,115,'2023-09-08 11:55:16','2023-09-08 11:55:16',0),(136,31,138,'2023-09-08 11:57:59','2023-09-08 11:57:59',0),(137,31,139,'2023-09-08 11:58:34','2023-09-08 11:58:34',0),(138,31,140,'2023-09-08 12:03:19','2023-09-08 12:03:19',0),(139,31,141,'2023-09-08 12:04:37','2023-09-08 12:04:37',0),(140,31,142,'2023-09-08 12:04:54','2023-09-08 12:04:54',0),(141,31,143,'2023-09-08 12:07:49','2023-09-08 12:07:49',0),(142,31,144,'2023-09-08 12:10:06','2023-09-08 12:10:06',0),(143,31,145,'2023-09-08 12:10:59','2023-09-08 12:10:59',0),(144,31,147,'2023-09-08 12:20:34','2023-09-08 12:20:34',0),(145,31,148,'2023-09-08 12:23:06','2023-09-08 12:23:06',0),(146,31,149,'2023-09-08 12:25:12','2023-09-08 12:25:12',0),(147,31,150,'2023-09-08 12:29:03','2023-09-08 12:29:03',0),(148,31,151,'2023-09-08 12:30:36','2023-09-08 12:30:36',0),(149,31,152,'2023-09-08 12:32:35','2023-09-08 12:32:35',0),(150,31,153,'2023-09-08 12:32:47','2023-09-08 12:32:47',0),(151,31,154,'2023-09-08 12:32:53','2023-09-08 12:32:53',0),(152,31,155,'2023-09-08 12:33:52','2023-09-08 12:33:52',0),(153,31,156,'2023-09-08 12:34:29','2023-09-08 12:34:29',0),(154,31,157,'2023-09-08 12:37:28','2023-09-08 12:37:28',0),(155,31,158,'2023-09-08 12:38:21','2023-09-08 12:38:21',0),(156,31,161,'2023-09-08 12:39:04','2023-09-08 12:39:04',0),(157,31,162,'2023-09-08 12:39:14','2023-09-08 12:39:14',0),(158,31,163,'2023-09-08 12:39:56','2023-09-08 12:39:56',0),(159,31,164,'2023-09-08 12:42:50','2023-09-08 12:42:50',0),(160,31,165,'2023-09-08 12:44:51','2023-09-08 12:44:51',0),(161,31,166,'2023-09-08 12:47:25','2023-09-08 12:47:25',0),(162,31,167,'2023-09-08 12:47:56','2023-09-08 12:47:56',0),(163,31,168,'2023-09-08 12:52:10','2023-09-08 12:52:10',0),(164,31,169,'2023-09-08 12:52:27','2023-09-08 12:52:27',0),(165,31,170,'2023-09-08 12:52:58','2023-09-08 12:52:58',0),(166,31,171,'2023-09-08 12:53:32','2023-09-08 12:53:32',0),(167,31,172,'2023-09-08 12:57:57','2023-09-08 12:57:57',0),(168,31,173,'2023-09-08 12:58:50','2023-09-08 12:58:50',0),(169,31,174,'2023-09-08 13:01:03','2023-09-08 13:01:03',0),(170,31,175,'2023-09-08 13:05:03','2023-09-08 13:05:03',0),(171,31,176,'2023-09-08 13:05:41','2023-09-08 13:05:41',0),(172,31,177,'2023-09-08 13:11:26','2023-09-08 13:11:26',0),(173,31,178,'2023-09-08 13:13:01','2023-09-08 13:13:01',0),(174,31,179,'2023-09-08 13:21:09','2023-09-08 13:21:09',0),(175,31,180,'2023-09-08 13:21:31','2023-09-08 13:21:31',0),(176,31,181,'2023-09-08 13:21:39','2023-09-08 13:21:39',0),(177,31,182,'2023-09-09 00:27:33','2023-09-09 00:27:33',0),(178,31,184,'2023-09-10 09:50:38','2023-09-10 09:50:38',0),(179,31,185,'2023-09-10 12:45:05','2023-09-10 12:45:05',0);
/*Table structure for table `user_images` */
DROP TABLE IF EXISTS `user_images`;
CREATE TABLE `user_images` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '图片id',
`user_id` bigint NOT NULL COMMENT '用户id',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户的姓名',
`image_name` varchar(50) DEFAULT NULL COMMENT '图片的名称',
`url` varchar(200) DEFAULT NULL COMMENT '头像地址',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';
/*Data for the table `user_images` */
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;