"""empty message

Revision ID: 4eacd6dcd461
Revises: c208cbc25232
Create Date: 2024-04-03 23:25:42.271936

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '4eacd6dcd461'
down_revision = 'c208cbc25232'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('oboruds', schema=None) as batch_op:
        batch_op.add_column(sa.Column('numberved', sa.String(length=100), nullable=True))
        batch_op.add_column(sa.Column('numberppasu', sa.String(length=100), nullable=True))
        batch_op.add_column(sa.Column('balancenumber', sa.Integer(), nullable=True))
        batch_op.alter_column('nazvanie',
               existing_type=sa.TEXT(length=500),
               type_=sa.String(length=500),
               existing_nullable=True)
        batch_op.alter_column('raspologenie',
               existing_type=sa.TEXT(length=200),
               type_=sa.String(length=200),
               existing_nullable=True)
        batch_op.drop_column('buhnumberpp')

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('oboruds', schema=None) as batch_op:
        batch_op.add_column(sa.Column('buhnumberpp', sa.VARCHAR(length=100), nullable=True))
        batch_op.alter_column('raspologenie',
               existing_type=sa.String(length=200),
               type_=sa.TEXT(length=200),
               existing_nullable=True)
        batch_op.alter_column('nazvanie',
               existing_type=sa.String(length=500),
               type_=sa.TEXT(length=500),
               existing_nullable=True)
        batch_op.drop_column('balancenumber')
        batch_op.drop_column('numberppasu')
        batch_op.drop_column('numberved')

    # ### end Alembic commands ###