| 123456789101112131415161718 |
- -- 创建系统日志表
- CREATE TABLE IF NOT EXISTS system_logs (
- id INT PRIMARY KEY AUTO_INCREMENT,
- level ENUM('info', 'warn', 'error', 'debug') NOT NULL COMMENT '日志级别',
- message TEXT NOT NULL COMMENT '日志消息',
- source VARCHAR(255) NOT NULL COMMENT '日志来源',
- module VARCHAR(255) COMMENT '模块名称',
- user_id INT COMMENT '用户ID',
- username VARCHAR(255) COMMENT '用户名',
- ip_address VARCHAR(45) COMMENT 'IP地址',
- details TEXT COMMENT '详细信息',
- created_at DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- INDEX idx_level (level),
- INDEX idx_source (source),
- INDEX idx_module (module),
- INDEX idx_created_at (created_at),
- INDEX idx_user_id (user_id)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统运行日志表';
|
