42 lines
1.8 KiB
SQL
42 lines
1.8 KiB
SQL
-- 创建操作日志表
|
|
CREATE TABLE IF NOT EXISTS sys_operation_log (
|
|
id BIGINT PRIMARY KEY,
|
|
username VARCHAR(50),
|
|
operation VARCHAR(100),
|
|
method VARCHAR(200),
|
|
params TEXT,
|
|
result TEXT,
|
|
ip VARCHAR(50),
|
|
duration BIGINT,
|
|
status VARCHAR(1) DEFAULT '0',
|
|
error_msg TEXT,
|
|
create_by VARCHAR(50),
|
|
update_by VARCHAR(50),
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
deleted_at TIMESTAMP
|
|
);
|
|
|
|
-- 创建索引
|
|
CREATE INDEX IF NOT EXISTS idx_operation_log_username ON sys_operation_log(username);
|
|
CREATE INDEX IF NOT EXISTS idx_operation_log_created_at ON sys_operation_log(created_at);
|
|
CREATE INDEX IF NOT EXISTS idx_operation_log_status ON sys_operation_log(status);
|
|
|
|
-- 添加注释
|
|
COMMENT ON TABLE sys_operation_log IS '操作日志表';
|
|
COMMENT ON COLUMN sys_operation_log.id IS '主键ID';
|
|
COMMENT ON COLUMN sys_operation_log.username IS '操作用户';
|
|
COMMENT ON COLUMN sys_operation_log.operation IS '操作描述';
|
|
COMMENT ON COLUMN sys_operation_log.method IS '请求方法';
|
|
COMMENT ON COLUMN sys_operation_log.params IS '请求参数';
|
|
COMMENT ON COLUMN sys_operation_log.result IS '操作结果';
|
|
COMMENT ON COLUMN sys_operation_log.ip IS 'IP地址';
|
|
COMMENT ON COLUMN sys_operation_log.duration IS '执行时长(毫秒)';
|
|
COMMENT ON COLUMN sys_operation_log.status IS '操作状态(0成功 1失败)';
|
|
COMMENT ON COLUMN sys_operation_log.error_msg IS '错误消息';
|
|
COMMENT ON COLUMN sys_operation_log.create_by IS '创建人';
|
|
COMMENT ON COLUMN sys_operation_log.update_by IS '更新人';
|
|
COMMENT ON COLUMN sys_operation_log.created_at IS '创建时间';
|
|
COMMENT ON COLUMN sys_operation_log.updated_at IS '更新时间';
|
|
COMMENT ON COLUMN sys_operation_log.deleted_at IS '删除时间';
|