U
    Vc]                     @   s<   d Z ddlmZ ddlZdZdZdZdZdd Z	dd	 Z
dS )
zhempty message

Revision ID: 6027b3a5875e
Revises: 2914f0e09877
Create Date: 2022-05-22 22:07:11.463968

    )opN6027b3a5875eZ2914f0e09877c                   C   sf  t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt d
ddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t dtjdt dd t dtjdt dd t dtjdt dd t dtjdtjdd	dd t jt dddgdd t d tjdt dd t d tjdt dd t d tjdt dd t d tjdtjdd	dd t jt d!d dgdd t d"tjdt dd t d"tjdt dd t d"tjdt dd t d"tjdtjdd	dd t jt d#d"dgdd t d$tjdt dd t d$tjdt dd t d$tjdt dd t d$tjdtjdd	dd t jt d%d$dgdd t d&tjdt dd t d&tjdt dd t d&tjdt dd t d&tjdtjdd	dd t jt d'd&dgdd t d(tjdt dd t d(tjdt dd t d(tjdt dd t d(tjdtjdd	dd t jt d)d(dgdd t d*tjdt dd t d*tjdt dd t d*tjdt dd t d*tjdtjdd	dd t jt d+d*dgdd t d,tjdt dd t d,tjdt dd t d,tjdt dd t d,tjdtjdd	dd t jt d-d,dgdd t d.tjdt dd t d.tjdt dd t d.tjdt dd t d.tjdtjdd	dd t jt d/d.dgdd t d0tjdt dd t d0tjdt dd t d0tjdt dd t d0tjdtjdd	dd t jt d1d0dgdd t d2tjdt dd t d2tjdt dd t d2tjdt dd t d2tjdtjdd	dd t jt d3d2dgdd t d4tjdt dd t d4tjdt dd t d4tjdt dd t d4tjdtjdd	dd t jt d5d4dgdd t d6tjdt dd t d6tjdt dd t d6tjdt dd t d6tjdtjdd	dd t jt d7d6dgdd t d8tjdt dd t d8tjdt dd t d8tjdt dd t d8tjdtjdd	dd t jt d9d8dgdd t d:tjdt dd t d:tjdt dd t d:tjdt dd t d:tjdtjdd	dd t jt d;d:dgdd t d<tjdt dd t d<tjdt dd t d<tjdt dd t d<tjdtjdd	dd t jt d=d<dgdd t d>tjdt dd t d>tjdt dd t d>tjdt dd t d?tjdt dd t d?tjdt dd t d?tjdt dd t d?tjdtjdd	dd t jt d@d?dgdd t dAtjdt dd t dAtjdt dd t dAtjdt dd t dAtjdtjdd	dd t jt dBdAdgdd t dCtjdt dd t dCtjdt dd t dCtjdt dd t dCtjdtjdd	dd t jt dDdCdgdd t dEtjdt dd t dEtjdt dd t dEtjdt dd t dEtjdtjdd	dd t jt dFdEdgdd t dGtjdt dd t dGtjdt dd t dGtjdt dd t dGtjdtjdd	dd t jt dHdGdgdd t dItjdt dd t dItjdt dd t dItjdt dd t dItjdtjdd	dd t jt dJdIdgdd t dKtjdt dd t dKtjdt dd t dKtjdt dd t dKtjdtjdd	dd t jt dLdKdgdd t dMtjdt dd t dMtjdt dd t dMtjdt dd t dMtjdtjdd	dd t jt dNdMdgdd t dOtjdt dd t dOtjdt dd t dOtjdt dd t dOtjdtjdd	dd t jt dPdOdgdd t dQtjdt dd t dQtjdt dd t dQtjdt dd t dQtjdtjdd	dd t jt dRdQdgdd t dStjdt dd t dStjdt dd t dStjdt dd t dStjdtjdd	dd t jt dTdSdgdd t dUtjdt dd t dUtjdt dd t dUtjdt dd t dUtjdtjdd	dd t jt dVdUdgdd t dWtjdt dd t dWtjdt dd t dWtjdt dd t dWtjdtjdd	dd t jt dXdWdgdd t dYtjdt dd t dYtjdt dd t dYtjdt dd t dYtjdtjdd	dd t jt dZdYdgdd t d[tjdt dd t d[tjdt dd t d[tjdt dd t d[tjdtjdd	dd t jt d\d[dgdd t d]tjdt dd t d]tjdt dd t d]tjdt dd t d]tjdtjdd	dd t jt d^d]dgdd t d_tjdt dd t d_tjdt dd t d_tjdt dd t d`tjdt dd t d`tjdt dd t d`tjdt dd t d`tjdtjdd	dd t jt dad`dgdd t dbtjdt dd t dbtjdt dd t dbtjdt dd t dbtjdtjdd	dd t jt dcdbdgdd t ddtjdt dd t ddtjdt dd t ddtjdt dd t ddtjdtjdd	dd t jt dedddgdd t dftjdt dd t dftjdt dd t dftjdt dd t dftjdtjdd	dd t jt dgdfdgdd t dhtjdt dd t dhtjdt dd t dhtjdt dd t dhtjdtjdd	dd t jt didhdgdd t djtjdt dd t djtjdt dd t djtjdt dd t djtjdtjdd	dd t jt dkdjdgdd t dltjdt dd t dltjdt dd t dltjdt dd t dltjdtjdd	dd t jt dmdldgdd t dntjdt dd t dntjdt dd t dntjdt dd t dntjdtjdd	dd t jt dodndgdd t dptjdt dd t dptjdt dd t dptjdt dd t dptjdtjdd	dd t jt dqdpdgdd t drtjdt dd t drtjdt dd t drtjdt dd t drtjdtjdd	dd t jt dsdrdgdd t dttjdt dd t dttjdt dd t dttjdt dd t dttjdtjdd	dd t jt dudtdgdd t dvtjdt dd t dvtjdt dd t dvtjdt dd t dvtjdtjdd	dd t jt dwdvdgdd d S )xNcmf_activityhas_tree_nodesT)nullabletree_node_is_branchtree_hiddentree_parent_id@   )lengthix_cmf_activity_tree_parent_idF)uniquecmf_attachment ix_cmf_attachment_tree_parent_idcmf_balanceix_cmf_balance_tree_parent_idcmf_balance_operation'ix_cmf_balance_operation_tree_parent_idcmf_cardix_cmf_card_tree_parent_idcmf_chat_message"ix_cmf_chat_message_tree_parent_idcmf_commentcmf_contractix_cmf_contract_tree_parent_idcmf_currencyix_cmf_currency_tree_parent_idcmf_deal_items ix_cmf_deal_items_tree_parent_idcmf_document_history&ix_cmf_document_history_tree_parent_id
cmf_filterix_cmf_filter_tree_parent_idcmf_formix_cmf_form_tree_parent_idcmf_form_field ix_cmf_form_field_tree_parent_id
cmf_importix_cmf_import_tree_parent_idcmf_integration!ix_cmf_integration_tree_parent_idcmf_invoice_items#ix_cmf_invoice_items_tree_parent_idcmf_jobix_cmf_job_tree_parent_idcmf_lead_mailbox"ix_cmf_lead_mailbox_tree_parent_idcmf_linkix_cmf_link_tree_parent_idcmf_mail_signature$ix_cmf_mail_signature_tree_parent_idcmf_mail_template#ix_cmf_mail_template_tree_parent_idcmf_mailboxix_cmf_mailbox_tree_parent_idcmf_menu_itemix_cmf_menu_item_tree_parent_idcmf_menu_treeix_cmf_menu_tree_tree_parent_id
cmf_notifyix_cmf_notify_tree_parent_idcmf_org_unit
cmf_personix_cmf_person_tree_parent_idcmf_person_group"ix_cmf_person_group_tree_parent_idcmf_person_var ix_cmf_person_var_tree_parent_idcmf_planix_cmf_plan_tree_parent_id
cmf_pluginix_cmf_plugin_tree_parent_idcmf_plugin_asana"ix_cmf_plugin_asana_tree_parent_idcmf_plugin_confluence'ix_cmf_plugin_confluence_tree_parent_idcmf_plugin_jira!ix_cmf_plugin_jira_tree_parent_idcmf_plugin_mail_box%ix_cmf_plugin_mail_box_tree_parent_idcmf_plugin_s_m_s_gate'ix_cmf_plugin_s_m_s_gate_tree_parent_idcmf_plugin_telphin$ix_cmf_plugin_telphin_tree_parent_idcmf_plugin_trello#ix_cmf_plugin_trello_tree_parent_idcmf_plugin_zadarma$ix_cmf_plugin_zadarma_tree_parent_id	cmf_priceix_cmf_price_tree_parent_idcmf_print_tmpl ix_cmf_print_tmpl_tree_parent_idcmf_productix_cmf_product_tree_parent_idcmf_rolecmf_staff_control_settings,ix_cmf_staff_control_settings_tree_parent_id
cmf_statusix_cmf_status_tree_parent_idcmf_status_opt ix_cmf_status_opt_tree_parent_id	cmf_stockix_cmf_stock_tree_parent_idcmf_stock_items!ix_cmf_stock_items_tree_parent_idcmf_stock_operations&ix_cmf_stock_operations_tree_parent_idcmf_subscription"ix_cmf_subscription_tree_parent_idcmf_tagix_cmf_tag_tree_parent_idcmf_tag_category"ix_cmf_tag_category_tree_parent_idcmf_triggerix_cmf_trigger_tree_parent_idcmf_unitix_cmf_unit_tree_parent_idcmf_whatsappix_cmf_whatsapp_tree_parent_id)r   
add_columnsaColumnBooleanStringcreate_indexf r   r   */opt/crm/alembic/versions/6027b3a5875e_.pyupgrade   s$                                                        r   c                   C   s  t jt ddd t dd t dd t dd t dd t jt dd	d t d	d t d	d t d	d t d	d t jt d
dd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t jt ddd t dd t dd t dd t dd t dd t dd t dd t jt dd d t d d t d d t d d t d d t jt d!d"d t d"d t d"d t d"d t d"d t jt d#d$d t d$d t d$d t d$d t d$d t jt d%d&d t d&d t d&d t d&d t d&d t jt d'd(d t d(d t d(d t d(d t d(d t jt d)d*d t d*d t d*d t d*d t d*d t jt d+d,d t d,d t d,d t d,d t d,d t jt d-d.d t d.d t d.d t d.d t d.d t jt d/d0d t d0d t d0d t d0d t d0d t jt d1d2d t d2d t d2d t d2d t d2d t jt d3d4d t d4d t d4d t d4d t d4d t jt d5d6d t d6d t d6d t d6d t d6d t jt d7d8d t d8d t d8d t d8d t d8d t jt d9d:d t d:d t d:d t d:d t d:d t jt d;d<d t d<d t d<d t d<d t d<d t jt d=d>d t d>d t d>d t d>d t d>d t d?d t d?d t d?d t jt d@dAd t dAd t dAd t dAd t dAd t jt dBdCd t dCd t dCd t dCd t dCd t jt dDdEd t dEd t dEd t dEd t dEd t jt dFdGd t dGd t dGd t dGd t dGd t jt dHdId t dId t dId t dId t dId t jt dJdKd t dKd t dKd t dKd t dKd t jt dLdMd t dMd t dMd t dMd t dMd t jt dNdOd t dOd t dOd t dOd t dOd t jt dPdQd t dQd t dQd t dQd t dQd t jt dRdSd t dSd t dSd t dSd t dSd t jt dTdUd t dUd t dUd t dUd t dUd t jt dVdWd t dWd t dWd t dWd t dWd t jt dXdYd t dYd t dYd t dYd t dYd t jt dZd[d t d[d t d[d t d[d t d[d t jt d\d]d t d]d t d]d t d]d t d]d t jt d^d_d t d_d t d_d t d_d t d_d t jt d`dad t dad t dad t dad t dad t jt dbdcd t dcd t dcd t dcd t dcd t jt ddded t ded t ded t ded t ded t dfd t dfd t dfd t jt dgdhd t dhd t dhd t dhd t dhd t jt didjd t djd t djd t djd t djd t jt dkdld t dld t dld t dld t dld t jt dmdnd t dnd t dnd t dnd t dnd t jt dodpd t dpd t dpd t dpd t dpd t jt dqdrd t drd t drd t drd t drd d S )sNrx   rw   )
table_namer	   r   r   r   rv   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   ri   rh   rg   rf   re   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r$   r#   r"   r!   r    r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )r   
drop_indexr   drop_columnr   r   r   r   	downgrade*  s$   r   )__doc__alembicr   
sqlalchemyrz   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   r   <module>   s     