"""cascade template deletion to slot

Revision ID: eabd3ad5aaf8
Revises: 4ca2e4cc7b95
Create Date: 2024-06-02 16:00:29.689607

"""

from alembic import op


# revision identifiers, used by Alembic.
revision = "eabd3ad5aaf8"
down_revision = "4ca2e4cc7b95"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint("slots_template_id_fkey", "slots", type_="foreignkey")
    op.create_foreign_key(
        "slots_template_id_fkey_v2",
        "slots",
        "slot_templates",
        ["template_id"],
        ["id"],
        ondelete="CASCADE",
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint("slots_template_id_fkey_v2", "slots", type_="foreignkey")
    op.create_foreign_key(
        "slots_template_id_fkey", "slots", "slot_templates", ["template_id"], ["id"]
    )
    # ### end Alembic commands ###