"""sl

Revision ID: 571b19b90fc2
Revises: 44aa5c2a5f78
Create Date: 2024-12-27 09:56:58.857047

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '571b19b90fc2'
down_revision = '44aa5c2a5f78'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_test_configuration', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_test_environment', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_test_param', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_test_param_value', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_folder', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_param', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_params_row', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_run', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_run_step', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcase_step', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.alter_column('cmf_testcase_step', 'step_section',
               existing_type=sa.VARCHAR(length=32),
               nullable=False)
    op.add_column('cmf_testcycle', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcycle_testcase_folder', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testcycle_testcase_result', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testplan', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testplan_testcase', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    op.add_column('cmf_testplan_testcase_folder', sa.Column('sl_owner_lock', sa.Boolean(), nullable=False))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_testplan_testcase_folder', 'sl_owner_lock')
    op.drop_column('cmf_testplan_testcase', 'sl_owner_lock')
    op.drop_column('cmf_testplan', 'sl_owner_lock')
    op.drop_column('cmf_testcycle_testcase_result', 'sl_owner_lock')
    op.drop_column('cmf_testcycle_testcase_folder', 'sl_owner_lock')
    op.drop_column('cmf_testcycle', 'sl_owner_lock')
    op.alter_column('cmf_testcase_step', 'step_section',
               existing_type=sa.VARCHAR(length=32),
               nullable=True)
    op.drop_column('cmf_testcase_step', 'sl_owner_lock')
    op.drop_column('cmf_testcase_run_step', 'sl_owner_lock')
    op.drop_column('cmf_testcase_run', 'sl_owner_lock')
    op.drop_column('cmf_testcase_params_row', 'sl_owner_lock')
    op.drop_column('cmf_testcase_param', 'sl_owner_lock')
    op.drop_column('cmf_testcase_folder', 'sl_owner_lock')
    op.drop_column('cmf_testcase', 'sl_owner_lock')
    op.drop_column('cmf_test_param_value', 'sl_owner_lock')
    op.drop_column('cmf_test_param', 'sl_owner_lock')
    op.drop_column('cmf_test_environment', 'sl_owner_lock')
    op.drop_column('cmf_test_configuration', 'sl_owner_lock')
    # ### end Alembic commands ###