"""Add relation-scoped directory query indexes.

Revision ID: 538
Revises: 537
Create Date: 2026-08-24
"""
from __future__ import annotations

from alembic import op

revision = "538"
down_revision = "537"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_index(
        "ix_cmdb_cloud_resources_integration_scope_deleted",
        "cmdb_cloud_resources",
        ["integration_id", "scope_external_id", "deleted_at"],
    )


def downgrade() -> None:
    op.drop_index(
        "ix_cmdb_cloud_resources_integration_scope_deleted",
        table_name="cmdb_cloud_resources",
    )