-
Notifications
You must be signed in to change notification settings - Fork 24
Expand file tree
/
Copy pathspba.sql
More file actions
180 lines (166 loc) · 15 KB
/
spba.sql
File metadata and controls
180 lines (166 loc) · 15 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
/*
Navicat MySQL Data Transfer
Date: 2022-01-03 21:09:06
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`password` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色',
`avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像地址',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '帐号状态（0停用 1正常）',
`safe` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '加密随机码',
`login_ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '最后登录IP',
`login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='管理员表';
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '2fe768c4abef3b434ab7209f535f58b5', '[1]', '', '1', 'NdSr', '127.0.0.1', '2022-01-03 17:27:26', '2022-01-03 17:27:26', '2020-01-03 17:05:00');
INSERT INTO `admin` VALUES ('2', 'style', '9d9ee979435c6ee8499f75a9abd711b0', '[2]', '', '1', 'lnNk', '127.0.0.1', '2022-01-03 17:19:29', '2022-01-03 17:19:29', '2020-01-03 17:08:00');
-- ----------------------------
-- Table structure for error_log
-- ----------------------------
DROP TABLE IF EXISTS `error_log`;
CREATE TABLE `error_log` (
`id` int NOT NULL AUTO_INCREMENT,
`url` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求路由',
`method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求方式',
`params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '请求参数',
`message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '错误信息',
`exception` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '错误类型',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='错误日志表';
-- ----------------------------
-- Records of error_log
-- ----------------------------
INSERT INTO `error_log` VALUES ('1', '/spba/admin', 'PUT', '{\"role_arr[0]\":[\"4\"],\"status_name\":[\"true\"],\"role_ids\":[\"4,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:08:14');
INSERT INTO `error_log` VALUES ('2', '/spba/admin', 'PUT', '{\"role_arr[0]\":[\"4\"],\"status_name\":[\"true\"],\"role_ids\":[\"4,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:08:15');
INSERT INTO `error_log` VALUES ('3', '/spba/admin', 'PUT', '{\"status_name\":[\"true\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:08:22');
INSERT INTO `error_log` VALUES ('4', '/spba/admin', 'PUT', '{\"status_name\":[\"true\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:08:37');
INSERT INTO `error_log` VALUES ('5', '/spba/admin', 'PUT', '{\"status_name\":[\"true\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:09:23');
INSERT INTO `error_log` VALUES ('6', '/spba/admin', 'PUT', '{\"role_arr[0]\":[\"4\"],\"status_name\":[\"true\"],\"role_ids\":[\"4,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:11:42');
INSERT INTO `error_log` VALUES ('7', '/spba/admin', 'PUT', '{\"status_name\":[\"false\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"0\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:11:47');
INSERT INTO `error_log` VALUES ('8', '/spba/admin', 'PUT', '{\"status_name\":[\"false\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"0\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:11:48');
INSERT INTO `error_log` VALUES ('9', '/spba/admin', 'PUT', '{\"status_name\":[\"true\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:13:27');
INSERT INTO `error_log` VALUES ('10', '/spba/admin', 'PUT', '{\"status_name\":[\"true\"],\"role_arr[0][0]\":[\"2\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', null, 'class java.lang.NullPointerException', '2022-01-03 17:16:12');
INSERT INTO `error_log` VALUES ('11', '/spba/menu', 'GET', '{}', 'Request method \'GET\' not supported', 'class org.springframework.web.HttpRequestMethodNotSupportedException', '2022-01-03 17:20:53');
-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
`id` int NOT NULL AUTO_INCREMENT,
`admin_id` int NOT NULL DEFAULT '0',
`login_ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='管理员登录日志表';
-- ----------------------------
-- Records of login_log
-- ----------------------------
INSERT INTO `login_log` VALUES ('1', '1', '127.0.0.1', '2022-01-03 17:07:19');
INSERT INTO `login_log` VALUES ('2', '1', '127.0.0.1', '2022-01-03 17:15:02');
INSERT INTO `login_log` VALUES ('3', '1', '127.0.0.1', '2022-01-03 17:15:19');
INSERT INTO `login_log` VALUES ('4', '1', '127.0.0.1', '2022-01-03 17:18:17');
INSERT INTO `login_log` VALUES ('5', '2', '127.0.0.1', '2022-01-03 17:19:29');
INSERT INTO `login_log` VALUES ('6', '1', '127.0.0.1', '2022-01-03 17:21:09');
INSERT INTO `login_log` VALUES ('7', '1', '127.0.0.1', '2022-01-03 17:27:26');
-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
`parent_id` int NOT NULL DEFAULT '0' COMMENT '父菜单ID',
`type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
`path` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '组件路径',
`perms` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '权限标识',
`icon` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '菜单图标',
`sort` int NOT NULL DEFAULT '0' COMMENT '显示顺序',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '菜单状态（0停用 1正常 ）',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';
-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '系统', '0', 'M', '', '', 'el-icon-s-tools', '0', '1', '2022-01-03 17:15:34', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('2', '首页', '1', 'C', 'home', 'home', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('3', '管理员', '1', 'C', 'admin', 'admin:list', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('4', '管理员查询', '3', 'F', '', 'admin:query', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('5', '管理员新增', '3', 'F', '', 'admin:add', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('6', '管理员编辑', '3', 'F', '', 'admin:edit', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('7', '管理员删除', '3', 'F', '', 'admin:del', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('8', '角色管理', '1', 'C', 'role', 'role:list', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('9', '查询角色', '8', 'F', '', 'role:query', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('10', '新增角色', '8', 'F', '', 'role:add', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('11', '编辑角色', '8', 'F', '', 'role:edit', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('12', '删除角色', '8', 'F', '', 'role:del', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('13', '菜单管理', '1', 'C', 'menus', 'menu:list', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('14', '菜单查询', '13', 'F', '', 'menu:query', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('15', '新增菜单', '13', 'F', '', 'menu:add', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('16', '编辑菜单', '13', 'F', '', 'menu:edit', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('17', '删除菜单', '13', 'F', '', 'menu:del', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('18', '日志', '0', 'M', '', '', 'el-icon-s-order', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('19', '操作日志', '18', 'C', 'operatelog', 'operation:log', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('20', '登录日志', '18', 'C', 'loginlog', 'login:log', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('21', '错误日志', '18', 'C', 'errorlog', 'error:log', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('22', '组件', '0', 'M', '', '', 'el-icon-menu', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('23', '剪切板', '22', 'C', 'clipboard', 'clipboard', '', '1', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('24', '上传视频', '22', 'C', 'uploadvideo', 'upload:video', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `menu` VALUES ('25', '导出Excel', '22', 'C', 'export', 'export', '', '0', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
-- ----------------------------
-- Table structure for operate_log
-- ----------------------------
DROP TABLE IF EXISTS `operate_log`;
CREATE TABLE `operate_log` (
`id` int NOT NULL AUTO_INCREMENT,
`admin_id` int NOT NULL DEFAULT '0' COMMENT '管理员ID',
`username` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员名称',
`url` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求路由',
`method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求方式',
`params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求参数',
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志表';
-- ----------------------------
-- Records of operate_log
-- ----------------------------
INSERT INTO `operate_log` VALUES ('1', '1', 'admin', '/spba/role', 'PUT', '{}', '127.0.0.1', '2022-01-03 17:07:29');
INSERT INTO `operate_log` VALUES ('2', '1', 'admin', '/spba/role', 'PUT', '{}', '127.0.0.1', '2022-01-03 17:15:30');
INSERT INTO `operate_log` VALUES ('3', '1', 'admin', '/spba/menu', 'PUT', '{\"status_name\":[\"true\"],\"icon\":[\"el-icon-s-tools\"],\"sort\":[\"0\"],\"type\":[\"M\"],\"path\":[\"\"],\"parent_id\":[\"0\"],\"name\":[\"系统\"],\"perms\":[\"\"],\"id\":[\"1\"],\"status\":[\"1\"]}', '127.0.0.1', '2022-01-03 17:15:34');
INSERT INTO `operate_log` VALUES ('4', '1', 'admin', '/spba/admin', 'PUT', '{\"role_arr[0]\":[\"2\"],\"status_name\":[\"true\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', '127.0.0.1', '2022-01-03 17:16:35');
INSERT INTO `operate_log` VALUES ('5', '1', 'admin', '/spba/admin', 'PUT', '{\"role_arr[0]\":[\"2\"],\"status_name\":[\"true\"],\"role_ids\":[\"2,\"],\"password\":[\"\"],\"id\":[\"2\"],\"username\":[\"style\"],\"status\":[\"1\"]}', '127.0.0.1', '2022-01-03 17:16:55');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
`permission` json NOT NULL COMMENT '权限集合',
`root` tinyint NOT NULL DEFAULT '0' COMMENT '超级管理员（0否 1是）',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '角色状态（0停用 1正常）',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='角色表';
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '超级管理员', '[0]', '1', '1', '2020-01-03 17:05:00', '2020-01-03 17:05:00');
INSERT INTO `role` VALUES ('2', '技术', '[2, 5, 6, 11, 12, 1, 3, 8]', '0', '1', '2022-01-03 17:15:30', '2020-01-03 17:07:29');