"""stop cascade template deletion to slot

Revision ID: 8fee990845df
Revises: eabd3ad5aaf8
Create Date: 2024-06-02 17:10:22.363720

"""

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "8fee990845df"
down_revision = "eabd3ad5aaf8"
branch_labels = None
depends_on = None


def upgrade():
    # ### 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_v3",
        "slots",
        "slot_templates",
        ["template_id"],
        ["id"],
        ondelete="SET NULL",
    )
    # ### end Alembic commands ###


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