"""coupling: add co_changes + file_a indexes to musehub_intel_coupling

Revision ID: 0011
Revises: 0010
"""

from __future__ import annotations

from typing import Union

from alembic import op

revision: str = "0011"
down_revision: Union[str, None] = "0010"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_index(
        "ix_intel_coupling_repo_co",
        "musehub_intel_coupling",
        ["repo_id", "co_changes"],
    )
    op.create_index(
        "ix_intel_coupling_repo_file_a",
        "musehub_intel_coupling",
        ["repo_id", "file_a"],
    )


def downgrade() -> None:
    op.drop_index("ix_intel_coupling_repo_file_a", table_name="musehub_intel_coupling")
    op.drop_index("ix_intel_coupling_repo_co", table_name="musehub_intel_coupling")