-- Novalon管理系统审计日志表补充字段
-- 版本: V15
-- 描述: 为审计日志表添加缺失的基础字段，与BaseDomain保持一致
ALTER TABLE audit_log ADD COLUMN IF NOT EXISTS create_by VARCHAR(50);
ALTER TABLE audit_log ADD COLUMN IF NOT EXISTS update_by VARCHAR(50);
ALTER TABLE audit_log ADD COLUMN IF NOT EXISTS updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE audit_log ADD COLUMN IF NOT EXISTS deleted_at TIMESTAMP;

COMMENT ON COLUMN audit_log.create_by IS '创建人';
COMMENT ON COLUMN audit_log.update_by IS '更新人';
COMMENT ON COLUMN audit_log.updated_at IS '更新时间';
COMMENT ON COLUMN audit_log.deleted_at IS '删除时间';
