"""empty message

Revision ID: 5aba0338fe03
Revises: e324133fa8e0
Create Date: 2022-07-31 23:36:05.619951

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '5aba0338fe03'
down_revision = 'e324133fa8e0'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_access_list', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_access_list', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_access_list', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_access_list', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_access_rule', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_access_rule', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_access_rule', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_access_rule', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_comment', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_comment', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_comment', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_comment', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_document', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_document', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_document', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_document', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_document', sa.Column('likes', sa.TEXT(), nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_document_history', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_filter', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_filter', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_filter', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_filter', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_import', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_import', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_import', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_import', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_link', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_link', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_link', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_link', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_notify', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_notify', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_notify', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_notify', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_person', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_person', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_person', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_group', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_person_group', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_person_group', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_person_group', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_var', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_person_var', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_person_var', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_person_var', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_plugin', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_plugin', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_plugin', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_task', sa.Column('perm_policy_guest', sa.String(length=32), nullable=False))
    op.add_column('cmf_task', sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False))
    op.add_column('cmf_task', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_task', sa.Column('perm_inherit_parent_owner_id', sa.String(length=64), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_task', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_task', 'perm_public')
    op.drop_column('cmf_task', 'perm_policy_anonymous')
    op.drop_column('cmf_task', 'perm_policy_guest')
    op.drop_column('cmf_plugin', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_plugin', 'perm_public')
    op.drop_column('cmf_plugin', 'perm_policy_anonymous')
    op.drop_column('cmf_plugin', 'perm_policy_guest')
    op.drop_column('cmf_person_var', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person_var', 'perm_public')
    op.drop_column('cmf_person_var', 'perm_policy_anonymous')
    op.drop_column('cmf_person_var', 'perm_policy_guest')
    op.drop_column('cmf_person_group', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person_group', 'perm_public')
    op.drop_column('cmf_person_group', 'perm_policy_anonymous')
    op.drop_column('cmf_person_group', 'perm_policy_guest')
    op.drop_column('cmf_person', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person', 'perm_public')
    op.drop_column('cmf_person', 'perm_policy_anonymous')
    op.drop_column('cmf_person', 'perm_policy_guest')
    op.drop_column('cmf_notify', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_notify', 'perm_public')
    op.drop_column('cmf_notify', 'perm_policy_anonymous')
    op.drop_column('cmf_notify', 'perm_policy_guest')
    op.drop_column('cmf_link', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_link', 'perm_public')
    op.drop_column('cmf_link', 'perm_policy_anonymous')
    op.drop_column('cmf_link', 'perm_policy_guest')
    op.drop_column('cmf_import', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_import', 'perm_public')
    op.drop_column('cmf_import', 'perm_policy_anonymous')
    op.drop_column('cmf_import', 'perm_policy_guest')
    op.drop_column('cmf_filter', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_filter', 'perm_public')
    op.drop_column('cmf_filter', 'perm_policy_anonymous')
    op.drop_column('cmf_filter', 'perm_policy_guest')
    op.drop_column('cmf_document_history', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_document_history', 'perm_public')
    op.drop_column('cmf_document_history', 'perm_policy_anonymous')
    op.drop_column('cmf_document_history', 'perm_policy_guest')
    op.drop_column('cmf_document', 'likes')
    op.drop_column('cmf_document', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_document', 'perm_public')
    op.drop_column('cmf_document', 'perm_policy_anonymous')
    op.drop_column('cmf_document', 'perm_policy_guest')
    op.drop_column('cmf_comment', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_comment', 'perm_public')
    op.drop_column('cmf_comment', 'perm_policy_anonymous')
    op.drop_column('cmf_comment', 'perm_policy_guest')
    op.drop_column('cmf_access_rule', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_access_rule', 'perm_public')
    op.drop_column('cmf_access_rule', 'perm_policy_anonymous')
    op.drop_column('cmf_access_rule', 'perm_policy_guest')
    op.drop_column('cmf_access_list', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_access_list', 'perm_public')
    op.drop_column('cmf_access_list', 'perm_policy_anonymous')
    op.drop_column('cmf_access_list', 'perm_policy_guest')
    # ### end Alembic commands ###