"""empty message

Revision ID: ecc8471fb4f4
Revises: b2ba9386f50c
Create Date: 2022-03-02 11:14:19.283913

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = 'ecc8471fb4f4'
down_revision = 'b2ba9386f50c'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_global_settings',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('cmf_person_var_favorites',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('root_id', sa.String(length=64), nullable=True),
    sa.Column('description', sa.String(length=4096), nullable=True),
    sa.Column('left_id', sa.String(length=64), nullable=True),
    sa.Column('right_id', sa.String(length=64), nullable=True),
    sa.Column('left_name_cache', sa.String(length=256), nullable=True),
    sa.Column('right_name_cache', sa.String(length=256), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_person_var_favorites_left_id'), 'cmf_person_var_favorites', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_favorites_parent_id'), 'cmf_person_var_favorites', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_favorites_right_id'), 'cmf_person_var_favorites', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_favorites_root_id'), 'cmf_person_var_favorites', ['root_id'], unique=False)
    op.create_table('cmf_link',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_deleted', sa.Boolean(), nullable=False),
    sa.Column('cmf_version', sa.Integer(), nullable=True),
    sa.Column('name', sa.String(length=256), nullable=True),
    sa.Column('code', sa.String(length=64), nullable=True),
    sa.Column('system', sa.Boolean(), nullable=False),
    sa.Column('text', sa.TEXT(), nullable=True),
    sa.Column('cache_last_comments', sa.TEXT(), nullable=False),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('url', sa.String(length=4096), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_link_cmf_author_id'), 'cmf_link', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_created_at'), 'cmf_link', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_deleted'), 'cmf_link', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_import_id'), 'cmf_link', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_locked_at'), 'cmf_link', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_locked_by_id'), 'cmf_link', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_modified_at'), 'cmf_link', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_modified_by_id'), 'cmf_link', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_owner_assistant_id'), 'cmf_link', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_owner_id'), 'cmf_link', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_version'), 'cmf_link', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_link_cmf_viewed_at'), 'cmf_link', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_link_code'), 'cmf_link', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_link_name'), 'cmf_link', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_link_parent_id'), 'cmf_link', ['parent_id'], unique=False)
    op.create_table('cmf_notify',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_deleted', sa.Boolean(), nullable=False),
    sa.Column('cmf_version', sa.Integer(), nullable=True),
    sa.Column('name', sa.String(length=256), nullable=True),
    sa.Column('code', sa.String(length=64), nullable=True),
    sa.Column('system', sa.Boolean(), nullable=False),
    sa.Column('text', sa.TEXT(), nullable=True),
    sa.Column('comments', sa.TEXT(), nullable=True),
    sa.Column('cache_last_comments', sa.TEXT(), nullable=False),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('confirmed', sa.Boolean(), nullable=False),
    sa.Column('status', sa.String(length=32), nullable=True),
    sa.Column('strikethrough', sa.Boolean(), nullable=False),
    sa.Column('obj_id', sa.String(length=64), nullable=True),
    sa.Column('obj_code', sa.String(length=64), nullable=True),
    sa.Column('obj_ui_name', sa.String(length=64), nullable=True),
    sa.Column('obj_href', sa.String(length=4096), nullable=True),
    sa.Column('obj_cache_status_type', sa.String(length=32), nullable=True),
    sa.Column('person_id', sa.String(length=64), nullable=True),
    sa.Column('unread_cnt', sa.Integer(), nullable=False),
    sa.Column('priority_old', sa.String(length=32), nullable=False),
    sa.Column('priority', sa.Integer(), nullable=False),
    sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_notify_alarm_date'), 'cmf_notify', ['alarm_date'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_author_id'), 'cmf_notify', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_created_at'), 'cmf_notify', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_deleted'), 'cmf_notify', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_import_id'), 'cmf_notify', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_locked_at'), 'cmf_notify', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_locked_by_id'), 'cmf_notify', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_modified_at'), 'cmf_notify', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_modified_by_id'), 'cmf_notify', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_owner_assistant_id'), 'cmf_notify', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_owner_id'), 'cmf_notify', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_version'), 'cmf_notify', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_notify_cmf_viewed_at'), 'cmf_notify', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_notify_code'), 'cmf_notify', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_notify_confirmed'), 'cmf_notify', ['confirmed'], unique=False)
    op.create_index(op.f('ix_cmf_notify_name'), 'cmf_notify', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_notify_obj_cache_status_type'), 'cmf_notify', ['obj_cache_status_type'], unique=False)
    op.create_index(op.f('ix_cmf_notify_obj_code'), 'cmf_notify', ['obj_code'], unique=False)
    op.create_index(op.f('ix_cmf_notify_obj_href'), 'cmf_notify', ['obj_href'], unique=False)
    op.create_index(op.f('ix_cmf_notify_obj_id'), 'cmf_notify', ['obj_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_obj_ui_name'), 'cmf_notify', ['obj_ui_name'], unique=False)
    op.create_index(op.f('ix_cmf_notify_parent_id'), 'cmf_notify', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_person_id'), 'cmf_notify', ['person_id'], unique=False)
    op.create_index(op.f('ix_cmf_notify_status'), 'cmf_notify', ['status'], unique=False)
    op.create_index(op.f('ix_cmf_notify_unread_cnt'), 'cmf_notify', ['unread_cnt'], unique=False)
    op.create_table('cmf_person_var',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_deleted', sa.Boolean(), nullable=False),
    sa.Column('cmf_version', sa.Integer(), nullable=True),
    sa.Column('name', sa.String(length=256), nullable=True),
    sa.Column('code', sa.String(length=64), nullable=True),
    sa.Column('system', sa.Boolean(), nullable=False),
    sa.Column('text', sa.TEXT(), nullable=True),
    sa.Column('cache_last_comments', sa.TEXT(), nullable=False),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_person_var_cmf_author_id'), 'cmf_person_var', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_created_at'), 'cmf_person_var', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_deleted'), 'cmf_person_var', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_import_id'), 'cmf_person_var', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_locked_at'), 'cmf_person_var', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_locked_by_id'), 'cmf_person_var', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_modified_at'), 'cmf_person_var', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_modified_by_id'), 'cmf_person_var', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_owner_assistant_id'), 'cmf_person_var', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_owner_id'), 'cmf_person_var', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_version'), 'cmf_person_var', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_cmf_viewed_at'), 'cmf_person_var', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_code'), 'cmf_person_var', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_person_var_name'), 'cmf_person_var', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_parent_id'), 'cmf_person_var', ['parent_id'], unique=False)
    op.create_table('cmf_person_view',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('person_id', sa.String(length=64), nullable=False),
    sa.Column('obj_id', sa.String(length=64), nullable=False),
    sa.ForeignKeyConstraint(['person_id'], ['cmf_person.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_person_view_cmf_created_at'), 'cmf_person_view', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_view_obj_id'), 'cmf_person_view', ['obj_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_view_person_id'), 'cmf_person_view', ['person_id'], unique=False)
    op.add_column('cmf_comment', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_document', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_filter', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_import', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_person', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_task', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('cmf_task', 'is_favorite')
    op.drop_column('cmf_plugin', 'is_favorite')
    op.drop_column('cmf_person', 'is_favorite')
    op.drop_column('cmf_import', 'is_favorite')
    op.drop_column('cmf_filter', 'is_favorite')
    op.drop_column('cmf_document', 'is_favorite')
    op.drop_column('cmf_comment', 'is_favorite')
    op.drop_index(op.f('ix_cmf_person_view_person_id'), table_name='cmf_person_view')
    op.drop_index(op.f('ix_cmf_person_view_obj_id'), table_name='cmf_person_view')
    op.drop_index(op.f('ix_cmf_person_view_cmf_created_at'), table_name='cmf_person_view')
    op.drop_table('cmf_person_view')
    op.drop_index(op.f('ix_cmf_person_var_parent_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_name'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_code'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_viewed_at'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_version'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_owner_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_owner_assistant_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_modified_by_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_modified_at'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_locked_by_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_locked_at'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_import_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_deleted'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_created_at'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_cmf_author_id'), table_name='cmf_person_var')
    op.drop_table('cmf_person_var')
    op.drop_index(op.f('ix_cmf_notify_unread_cnt'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_status'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_person_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_parent_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_obj_ui_name'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_obj_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_obj_href'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_obj_code'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_obj_cache_status_type'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_name'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_confirmed'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_code'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_viewed_at'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_version'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_owner_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_owner_assistant_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_modified_by_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_modified_at'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_locked_by_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_locked_at'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_import_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_deleted'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_created_at'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_cmf_author_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_alarm_date'), table_name='cmf_notify')
    op.drop_table('cmf_notify')
    op.drop_index(op.f('ix_cmf_link_parent_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_name'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_code'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_viewed_at'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_version'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_owner_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_owner_assistant_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_modified_by_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_modified_at'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_locked_by_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_locked_at'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_import_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_deleted'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_created_at'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_cmf_author_id'), table_name='cmf_link')
    op.drop_table('cmf_link')
    op.drop_index(op.f('ix_cmf_person_var_favorites_root_id'), table_name='cmf_person_var_favorites')
    op.drop_index(op.f('ix_cmf_person_var_favorites_right_id'), table_name='cmf_person_var_favorites')
    op.drop_index(op.f('ix_cmf_person_var_favorites_parent_id'), table_name='cmf_person_var_favorites')
    op.drop_index(op.f('ix_cmf_person_var_favorites_left_id'), table_name='cmf_person_var_favorites')
    op.drop_table('cmf_person_var_favorites')
    op.drop_table('cmf_global_settings')
    # ### end Alembic commands ###