spring-boot-redis-shiro-jwt
/
base.sql

/*
Navicat MySQL Data Transfer

Source Server         : VIP
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : test

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

Date: 2021-05-29 14:33:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_logger_online`
-- ----------------------------
DROP TABLE IF EXISTS `t_logger_online`;
CREATE TABLE `t_logger_online` (
  `id` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `username` varchar(50) DEFAULT NULL COMMENT '用户',
  `type` varchar(10) DEFAULT NULL COMMENT '登录或退出',
  `device` varchar(50) DEFAULT NULL COMMENT '设备',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP',
  `log_time` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='登录日志';

-- ----------------------------
-- Records of t_logger_online
-- ----------------------------

-- ----------------------------
-- Table structure for `t_logger_operation`
-- ----------------------------
DROP TABLE IF EXISTS `t_logger_operation`;
CREATE TABLE `t_logger_operation` (
  `id` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `username` varchar(50) DEFAULT NULL COMMENT '用户',
  `log_desc` varchar(100) DEFAULT NULL COMMENT '类型',
  `method` varchar(512) DEFAULT NULL COMMENT '方法名',
  `params` text COMMENT '参数',
  `exception_name` varchar(512) DEFAULT NULL COMMENT '异常代码',
  `exception_message` text COMMENT '异常信息',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP',
  `log_time` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='操作日志';

-- ----------------------------
-- Records of t_logger_operation
-- ----------------------------

-- ----------------------------
-- Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` varchar(50) NOT NULL COMMENT 'ID',
  `title` varchar(50) DEFAULT NULL COMMENT '标题',
  `url` varchar(50) DEFAULT NULL COMMENT '路由',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `parent_id` varchar(50) DEFAULT NULL COMMENT '父ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES ('1', '系统管理', null, 'el-icon-setting', '8', null);
INSERT INTO `t_menu` VALUES ('1253575302598909953', '账户列表', '/users', null, '1', '1');
INSERT INTO `t_menu` VALUES ('1389749066133757954', '角色列表', '/roles', null, '3', '1');
INSERT INTO `t_menu` VALUES ('1389751610566307841', '权限列表', '/permissions', null, '5', '1');
INSERT INTO `t_menu` VALUES ('1389797488152825858', '首页', '/index', 'el-icon-s-grid', '1', null);
INSERT INTO `t_menu` VALUES ('1398493199283281922', '日志管理', '', 'el-icon-setting', '9', null);
INSERT INTO `t_menu` VALUES ('1398493265205157890', '登录登出', '/onlines', null, '2', '1398493199283281922');
INSERT INTO `t_menu` VALUES ('1398497496565895169', '操作日志', '/operations', null, '3', '1398493199283281922');
INSERT INTO `t_menu` VALUES ('2', '菜单列表', '/menus', null, '2', '1');

-- ----------------------------
-- Table structure for `t_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT '权限名称',
  `code` varchar(255) DEFAULT NULL COMMENT '权限码',
  `introduce` varchar(255) DEFAULT NULL COMMENT '权限介绍',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of t_permission
-- ----------------------------
INSERT INTO `t_permission` VALUES ('1389751845862567938', '23146111', '3216411', '231435111');

-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `code` varchar(255) DEFAULT NULL COMMENT '角色码',
  `introduce` varchar(255) DEFAULT NULL COMMENT '角色介绍',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1389756175042801665', '63634', '535', '53643');

-- ----------------------------
-- Table structure for `t_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色ID',
  `menu_id` varchar(255) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单关联表';

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
INSERT INTO `t_role_menu` VALUES ('1389775748634816513', '1389756175042801665', '1387227187019841537');
INSERT INTO `t_role_menu` VALUES ('1389775748634816514', '1389756175042801665', '1253575302598909953');
INSERT INTO `t_role_menu` VALUES ('1389775748634816515', '1389756175042801665', '1389749066133757954');
INSERT INTO `t_role_menu` VALUES ('1389775748634816516', '1389756175042801665', '1389775545513062402');

-- ----------------------------
-- Table structure for `t_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色ID',
  `permission_id` varchar(255) DEFAULT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限关联表';

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
INSERT INTO `t_role_permission` VALUES ('1389775748634816517', '1389756175042801665', '1389751845862567938');

-- ----------------------------
-- Table structure for `t_transaction`
-- ----------------------------
DROP TABLE IF EXISTS `t_transaction`;
CREATE TABLE `t_transaction` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户ID',
  `pay_type` int(11) DEFAULT NULL COMMENT '支付类型',
  `transaction_no` varchar(255) DEFAULT NULL COMMENT '支付订单号',
  `out_trade_no` varchar(255) DEFAULT NULL COMMENT '商户订单号',
  `total_amount` varchar(255) DEFAULT NULL COMMENT '全部金额',
  `status` int(11) DEFAULT NULL COMMENT '交易状态（发起交易、取消交易、交易成功、发起退款、驳回退款、退款成功）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `refund_time` datetime DEFAULT NULL COMMENT '退款时间',
  `reason` varchar(255) DEFAULT NULL COMMENT '原因（退款、拒绝退款）',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='交易表';

-- ----------------------------
-- Records of t_transaction
-- ----------------------------

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `salt` varchar(255) DEFAULT NULL COMMENT '盐',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1386623828965511169', 'admin', '1f2c6c8ee4eb014325d211c5ac8d9145', 'tovee', '2021-05-05 08:46:49', '2021-05-05 08:46:51');
INSERT INTO `t_user` VALUES ('1398511046596288514', '111111', '0c620718882834b57f66c8fab3189272', 'c1w1d', '2021-05-29 13:26:31', '2021-05-29 13:26:31');

-- ----------------------------
-- Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` varchar(255) NOT NULL COMMENT 'ID',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户ID',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES ('1', '1386623828965511169', '1389756175042801665');
INSERT INTO `t_user_role` VALUES ('1398511046621454337', '1398511046596288514', '1389756175042801665');