yvjia/db/sys_log.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2024/12/28 16:37:00
*/

DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `username` VARCHAR(255) COMMENT '用户名',
    `action` VARCHAR(255) COMMENT '用户操作',
    `classname` VARCHAR(255) COMMENT '请求类名',
    `method` VARCHAR(255) COMMENT '请求方法',
    `params` VARCHAR(5000) COMMENT '请求参数',
    `time` INT COMMENT '执行时长(毫秒)',
    `ip` VARCHAR(64) COMMENT 'IP',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统日志';

INSERT INTO `sys_log` (`username`, `action`, `classname`, `method`,
                       `params`, `time`, `ip`) VALUES
    ('admin', '创建系统用户', 'com.backendsys.modules.system.controller.SysUserController', 'createUser',
     '[{\"id\":52,\"username\":\"wangwu05\",\"password\":\"$2a$10$.2WbqVJ6q6fZAwinwBk5BuiDMVwd1DqgWJcowmOPt6Fxw.x5rlJ1O\",\"nickname\":\"王五05\",\"email\":\"ww12@qq.com\",\"phone\":\"18113128505\",\"gender\":1,\"avatar\":\"http://dummyimage.com/100x100\",\"role_id\":[2]}]', 62, '0:0:0:0:0:0:0:1')
;