from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


# revision identifiers, used by Alembic.
revision = '5a291251823c'
down_revision = '4095103c7d01'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('project', sa.Column('max_retakes', sa.Integer(), nullable=True))
    op.drop_index('ix_task_status_is_default', table_name='task_status')
    op.create_index(op.f('ix_task_status_is_default'), 'task_status', ['is_default'], unique=False)
    op.drop_column('task_type', 'for_shots')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('task_type', sa.Column('for_shots', sa.BOOLEAN(), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_task_status_is_default'), table_name='task_status')
    op.create_index('ix_task_status_is_default', 'task_status', ['is_default'], unique=False)
    op.drop_column('project', 'max_retakes')
    # ### end Alembic commands ###

from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


# revision identifiers, used by Alembic.
revision = '5a291251823c'
down_revision = '4095103c7d01'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('project', sa.Column('max_retakes', sa.Integer(), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('project', 'max_retakes')
    # ### end Alembic commands ###

Fix max retake migration file
[db] Fix max retake migration file

  from alembic import op
  import sqlalchemy as sa
  import sqlalchemy_utils
  
  
  # revision identifiers, used by Alembic.
  revision = '5a291251823c'
  down_revision = '4095103c7d01'
  branch_labels = None
  depends_on = None
  
  
  def upgrade():
      # ### commands auto generated by Alembic - please adjust! ###
      op.add_column('project', sa.Column('max_retakes', sa.Integer(), nullable=True))
-     op.drop_index('ix_task_status_is_default', table_name='task_status')
-     op.create_index(op.f('ix_task_status_is_default'), 'task_status', ['is_default'], unique=False)
-     op.drop_column('task_type', 'for_shots')
      # ### end Alembic commands ###
  
  
  def downgrade():
      # ### commands auto generated by Alembic - please adjust! ###
-     op.add_column('task_type', sa.Column('for_shots', sa.BOOLEAN(), autoincrement=False, nullable=True))
-     op.drop_index(op.f('ix_task_status_is_default'), table_name='task_status')
-     op.create_index('ix_task_status_is_default', 'task_status', ['is_default'], unique=False)
      op.drop_column('project', 'max_retakes')
      # ### end Alembic commands ###
  
Fix max retake migration file
## Code Before:
from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


# revision identifiers, used by Alembic.
revision = '5a291251823c'
down_revision = '4095103c7d01'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('project', sa.Column('max_retakes', sa.Integer(), nullable=True))
    op.drop_index('ix_task_status_is_default', table_name='task_status')
    op.create_index(op.f('ix_task_status_is_default'), 'task_status', ['is_default'], unique=False)
    op.drop_column('task_type', 'for_shots')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('task_type', sa.Column('for_shots', sa.BOOLEAN(), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_task_status_is_default'), table_name='task_status')
    op.create_index('ix_task_status_is_default', 'task_status', ['is_default'], unique=False)
    op.drop_column('project', 'max_retakes')
    # ### end Alembic commands ###

## Instruction:
Fix max retake migration file
## Code After:
from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


# revision identifiers, used by Alembic.
revision = '5a291251823c'
down_revision = '4095103c7d01'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('project', sa.Column('max_retakes', sa.Integer(), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('project', 'max_retakes')
    # ### end Alembic commands ###
