-- 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);