/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : school

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

 Date: 20/05/2023 00:14:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_class
-- ----------------------------
DROP TABLE IF EXISTS `tb_class`;
CREATE TABLE `tb_class`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `teacher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `expense` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_class
-- ----------------------------
INSERT INTO `tb_class` VALUES (1, '篮球一班', '汪志超', '1500');
INSERT INTO `tb_class` VALUES (2, '书法一班', '胡英姿', '1500');
INSERT INTO `tb_class` VALUES (3, '编程一班', '王美玲', '2000');
INSERT INTO `tb_class` VALUES (4, '羽毛球一班', '瞿萌', '1100');
INSERT INTO `tb_class` VALUES (5, '篮球二班', '舒丽伟', '1000');
INSERT INTO `tb_class` VALUES (6, '排球一班', '熊湘', '1200');

-- ----------------------------
-- Table structure for tb_course
-- ----------------------------
DROP TABLE IF EXISTS `tb_course`;
CREATE TABLE `tb_course`  (
  `id` int(0) NOT NULL,
  `one` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `three` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `four` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `five` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `six` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `seven` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  `eight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_course
-- ----------------------------
INSERT INTO `tb_course` VALUES (1, '篮球', '画画', '书法', '', '编程', '', '', '');
INSERT INTO `tb_course` VALUES (2, '羽毛球', '歌唱', '', '书法', '', '', '', '');
INSERT INTO `tb_course` VALUES (3, '绘画', '', '', '', '', '', '', '');
INSERT INTO `tb_course` VALUES (4, '', '', '羽毛球', '', '', '', '', '');
INSERT INTO `tb_course` VALUES (5, '', 'sadasd', '', '', '', '', '', '');
INSERT INTO `tb_course` VALUES (6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tb_course` VALUES (7, '', '', '', '', '', '', '', '积木');

-- ----------------------------
-- Table structure for tb_permission
-- ----------------------------
DROP TABLE IF EXISTS `tb_permission`;
CREATE TABLE `tb_permission`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `parent_id` int(0) NOT NULL DEFAULT 0,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `type` int(0) NOT NULL DEFAULT 0 COMMENT '类型， 0：目录  1：菜单  2：按钮',
  `path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '组价路径',
  `perms` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `status` int(0) DEFAULT NULL,
  `sort_value` int(0) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_permission
-- ----------------------------
INSERT INTO `tb_permission` VALUES (1, 0, '系统管理', 0, 'system', 'Layout', NULL, 'el-icon-s-tools', 1, 1);
INSERT INTO `tb_permission` VALUES (3, 1, '用户管理', 1, 'user', 'system/user/index', '', 'el-icon-s-custom', 1, 1);
INSERT INTO `tb_permission` VALUES (4, 1, '角色管理', 1, 'role', 'system/role/index', '', 'el-icon-user-solid', 1, 2);
INSERT INTO `tb_permission` VALUES (5, 1, '菜单管理', 1, 'menu', 'system/menu/index', '', 'el-icon-s-unfold', 1, 3);
INSERT INTO `tb_permission` VALUES (6, 3, '查看', 2, NULL, NULL, 'bnt.sysUser.list', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (7, 3, '添加', 2, NULL, NULL, 'bnt.sysUser.add', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (8, 3, '修改', 2, NULL, NULL, 'bnt.sysUser.update', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (9, 3, '删除', 2, NULL, NULL, 'bnt.sysUser.remove', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (10, 4, '查看', 2, NULL, NULL, 'bnt.sysRole.list', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (11, 4, '添加', 2, NULL, NULL, 'bnt.sysRole.add', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (12, 4, '修改', 2, NULL, NULL, 'bnt.sysRole.update', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (13, 4, '删除', 2, NULL, NULL, 'bnt.sysRole.remove', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (14, 5, '查看', 2, NULL, NULL, 'bnt.sysMenu.list', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (15, 5, '添加', 2, NULL, NULL, 'bnt.sysMenu.add', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (16, 5, '修改', 2, NULL, NULL, 'bnt.sysMenu.update', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (17, 5, '删除', 2, NULL, NULL, 'bnt.sysMenu.remove', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (18, 3, '分配角色', 2, NULL, NULL, 'bnt.sysUser.assignRole', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (19, 4, '分配权限', 2, 'assignAuth', 'system/role/assignAuth', 'bnt.sysRole.assignAuth', NULL, 1, 1);
INSERT INTO `tb_permission` VALUES (36, 1, '学生管理', 1, 'student', 'system/student/index', NULL, 'el-icon-s-finance', 1, 4);
INSERT INTO `tb_permission` VALUES (37, 1, '教师管理', 1, 'teacher', 'system/teacher/index', NULL, 'el-icon-s-check', 1, 5);
INSERT INTO `tb_permission` VALUES (38, 1, '课表管理', 1, 'schedule', 'system/schedule/index', NULL, 'el-icon-s-check', 1, 6);
INSERT INTO `tb_permission` VALUES (39, 36, '查看', 2, '', '', 'bnt.sysStu.list', '', 1, 1);
INSERT INTO `tb_permission` VALUES (40, 36, '添加', 2, '', '', 'bnt.sysStu.add', '', 1, 1);
INSERT INTO `tb_permission` VALUES (41, 36, '修改', 2, '', '', 'bnt.sysStu.update', '', 1, 1);
INSERT INTO `tb_permission` VALUES (42, 36, '删除', 2, '', '', 'bnt.sysStu.remove', '', 1, 1);
INSERT INTO `tb_permission` VALUES (43, 37, '查看', 2, '', '', 'bnt.sysTea.list', '', 1, 1);
INSERT INTO `tb_permission` VALUES (44, 37, '添加', 2, '', '', 'bnt.sysTea.add', '', 1, 1);
INSERT INTO `tb_permission` VALUES (45, 37, '修改', 2, '', '', 'bnt.sysTea.update', '', 1, 1);
INSERT INTO `tb_permission` VALUES (46, 37, '删除', 2, '', '', 'bnt.sysTea.remove', '', 1, 1);
INSERT INTO `tb_permission` VALUES (47, 38, '修改', 2, '', '', 'bnt.sysCourse.update', '', 1, 1);
INSERT INTO `tb_permission` VALUES (48, 38, '查看', 2, '', '', 'bnt.sysCourse.list', '', 1, 1);
INSERT INTO `tb_permission` VALUES (49, 36, '搜索', 2, '', '', 'bnt.sysStu.search', '', 1, 1);
INSERT INTO `tb_permission` VALUES (53, 1, '班级管理', 1, 'sclass', 'system/sclass/index', '', 'el-icon-more-outline', 1, 7);
INSERT INTO `tb_permission` VALUES (54, 53, '查看', 2, '', '', 'bnt.sysSclass.remove', '', 1, 1);
INSERT INTO `tb_permission` VALUES (55, 53, '修改', 2, '', '', 'bnt.sysSclass.update', '', 1, 1);
INSERT INTO `tb_permission` VALUES (56, 53, '删除', 2, '', '', 'bnt.sysSclass.remove', '', 1, 1);
INSERT INTO `tb_permission` VALUES (57, 53, '添加', 2, '', '', 'bnt.sysSclass.add', '', 1, 1);
INSERT INTO `tb_permission` VALUES (58, 53, '搜索', 2, '', '', 'bnt.sysSclass.search', '', 1, 1);

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `role_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_name`(`role_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES (1, '超级管理员', 'admin');
INSERT INTO `tb_role` VALUES (3, '助教', 'supteacher');
INSERT INTO `tb_role` VALUES (5, '学生', 'student');
INSERT INTO `tb_role` VALUES (25, '辅导员', 'aider');
INSERT INTO `tb_role` VALUES (26, '老师', 'teacher');
INSERT INTO `tb_role` VALUES (27, '家长', 'parent');

-- ----------------------------
-- Table structure for tb_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_permission`;
CREATE TABLE `tb_role_permission`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `permission_id` int(0) NOT NULL,
  `role_id` int(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `permission_id`(`permission_id`, `role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 190 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_role_permission
-- ----------------------------
INSERT INTO `tb_role_permission` VALUES (113, 1, 1);
INSERT INTO `tb_role_permission` VALUES (172, 1, 26);
INSERT INTO `tb_role_permission` VALUES (74, 1, 27);
INSERT INTO `tb_role_permission` VALUES (23, 1, 29);
INSERT INTO `tb_role_permission` VALUES (2, 2, 2);
INSERT INTO `tb_role_permission` VALUES (9, 2, 28);
INSERT INTO `tb_role_permission` VALUES (114, 3, 1);
INSERT INTO `tb_role_permission` VALUES (3, 3, 3);
INSERT INTO `tb_role_permission` VALUES (10, 3, 28);
INSERT INTO `tb_role_permission` VALUES (120, 4, 1);
INSERT INTO `tb_role_permission` VALUES (24, 4, 29);
INSERT INTO `tb_role_permission` VALUES (126, 5, 1);
INSERT INTO `tb_role_permission` VALUES (115, 6, 1);
INSERT INTO `tb_role_permission` VALUES (11, 6, 28);
INSERT INTO `tb_role_permission` VALUES (116, 7, 1);
INSERT INTO `tb_role_permission` VALUES (12, 7, 28);
INSERT INTO `tb_role_permission` VALUES (117, 8, 1);
INSERT INTO `tb_role_permission` VALUES (13, 8, 28);
INSERT INTO `tb_role_permission` VALUES (118, 9, 1);
INSERT INTO `tb_role_permission` VALUES (14, 9, 28);
INSERT INTO `tb_role_permission` VALUES (121, 10, 1);
INSERT INTO `tb_role_permission` VALUES (25, 10, 29);
INSERT INTO `tb_role_permission` VALUES (122, 11, 1);
INSERT INTO `tb_role_permission` VALUES (26, 11, 29);
INSERT INTO `tb_role_permission` VALUES (123, 12, 1);
INSERT INTO `tb_role_permission` VALUES (27, 12, 29);
INSERT INTO `tb_role_permission` VALUES (124, 13, 1);
INSERT INTO `tb_role_permission` VALUES (127, 14, 1);
INSERT INTO `tb_role_permission` VALUES (128, 15, 1);
INSERT INTO `tb_role_permission` VALUES (129, 16, 1);
INSERT INTO `tb_role_permission` VALUES (130, 17, 1);
INSERT INTO `tb_role_permission` VALUES (119, 18, 1);
INSERT INTO `tb_role_permission` VALUES (15, 18, 28);
INSERT INTO `tb_role_permission` VALUES (125, 19, 1);
INSERT INTO `tb_role_permission` VALUES (28, 19, 29);
INSERT INTO `tb_role_permission` VALUES (131, 36, 1);
INSERT INTO `tb_role_permission` VALUES (173, 36, 26);
INSERT INTO `tb_role_permission` VALUES (75, 36, 27);
INSERT INTO `tb_role_permission` VALUES (137, 37, 1);
INSERT INTO `tb_role_permission` VALUES (179, 37, 26);
INSERT INTO `tb_role_permission` VALUES (77, 37, 27);
INSERT INTO `tb_role_permission` VALUES (142, 38, 1);
INSERT INTO `tb_role_permission` VALUES (181, 38, 26);
INSERT INTO `tb_role_permission` VALUES (79, 38, 27);
INSERT INTO `tb_role_permission` VALUES (132, 39, 1);
INSERT INTO `tb_role_permission` VALUES (174, 39, 26);
INSERT INTO `tb_role_permission` VALUES (76, 39, 27);
INSERT INTO `tb_role_permission` VALUES (133, 40, 1);
INSERT INTO `tb_role_permission` VALUES (175, 40, 26);
INSERT INTO `tb_role_permission` VALUES (134, 41, 1);
INSERT INTO `tb_role_permission` VALUES (176, 41, 26);
INSERT INTO `tb_role_permission` VALUES (135, 42, 1);
INSERT INTO `tb_role_permission` VALUES (177, 42, 26);
INSERT INTO `tb_role_permission` VALUES (138, 43, 1);
INSERT INTO `tb_role_permission` VALUES (180, 43, 26);
INSERT INTO `tb_role_permission` VALUES (78, 43, 27);
INSERT INTO `tb_role_permission` VALUES (139, 44, 1);
INSERT INTO `tb_role_permission` VALUES (140, 45, 1);
INSERT INTO `tb_role_permission` VALUES (141, 46, 1);
INSERT INTO `tb_role_permission` VALUES (143, 47, 1);
INSERT INTO `tb_role_permission` VALUES (182, 47, 26);
INSERT INTO `tb_role_permission` VALUES (144, 48, 1);
INSERT INTO `tb_role_permission` VALUES (183, 48, 26);
INSERT INTO `tb_role_permission` VALUES (80, 48, 27);
INSERT INTO `tb_role_permission` VALUES (136, 49, 1);
INSERT INTO `tb_role_permission` VALUES (178, 49, 26);
INSERT INTO `tb_role_permission` VALUES (145, 53, 1);
INSERT INTO `tb_role_permission` VALUES (184, 53, 26);
INSERT INTO `tb_role_permission` VALUES (146, 54, 1);
INSERT INTO `tb_role_permission` VALUES (185, 54, 26);
INSERT INTO `tb_role_permission` VALUES (147, 55, 1);
INSERT INTO `tb_role_permission` VALUES (186, 55, 26);
INSERT INTO `tb_role_permission` VALUES (148, 56, 1);
INSERT INTO `tb_role_permission` VALUES (187, 56, 26);
INSERT INTO `tb_role_permission` VALUES (149, 57, 1);
INSERT INTO `tb_role_permission` VALUES (188, 57, 26);
INSERT INTO `tb_role_permission` VALUES (150, 58, 1);
INSERT INTO `tb_role_permission` VALUES (189, 58, 26);

-- ----------------------------
-- Table structure for tb_student
-- ----------------------------
DROP TABLE IF EXISTS `tb_student`;
CREATE TABLE `tb_student`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `age` int(0) NOT NULL,
  `school` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `sclass` int(0) DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_student
-- ----------------------------
INSERT INTO `tb_student` VALUES (2, '段柯', 17, '怀化一中', '学府花园', '男', 1, '15273839857');
INSERT INTO `tb_student` VALUES (3, '周希', 14, '怀化一中', '北岸花园', '女', 2, '15273839856');
INSERT INTO `tb_student` VALUES (4, '周磊', 16, '铁路一中', '车务段家属区', '女', 2, '15273839566');
INSERT INTO `tb_student` VALUES (5, '杨涵', 14, '怀化三中', '岳麓欧城', '女', 3, '13707462983');
INSERT INTO `tb_student` VALUES (6, '贺晨鸣', 15, '怀化三中', '学林雅苑', '男', 4, '17399482887');
INSERT INTO `tb_student` VALUES (7, '杨鸿飞', 17, '怀化三中', '城市中央', '男', 2, '16283627299');
INSERT INTO `tb_student` VALUES (8, '开心瑞', 17, '怀化三中', '河西天花', '女', 2, '17348992744');
INSERT INTO `tb_student` VALUES (9, '杨巧霞', 15, '怀化三中', '鲁班雅苑', '女', 4, ' 14311673457');
INSERT INTO `tb_student` VALUES (10, '潘雅葵', 13, '怀化三中', '学府花园', '女', 4, '18313741933');
INSERT INTO `tb_student` VALUES (11, '王舒豪', 14, '怀化一中', '车务段家属区', '男', 2, '19311833277');
INSERT INTO `tb_student` VALUES (12, '吴泽峰', 15, '铁路一中', '城市中央', '男', 4, '17422733892');

-- ----------------------------
-- Table structure for tb_teacher
-- ----------------------------
DROP TABLE IF EXISTS `tb_teacher`;
CREATE TABLE `tb_teacher`  (
  `teaid` int(0) NOT NULL AUTO_INCREMENT,
  `teaname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `teasex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `teaage` int(0) DEFAULT NULL,
  `ptitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '老师',
  `teaproject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`teaid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_teacher
-- ----------------------------
INSERT INTO `tb_teacher` VALUES (1, '王华中化', '男', 18, '老师', 'C语言');
INSERT INTO `tb_teacher` VALUES (2, '催哈啊', '女', 48, '助教', 'java');
INSERT INTO `tb_teacher` VALUES (3, '萨达', '男', 48, '老师', '化学');
INSERT INTO `tb_teacher` VALUES (4, '杨秋萍', '女', 56, '助教', '化学');
INSERT INTO `tb_teacher` VALUES (5, '王美玲', '女', 27, '助教', 'Python');
INSERT INTO `tb_teacher` VALUES (6, '侯永利', '女', 58, '老师', '数据库');
INSERT INTO `tb_teacher` VALUES (7, '王天龙', '男', 56, '老师', '网络安全');
INSERT INTO `tb_teacher` VALUES (8, '李面请', '男', 65, '老师', '大前端vue');
INSERT INTO `tb_teacher` VALUES (9, '付海平', '男', 63, '老师', '智能技术');
INSERT INTO `tb_teacher` VALUES (10, '王海义', '男', 45, '老师', '大数据');
INSERT INTO `tb_teacher` VALUES (12, '美恋依', '女', 24, '助教', '社会实践');
INSERT INTO `tb_teacher` VALUES (13, '易凯平', '男', 25, '老师', '社会实践');
INSERT INTO `tb_teacher` VALUES (14, '开心瑞', '女', 22, '老师', '美术');
INSERT INTO `tb_teacher` VALUES (16, '姜承録', '男', 24, '老师', '英雄联盟');
INSERT INTO `tb_teacher` VALUES (19, '周东东', '男', 47, '老师', '密码学');
INSERT INTO `tb_teacher` VALUES (20, '王舒瑶', '女', 23, '助教', 'Java');

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '七个1',
  `realname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` tinyint(0) DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES (1, 'admin', '7fa8282ad93047a4d6fe6111c93b308a', '管理员', '15211571988', 1);
INSERT INTO `tb_user` VALUES (28, 'wenyi', 'e10adc3949ba59abbe56e057f20f883e', '文艺', '15211571988', 1);

-- ----------------------------
-- Table structure for tb_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_role`;
CREATE TABLE `tb_user_role`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '角色id',
  `user_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_admin_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_user_role
-- ----------------------------
INSERT INTO `tb_user_role` VALUES (1, 1, 1);
INSERT INTO `tb_user_role` VALUES (16, 29, 25);
INSERT INTO `tb_user_role` VALUES (17, 27, 26);
INSERT INTO `tb_user_role` VALUES (18, 26, 28);

SET FOREIGN_KEY_CHECKS = 1;