"""add index to table

Revision ID: df4d759fc05b
Revises: 5ae206c737ac
Create Date: 2023-08-29 14:46:46.676958

"""
import sqlalchemy as sa

from alembic import op

# revision identifiers, used by Alembic.
revision = "df4d759fc05b"
down_revision = "5ae206c737ac"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_index(
        op.f("ix_applications_name"), "applications", ["name"], unique=False
    )
    op.create_index(
        op.f("ix_applications_owner"), "applications", ["owner"], unique=False
    )
    op.create_index(
        op.f("ix_applications_created_at"), "applications", ["created_at"], unique=False
    )
    op.create_index(
        op.f("ix_applications_updated_at"), "applications", ["updated_at"], unique=False
    )
    op.create_index(
        op.f("ix_interactions_created_at"), "interactions", ["created_at"], unique=False
    )


def downgrade() -> None:
    op.drop_index(op.f("ix_applications_name"), table_name="applications")
    op.drop_index(op.f("ix_applications_owner"), table_name="applications")
    op.drop_index(op.f("ix_applications_created_at"), table_name="applications")
    op.drop_index(op.f("ix_applications_updated_at"), table_name="applications")
    op.drop_index(op.f("ix_interactions_created_at"), table_name="interactions")