U
    ]ÚdÊE  ã                   @   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

é    )ÚopNÚe7916fbdb2bdZ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    