selfrelease
20 lines
1008 B
SQL
20 lines
1008 B
SQL
-- Migration: 006_optimize_indexes
|
|
-- Description: 索引优化（audit_logs 表）
|
|
-- Date: 2026-08-01
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_audit_record_id ON audit_logs(record_id);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_actor_role ON audit_logs(actor_role);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_created_at ON audit_logs(created_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_work_station ON work_records(station);
|
|
CREATE INDEX IF NOT EXISTS idx_work_reporter ON work_records(reporter);
|
|
CREATE INDEX IF NOT EXISTS idx_work_status ON work_records(status);
|
|
CREATE INDEX IF NOT EXISTS idx_work_updated_at ON work_records(updated_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_people_station ON people(station);
|
|
CREATE INDEX IF NOT EXISTS idx_people_status ON people(status);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_stations_region ON stations(region);
|
|
CREATE INDEX IF NOT EXISTS idx_stations_status ON stations(status);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_notice_receipt_notice ON notice_receipts(notice_id); |