U
    ̟dE                     @   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 )
zecomponents

Revision ID: e7916fbdb2bd
Revises: 41eef43ae0f9
Create Date: 2023-06-26 17:26:35.601227

    )opNZe7916fbdb2bd41eef43ae0f9c                   C   s  t dtjdtjddddtjdtjddd	dtjd
tjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtd
 t jt dddgdd t jt dddgdd t jt dddgdd t jt ddd
gdd t dtjdtjddddtjdtjddd	dtjd
tjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtd
 t jt dddgdd t jt dddgdd t jt dddgdd t jt ddd
gdd t dtjdtjddddtjdtjddd	dtjd
tjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtd
 t jt dddgdd t jt dddgdd t jt dddgdd t jt d dd
gdd t d!tjdtjddddtjdtjddd	dtjd
tjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtjdtjddd	dtd
 t jt d"d!dgdd t jt d#d!dgdd t jt d$d!dg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jd)ddd t d&tjd*t d	d t d&tjd+tj	d	d,d	d t d&tjd-tj	d	d,d	d t d&tjd.tj	d	d,d	d t d&tjd/tj	d	d,d	d t d&tjd0tj	d	d,d	d t d&tjd1t
 d	d t d&tjd2t dd t d&tjd3tjd)dd	d t d&tjd4tj	d	d,d	d t d&tjd5tj	d	d,d	d t d&tjd6tj	d	d,d	d t d&tjd7tj	d	d,d	d t d&tjd8tj	d	d,d	d t d&tjd9tjd)d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 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 d&tjd@tjd)ddd t d&tjdAtjd)ddd t d&tjdBtjd)ddd t d&tjdCtjd)dd	d t d&tjdDtjddd	d t d&tjdEtjddd	d t d&tjdFtjddd	d t d&tjdGtjddd	d t d&tjdHtjddd	d t d&tjdItjddd	d t d&tjdJtjddd	d t d&tjdKtjddd	d t d&tjdLtjddd	d t d&tjdMtjddd	d t d&tjdNtjddd	d t d&tjdOtjddd	d t jt dPd&dNgdd t jt dQd&d4gdd t jt dRd&d>gdd t jt dSd&dOgdd t jt dTd&d<gdd t jt dUd&dMgdd t jt dVd&dHgdd t jt dWd&dJgdd t jt dXd&dEgdd t jt dYd&d:gdd t jt dZd&d'gdd t jt d[d&dFgdd t jt d\d&d*gdd t jt d]d&dKgdd t jt d^d&dGgdd t jt d_d&dIgdd t jt d`d&dLgdd t jt dad&dDgdd t d d&dbdIgdg t d d&dcdNgdg t d d&dddJgdg t d d&dedEgdg t d d&dedDgdg t d d&dfdFgdg t d d&dgdOgdg t d d&dhdGgdg d S )iN"cmf_component_cmf_owner_assistantsid   )lengthF)nullable	parent_id@   Troot_iddescriptioni   left_idright_idleft_name_cache   right_name_cache-ix_cmf_component_cmf_owner_assistants_left_id)unique/ix_cmf_component_cmf_owner_assistants_parent_id.ix_cmf_component_cmf_owner_assistants_right_id-ix_cmf_component_cmf_owner_assistants_root_idcmf_component_executors"ix_cmf_component_executors_left_id$ix_cmf_component_executors_parent_id#ix_cmf_component_executors_right_id"ix_cmf_component_executors_root_idcmf_component_local_links$ix_cmf_component_local_links_left_id&ix_cmf_component_local_links_parent_id%ix_cmf_component_local_links_right_id$ix_cmf_component_local_links_root_idcmf_component_spectators#ix_cmf_component_spectators_left_id%ix_cmf_component_spectators_parent_id$ix_cmf_component_spectators_right_id#ix_cmf_component_spectators_root_idcmf_componentlogic_prefixui_view_form    parent_logic_prefixstatus_modified_at)timezonestatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymark
alarm_datedeadlineplan_start_dateplan_end_dateperiod_next_dateperiod_intervalis_template
is_penaltycache_status_typecache_fieldsapprovedperm_policyperm_policy_guestperm_policy_anonymousperm_policy_sharelinksharelink_hashworkflow_iddefault_task_workflow_idlogic_type_idscheme_wf_idcmf_owner_assistant_id	status_id
company_idresponsible_idwaiting_for_idcloned_from_idactivity_idcache_status_opt_idix_cmf_component_activity_idix_cmf_component_alarm_dateix_cmf_component_approved$ix_cmf_component_cache_status_opt_id"ix_cmf_component_cache_status_typeix_cmf_component_cloned_from_id'ix_cmf_component_cmf_owner_assistant_idix_cmf_component_company_id)ix_cmf_component_default_task_workflow_idix_cmf_component_is_templateix_cmf_component_logic_prefixix_cmf_component_logic_type_id$ix_cmf_component_parent_logic_prefixix_cmf_component_responsible_idix_cmf_component_scheme_wf_idix_cmf_component_status_idix_cmf_component_waiting_for_idix_cmf_component_workflow_id
cmf_statuscmf_activitycmf_companycmf_workflowcmf_logic_typecmf_status_optcmf_scheme_wf)r   create_tablesaColumnStringPrimaryKeyConstraintcreate_indexf
add_column	TIMESTAMPBooleanIntegerTEXTcreate_foreign_key rv   rv   8/opt/eva-app/alembic/versions/e7916fbdb2bd_components.pyupgrade   s                                   rx   c                   C   s(  t jd ddd t jd ddd t jd ddd t jd ddd t jd ddd t jd ddd t jd ddd t jd ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt d	dd t jt d
dd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt d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 dd t dd t dd  t dd! t dd" t dd# t dd$ t dd% t dd& t dd' t dd( t dd) t dd* t dd+ t dd, t dd- t dd. t dd/ t dd0 t dd1 t dd2 t dd3 t dd4 t dd5 t dd6 t dd7 t dd8 t dd9 t dd: t dd; t dd< t dd= t jt d>d?d t jt d@d?d t jt dAd?d t jt dBd?d t d? t jt dCdDd t jt dEdDd t jt dFdDd t jt dGdDd t dD t jt dHdId t jt dJdId t jt dKdId t jt dLdId t dI t jt dMdNd t jt dOdNd t jt dPdNd t jt dQdNd t dN d S )RNr&   
foreignkey)type_ra   )
table_namer`   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   drop_constraint
drop_indexro   drop_column
drop_tablerv   rv   rv   rw   	downgrade   s    


r   )__doc__alembicr   
sqlalchemyrj   revisiondown_revisionbranch_labels
depends_onrx   r   rv   rv   rv   rw   <module>   s    