"""refactor count

Revision ID: 3d19fb38f19e
Revises: 3b4e88ddc125
Create Date: 2021-08-31 16:28:17.993929

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '3d19fb38f19e'
down_revision = '3b4e88ddc125'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_invoice_items', sa.Column('item_count', sa.Numeric(precision=14, scale=2), nullable=True))
    op.drop_column('cmf_invoice_items', 'count')
    op.add_column('cmf_purchase_order_items', sa.Column('item_count', sa.Integer(), nullable=True))
    op.drop_column('cmf_purchase_order_items', 'count')
    op.add_column('cmf_sales_order_items', sa.Column('item_count', sa.Numeric(precision=14, scale=2), nullable=True))
    op.drop_column('cmf_sales_order_items', 'count')
    op.add_column('cmf_stock_items', sa.Column('item_count', sa.Integer(), nullable=True))
    op.drop_column('cmf_stock_items', 'count')
    op.add_column('cmf_stock_move_items', sa.Column('item_count', sa.Integer(), nullable=True))
    op.drop_column('cmf_stock_move_items', 'count')
    op.add_column('cmf_stock_operations', sa.Column('item_count', sa.Integer(), nullable=True))
    op.drop_column('cmf_stock_operations', 'count')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_stock_operations', sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column('cmf_stock_operations', 'item_count')
    op.add_column('cmf_stock_move_items', sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column('cmf_stock_move_items', 'item_count')
    op.add_column('cmf_stock_items', sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column('cmf_stock_items', 'item_count')
    op.add_column('cmf_sales_order_items', sa.Column('count', sa.NUMERIC(precision=14, scale=2), autoincrement=False, nullable=True))
    op.drop_column('cmf_sales_order_items', 'item_count')
    op.add_column('cmf_purchase_order_items', sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column('cmf_purchase_order_items', 'item_count')
    op.add_column('cmf_invoice_items', sa.Column('count', sa.NUMERIC(precision=14, scale=2), autoincrement=False, nullable=True))
    op.drop_column('cmf_invoice_items', 'item_count')
    # ### end Alembic commands ###