break
88cc5e96ec
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 8m32s
20 lines
689 B
SQL
20 lines
689 B
SQL
-- 回滚统一审计跨视角查询索引，并恢复 request 与 parent 的原始精确查询索引。
|
|
DROP INDEX idx_audit_resource_key_event;
|
|
DROP INDEX idx_audit_resource_id_event;
|
|
|
|
DROP INDEX idx_audit_event_parent;
|
|
CREATE INDEX idx_audit_event_parent
|
|
ON tb_audit_event (parent_event_id)
|
|
WHERE parent_event_id <> '';
|
|
|
|
DROP INDEX idx_audit_event_request;
|
|
CREATE INDEX idx_audit_event_request
|
|
ON tb_audit_event (request_id)
|
|
WHERE request_id <> '';
|
|
|
|
DROP INDEX idx_audit_event_source_occurred;
|
|
DROP INDEX idx_audit_event_category_occurred;
|
|
DROP INDEX idx_audit_event_risk_occurred;
|
|
DROP INDEX idx_audit_event_result_occurred;
|
|
DROP INDEX idx_audit_event_action_occurred;
|