"""new permisions Revision ID: c74984e9ee6d Revises: aff93dc71b30 Create Date: 2022-06-23 16:28:43.796448 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = 'c74984e9ee6d' down_revision = 'aff93dc71b30' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_acl', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('disabled', sa.Boolean(), nullable=True), sa.Column('sys_type', sa.String(), nullable=True), sa.Column('object', sa.String(length=64), nullable=False), sa.Column('access_level', sa.String(length=32), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_acl_orderno'), 'cmf_acl', ['orderno'], unique=False) op.create_table('cmf_acl_subjects', 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_acl_subjects_left_id'), 'cmf_acl_subjects', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_acl_subjects_parent_id'), 'cmf_acl_subjects', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_acl_subjects_right_id'), 'cmf_acl_subjects', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_acl_subjects_root_id'), 'cmf_acl_subjects', ['root_id'], unique=False) op.add_column('cmf_active_entity_filter', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_card', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_company', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_company', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_document', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_document', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_form', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_import', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_import', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_job', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_link', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_list', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_list', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_price', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_product', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_project', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_project', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_role', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_task', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_task', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_id', sa.String(length=64), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_field', sa.String(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_private', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_readonly', sa.Boolean(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_encrypt', sa.Boolean(), nullable=True)) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('cmf_workflow_type', 'perm_encrypt') op.drop_column('cmf_workflow_type', 'perm_readonly') op.drop_column('cmf_workflow_type', 'perm_private') op.drop_column('cmf_workflow_type', 'perm_field') op.drop_column('cmf_workflow_type', 'perm_id') op.drop_column('cmf_workflow', 'perm_encrypt') op.drop_column('cmf_workflow', 'perm_readonly') op.drop_column('cmf_workflow', 'perm_private') op.drop_column('cmf_workflow', 'perm_field') op.drop_column('cmf_workflow', 'perm_id') op.drop_column('cmf_wiki', 'perm_encrypt') op.drop_column('cmf_wiki', 'perm_readonly') op.drop_column('cmf_wiki', 'perm_private') op.drop_column('cmf_wiki', 'perm_field') op.drop_column('cmf_wiki', 'perm_id') op.drop_column('cmf_whatsapp', 'perm_encrypt') op.drop_column('cmf_whatsapp', 'perm_readonly') op.drop_column('cmf_whatsapp', 'perm_private') op.drop_column('cmf_whatsapp', 'perm_field') op.drop_column('cmf_whatsapp', 'perm_id') op.drop_column('cmf_unit', 'perm_encrypt') op.drop_column('cmf_unit', 'perm_readonly') op.drop_column('cmf_unit', 'perm_private') op.drop_column('cmf_unit', 'perm_field') op.drop_column('cmf_unit', 'perm_id') op.drop_column('cmf_u_work_post', 'perm_field') op.drop_column('cmf_u_work_post', 'perm_id') op.drop_column('cmf_trigger', 'perm_encrypt') op.drop_column('cmf_trigger', 'perm_readonly') op.drop_column('cmf_trigger', 'perm_private') op.drop_column('cmf_trigger', 'perm_field') op.drop_column('cmf_trigger', 'perm_id') op.drop_column('cmf_task', 'perm_field') op.drop_column('cmf_task', 'perm_id') op.drop_column('cmf_tag_category', 'perm_encrypt') op.drop_column('cmf_tag_category', 'perm_readonly') op.drop_column('cmf_tag_category', 'perm_private') op.drop_column('cmf_tag_category', 'perm_field') op.drop_column('cmf_tag_category', 'perm_id') op.drop_column('cmf_tag', 'perm_encrypt') op.drop_column('cmf_tag', 'perm_readonly') op.drop_column('cmf_tag', 'perm_private') op.drop_column('cmf_tag', 'perm_field') op.drop_column('cmf_tag', 'perm_id') op.drop_column('cmf_subscription', 'perm_encrypt') op.drop_column('cmf_subscription', 'perm_readonly') op.drop_column('cmf_subscription', 'perm_private') op.drop_column('cmf_subscription', 'perm_field') op.drop_column('cmf_subscription', 'perm_id') op.drop_column('cmf_stock_outcoming_order_item', 'perm_encrypt') op.drop_column('cmf_stock_outcoming_order_item', 'perm_readonly') op.drop_column('cmf_stock_outcoming_order_item', 'perm_private') op.drop_column('cmf_stock_outcoming_order_item', 'perm_field') op.drop_column('cmf_stock_outcoming_order_item', 'perm_id') op.drop_column('cmf_stock_outcoming_order', 'perm_field') op.drop_column('cmf_stock_outcoming_order', 'perm_id') op.drop_column('cmf_stock_operation_item', 'perm_encrypt') op.drop_column('cmf_stock_operation_item', 'perm_readonly') op.drop_column('cmf_stock_operation_item', 'perm_private') op.drop_column('cmf_stock_operation_item', 'perm_field') op.drop_column('cmf_stock_operation_item', 'perm_id') op.drop_column('cmf_stock_operation', 'perm_encrypt') op.drop_column('cmf_stock_operation', 'perm_readonly') op.drop_column('cmf_stock_operation', 'perm_private') op.drop_column('cmf_stock_operation', 'perm_field') op.drop_column('cmf_stock_operation', 'perm_id') op.drop_column('cmf_stock_move_item', 'perm_encrypt') op.drop_column('cmf_stock_move_item', 'perm_readonly') op.drop_column('cmf_stock_move_item', 'perm_private') op.drop_column('cmf_stock_move_item', 'perm_field') op.drop_column('cmf_stock_move_item', 'perm_id') op.drop_column('cmf_stock_move', 'perm_field') op.drop_column('cmf_stock_move', 'perm_id') op.drop_column('cmf_stock_menu_group', 'perm_encrypt') op.drop_column('cmf_stock_menu_group', 'perm_readonly') op.drop_column('cmf_stock_menu_group', 'perm_private') op.drop_column('cmf_stock_menu_group', 'perm_field') op.drop_column('cmf_stock_menu_group', 'perm_id') op.drop_column('cmf_stock_item', 'perm_encrypt') op.drop_column('cmf_stock_item', 'perm_readonly') op.drop_column('cmf_stock_item', 'perm_private') op.drop_column('cmf_stock_item', 'perm_field') op.drop_column('cmf_stock_item', 'perm_id') op.drop_column('cmf_stock_inventory_item', 'perm_encrypt') op.drop_column('cmf_stock_inventory_item', 'perm_readonly') op.drop_column('cmf_stock_inventory_item', 'perm_private') op.drop_column('cmf_stock_inventory_item', 'perm_field') op.drop_column('cmf_stock_inventory_item', 'perm_id') op.drop_column('cmf_stock_inventory', 'perm_field') op.drop_column('cmf_stock_inventory', 'perm_id') op.drop_column('cmf_stock_initial_item', 'perm_encrypt') op.drop_column('cmf_stock_initial_item', 'perm_readonly') op.drop_column('cmf_stock_initial_item', 'perm_private') op.drop_column('cmf_stock_initial_item', 'perm_field') op.drop_column('cmf_stock_initial_item', 'perm_id') op.drop_column('cmf_stock_initial', 'perm_field') op.drop_column('cmf_stock_initial', 'perm_id') op.drop_column('cmf_stock_incoming_order_item', 'perm_encrypt') op.drop_column('cmf_stock_incoming_order_item', 'perm_readonly') op.drop_column('cmf_stock_incoming_order_item', 'perm_private') op.drop_column('cmf_stock_incoming_order_item', 'perm_field') op.drop_column('cmf_stock_incoming_order_item', 'perm_id') op.drop_column('cmf_stock_incoming_order', 'perm_field') op.drop_column('cmf_stock_incoming_order', 'perm_id') op.drop_column('cmf_stock', 'perm_encrypt') op.drop_column('cmf_stock', 'perm_readonly') op.drop_column('cmf_stock', 'perm_private') op.drop_column('cmf_stock', 'perm_field') op.drop_column('cmf_stock', 'perm_id') op.drop_column('cmf_status_opt', 'perm_encrypt') op.drop_column('cmf_status_opt', 'perm_readonly') op.drop_column('cmf_status_opt', 'perm_private') op.drop_column('cmf_status_opt', 'perm_field') op.drop_column('cmf_status_opt', 'perm_id') op.drop_column('cmf_status', 'perm_encrypt') op.drop_column('cmf_status', 'perm_readonly') op.drop_column('cmf_status', 'perm_private') op.drop_column('cmf_status', 'perm_field') op.drop_column('cmf_status', 'perm_id') op.drop_column('cmf_staff_control_settings', 'perm_encrypt') op.drop_column('cmf_staff_control_settings', 'perm_readonly') op.drop_column('cmf_staff_control_settings', 'perm_private') op.drop_column('cmf_staff_control_settings', 'perm_field') op.drop_column('cmf_staff_control_settings', 'perm_id') op.drop_column('cmf_sale_menu_group', 'perm_encrypt') op.drop_column('cmf_sale_menu_group', 'perm_readonly') op.drop_column('cmf_sale_menu_group', 'perm_private') op.drop_column('cmf_sale_menu_group', 'perm_field') op.drop_column('cmf_sale_menu_group', 'perm_id') op.drop_column('cmf_role', 'perm_encrypt') op.drop_column('cmf_role', 'perm_readonly') op.drop_column('cmf_role', 'perm_private') op.drop_column('cmf_role', 'perm_field') op.drop_column('cmf_role', 'perm_id') op.drop_column('cmf_roadmap', 'perm_field') op.drop_column('cmf_roadmap', 'perm_id') op.drop_column('cmf_refbook', 'perm_encrypt') op.drop_column('cmf_refbook', 'perm_readonly') op.drop_column('cmf_refbook', 'perm_private') op.drop_column('cmf_refbook', 'perm_field') op.drop_column('cmf_refbook', 'perm_id') op.drop_column('cmf_purchase_order_items', 'perm_field') op.drop_column('cmf_purchase_order_items', 'perm_id') op.drop_column('cmf_purchase_order', 'perm_field') op.drop_column('cmf_purchase_order', 'perm_id') op.drop_column('cmf_project', 'perm_field') op.drop_column('cmf_project', 'perm_id') op.drop_column('cmf_product', 'perm_encrypt') op.drop_column('cmf_product', 'perm_readonly') op.drop_column('cmf_product', 'perm_private') op.drop_column('cmf_product', 'perm_field') op.drop_column('cmf_product', 'perm_id') op.drop_column('cmf_print_tmpl', 'perm_encrypt') op.drop_column('cmf_print_tmpl', 'perm_readonly') op.drop_column('cmf_print_tmpl', 'perm_private') op.drop_column('cmf_print_tmpl', 'perm_field') op.drop_column('cmf_print_tmpl', 'perm_id') op.drop_column('cmf_price', 'perm_encrypt') op.drop_column('cmf_price', 'perm_readonly') op.drop_column('cmf_price', 'perm_private') op.drop_column('cmf_price', 'perm_field') op.drop_column('cmf_price', 'perm_id') op.drop_column('cmf_plugin_zadarma', 'perm_encrypt') op.drop_column('cmf_plugin_zadarma', 'perm_readonly') op.drop_column('cmf_plugin_zadarma', 'perm_private') op.drop_column('cmf_plugin_zadarma', 'perm_field') op.drop_column('cmf_plugin_zadarma', 'perm_id') op.drop_column('cmf_plugin_trello', 'perm_encrypt') op.drop_column('cmf_plugin_trello', 'perm_readonly') op.drop_column('cmf_plugin_trello', 'perm_private') op.drop_column('cmf_plugin_trello', 'perm_field') op.drop_column('cmf_plugin_trello', 'perm_id') op.drop_column('cmf_plugin_telphin', 'perm_encrypt') op.drop_column('cmf_plugin_telphin', 'perm_readonly') op.drop_column('cmf_plugin_telphin', 'perm_private') op.drop_column('cmf_plugin_telphin', 'perm_field') op.drop_column('cmf_plugin_telphin', 'perm_id') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_encrypt') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_readonly') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_private') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_field') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_id') op.drop_column('cmf_plugin_mail_box', 'perm_encrypt') op.drop_column('cmf_plugin_mail_box', 'perm_readonly') op.drop_column('cmf_plugin_mail_box', 'perm_private') op.drop_column('cmf_plugin_mail_box', 'perm_field') op.drop_column('cmf_plugin_mail_box', 'perm_id') op.drop_column('cmf_plugin_jira', 'perm_encrypt') op.drop_column('cmf_plugin_jira', 'perm_readonly') op.drop_column('cmf_plugin_jira', 'perm_private') op.drop_column('cmf_plugin_jira', 'perm_field') op.drop_column('cmf_plugin_jira', 'perm_id') op.drop_column('cmf_plugin_confluence', 'perm_encrypt') op.drop_column('cmf_plugin_confluence', 'perm_readonly') op.drop_column('cmf_plugin_confluence', 'perm_private') op.drop_column('cmf_plugin_confluence', 'perm_field') op.drop_column('cmf_plugin_confluence', 'perm_id') op.drop_column('cmf_plugin_asana', 'perm_encrypt') op.drop_column('cmf_plugin_asana', 'perm_readonly') op.drop_column('cmf_plugin_asana', 'perm_private') op.drop_column('cmf_plugin_asana', 'perm_field') op.drop_column('cmf_plugin_asana', 'perm_id') op.drop_column('cmf_plugin', 'perm_encrypt') op.drop_column('cmf_plugin', 'perm_readonly') op.drop_column('cmf_plugin', 'perm_private') op.drop_column('cmf_plugin', 'perm_field') op.drop_column('cmf_plugin', 'perm_id') op.drop_column('cmf_plan', 'perm_encrypt') op.drop_column('cmf_plan', 'perm_readonly') op.drop_column('cmf_plan', 'perm_private') op.drop_column('cmf_plan', 'perm_field') op.drop_column('cmf_plan', 'perm_id') op.drop_column('cmf_pipeline', 'perm_field') op.drop_column('cmf_pipeline', 'perm_id') op.drop_column('cmf_person_var', 'perm_encrypt') op.drop_column('cmf_person_var', 'perm_readonly') op.drop_column('cmf_person_var', 'perm_private') op.drop_column('cmf_person_var', 'perm_field') op.drop_column('cmf_person_var', 'perm_id') op.drop_column('cmf_person_group', 'perm_encrypt') op.drop_column('cmf_person_group', 'perm_readonly') op.drop_column('cmf_person_group', 'perm_private') op.drop_column('cmf_person_group', 'perm_field') op.drop_column('cmf_person_group', 'perm_id') op.drop_column('cmf_person', 'perm_encrypt') op.drop_column('cmf_person', 'perm_readonly') op.drop_column('cmf_person', 'perm_private') op.drop_column('cmf_person', 'perm_field') op.drop_column('cmf_person', 'perm_id') op.drop_column('cmf_payment', 'perm_field') op.drop_column('cmf_payment', 'perm_id') op.drop_column('cmf_org_unit', 'perm_encrypt') op.drop_column('cmf_org_unit', 'perm_readonly') op.drop_column('cmf_org_unit', 'perm_private') op.drop_column('cmf_org_unit', 'perm_field') op.drop_column('cmf_org_unit', 'perm_id') op.drop_column('cmf_notify', 'perm_encrypt') op.drop_column('cmf_notify', 'perm_readonly') op.drop_column('cmf_notify', 'perm_private') op.drop_column('cmf_notify', 'perm_field') op.drop_column('cmf_notify', 'perm_id') op.drop_column('cmf_menu_tree_item', 'perm_encrypt') op.drop_column('cmf_menu_tree_item', 'perm_readonly') op.drop_column('cmf_menu_tree_item', 'perm_private') op.drop_column('cmf_menu_tree_item', 'perm_field') op.drop_column('cmf_menu_tree_item', 'perm_id') op.drop_column('cmf_menu_tree', 'perm_encrypt') op.drop_column('cmf_menu_tree', 'perm_readonly') op.drop_column('cmf_menu_tree', 'perm_private') op.drop_column('cmf_menu_tree', 'perm_field') op.drop_column('cmf_menu_tree', 'perm_id') op.drop_column('cmf_menu_item', 'perm_encrypt') op.drop_column('cmf_menu_item', 'perm_readonly') op.drop_column('cmf_menu_item', 'perm_private') op.drop_column('cmf_menu_item', 'perm_field') op.drop_column('cmf_menu_item', 'perm_id') op.drop_column('cmf_mailbox', 'perm_encrypt') op.drop_column('cmf_mailbox', 'perm_readonly') op.drop_column('cmf_mailbox', 'perm_private') op.drop_column('cmf_mailbox', 'perm_field') op.drop_column('cmf_mailbox', 'perm_id') op.drop_column('cmf_mail_template', 'perm_encrypt') op.drop_column('cmf_mail_template', 'perm_readonly') op.drop_column('cmf_mail_template', 'perm_private') op.drop_column('cmf_mail_template', 'perm_field') op.drop_column('cmf_mail_template', 'perm_id') op.drop_column('cmf_mail_signature', 'perm_encrypt') op.drop_column('cmf_mail_signature', 'perm_readonly') op.drop_column('cmf_mail_signature', 'perm_private') op.drop_column('cmf_mail_signature', 'perm_field') op.drop_column('cmf_mail_signature', 'perm_id') op.drop_column('cmf_mail', 'perm_field') op.drop_column('cmf_mail', 'perm_id') op.drop_column('cmf_list', 'perm_field') op.drop_column('cmf_list', 'perm_id') op.drop_column('cmf_link', 'perm_encrypt') op.drop_column('cmf_link', 'perm_readonly') op.drop_column('cmf_link', 'perm_private') op.drop_column('cmf_link', 'perm_field') op.drop_column('cmf_link', 'perm_id') op.drop_column('cmf_lead_mailbox', 'perm_encrypt') op.drop_column('cmf_lead_mailbox', 'perm_readonly') op.drop_column('cmf_lead_mailbox', 'perm_private') op.drop_column('cmf_lead_mailbox', 'perm_field') op.drop_column('cmf_lead_mailbox', 'perm_id') op.drop_column('cmf_lead', 'perm_field') op.drop_column('cmf_lead', 'perm_id') op.drop_column('cmf_job', 'perm_encrypt') op.drop_column('cmf_job', 'perm_readonly') op.drop_column('cmf_job', 'perm_private') op.drop_column('cmf_job', 'perm_field') op.drop_column('cmf_job', 'perm_id') op.drop_column('cmf_invoice_items', 'perm_encrypt') op.drop_column('cmf_invoice_items', 'perm_readonly') op.drop_column('cmf_invoice_items', 'perm_private') op.drop_column('cmf_invoice_items', 'perm_field') op.drop_column('cmf_invoice_items', 'perm_id') op.drop_column('cmf_invoice', 'perm_field') op.drop_column('cmf_invoice', 'perm_id') op.drop_column('cmf_integration', 'perm_encrypt') op.drop_column('cmf_integration', 'perm_readonly') op.drop_column('cmf_integration', 'perm_private') op.drop_column('cmf_integration', 'perm_field') op.drop_column('cmf_integration', 'perm_id') op.drop_column('cmf_import', 'perm_field') op.drop_column('cmf_import', 'perm_id') op.drop_column('cmf_form_field', 'perm_encrypt') op.drop_column('cmf_form_field', 'perm_readonly') op.drop_column('cmf_form_field', 'perm_private') op.drop_column('cmf_form_field', 'perm_field') op.drop_column('cmf_form_field', 'perm_id') op.drop_column('cmf_form', 'perm_encrypt') op.drop_column('cmf_form', 'perm_readonly') op.drop_column('cmf_form', 'perm_private') op.drop_column('cmf_form', 'perm_field') op.drop_column('cmf_form', 'perm_id') op.drop_column('cmf_folder', 'perm_encrypt') op.drop_column('cmf_folder', 'perm_readonly') op.drop_column('cmf_folder', 'perm_private') op.drop_column('cmf_folder', 'perm_field') op.drop_column('cmf_folder', 'perm_id') op.drop_column('cmf_filter', 'perm_encrypt') op.drop_column('cmf_filter', 'perm_readonly') op.drop_column('cmf_filter', 'perm_private') op.drop_column('cmf_filter', 'perm_field') op.drop_column('cmf_filter', 'perm_id') op.drop_column('cmf_document_history', 'perm_encrypt') op.drop_column('cmf_document_history', 'perm_readonly') op.drop_column('cmf_document_history', 'perm_private') op.drop_column('cmf_document_history', 'perm_field') op.drop_column('cmf_document_history', 'perm_id') op.drop_column('cmf_document', 'perm_field') op.drop_column('cmf_document', 'perm_id') op.drop_column('cmf_deal_items', 'perm_encrypt') op.drop_column('cmf_deal_items', 'perm_readonly') op.drop_column('cmf_deal_items', 'perm_private') op.drop_column('cmf_deal_items', 'perm_field') op.drop_column('cmf_deal_items', 'perm_id') op.drop_column('cmf_deal', 'perm_field') op.drop_column('cmf_deal', 'perm_id') op.drop_column('cmf_currency', 'perm_encrypt') op.drop_column('cmf_currency', 'perm_readonly') op.drop_column('cmf_currency', 'perm_private') op.drop_column('cmf_currency', 'perm_field') op.drop_column('cmf_currency', 'perm_id') op.drop_column('cmf_contract', 'perm_encrypt') op.drop_column('cmf_contract', 'perm_readonly') op.drop_column('cmf_contract', 'perm_private') op.drop_column('cmf_contract', 'perm_field') op.drop_column('cmf_contract', 'perm_id') op.drop_column('cmf_company', 'perm_field') op.drop_column('cmf_company', 'perm_id') op.drop_column('cmf_comment', 'perm_encrypt') op.drop_column('cmf_comment', 'perm_readonly') op.drop_column('cmf_comment', 'perm_private') op.drop_column('cmf_comment', 'perm_field') op.drop_column('cmf_comment', 'perm_id') op.drop_column('cmf_chat_topic', 'perm_field') op.drop_column('cmf_chat_topic', 'perm_id') op.drop_column('cmf_chat_message', 'perm_encrypt') op.drop_column('cmf_chat_message', 'perm_readonly') op.drop_column('cmf_chat_message', 'perm_private') op.drop_column('cmf_chat_message', 'perm_field') op.drop_column('cmf_chat_message', 'perm_id') op.drop_column('cmf_chat_group', 'perm_field') op.drop_column('cmf_chat_group', 'perm_id') op.drop_column('cmf_card', 'perm_encrypt') op.drop_column('cmf_card', 'perm_readonly') op.drop_column('cmf_card', 'perm_private') op.drop_column('cmf_card', 'perm_field') op.drop_column('cmf_card', 'perm_id') op.drop_column('cmf_balance_operation', 'perm_encrypt') op.drop_column('cmf_balance_operation', 'perm_readonly') op.drop_column('cmf_balance_operation', 'perm_private') op.drop_column('cmf_balance_operation', 'perm_field') op.drop_column('cmf_balance_operation', 'perm_id') op.drop_column('cmf_balance', 'perm_encrypt') op.drop_column('cmf_balance', 'perm_readonly') op.drop_column('cmf_balance', 'perm_private') op.drop_column('cmf_balance', 'perm_field') op.drop_column('cmf_balance', 'perm_id') op.drop_column('cmf_attachment', 'perm_encrypt') op.drop_column('cmf_attachment', 'perm_readonly') op.drop_column('cmf_attachment', 'perm_private') op.drop_column('cmf_attachment', 'perm_field') op.drop_column('cmf_attachment', 'perm_id') op.drop_column('cmf_activity', 'perm_encrypt') op.drop_column('cmf_activity', 'perm_readonly') op.drop_column('cmf_activity', 'perm_private') op.drop_column('cmf_activity', 'perm_field') op.drop_column('cmf_activity', 'perm_id') op.drop_column('cmf_active_entity_filter', 'perm_encrypt') op.drop_column('cmf_active_entity_filter', 'perm_readonly') op.drop_column('cmf_active_entity_filter', 'perm_private') op.drop_column('cmf_active_entity_filter', 'perm_field') op.drop_column('cmf_active_entity_filter', 'perm_id') op.drop_index(op.f('ix_cmf_acl_subjects_root_id'), table_name='cmf_acl_subjects') op.drop_index(op.f('ix_cmf_acl_subjects_right_id'), table_name='cmf_acl_subjects') op.drop_index(op.f('ix_cmf_acl_subjects_parent_id'), table_name='cmf_acl_subjects') op.drop_index(op.f('ix_cmf_acl_subjects_left_id'), table_name='cmf_acl_subjects') op.drop_table('cmf_acl_subjects') op.drop_index(op.f('ix_cmf_acl_orderno'), table_name='cmf_acl') op.drop_table('cmf_acl') # ### end Alembic commands ###