CREATE INDEX IF NOT EXISTS webdav_retention_scan_idx
  ON webdav_configs(manifest_retention_expires_at, retention_state)
  WHERE manifest_retention_expires_at IS NOT NULL;

CREATE INDEX IF NOT EXISTS webdav_retention_job_dedupe_idx
  ON webdav_sync_jobs(user_id, intent, path, status);