"""not null cmf order

Revision ID: 41847513c532
Revises: 182568104ca8
Create Date: 2021-02-15 09:34:10.376014

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '41847513c532'
down_revision = '182568104ca8'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute('update cmf_chat_group set orderno=0 where orderno is null')
    op.alter_column('cmf_chat_group', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_chat_topic set orderno=0 where orderno is null')
    op.alter_column('cmf_chat_topic', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_company set orderno=0 where orderno is null')
    op.alter_column('cmf_company', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_deal set orderno=0 where orderno is null')
    op.alter_column('cmf_deal', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_document set orderno=0 where orderno is null')
    op.alter_column('cmf_document', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_form_field set orderno=0 where orderno is null')
    op.alter_column('cmf_form_field', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_invoice set orderno=0 where orderno is null')
    op.alter_column('cmf_invoice', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_lead set orderno=0 where orderno is null')
    op.alter_column('cmf_lead', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_list set orderno=0 where orderno is null')
    op.alter_column('cmf_list', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_mail set orderno=0 where orderno is null')
    op.alter_column('cmf_mail', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_payment set orderno=0 where orderno is null')
    op.alter_column('cmf_payment', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_pipeline set orderno=0 where orderno is null')
    op.alter_column('cmf_pipeline', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_purchase_order set orderno=0 where orderno is null')
    op.alter_column('cmf_purchase_order', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_purchase_order_items set orderno=0 where orderno is null')
    op.alter_column('cmf_purchase_order_items', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_sales_order set orderno=0 where orderno is null')
    op.alter_column('cmf_sales_order', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_stock_move set orderno=0 where orderno is null')
    op.alter_column('cmf_stock_move', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_stock_move_items set orderno=0 where orderno is null')
    op.alter_column('cmf_stock_move_items', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_task set orderno=0 where orderno is null')
    op.alter_column('cmf_task', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.execute('update cmf_u_work_post set orderno=0 where orderno is null')
    op.alter_column('cmf_u_work_post', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('cmf_u_work_post', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_task', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_stock_move_items', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_stock_move', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_sales_order', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_purchase_order_items', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_purchase_order', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_pipeline', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_payment', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_mail', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_list', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_lead', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_invoice', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_form_field', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_document', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_deal', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_company', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_chat_topic', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('cmf_chat_group', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    # ### end Alembic commands ###