"""empty message

Revision ID: 9a76db159a34
Revises: 0a2e13051c18
Create Date: 2023-01-09 15:30:04.845686

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '9a76db159a34'
down_revision = '0a2e13051c18'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_access_list', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_access_list_cmf_owner_assistant_id', table_name='cmf_access_list')
    op.execute('DROP INDEX IF EXISTS ix_cmf_access_list_cmf_owner_assistant_id')
    # op.drop_column('cmf_access_list', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_access_list DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_access_rule', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_access_rule_cmf_owner_assistant_id', table_name='cmf_access_rule')
    op.execute('DROP INDEX IF EXISTS ix_cmf_access_rule_cmf_owner_assistant_id')
    # op.drop_column('cmf_access_rule', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_access_rule DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # op.drop_index('ix_cmf_auth_cmf_owner_assistant_id', table_name='cmf_auth')
    op.execute('DROP INDEX IF EXISTS ix_cmf_auth_cmf_owner_assistant_id')
    # op.drop_column('cmf_auth', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_auth DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_auth_ldap_plugin', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_auth_ldap_plugin_cmf_owner_assistant_id', table_name='cmf_auth_ldap_plugin')
    op.execute('DROP INDEX IF EXISTS ix_cmf_auth_ldap_plugin_cmf_owner_assistant_id')
    # op.drop_column('cmf_auth_ldap_plugin', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_auth_ldap_plugin DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_comment', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_comment_cmf_owner_assistant_id', table_name='cmf_comment')
    op.execute('DROP INDEX IF EXISTS ix_cmf_comment_cmf_owner_assistant_id')
    # op.drop_column('cmf_comment', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_comment DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_document', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_document_cmf_owner_assistant_id', table_name='cmf_document')
    op.execute('DROP INDEX IF EXISTS ix_cmf_document_cmf_owner_assistant_id')
    # op.drop_column('cmf_document', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_document DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_document_history', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_document_history_cmf_owner_assistant_id', table_name='cmf_document_history')
    op.execute('DROP INDEX IF EXISTS ix_cmf_document_history_cmf_owner_assistant_id')
    # op.drop_column('cmf_document_history', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_document_history DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_filter', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_filter_cmf_owner_assistant_id', table_name='cmf_filter')
    op.execute('DROP INDEX IF EXISTS ix_cmf_filter_cmf_owner_assistant_id')
    # op.drop_column('cmf_filter', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_filter DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_global_settings', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_global_settings_cmf_owner_assistant_id', table_name='cmf_global_settings')
    op.execute('DROP INDEX IF EXISTS ix_cmf_global_settings_cmf_owner_assistant_id')
    # op.drop_column('cmf_global_settings', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_global_settings DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # op.drop_index('ix_cmf_global_var_cmf_owner_assistant_id', table_name='cmf_global_var')
    op.execute('DROP INDEX IF EXISTS ix_cmf_global_var_cmf_owner_assistant_id')
    # op.drop_column('cmf_global_var', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_global_var DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_import', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_import_cmf_owner_assistant_id', table_name='cmf_import')
    op.execute('DROP INDEX IF EXISTS ix_cmf_import_cmf_owner_assistant_id')
    # op.drop_column('cmf_import', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_import DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_link', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_link_cmf_owner_assistant_id', table_name='cmf_link')
    op.execute('DROP INDEX IF EXISTS ix_cmf_link_cmf_owner_assistant_id')
    # op.drop_column('cmf_link', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_link DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_notify', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_notify_cmf_owner_assistant_id', table_name='cmf_notify')
    op.execute('DROP INDEX IF EXISTS ix_cmf_notify_cmf_owner_assistant_id')
    # op.drop_column('cmf_notify', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_notify DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # op.drop_index('ix_cmf_patch_cmf_owner_assistant_id', table_name='cmf_patch')
    op.execute('DROP INDEX IF EXISTS ix_cmf_patch_cmf_owner_assistant_id')
    # op.drop_column('cmf_patch', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_patch DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_person', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_person_cmf_owner_assistant_id', table_name='cmf_person')
    op.execute('DROP INDEX IF EXISTS ix_cmf_person_cmf_owner_assistant_id')
    # op.drop_column('cmf_person', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_person DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_person_group', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_person_group_cmf_owner_assistant_id', table_name='cmf_person_group')
    op.execute('DROP INDEX IF EXISTS ix_cmf_person_group_cmf_owner_assistant_id')
    # op.drop_column('cmf_person_group', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_person_group DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # op.drop_index('ix_cmf_person_sign_cmf_owner_assistant_id', table_name='cmf_person_sign')
    op.execute('DROP INDEX IF EXISTS ix_cmf_person_sign_cmf_owner_assistant_id')
    # op.drop_column('cmf_person_sign', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_person_sign DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_person_var', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_person_var_cmf_owner_assistant_id', table_name='cmf_person_var')
    op.execute('DROP INDEX IF EXISTS ix_cmf_person_var_cmf_owner_assistant_id')
    # op.drop_column('cmf_person_var', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_person_var DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_plugin', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_plugin_cmf_owner_assistant_id', table_name='cmf_plugin')
    op.execute('DROP INDEX IF EXISTS ix_cmf_plugin_cmf_owner_assistant_id')
    # op.drop_column('cmf_plugin', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_plugin DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # op.drop_index('ix_cmf_sign_cmf_owner_assistant_id', table_name='cmf_sign')
    op.execute('DROP INDEX IF EXISTS ix_cmf_sign_cmf_owner_assistant_id')
    # op.drop_column('cmf_sign', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_sign DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    op.add_column('cmf_task', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    # op.drop_index('ix_cmf_task_cmf_owner_assistant_id', table_name='cmf_task')
    op.execute('DROP INDEX IF EXISTS ix_cmf_task_cmf_owner_assistant_id')
    # op.drop_column('cmf_task', 'cmf_owner_assistant_id')
    op.execute('ALTER TABLE cmf_task DROP COLUMN IF EXISTS cmf_owner_assistant_id')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_task', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_task_cmf_owner_assistant_id', 'cmf_task', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_task', 'import_raw_json')
    op.add_column('cmf_sign', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_sign_cmf_owner_assistant_id', 'cmf_sign', ['cmf_owner_assistant_id'], unique=False)
    op.add_column('cmf_plugin', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_plugin_cmf_owner_assistant_id', 'cmf_plugin', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_plugin', 'import_raw_json')
    op.add_column('cmf_person_var', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_person_var_cmf_owner_assistant_id', 'cmf_person_var', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_person_var', 'import_raw_json')
    op.add_column('cmf_person_sign', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_person_sign_cmf_owner_assistant_id', 'cmf_person_sign', ['cmf_owner_assistant_id'], unique=False)
    op.add_column('cmf_person_group', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_person_group_cmf_owner_assistant_id', 'cmf_person_group', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_person_group', 'import_raw_json')
    op.add_column('cmf_person', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_person_cmf_owner_assistant_id', 'cmf_person', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_person', 'import_raw_json')
    op.add_column('cmf_patch', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_patch_cmf_owner_assistant_id', 'cmf_patch', ['cmf_owner_assistant_id'], unique=False)
    op.add_column('cmf_notify', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_notify_cmf_owner_assistant_id', 'cmf_notify', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_notify', 'import_raw_json')
    op.add_column('cmf_link', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_link_cmf_owner_assistant_id', 'cmf_link', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_link', 'import_raw_json')
    op.add_column('cmf_import', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_import_cmf_owner_assistant_id', 'cmf_import', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_import', 'import_raw_json')
    op.add_column('cmf_global_var', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_global_var_cmf_owner_assistant_id', 'cmf_global_var', ['cmf_owner_assistant_id'], unique=False)
    op.add_column('cmf_global_settings', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_global_settings_cmf_owner_assistant_id', 'cmf_global_settings', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_global_settings', 'import_raw_json')
    op.add_column('cmf_filter', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_filter_cmf_owner_assistant_id', 'cmf_filter', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_filter', 'import_raw_json')
    op.add_column('cmf_document_history', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_document_history_cmf_owner_assistant_id', 'cmf_document_history', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_document_history', 'import_raw_json')
    op.add_column('cmf_document', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_document_cmf_owner_assistant_id', 'cmf_document', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_document', 'import_raw_json')
    op.add_column('cmf_comment', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_comment_cmf_owner_assistant_id', 'cmf_comment', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_comment', 'import_raw_json')
    op.add_column('cmf_auth_ldap_plugin', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_auth_ldap_plugin_cmf_owner_assistant_id', 'cmf_auth_ldap_plugin', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_auth_ldap_plugin', 'import_raw_json')
    op.add_column('cmf_auth', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_auth_cmf_owner_assistant_id', 'cmf_auth', ['cmf_owner_assistant_id'], unique=False)
    op.add_column('cmf_access_rule', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_access_rule_cmf_owner_assistant_id', 'cmf_access_rule', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_access_rule', 'import_raw_json')
    op.add_column('cmf_access_list', sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.create_index('ix_cmf_access_list_cmf_owner_assistant_id', 'cmf_access_list', ['cmf_owner_assistant_id'], unique=False)
    op.drop_column('cmf_access_list', 'import_raw_json')
    # ### end Alembic commands ###