"""add percent needed field for spreadsheet; default is null

Revision ID: ec4f9c6a23ee
Revises: c81b06cdfb83
Create Date: 2022-10-13 16:16:36.309226

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ec4f9c6a23ee'
down_revision = 'c81b06cdfb83'
branch_labels = None
depends_on = None


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


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