def METHOD_NAME():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('package_versions', schema=None) as batch_op:
        batch_op.alter_column(
            'size',
            existing_type=sa.BigInteger(),
            type_=sa.INTEGER(),
            existing_nullable=True,
        )
    with op.batch_alter_table('channels', schema=None) as batch_op:
        batch_op.alter_column(
            'size_limit',
            existing_type=sa.BigInteger(),
            type_=sa.INTEGER(),
            existing_nullable=True,
        )
        batch_op.alter_column(
            'size',
            existing_type=sa.BigInteger(),
            type_=sa.INTEGER(),
            existing_nullable=True,
        )
    op.create_table(
        'repodata_signing_keys',
        sa.Column('id', sa.BLOB(), nullable=False),
        sa.Column('private_key', sa.VARCHAR(), nullable=True),
        sa.Column(
            'time_created',
            sa.DATE(),
            server_default=sa.text('(CURRENT_TIMESTAMP)'),
            nullable=False,
        ),
        sa.Column('user_id', sa.BLOB(), nullable=True),
        sa.Column('channel_name', sa.VARCHAR(), nullable=True),
        sa.ForeignKeyConstraint(
            ['channel_name'],
            ['channels.name'],
        ),
        sa.ForeignKeyConstraint(
            ['user_id'],
            ['users.id'],
        ),
        sa.PrimaryKeyConstraint('id'),
    )
    op.drop_table('delegations_keys')
    op.drop_table('signing_keys')
    op.drop_table('role_delegations')
    op.drop_table('content_trust_roles')
    # ### end Alembic commands ###