"""add project v4 Revision ID: 3e767a969aa6 Revises: 1b4a830107f2 Create Date: 2024-03-19 18:30:46.361891 """ from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import postgresql # revision identifiers, used by Alembic. revision = '3e767a969aa6' down_revision = '1b4a830107f2' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('cmf_access_list', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_access_list_project_id'), 'cmf_access_list', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_access_list', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_access_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_access_rule_project_id'), 'cmf_access_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_access_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_activity', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_activity_project_id'), 'cmf_activity', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_activity', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_approve', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_approve_project_id'), 'cmf_approve', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_approve', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_approve_group', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_approve_group_project_id'), 'cmf_approve_group', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_approve_group', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_asset_cat', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_asset_cat_project_id'), 'cmf_asset_cat', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_asset_cat', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_asset_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_asset_scheme_project_id'), 'cmf_asset_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_asset_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_asset_type', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_asset_type_project_id'), 'cmf_asset_type', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_asset_type', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_asset_type_cat', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_asset_type_cat_project_id'), 'cmf_asset_type_cat', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_asset_type_cat', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_auth_ldap_plugin', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_auth_ldap_plugin_project_id'), 'cmf_auth_ldap_plugin', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_auth_ldap_plugin', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_auth_open_id_plugin', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_auth_open_id_plugin_project_id'), 'cmf_auth_open_id_plugin', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_auth_open_id_plugin', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_auth_plugin_data', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_auth_plugin_data_project_id'), 'cmf_auth_plugin_data', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_auth_plugin_data', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_automation_cron_trigger', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_automation_cron_trigger_project_id'), 'cmf_automation_cron_trigger', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_automation_cron_trigger', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_automation_crud_trigger', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_automation_crud_trigger_project_id'), 'cmf_automation_crud_trigger', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_automation_crud_trigger', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_automation_ui_form', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_automation_ui_form_project_id'), 'cmf_automation_ui_form', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_automation_ui_form', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_balance', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_balance_project_id'), 'cmf_balance', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_balance', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_balance_operation', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_balance_operation_project_id'), 'cmf_balance_operation', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_balance_operation', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_business_sector', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_business_sector_project_id'), 'cmf_business_sector', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_business_sector', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_calendar', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_calendar_project_id'), 'cmf_calendar', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_calendar', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_calendar_exclude', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_calendar_exclude_project_id'), 'cmf_calendar_exclude', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_calendar_exclude', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_calendar_exclude_interval', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_calendar_exclude_interval_project_id'), 'cmf_calendar_exclude_interval', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_calendar_exclude_interval', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_calendar_work_week', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_calendar_work_week_project_id'), 'cmf_calendar_work_week', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_calendar_work_week', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_calendar_work_week_interval', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_calendar_work_week_interval_project_id'), 'cmf_calendar_work_week_interval', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_calendar_work_week_interval', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_card', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_card_project_id'), 'cmf_card', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_card', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_chat_message', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_chat_message_project_id'), 'cmf_chat_message', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_message', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_client_job', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_client_job_project_id'), 'cmf_client_job', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_client_job', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_contract', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_contract_project_id'), 'cmf_contract', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_contract', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_currency', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_currency_project_id'), 'cmf_currency', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_currency', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_deal_items', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_deal_items_project_id'), 'cmf_deal_items', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_deal_items', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_document_history', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_document_history_project_id'), 'cmf_document_history', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_document_history', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_event_type', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_event_type_project_id'), 'cmf_event_type', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_event_type', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_filter', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_filter_project_id'), 'cmf_filter', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_filter', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_follower', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_follower_project_id'), 'cmf_follower', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_follower', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_form', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_form_project_id'), 'cmf_form', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_form', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_form_field', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_form_field_project_id'), 'cmf_form_field', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_form_field', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_gantt_baseline', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_gantt_baseline_project_id'), 'cmf_gantt_baseline', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_gantt_baseline', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_git_branch', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_git_branch_project_id'), 'cmf_git_branch', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_git_branch', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_git_commit', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_git_commit_project_id'), 'cmf_git_commit', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_git_commit', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_git_merge_request', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_git_merge_request_project_id'), 'cmf_git_merge_request', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_git_merge_request', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_git_repo', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_git_repo_project_id'), 'cmf_git_repo', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_git_repo', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_global_settings', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_global_settings_project_id'), 'cmf_global_settings', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_global_settings', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_html_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_html_scheme_project_id'), 'cmf_html_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_html_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_integration', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_integration_project_id'), 'cmf_integration', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_integration', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_invoice_items', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_invoice_items_project_id'), 'cmf_invoice_items', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_invoice_items', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_job', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_job_project_id'), 'cmf_job', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_job', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_kanban_board_card_color_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_kanban_board_card_color_rule_project_id'), 'cmf_kanban_board_card_color_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_kanban_board_card_color_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_kanban_board_column', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_kanban_board_column_project_id'), 'cmf_kanban_board_column', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_kanban_board_column', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_lead_mailbox', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_lead_mailbox_project_id'), 'cmf_lead_mailbox', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_lead_mailbox', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_license', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_license_project_id'), 'cmf_license', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_license', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_link', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_link_project_id'), 'cmf_link', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_link', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_location', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_location_project_id'), 'cmf_location', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_location', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_logic_type', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_logic_type_project_id'), 'cmf_logic_type', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_logic_type', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mail', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_project_id'), 'cmf_mail', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mail', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mail_signature', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_signature_project_id'), 'cmf_mail_signature', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mail_signature', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mail_template', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_template_project_id'), 'cmf_mail_template', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mail_template', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mailbox', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mailbox_project_id'), 'cmf_mailbox', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mailbox', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mailbox2', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mailbox2_project_id'), 'cmf_mailbox2', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mailbox2', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_mailbox_folder', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mailbox_folder_project_id'), 'cmf_mailbox_folder', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_mailbox_folder', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_menu_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_item_project_id'), 'cmf_menu_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_menu_tree', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_tree_project_id'), 'cmf_menu_tree', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_tree', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_menu_tree_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_tree_item_project_id'), 'cmf_menu_tree_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_tree_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_notepad', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_notepad_project_id'), 'cmf_notepad', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_notepad', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_notify', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_notify_project_id'), 'cmf_notify', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_notify', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_org_unit', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_org_unit_project_id'), 'cmf_org_unit', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_org_unit', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_person', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_project_id'), 'cmf_person', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_person', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_person_group', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_group_project_id'), 'cmf_person_group', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_person_group', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_person_var', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_var_project_id'), 'cmf_person_var', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_person_var', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plan', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plan_project_id'), 'cmf_plan', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plan', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_project_id'), 'cmf_plugin', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_asana', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_asana_project_id'), 'cmf_plugin_asana', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_asana', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_confluence', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_confluence_project_id'), 'cmf_plugin_confluence', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_confluence', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_csv', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_csv_project_id'), 'cmf_plugin_csv', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_csv', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_git', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_git_project_id'), 'cmf_plugin_git', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_git', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_jira', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_jira_project_id'), 'cmf_plugin_jira', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_jira', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_mail_box', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_mail_box_project_id'), 'cmf_plugin_mail_box', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_mail_box', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_s_m_s_gate_project_id'), 'cmf_plugin_s_m_s_gate', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_s_m_s_gate', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_telphin', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_telphin_project_id'), 'cmf_plugin_telphin', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_telphin', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_tracker_api', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_tracker_api_project_id'), 'cmf_plugin_tracker_api', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_tracker_api', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_trello', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_trello_project_id'), 'cmf_plugin_trello', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_trello', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_plugin_zadarma', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_zadarma_project_id'), 'cmf_plugin_zadarma', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_zadarma', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_price', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_price_project_id'), 'cmf_price', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_price', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_print_tmpl', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_print_tmpl_project_id'), 'cmf_print_tmpl', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_print_tmpl', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_product', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_product_project_id'), 'cmf_product', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_product', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_category', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_category_project_id'), 'cmf_project_category', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_category', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_notify_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_notify_scheme_project_id'), 'cmf_project_notify_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_notify_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_notify_scheme_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_notify_scheme_rule_project_id'), 'cmf_project_notify_scheme_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_notify_scheme_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_perm_permission', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_perm_permission_project_id'), 'cmf_project_perm_permission', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_perm_permission', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_perm_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_perm_scheme_project_id'), 'cmf_project_perm_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_perm_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_perm_scheme_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_perm_scheme_rule_project_id'), 'cmf_project_perm_scheme_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_perm_scheme_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_role', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_role_project_id'), 'cmf_project_role', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_role', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_project_role_assign', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_role_assign_project_id'), 'cmf_project_role_assign', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_project_role_assign', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_refbook', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_refbook_project_id'), 'cmf_refbook', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_refbook', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_relation_option', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_relation_option_project_id'), 'cmf_relation_option', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_relation_option', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_relation_type', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_relation_type_project_id'), 'cmf_relation_type', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_relation_type', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_rep_line_chart_row', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_rep_line_chart_row_project_id'), 'cmf_rep_line_chart_row', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_rep_line_chart_row', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_role', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_role_project_id'), 'cmf_role', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_role', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_request_group', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_request_group_project_id'), 'cmf_s_desk_request_group', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_request_group', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_request_type', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_request_type_project_id'), 'cmf_s_desk_request_type', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_request_type', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_sla', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_sla_project_id'), 'cmf_s_desk_sla', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_sla', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_sla_cycle', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_sla_cycle_project_id'), 'cmf_s_desk_sla_cycle', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_sla_cycle', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_sla_goal', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_sla_goal_project_id'), 'cmf_s_desk_sla_goal', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_sla_goal', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_s_desk_sla_trigger', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_s_desk_sla_trigger_project_id'), 'cmf_s_desk_sla_trigger', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_s_desk_sla_trigger', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_sale_menu_group', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_sale_menu_group_project_id'), 'cmf_sale_menu_group', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_sale_menu_group', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_scheme_wf_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_scheme_wf_rule_project_id'), 'cmf_scheme_wf_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_scheme_wf_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_security_level', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_security_level_project_id'), 'cmf_security_level', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_security_level', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_security_level_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_security_level_rule_project_id'), 'cmf_security_level_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_security_level_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_security_level_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_security_level_scheme_project_id'), 'cmf_security_level_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_security_level_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_staff_control_settings', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_staff_control_settings_project_id'), 'cmf_staff_control_settings', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_staff_control_settings', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_status', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_project_id'), 'cmf_status', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_status', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_status_code', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_code_project_id'), 'cmf_status_code', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_status_code', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_status_opt', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_opt_project_id'), 'cmf_status_opt', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_status_opt', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_project_id'), 'cmf_stock', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_incoming_order_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_incoming_order_item_project_id'), 'cmf_stock_incoming_order_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_incoming_order_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_initial_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_initial_item_project_id'), 'cmf_stock_initial_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_initial_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_inventory_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_inventory_item_project_id'), 'cmf_stock_inventory_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_inventory_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_item_project_id'), 'cmf_stock_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_menu_group', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_menu_group_project_id'), 'cmf_stock_menu_group', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_menu_group', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_move_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_move_item_project_id'), 'cmf_stock_move_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_move_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_operation', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_operation_project_id'), 'cmf_stock_operation', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_operation', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_operation_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_operation_item_project_id'), 'cmf_stock_operation_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_operation_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_stock_outcoming_order_item', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_outcoming_order_item_project_id'), 'cmf_stock_outcoming_order_item', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_outcoming_order_item', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_subscription', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_subscription_project_id'), 'cmf_subscription', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_subscription', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_synonym', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_synonym_project_id'), 'cmf_synonym', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_synonym', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_tag', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_tag_project_id'), 'cmf_tag', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_tag', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_tag_category', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_tag_category_project_id'), 'cmf_tag_category', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_tag_category', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_task_res_assign', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_task_res_assign_project_id'), 'cmf_task_res_assign', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_task_res_assign', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_task_res_assign_timephase', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_task_res_assign_timephase_project_id'), 'cmf_task_res_assign_timephase', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_task_res_assign_timephase', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_time_tracker', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_time_tracker_project_id'), 'cmf_time_tracker', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_time_tracker', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_timesheets_team', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_timesheets_team_project_id'), 'cmf_timesheets_team', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_timesheets_team', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_timesheets_team_member', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_timesheets_team_member_project_id'), 'cmf_timesheets_team_member', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_timesheets_team_member', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_trans', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trans_project_id'), 'cmf_trans', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_trans', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_trans_action', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trans_action_project_id'), 'cmf_trans_action', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_trans_action', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_trans_filter', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trans_filter_project_id'), 'cmf_trans_filter', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_trans_filter', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_trans_valid', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trans_valid_project_id'), 'cmf_trans_valid', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_trans_valid', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_trigger', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trigger_project_id'), 'cmf_trigger', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_trigger', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_ui_form', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_ui_form_project_id'), 'cmf_ui_form', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_ui_form', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_ui_form_scheme', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_ui_form_scheme_project_id'), 'cmf_ui_form_scheme', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_ui_form_scheme', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_ui_form_scheme_rule', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_ui_form_scheme_rule_project_id'), 'cmf_ui_form_scheme_rule', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_ui_form_scheme_rule', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_unit', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_unit_project_id'), 'cmf_unit', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_unit', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_webhook', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_webhook_project_id'), 'cmf_webhook', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_webhook', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_whatsapp', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_whatsapp_project_id'), 'cmf_whatsapp', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_whatsapp', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_wiki', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_wiki_project_id'), 'cmf_wiki', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_wiki', 'cmf_project', ['project_id'], ['id']) op.add_column('cmf_workflow', sa.Column('project_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_workflow_project_id'), 'cmf_workflow', ['project_id'], unique=False) op.create_foreign_key(None, 'cmf_workflow', 'cmf_project', ['project_id'], ['id']) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'cmf_workflow', type_='foreignkey') op.drop_index(op.f('ix_cmf_workflow_project_id'), table_name='cmf_workflow') op.drop_column('cmf_workflow', 'project_id') op.drop_constraint(None, 'cmf_wiki', type_='foreignkey') op.drop_index(op.f('ix_cmf_wiki_project_id'), table_name='cmf_wiki') op.drop_column('cmf_wiki', 'project_id') op.drop_constraint(None, 'cmf_whatsapp', type_='foreignkey') op.drop_index(op.f('ix_cmf_whatsapp_project_id'), table_name='cmf_whatsapp') op.drop_column('cmf_whatsapp', 'project_id') op.drop_constraint(None, 'cmf_webhook', type_='foreignkey') op.drop_index(op.f('ix_cmf_webhook_project_id'), table_name='cmf_webhook') op.drop_column('cmf_webhook', 'project_id') op.drop_constraint(None, 'cmf_unit', type_='foreignkey') op.drop_index(op.f('ix_cmf_unit_project_id'), table_name='cmf_unit') op.drop_column('cmf_unit', 'project_id') op.drop_constraint(None, 'cmf_ui_form_scheme_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_ui_form_scheme_rule_project_id'), table_name='cmf_ui_form_scheme_rule') op.drop_column('cmf_ui_form_scheme_rule', 'project_id') op.drop_constraint(None, 'cmf_ui_form_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_ui_form_scheme_project_id'), table_name='cmf_ui_form_scheme') op.drop_column('cmf_ui_form_scheme', 'project_id') op.drop_constraint(None, 'cmf_ui_form', type_='foreignkey') op.drop_index(op.f('ix_cmf_ui_form_project_id'), table_name='cmf_ui_form') op.drop_column('cmf_ui_form', 'project_id') op.drop_constraint(None, 'cmf_trigger', type_='foreignkey') op.drop_index(op.f('ix_cmf_trigger_project_id'), table_name='cmf_trigger') op.drop_column('cmf_trigger', 'project_id') op.drop_constraint(None, 'cmf_trans_valid', type_='foreignkey') op.drop_index(op.f('ix_cmf_trans_valid_project_id'), table_name='cmf_trans_valid') op.drop_column('cmf_trans_valid', 'project_id') op.drop_constraint(None, 'cmf_trans_filter', type_='foreignkey') op.drop_index(op.f('ix_cmf_trans_filter_project_id'), table_name='cmf_trans_filter') op.drop_column('cmf_trans_filter', 'project_id') op.drop_constraint(None, 'cmf_trans_action', type_='foreignkey') op.drop_index(op.f('ix_cmf_trans_action_project_id'), table_name='cmf_trans_action') op.drop_column('cmf_trans_action', 'project_id') op.drop_constraint(None, 'cmf_trans', type_='foreignkey') op.drop_index(op.f('ix_cmf_trans_project_id'), table_name='cmf_trans') op.drop_column('cmf_trans', 'project_id') op.drop_constraint(None, 'cmf_timesheets_team_member', type_='foreignkey') op.drop_index(op.f('ix_cmf_timesheets_team_member_project_id'), table_name='cmf_timesheets_team_member') op.drop_column('cmf_timesheets_team_member', 'project_id') op.drop_constraint(None, 'cmf_timesheets_team', type_='foreignkey') op.drop_index(op.f('ix_cmf_timesheets_team_project_id'), table_name='cmf_timesheets_team') op.drop_column('cmf_timesheets_team', 'project_id') op.drop_constraint(None, 'cmf_time_tracker', type_='foreignkey') op.drop_index(op.f('ix_cmf_time_tracker_project_id'), table_name='cmf_time_tracker') op.drop_column('cmf_time_tracker', 'project_id') op.drop_constraint(None, 'cmf_task_res_assign_timephase', type_='foreignkey') op.drop_index(op.f('ix_cmf_task_res_assign_timephase_project_id'), table_name='cmf_task_res_assign_timephase') op.drop_column('cmf_task_res_assign_timephase', 'project_id') op.drop_constraint(None, 'cmf_task_res_assign', type_='foreignkey') op.drop_index(op.f('ix_cmf_task_res_assign_project_id'), table_name='cmf_task_res_assign') op.drop_column('cmf_task_res_assign', 'project_id') op.drop_constraint(None, 'cmf_tag_category', type_='foreignkey') op.drop_index(op.f('ix_cmf_tag_category_project_id'), table_name='cmf_tag_category') op.drop_column('cmf_tag_category', 'project_id') op.drop_constraint(None, 'cmf_tag', type_='foreignkey') op.drop_index(op.f('ix_cmf_tag_project_id'), table_name='cmf_tag') op.drop_column('cmf_tag', 'project_id') op.drop_constraint(None, 'cmf_synonym', type_='foreignkey') op.drop_index(op.f('ix_cmf_synonym_project_id'), table_name='cmf_synonym') op.drop_column('cmf_synonym', 'project_id') op.drop_constraint(None, 'cmf_subscription', type_='foreignkey') op.drop_index(op.f('ix_cmf_subscription_project_id'), table_name='cmf_subscription') op.drop_column('cmf_subscription', 'project_id') op.drop_constraint(None, 'cmf_stock_outcoming_order_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_outcoming_order_item_project_id'), table_name='cmf_stock_outcoming_order_item') op.drop_column('cmf_stock_outcoming_order_item', 'project_id') op.drop_constraint(None, 'cmf_stock_operation_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_operation_item_project_id'), table_name='cmf_stock_operation_item') op.drop_column('cmf_stock_operation_item', 'project_id') op.drop_constraint(None, 'cmf_stock_operation', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_operation_project_id'), table_name='cmf_stock_operation') op.drop_column('cmf_stock_operation', 'project_id') op.drop_constraint(None, 'cmf_stock_move_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_move_item_project_id'), table_name='cmf_stock_move_item') op.drop_column('cmf_stock_move_item', 'project_id') op.drop_constraint(None, 'cmf_stock_menu_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_menu_group_project_id'), table_name='cmf_stock_menu_group') op.drop_column('cmf_stock_menu_group', 'project_id') op.drop_constraint(None, 'cmf_stock_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_item_project_id'), table_name='cmf_stock_item') op.drop_column('cmf_stock_item', 'project_id') op.drop_constraint(None, 'cmf_stock_inventory_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_inventory_item_project_id'), table_name='cmf_stock_inventory_item') op.drop_column('cmf_stock_inventory_item', 'project_id') op.drop_constraint(None, 'cmf_stock_initial_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_initial_item_project_id'), table_name='cmf_stock_initial_item') op.drop_column('cmf_stock_initial_item', 'project_id') op.drop_constraint(None, 'cmf_stock_incoming_order_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_incoming_order_item_project_id'), table_name='cmf_stock_incoming_order_item') op.drop_column('cmf_stock_incoming_order_item', 'project_id') op.drop_constraint(None, 'cmf_stock', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_project_id'), table_name='cmf_stock') op.drop_column('cmf_stock', 'project_id') op.drop_constraint(None, 'cmf_status_opt', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_opt_project_id'), table_name='cmf_status_opt') op.drop_column('cmf_status_opt', 'project_id') op.drop_constraint(None, 'cmf_status_code', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_code_project_id'), table_name='cmf_status_code') op.drop_column('cmf_status_code', 'project_id') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_project_id'), table_name='cmf_status') op.drop_column('cmf_status', 'project_id') op.drop_constraint(None, 'cmf_staff_control_settings', type_='foreignkey') op.drop_index(op.f('ix_cmf_staff_control_settings_project_id'), table_name='cmf_staff_control_settings') op.drop_column('cmf_staff_control_settings', 'project_id') op.drop_constraint(None, 'cmf_security_level_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_security_level_scheme_project_id'), table_name='cmf_security_level_scheme') op.drop_column('cmf_security_level_scheme', 'project_id') op.drop_constraint(None, 'cmf_security_level_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_security_level_rule_project_id'), table_name='cmf_security_level_rule') op.drop_column('cmf_security_level_rule', 'project_id') op.drop_constraint(None, 'cmf_security_level', type_='foreignkey') op.drop_index(op.f('ix_cmf_security_level_project_id'), table_name='cmf_security_level') op.drop_column('cmf_security_level', 'project_id') op.drop_constraint(None, 'cmf_scheme_wf_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_scheme_wf_rule_project_id'), table_name='cmf_scheme_wf_rule') op.drop_column('cmf_scheme_wf_rule', 'project_id') op.drop_constraint(None, 'cmf_sale_menu_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_sale_menu_group_project_id'), table_name='cmf_sale_menu_group') op.drop_column('cmf_sale_menu_group', 'project_id') op.drop_constraint(None, 'cmf_s_desk_sla_trigger', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_sla_trigger_project_id'), table_name='cmf_s_desk_sla_trigger') op.drop_column('cmf_s_desk_sla_trigger', 'project_id') op.drop_constraint(None, 'cmf_s_desk_sla_goal', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_sla_goal_project_id'), table_name='cmf_s_desk_sla_goal') op.drop_column('cmf_s_desk_sla_goal', 'project_id') op.drop_constraint(None, 'cmf_s_desk_sla_cycle', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_sla_cycle_project_id'), table_name='cmf_s_desk_sla_cycle') op.drop_column('cmf_s_desk_sla_cycle', 'project_id') op.drop_constraint(None, 'cmf_s_desk_sla', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_sla_project_id'), table_name='cmf_s_desk_sla') op.drop_column('cmf_s_desk_sla', 'project_id') op.drop_constraint(None, 'cmf_s_desk_request_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_request_type_project_id'), table_name='cmf_s_desk_request_type') op.drop_column('cmf_s_desk_request_type', 'project_id') op.drop_constraint(None, 'cmf_s_desk_request_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_s_desk_request_group_project_id'), table_name='cmf_s_desk_request_group') op.drop_column('cmf_s_desk_request_group', 'project_id') op.drop_constraint(None, 'cmf_role', type_='foreignkey') op.drop_index(op.f('ix_cmf_role_project_id'), table_name='cmf_role') op.drop_column('cmf_role', 'project_id') op.drop_constraint(None, 'cmf_rep_line_chart_row', type_='foreignkey') op.drop_index(op.f('ix_cmf_rep_line_chart_row_project_id'), table_name='cmf_rep_line_chart_row') op.drop_column('cmf_rep_line_chart_row', 'project_id') op.drop_constraint(None, 'cmf_relation_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_relation_type_project_id'), table_name='cmf_relation_type') op.drop_column('cmf_relation_type', 'project_id') op.drop_constraint(None, 'cmf_relation_option', type_='foreignkey') op.drop_index(op.f('ix_cmf_relation_option_project_id'), table_name='cmf_relation_option') op.drop_column('cmf_relation_option', 'project_id') op.drop_constraint(None, 'cmf_refbook', type_='foreignkey') op.drop_index(op.f('ix_cmf_refbook_project_id'), table_name='cmf_refbook') op.drop_column('cmf_refbook', 'project_id') op.drop_constraint(None, 'cmf_project_role_assign', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_role_assign_project_id'), table_name='cmf_project_role_assign') op.drop_column('cmf_project_role_assign', 'project_id') op.drop_constraint(None, 'cmf_project_role', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_role_project_id'), table_name='cmf_project_role') op.drop_column('cmf_project_role', 'project_id') op.drop_constraint(None, 'cmf_project_perm_scheme_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_perm_scheme_rule_project_id'), table_name='cmf_project_perm_scheme_rule') op.drop_column('cmf_project_perm_scheme_rule', 'project_id') op.drop_constraint(None, 'cmf_project_perm_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_perm_scheme_project_id'), table_name='cmf_project_perm_scheme') op.drop_column('cmf_project_perm_scheme', 'project_id') op.drop_constraint(None, 'cmf_project_perm_permission', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_perm_permission_project_id'), table_name='cmf_project_perm_permission') op.drop_column('cmf_project_perm_permission', 'project_id') op.drop_constraint(None, 'cmf_project_notify_scheme_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_notify_scheme_rule_project_id'), table_name='cmf_project_notify_scheme_rule') op.drop_column('cmf_project_notify_scheme_rule', 'project_id') op.drop_constraint(None, 'cmf_project_notify_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_notify_scheme_project_id'), table_name='cmf_project_notify_scheme') op.drop_column('cmf_project_notify_scheme', 'project_id') op.drop_constraint(None, 'cmf_project_category', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_category_project_id'), table_name='cmf_project_category') op.drop_column('cmf_project_category', 'project_id') op.drop_constraint(None, 'cmf_product', type_='foreignkey') op.drop_index(op.f('ix_cmf_product_project_id'), table_name='cmf_product') op.drop_column('cmf_product', 'project_id') op.drop_constraint(None, 'cmf_print_tmpl', type_='foreignkey') op.drop_index(op.f('ix_cmf_print_tmpl_project_id'), table_name='cmf_print_tmpl') op.drop_column('cmf_print_tmpl', 'project_id') op.drop_constraint(None, 'cmf_price', type_='foreignkey') op.drop_index(op.f('ix_cmf_price_project_id'), table_name='cmf_price') op.drop_column('cmf_price', 'project_id') op.drop_constraint(None, 'cmf_plugin_zadarma', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_zadarma_project_id'), table_name='cmf_plugin_zadarma') op.drop_column('cmf_plugin_zadarma', 'project_id') op.drop_constraint(None, 'cmf_plugin_trello', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_trello_project_id'), table_name='cmf_plugin_trello') op.drop_column('cmf_plugin_trello', 'project_id') op.drop_constraint(None, 'cmf_plugin_tracker_api', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_tracker_api_project_id'), table_name='cmf_plugin_tracker_api') op.drop_column('cmf_plugin_tracker_api', 'project_id') op.drop_constraint(None, 'cmf_plugin_telphin', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_telphin_project_id'), table_name='cmf_plugin_telphin') op.drop_column('cmf_plugin_telphin', 'project_id') op.drop_constraint(None, 'cmf_plugin_s_m_s_gate', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_s_m_s_gate_project_id'), table_name='cmf_plugin_s_m_s_gate') op.drop_column('cmf_plugin_s_m_s_gate', 'project_id') op.drop_constraint(None, 'cmf_plugin_mail_box', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_mail_box_project_id'), table_name='cmf_plugin_mail_box') op.drop_column('cmf_plugin_mail_box', 'project_id') op.drop_constraint(None, 'cmf_plugin_jira', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_jira_project_id'), table_name='cmf_plugin_jira') op.drop_column('cmf_plugin_jira', 'project_id') op.drop_constraint(None, 'cmf_plugin_git', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_git_project_id'), table_name='cmf_plugin_git') op.drop_column('cmf_plugin_git', 'project_id') op.drop_constraint(None, 'cmf_plugin_csv', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_csv_project_id'), table_name='cmf_plugin_csv') op.drop_column('cmf_plugin_csv', 'project_id') op.drop_constraint(None, 'cmf_plugin_confluence', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_confluence_project_id'), table_name='cmf_plugin_confluence') op.drop_column('cmf_plugin_confluence', 'project_id') op.drop_constraint(None, 'cmf_plugin_asana', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_asana_project_id'), table_name='cmf_plugin_asana') op.drop_column('cmf_plugin_asana', 'project_id') op.drop_constraint(None, 'cmf_plugin', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_project_id'), table_name='cmf_plugin') op.drop_column('cmf_plugin', 'project_id') op.drop_constraint(None, 'cmf_plan', type_='foreignkey') op.drop_index(op.f('ix_cmf_plan_project_id'), table_name='cmf_plan') op.drop_column('cmf_plan', 'project_id') op.drop_constraint(None, 'cmf_person_var', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_var_project_id'), table_name='cmf_person_var') op.drop_column('cmf_person_var', 'project_id') op.drop_constraint(None, 'cmf_person_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_group_project_id'), table_name='cmf_person_group') op.drop_column('cmf_person_group', 'project_id') op.drop_constraint(None, 'cmf_person', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_project_id'), table_name='cmf_person') op.drop_column('cmf_person', 'project_id') op.drop_constraint(None, 'cmf_org_unit', type_='foreignkey') op.drop_index(op.f('ix_cmf_org_unit_project_id'), table_name='cmf_org_unit') op.drop_column('cmf_org_unit', 'project_id') op.drop_constraint(None, 'cmf_notify', type_='foreignkey') op.drop_index(op.f('ix_cmf_notify_project_id'), table_name='cmf_notify') op.drop_column('cmf_notify', 'project_id') op.drop_constraint(None, 'cmf_notepad', type_='foreignkey') op.drop_index(op.f('ix_cmf_notepad_project_id'), table_name='cmf_notepad') op.drop_column('cmf_notepad', 'project_id') op.drop_constraint(None, 'cmf_menu_tree_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_tree_item_project_id'), table_name='cmf_menu_tree_item') op.drop_column('cmf_menu_tree_item', 'project_id') op.drop_constraint(None, 'cmf_menu_tree', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_tree_project_id'), table_name='cmf_menu_tree') op.drop_column('cmf_menu_tree', 'project_id') op.drop_constraint(None, 'cmf_menu_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_item_project_id'), table_name='cmf_menu_item') op.drop_column('cmf_menu_item', 'project_id') op.drop_constraint(None, 'cmf_mailbox_folder', type_='foreignkey') op.drop_index(op.f('ix_cmf_mailbox_folder_project_id'), table_name='cmf_mailbox_folder') op.drop_column('cmf_mailbox_folder', 'project_id') op.drop_constraint(None, 'cmf_mailbox2', type_='foreignkey') op.drop_index(op.f('ix_cmf_mailbox2_project_id'), table_name='cmf_mailbox2') op.drop_column('cmf_mailbox2', 'project_id') op.drop_constraint(None, 'cmf_mailbox', type_='foreignkey') op.drop_index(op.f('ix_cmf_mailbox_project_id'), table_name='cmf_mailbox') op.drop_column('cmf_mailbox', 'project_id') op.drop_constraint(None, 'cmf_mail_template', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_template_project_id'), table_name='cmf_mail_template') op.drop_column('cmf_mail_template', 'project_id') op.drop_constraint(None, 'cmf_mail_signature', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_signature_project_id'), table_name='cmf_mail_signature') op.drop_column('cmf_mail_signature', 'project_id') op.drop_constraint(None, 'cmf_mail', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_project_id'), table_name='cmf_mail') op.drop_column('cmf_mail', 'project_id') op.drop_constraint(None, 'cmf_logic_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_logic_type_project_id'), table_name='cmf_logic_type') op.drop_column('cmf_logic_type', 'project_id') op.drop_constraint(None, 'cmf_location', type_='foreignkey') op.drop_index(op.f('ix_cmf_location_project_id'), table_name='cmf_location') op.drop_column('cmf_location', 'project_id') op.drop_constraint(None, 'cmf_link', type_='foreignkey') op.drop_index(op.f('ix_cmf_link_project_id'), table_name='cmf_link') op.drop_column('cmf_link', 'project_id') op.drop_constraint(None, 'cmf_license', type_='foreignkey') op.drop_index(op.f('ix_cmf_license_project_id'), table_name='cmf_license') op.drop_column('cmf_license', 'project_id') op.drop_constraint(None, 'cmf_lead_mailbox', type_='foreignkey') op.drop_index(op.f('ix_cmf_lead_mailbox_project_id'), table_name='cmf_lead_mailbox') op.drop_column('cmf_lead_mailbox', 'project_id') op.drop_constraint(None, 'cmf_kanban_board_column', type_='foreignkey') op.drop_index(op.f('ix_cmf_kanban_board_column_project_id'), table_name='cmf_kanban_board_column') op.drop_column('cmf_kanban_board_column', 'project_id') op.drop_constraint(None, 'cmf_kanban_board_card_color_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_kanban_board_card_color_rule_project_id'), table_name='cmf_kanban_board_card_color_rule') op.drop_column('cmf_kanban_board_card_color_rule', 'project_id') op.drop_constraint(None, 'cmf_job', type_='foreignkey') op.drop_index(op.f('ix_cmf_job_project_id'), table_name='cmf_job') op.drop_column('cmf_job', 'project_id') op.drop_constraint(None, 'cmf_invoice_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_invoice_items_project_id'), table_name='cmf_invoice_items') op.drop_column('cmf_invoice_items', 'project_id') op.drop_constraint(None, 'cmf_integration', type_='foreignkey') op.drop_index(op.f('ix_cmf_integration_project_id'), table_name='cmf_integration') op.drop_column('cmf_integration', 'project_id') op.drop_constraint(None, 'cmf_html_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_html_scheme_project_id'), table_name='cmf_html_scheme') op.drop_column('cmf_html_scheme', 'project_id') op.drop_constraint(None, 'cmf_global_settings', type_='foreignkey') op.drop_index(op.f('ix_cmf_global_settings_project_id'), table_name='cmf_global_settings') op.drop_column('cmf_global_settings', 'project_id') op.drop_constraint(None, 'cmf_git_repo', type_='foreignkey') op.drop_index(op.f('ix_cmf_git_repo_project_id'), table_name='cmf_git_repo') op.drop_column('cmf_git_repo', 'project_id') op.drop_constraint(None, 'cmf_git_merge_request', type_='foreignkey') op.drop_index(op.f('ix_cmf_git_merge_request_project_id'), table_name='cmf_git_merge_request') op.drop_column('cmf_git_merge_request', 'project_id') op.drop_constraint(None, 'cmf_git_commit', type_='foreignkey') op.drop_index(op.f('ix_cmf_git_commit_project_id'), table_name='cmf_git_commit') op.drop_column('cmf_git_commit', 'project_id') op.drop_constraint(None, 'cmf_git_branch', type_='foreignkey') op.drop_index(op.f('ix_cmf_git_branch_project_id'), table_name='cmf_git_branch') op.drop_column('cmf_git_branch', 'project_id') op.drop_constraint(None, 'cmf_gantt_baseline', type_='foreignkey') op.drop_index(op.f('ix_cmf_gantt_baseline_project_id'), table_name='cmf_gantt_baseline') op.drop_column('cmf_gantt_baseline', 'project_id') op.drop_constraint(None, 'cmf_form_field', type_='foreignkey') op.drop_index(op.f('ix_cmf_form_field_project_id'), table_name='cmf_form_field') op.drop_column('cmf_form_field', 'project_id') op.drop_constraint(None, 'cmf_form', type_='foreignkey') op.drop_index(op.f('ix_cmf_form_project_id'), table_name='cmf_form') op.drop_column('cmf_form', 'project_id') op.drop_constraint(None, 'cmf_follower', type_='foreignkey') op.drop_index(op.f('ix_cmf_follower_project_id'), table_name='cmf_follower') op.drop_column('cmf_follower', 'project_id') op.drop_constraint(None, 'cmf_filter', type_='foreignkey') op.drop_index(op.f('ix_cmf_filter_project_id'), table_name='cmf_filter') op.drop_column('cmf_filter', 'project_id') op.drop_constraint(None, 'cmf_event_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_event_type_project_id'), table_name='cmf_event_type') op.drop_column('cmf_event_type', 'project_id') op.drop_constraint(None, 'cmf_document_history', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_history_project_id'), table_name='cmf_document_history') op.drop_column('cmf_document_history', 'project_id') op.drop_constraint(None, 'cmf_deal_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_deal_items_project_id'), table_name='cmf_deal_items') op.drop_column('cmf_deal_items', 'project_id') op.drop_constraint(None, 'cmf_currency', type_='foreignkey') op.drop_index(op.f('ix_cmf_currency_project_id'), table_name='cmf_currency') op.drop_column('cmf_currency', 'project_id') op.drop_constraint(None, 'cmf_contract', type_='foreignkey') op.drop_index(op.f('ix_cmf_contract_project_id'), table_name='cmf_contract') op.drop_column('cmf_contract', 'project_id') op.drop_constraint(None, 'cmf_client_job', type_='foreignkey') op.drop_index(op.f('ix_cmf_client_job_project_id'), table_name='cmf_client_job') op.drop_column('cmf_client_job', 'project_id') op.drop_constraint(None, 'cmf_chat_message', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_message_project_id'), table_name='cmf_chat_message') op.drop_column('cmf_chat_message', 'project_id') op.drop_constraint(None, 'cmf_card', type_='foreignkey') op.drop_index(op.f('ix_cmf_card_project_id'), table_name='cmf_card') op.drop_column('cmf_card', 'project_id') op.drop_constraint(None, 'cmf_calendar_work_week_interval', type_='foreignkey') op.drop_index(op.f('ix_cmf_calendar_work_week_interval_project_id'), table_name='cmf_calendar_work_week_interval') op.drop_column('cmf_calendar_work_week_interval', 'project_id') op.drop_constraint(None, 'cmf_calendar_work_week', type_='foreignkey') op.drop_index(op.f('ix_cmf_calendar_work_week_project_id'), table_name='cmf_calendar_work_week') op.drop_column('cmf_calendar_work_week', 'project_id') op.drop_constraint(None, 'cmf_calendar_exclude_interval', type_='foreignkey') op.drop_index(op.f('ix_cmf_calendar_exclude_interval_project_id'), table_name='cmf_calendar_exclude_interval') op.drop_column('cmf_calendar_exclude_interval', 'project_id') op.drop_constraint(None, 'cmf_calendar_exclude', type_='foreignkey') op.drop_index(op.f('ix_cmf_calendar_exclude_project_id'), table_name='cmf_calendar_exclude') op.drop_column('cmf_calendar_exclude', 'project_id') op.drop_constraint(None, 'cmf_calendar', type_='foreignkey') op.drop_index(op.f('ix_cmf_calendar_project_id'), table_name='cmf_calendar') op.drop_column('cmf_calendar', 'project_id') op.drop_constraint(None, 'cmf_business_sector', type_='foreignkey') op.drop_index(op.f('ix_cmf_business_sector_project_id'), table_name='cmf_business_sector') op.drop_column('cmf_business_sector', 'project_id') op.drop_constraint(None, 'cmf_balance_operation', type_='foreignkey') op.drop_index(op.f('ix_cmf_balance_operation_project_id'), table_name='cmf_balance_operation') op.drop_column('cmf_balance_operation', 'project_id') op.drop_constraint(None, 'cmf_balance', type_='foreignkey') op.drop_index(op.f('ix_cmf_balance_project_id'), table_name='cmf_balance') op.drop_column('cmf_balance', 'project_id') op.drop_constraint(None, 'cmf_automation_ui_form', type_='foreignkey') op.drop_index(op.f('ix_cmf_automation_ui_form_project_id'), table_name='cmf_automation_ui_form') op.drop_column('cmf_automation_ui_form', 'project_id') op.drop_constraint(None, 'cmf_automation_crud_trigger', type_='foreignkey') op.drop_index(op.f('ix_cmf_automation_crud_trigger_project_id'), table_name='cmf_automation_crud_trigger') op.drop_column('cmf_automation_crud_trigger', 'project_id') op.drop_constraint(None, 'cmf_automation_cron_trigger', type_='foreignkey') op.drop_index(op.f('ix_cmf_automation_cron_trigger_project_id'), table_name='cmf_automation_cron_trigger') op.drop_column('cmf_automation_cron_trigger', 'project_id') op.drop_constraint(None, 'cmf_auth_plugin_data', type_='foreignkey') op.drop_index(op.f('ix_cmf_auth_plugin_data_project_id'), table_name='cmf_auth_plugin_data') op.drop_column('cmf_auth_plugin_data', 'project_id') op.drop_constraint(None, 'cmf_auth_open_id_plugin', type_='foreignkey') op.drop_index(op.f('ix_cmf_auth_open_id_plugin_project_id'), table_name='cmf_auth_open_id_plugin') op.drop_column('cmf_auth_open_id_plugin', 'project_id') op.drop_constraint(None, 'cmf_auth_ldap_plugin', type_='foreignkey') op.drop_index(op.f('ix_cmf_auth_ldap_plugin_project_id'), table_name='cmf_auth_ldap_plugin') op.drop_column('cmf_auth_ldap_plugin', 'project_id') op.drop_constraint(None, 'cmf_asset_type_cat', type_='foreignkey') op.drop_index(op.f('ix_cmf_asset_type_cat_project_id'), table_name='cmf_asset_type_cat') op.drop_column('cmf_asset_type_cat', 'project_id') op.drop_constraint(None, 'cmf_asset_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_asset_type_project_id'), table_name='cmf_asset_type') op.drop_column('cmf_asset_type', 'project_id') op.drop_constraint(None, 'cmf_asset_scheme', type_='foreignkey') op.drop_index(op.f('ix_cmf_asset_scheme_project_id'), table_name='cmf_asset_scheme') op.drop_column('cmf_asset_scheme', 'project_id') op.drop_constraint(None, 'cmf_asset_cat', type_='foreignkey') op.drop_index(op.f('ix_cmf_asset_cat_project_id'), table_name='cmf_asset_cat') op.drop_column('cmf_asset_cat', 'project_id') op.drop_constraint(None, 'cmf_approve_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_approve_group_project_id'), table_name='cmf_approve_group') op.drop_column('cmf_approve_group', 'project_id') op.drop_constraint(None, 'cmf_approve', type_='foreignkey') op.drop_index(op.f('ix_cmf_approve_project_id'), table_name='cmf_approve') op.drop_column('cmf_approve', 'project_id') op.drop_constraint(None, 'cmf_activity', type_='foreignkey') op.drop_index(op.f('ix_cmf_activity_project_id'), table_name='cmf_activity') op.drop_column('cmf_activity', 'project_id') op.drop_constraint(None, 'cmf_access_rule', type_='foreignkey') op.drop_index(op.f('ix_cmf_access_rule_project_id'), table_name='cmf_access_rule') op.drop_column('cmf_access_rule', 'project_id') op.drop_constraint(None, 'cmf_access_list', type_='foreignkey') op.drop_index(op.f('ix_cmf_access_list_project_id'), table_name='cmf_access_list') op.drop_column('cmf_access_list', 'project_id') # ### end Alembic commands ###