U
    z]f}^  ã                   @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd„ Zd	d
„ ZdS )zbproject

Revision ID: af18a0280adf
Revises: f907d52e69fa
Create Date: 2024-03-13 19:26:45.346979

é    )ÚopN)Ú
postgresqlÚaf18a0280adfÚf907d52e69fac                   C   s~  t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  dtjdtjdddd¡ t jt  d¡ddgdd	 t  d dd
dgdg¡ t  d tjdtjdddd¡ t jt  d!¡d dgdd	 t  d d d
dgdg¡ 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jdddd¡ t jt  d&¡d%dgdd	 t  d d%d
dgdg¡ t  d'tjdtjdddd¡ t jt  d(¡d'dgdd	 t  d d'd
dgdg¡ t  d)tjdtjdddd¡ t jt  d*¡d)dgdd	 t  d d)d
dgdg¡ t  d+tjdtjdddd¡ t jt  d,¡d+dgdd	 t  d d+d
dgdg¡ t  d-tjdtjdddd¡ t jt  d.¡d-dgdd	 t  d d-d
dgdg¡ t  d/tjdtjdddd¡ t jt  d0¡d/dgdd	 t  d d/d
dgdg¡ t  d1tjdtjdddd¡ t jt  d2¡d1dgdd	 t  d d1d
dgdg¡ t  d3tjdtjdddd¡ t jt  d4¡d3dgdd	 t  d d3d
dgdg¡ t  d
tjdtjdddd¡ t jt  d5¡d
dgdd	 t  d d
d
dgdg¡ t  d6tjdtjdddd¡ t jt  d7¡d6dgdd	 t  d d6d
dgdg¡ t  d8tjdtjdddd¡ t jt  d9¡d8dgdd	 t  d d8d
dgdg¡ t  d:tjdtjdddd¡ t jt  d;¡d:dgdd	 t  d d:d
dgdg¡ t  d<tjdtjdddd¡ t jt  d=¡d<dgdd	 t  d d<d
dgdg¡ t  d>tjdtjdddd¡ t jt  d?¡d>dgdd	 t  d d>d
dgdg¡ t  d@tjdtjdddd¡ t jt  dA¡d@dgdd	 t  d d@d
dgdg¡ t  dBtjdtjdddd¡ t jt  dC¡dBdgdd	 t  d dBd
dgdg¡ t  dDtjdtjdddd¡ t jt  dE¡dDdgdd	 t  d dDd
dgdg¡ t  dFtjdtjdddd¡ t jt  dG¡dFdgdd	 t  d dFd
dgdg¡ t  dHtjdtjdddd¡ t jt  dI¡dHdgdd	 t  d dHd
dgdg¡ t  dJtjdtjdddd¡ t jt  dK¡dJdgdd	 t  d dJd
dgdg¡ t  dLtjdtjdddd¡ t jt  dM¡dLdgdd	 t  d dLd
dgdg¡ t  dNtjdtjdddd¡ t jt  dO¡dNdgdd	 t  d dNd
dgdg¡ t  dPtjdtjdddd¡ t jt  dQ¡dPdgdd	 t  d dPd
dgdg¡ t  dRtjdtjdddd¡ t jt  dS¡dRdgdd	 t  d dRd
dgdg¡ d S )TNÚcmf_answer_templateÚ
project_idé@   )ÚlengthT)ÚnullableÚ!ix_cmf_answer_template_project_idF)ÚuniqueÚcmf_projectÚidÚ	cmf_assetÚix_cmf_asset_project_idÚcmf_attachmentÚix_cmf_attachment_project_idÚcmf_chat_groupÚix_cmf_chat_group_project_idÚcmf_chat_topicÚix_cmf_chat_topic_project_idÚcmf_commentÚix_cmf_comment_project_idÚcmf_companyÚix_cmf_company_project_idÚcmf_componentÚix_cmf_component_project_idÚcmf_dashboardÚix_cmf_dashboard_project_idÚcmf_dealÚix_cmf_deal_project_idÚcmf_documentÚix_cmf_document_project_idÚ
cmf_folderÚix_cmf_folder_project_idÚcmf_full_searchÚobj_project_idÚ!ix_cmf_full_search_obj_project_idÚ
cmf_importÚix_cmf_import_project_idÚcmf_invoiceÚix_cmf_invoice_project_idÚcmf_kanban_boardÚix_cmf_kanban_board_project_idÚcmf_leadÚix_cmf_lead_project_idÚcmf_listÚix_cmf_list_project_idÚcmf_mail_handlerÚix_cmf_mail_handler_project_idÚcmf_paymentÚix_cmf_payment_project_idÚcmf_pipelineÚix_cmf_pipeline_project_idÚix_cmf_project_project_idÚcmf_purchase_orderÚ ix_cmf_purchase_order_project_idÚcmf_purchase_order_itemsÚ&ix_cmf_purchase_order_items_project_idÚcmf_roadmapÚix_cmf_roadmap_project_idÚcmf_scheme_wfÚix_cmf_scheme_wf_project_idÚcmf_stock_incoming_orderÚ&ix_cmf_stock_incoming_order_project_idÚcmf_stock_initialÚix_cmf_stock_initial_project_idÚcmf_stock_inventoryÚ!ix_cmf_stock_inventory_project_idÚcmf_stock_moveÚix_cmf_stock_move_project_idÚcmf_stock_outcoming_orderÚ'ix_cmf_stock_outcoming_order_project_idÚcmf_taskÚix_cmf_task_project_idÚcmf_task_filterÚix_cmf_task_filter_project_idÚcmf_task_queueÚix_cmf_task_queue_project_idÚcmf_task_reportÚix_cmf_task_report_project_idÚcmf_time_tracker_historyÚ&ix_cmf_time_tracker_history_project_idÚcmf_u_work_postÚix_cmf_u_work_post_project_id)r   Ú
add_columnÚsaÚColumnÚStringÚcreate_indexÚfÚcreate_foreign_key© r^   r^   ú5/opt/eva-app/alembic/versions/af18a0280adf_project.pyÚupgrade   sÜ                                         r`   c                   C   sä  t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd d	dd t jt  d
¡d	d t  d	d¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d¡dd t  dd¡ t jd ddd t jt  d ¡dd t  dd¡ t jd d!dd t jt  d"¡d!d t  d!d¡ t jd d#dd t jt  d$¡d#d t  d#d¡ t jd d%dd t jt  d&¡d%d t  d%d¡ t jd d'dd t jt  d(¡d'd t  d'd¡ t jd d)dd t jt  d*¡d)d t  d)d¡ t jd d+dd t jt  d,¡d+d t  d+d¡ t jd d-dd t jt  d.¡d-d t  d-d¡ t jd d/dd t jt  d0¡d/d t  d/d¡ t jd d1dd t jt  d2¡d1d t  d1d¡ t jd d3dd t jt  d4¡d3d t  d3d¡ t jt  d5¡d6d t  d6d7¡ t jd d8dd t jt  d9¡d8d t  d8d¡ t jd d:dd t jt  d;¡d:d t  d:d¡ t jd d<dd t jt  d=¡d<d t  d<d¡ t jd d>dd t jt  d?¡d>d t  d>d¡ t jd d@dd t jt  dA¡d@d t  d@d¡ t jd dBdd t jt  dC¡dBd t  dBd¡ t jd dDdd t jt  dE¡dDd t  dDd¡ t jd dFdd t jt  dG¡dFd t  dFd¡ t jd dHdd t jt  dI¡dHd t  dHd¡ t jd dJdd t jt  dK¡dJd t  dJd¡ t jd dLdd t jt  dM¡dLd t  dLd¡ t jd dNdd t jt  dO¡dNd t  dNd¡ d S )PNrU   Ú
foreignkey)Útype_rV   )Ú
table_namer   rS   rT   rQ   rR   rO   rP   rM   rN   rK   rL   rI   rJ   rG   rH   rE   rF   rC   rD   rA   rB   r?   r@   r=   r>   r;   r<   r9   r:   r   r8   r6   r7   r4   r5   r2   r3   r0   r1   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_constraintÚ
drop_indexr\   Údrop_columnr^   r^   r^   r_   Ú	downgrade¶   sÜ    rg   )Ú__doc__Úalembicr   Ú
sqlalchemyrX   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr`   rg   r^   r^   r^   r_   Ú<module>   s    $