
    z]f}^                     D    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 Zd Zy)	zbproject

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

    )opN)
postgresqlaf18a0280adff907d52e69fac            	      '   t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  dt        j                  dt        j                  d      d             t        j
                  t        j                  d      ddgd	       t        j                  d dd
dgdg       t        j                  d t        j                  dt        j                  d      d             t        j
                  t        j                  d!      d dgd	       t        j                  d d d
dgdg       t        j                  d"t        j                  d#t        j                  d      d             t        j
                  t        j                  d$      d"d#gd	       t        j                  d%t        j                  dt        j                  d      d             t        j
                  t        j                  d&      d%dgd	       t        j                  d d%d
dgdg       t        j                  d't        j                  dt        j                  d      d             t        j
                  t        j                  d(      d'dgd	       t        j                  d d'd
dgdg       t        j                  d)t        j                  dt        j                  d      d             t        j
                  t        j                  d*      d)dgd	       t        j                  d d)d
dgdg       t        j                  d+t        j                  dt        j                  d      d             t        j
                  t        j                  d,      d+dgd	       t        j                  d d+d
dgdg       t        j                  d-t        j                  dt        j                  d      d             t        j
                  t        j                  d.      d-dgd	       t        j                  d d-d
dgdg       t        j                  d/t        j                  dt        j                  d      d             t        j
                  t        j                  d0      d/dgd	       t        j                  d d/d
dgdg       t        j                  d1t        j                  dt        j                  d      d             t        j
                  t        j                  d2      d1dgd	       t        j                  d d1d
dgdg       t        j                  d3t        j                  dt        j                  d      d             t        j
                  t        j                  d4      d3dgd	       t        j                  d d3d
dgdg       t        j                  d
t        j                  dt        j                  d      d             t        j
                  t        j                  d5      d
dgd	       t        j                  d d
d
dgdg       t        j                  d6t        j                  dt        j                  d      d             t        j
                  t        j                  d7      d6dgd	       t        j                  d d6d
dgdg       t        j                  d8t        j                  dt        j                  d      d             t        j
                  t        j                  d9      d8dgd	       t        j                  d d8d
dgdg       t        j                  d:t        j                  dt        j                  d      d             t        j
                  t        j                  d;      d:dgd	       t        j                  d d:d
dgdg       t        j                  d<t        j                  dt        j                  d      d             t        j
                  t        j                  d=      d<dgd	       t        j                  d d<d
dgdg       t        j                  d>t        j                  dt        j                  d      d             t        j
                  t        j                  d?      d>dgd	       t        j                  d d>d
dgdg       t        j                  d@t        j                  dt        j                  d      d             t        j
                  t        j                  dA      d@dgd	       t        j                  d d@d
dgdg       t        j                  dBt        j                  dt        j                  d      d             t        j
                  t        j                  dC      dBdgd	       t        j                  d dBd
dgdg       t        j                  dDt        j                  dt        j                  d      d             t        j
                  t        j                  dE      dDdgd	       t        j                  d dDd
dgdg       t        j                  dFt        j                  dt        j                  d      d             t        j
                  t        j                  dG      dFdgd	       t        j                  d dFd
dgdg       t        j                  dHt        j                  dt        j                  d      d             t        j
                  t        j                  dI      dHdgd	       t        j                  d dHd
dgdg       t        j                  dJt        j                  dt        j                  d      d             t        j
                  t        j                  dK      dJdgd	       t        j                  d dJd
dgdg       t        j                  dLt        j                  dt        j                  d      d             t        j
                  t        j                  dM      dLdgd	       t        j                  d dLd
dgdg       t        j                  dNt        j                  dt        j                  d      d             t        j
                  t        j                  dO      dNdgd	       t        j                  d dNd
dgdg       t        j                  dPt        j                  dt        j                  d      d             t        j
                  t        j                  dQ      dPdgd	       t        j                  d dPd
dgdg       t        j                  dRt        j                  dt        j                  d      d             t        j
                  t        j                  dS      dRdgd	       t        j                  d dRd
