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(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `username` VARCHAR(255) NOT NULL COMMENT '用户名',
    `operation` 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='系统日志';