"""add license flags to person

Revision ID: 9a89fbbe4722
Revises: 2af7fd6220fe
Create Date: 2024-09-17 11:54:05.649579

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '9a89fbbe4722'
down_revision = '2af7fd6220fe'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_person', sa.Column('lic_evawiki', sa.Boolean(), nullable=False, server_default='false'))
    op.add_column('cmf_person', sa.Column('lic_evaproject', sa.Boolean(), nullable=False, server_default='false'))
    op.add_column('cmf_person', sa.Column('lic_evaservicedesk', sa.Boolean(), nullable=False, server_default='false'))
    op.add_column('cmf_person', sa.Column('lic_evagit', sa.Boolean(), nullable=False, server_default='false'))
    op.add_column('cmf_person', sa.Column('lic_evatest', sa.Boolean(), nullable=False, server_default='false'))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_person', 'lic_evatest')
    op.drop_column('cmf_person', 'lic_evagit')
    op.drop_column('cmf_person', 'lic_evaservicedesk')
    op.drop_column('cmf_person', 'lic_evaproject')
    op.drop_column('cmf_person', 'lic_evawiki')
    # ### end Alembic commands ###