dgdg       y )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     5/opt/eva-app/alembic/versions/af18a0280adf_project.pyupgraderc      s    MM'<RTAU`d)efOOBDD<=?TWcVdmrs$ 5}|nW[V\]MM+ryyryy7KVZ[\OOBDD23[<.Y^_$]\NTFSMM"BIIlBIIR<P[_$`aOOBDD78:J\Nchi$ 0-,RVQWXMM"BIIlBIIR<P[_$`aOOBDD78:J\Nchi$ 0-,RVQWXMM"BIIlBIIR<P[_$`aOOBDD78:J\Nchi$ 0-,RVQWXMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM/299\299B;OZ^#_`OOBDD67<.afg$QUPVWMM/299\299B;OZ^#_`OOBDD67<.afg$QUPVWMM*biibiir6JUYZ[OOBDD12JW\]$
ML>D6RMM."))L"))2:NY]"^_OOBDD56_de$~PTvVMM,		,		8LW[ \]OOBDD34l\N[`a$ml^dVTMM#RYY/?RTAU`d%efOOBDD<=?PScRdmrsMM,		,		8LW[ \]OOBDD34l\N[`a$ml^dVTMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM$biibiir>R]a&bcOOBDD9:<NQ]P^glm$ 2ML>TXSYZMM*biibiir6JUYZ[OOBDD12JW\]$
ML>D6RMM*biibiir6JUYZ[OOBDD12JW\]$
ML>D6RMM$biibiir>R]a&bcOOBDD9:<NQ]P^glm$ 2ML>TXSYZMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM."))L"))2:NY]"^_OOBDD56_de$~PTvVMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM&		,		QS@T_c(deOOBDD;<>RUaTbkpq$ 4ml^VZU[\MM,biibiiWYFZei.jkOOBDDABD^am`nw|}$ :ML>\`[abMM-<"9MX\!]^OOBDD45}|n]bc$}|ntfUMM/299\299B;OZ^#_`OOBDD67<.afg$QUPVWMM,biibiiWYFZei.jkOOBDDABD^am`nw|}$ :ML>\`[abMM%ryyryyPR?S^b'cdOOBDD:;=PS_R`ino$ 3]\NUYTZ[MM'<RTAU`d)efOOBDD<=?TWcVdmrs$ 5}|nW[V\]MM"BIIlBIIR<P[_$`aOOBDD78:J\Nchi$ 0-,RVQWXMM-ryyryyXZG[fj/klOOBDDBCE`cobpy~$ ;]\N]a\bcMM*biibiir6JUYZ[OOBDD12JW\]$
ML>D6RMM#RYY|RYYb=Q\`%abOOBDD89;L|nejk$ 1=<.SWRXYMM"BIIlBIIR<P[_$`aOOBDD78:J\Nchi$ 0-,RVQWXMM#RYY|RYYb=Q\`%abOOBDD89;L|nejk$ 1=<.SWRXYMM,biibiiWYFZei.jkOOBDDABD^am`nw|}$ :ML>\`[abMM#RYY|RYYb=Q\`%abOOBDD89;L|nejk$ 1=<.SWRXYra   c                  D   t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d d	d       t        j                  t        j                  d
      d	       t        j                  d	d       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  d dd       t        j                  t        j                  d       d       t        j                  dd       t        j                  d d!d       t        j                  t        j                  d"      d!       t        j                  d!d       t        j                  d d#d       t        j                  t        j                  d$      d#       t        j                  d#d       t        j                  d d%d       t        j                  t        j                  d&      d%       t        j                  d%d       t        j                  d d'd       t        j                  t        j                  d(      d'       t        j                  d'd       t        j                  d d)d       t        j                  t        j                  d*      d)       t        j                  d)d       t        j                  d d+d       t        j                  t        j                  d,      d+       t        j                  d+d       t        j                  d d-d       t        j                  t        j                  d.      d-       t        j                  d-d       t        j                  d d/d       t        j                  t        j                  d0      d/       t        j                  d/d       t        j                  d d1d       t        j                  t        j                  d2      d1       t        j                  d1d       t        j                  d d3d       t        j                  t        j                  d4      d3       t        j                  d3d       t        j                  t        j                  d5      d6       t        j                  d6d7       t        j                  d d8d       t        j                  t        j                  d9      d8       t        j                  d8d       t        j                  d d:d       t        j                  t        j                  d;      d:       t        j                  d:d       t        j                  d d<d       t        j                  t        j                  d=      d<       t        j                  d<d       t        j                  d d>d       t        j                  t        j                  d?      d>       t        j                  d>d       t        j                  d d@d       t        j                  t        j                  dA      d@       t        j                  d@d       t        j                  d dBd       t        j                  t        j                  dC      dB       t        j                  dBd       t        j                  d dDd       t        j                  t        j                  dE      dD       t        j                  dDd       t        j                  d dFd       t        j                  t        j                  dG      dF       t        j                  dFd       t        j                  d dHd       t        j                  t        j                  dI      dH       t        j                  dHd       t        j                  d dJd       t        j                  t        j                  dK      dJ       t        j                  dJd       t        j                  d dLd       t        j                  t        j                  dM      dL       t        j                  dLd       t        j                  d dNd       t        j                  t        j                  dO      dN       t        j                  dNd       y )PNrW   
foreignkey)type_rX   )
table_namer	   rU   rV   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<   r   r:   r8   r9   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   drop_constraint
drop_indexr^   drop_columnr`   ra   rb   	downgraderk      sA   t.lCMM"$$67DUVNN$l3t7|LMM"$$?@MghNN-|<t.lCMM"$$67DUVNN$l3t-\BMM"$$56CSTNN#\2t.lCMM"$$67DUVNN$l3tZ|<MM"$$/0ZHNN:|,t8MMM"$$@ANijNN.=t-\BMM"$$56CSTNN#\2t2,GMM"$$:;H]^NN(,7t0EMM"$$89FYZNN&5t7|LMM"$$?@MghNN-|<t_LAMM"$$45/RNN?L1t],?MM"$$23NNN=,/t7|LMM"$$?@MghNN-|<t1FMM"$$9:G[\NN'6t],?MM"$$23NNN=,/t^<@MM"$$34PNN><0t],?MM"$$23NNN=,/t/|DMM"$$78EWXNN%|4tZ|<MM"$$/0ZHNN:|,tZ|<MM"$$/0ZHNN:|,t/|DMM"$$78EWXNN%|4t],?MM"$$23NNN=,/t\>MM"$$12|LNN<.MM"$$:;HYZNN$&67t\>MM"$$12|LNN<.t^<@MM"$$34PNN><0tZ|<MM"$$/0ZHNN:|,t_LAMM"$$45/RNN?L1t_LAMM"$$45/RNN?L1t],?MM"$$23NNN=,/t],?MM"$$23NNN=,/t-\BMM"$$56CSTNN#\2t-\BMM"$$56CSTNN#\2t-\BMM"$$56CSTNN#\2t[=MM"$$01kJNN;-t2,GMM"$$:;H]^NN(,7ra   )__doc__alembicr   
sqlalchemyrZ   sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onrc   rk   r`   ra   rb   <module>rt      s9      * 
_ZFo8ra   