"""add_show_to_structure

Revision ID: 6b541ef32465
Revises: 40f23a3bb49d
Create Date: 2023-03-14 10:47:19.904838

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '6b541ef32465'
down_revision = '40f23a3bb49d'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_project', sa.Column('show_queue', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_project', sa.Column('show_knowlage_base', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_project',
                  sa.Column('show_servicedesk_channels', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_project',
                  sa.Column('show_servicedesk_clients', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_project', sa.Column('show_filters', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_project', sa.Column('show_reports', sa.Boolean(), nullable=False, server_default="false"))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_project', 'show_reports')
    op.drop_column('cmf_project', 'show_filters')
    op.drop_column('cmf_project', 'show_servicedesk_clients')
    op.drop_column('cmf_project', 'show_servicedesk_channels')
    op.drop_column('cmf_project', 'show_knowlage_base')
    op.drop_column('cmf_project', 'show_queue')
    # ### end Alembic commands ###