U
    \ÚdÌ+  ã                   @   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: f4d4e8cfc0e3
Revises: 0792f6b2a584
Create Date: 2022-08-05 13:10:52.866888

é    )ÚopNZf4d4e8cfc0e3Z0792f6b2a584c                   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  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d"t 
¡ dd¡ t  dtjd#tjd$ddd%d&¡ t  dtjd't ¡ 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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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 ¡ dd¡ t  dtjd5t 
¡ dd6d&¡ t  dtjd7t ¡ 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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d>tjdddd¡ t  dtjd?tjdddd¡ t jt  d@¡dd*gdd t jt  dA¡dd5gdd t jt  dB¡dd?gdd t jt  dC¡dd3gdd t jt  dD¡dd>gdd t jt  dE¡dd;gdd t jt  dF¡dd9gdd t jt  dG¡dd1gdd t jt  dH¡dd<gdd t jt  dI¡dd:gdd t jt  dJ¡dd=gdd t jt  dK¡dd8gdd t jt  dL¡dd7gdd t  d ddMd9gdg¡ t  d ddNd:gdg¡ t  d ddMd8gdg¡ t  d ddOd;gdg¡ t  d ddPd?gdg¡ d S )QNÚcmf_folder_executorsÚidé@   )ÚlengthF)ÚnullableÚ	parent_idTÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheé   Úright_name_cacheÚix_cmf_folder_executors_left_id)ÚuniqueÚ!ix_cmf_folder_executors_parent_idÚ ix_cmf_folder_executors_right_idÚix_cmf_folder_executors_root_idÚcmf_folder_spectatorsÚ ix_cmf_folder_spectators_left_idÚ"ix_cmf_folder_spectators_parent_idÚ!ix_cmf_folder_spectators_right_idÚ ix_cmf_folder_spectators_root_idÚ
cmf_folderÚstatus_modified_at)ÚtimezoneÚstatus_in_progress_startÚstatus_in_progress_endÚstatus_review_atÚstatus_closed_atÚ
no_controlÚpriority_oldé    ú-)r   Úserver_defaultÚpriorityÚ0ÚmarkÚ
alarm_dateÚdeadlineÚtime_estimateÚplan_start_dateÚplan_end_dateÚperiod_next_dateÚperiod_intervalÚis_templateÚ
is_penaltyÚcache_status_typeÚcache_fieldsÚapprovedÚfalseÚworkflow_typeÚworkflow_idÚdefault_task_workflow_idÚ	status_idÚ
company_idÚresponsible_idÚwaiting_for_idÚcloned_from_idÚcache_status_opt_idÚix_cmf_folder_alarm_dateÚix_cmf_folder_approvedÚ!ix_cmf_folder_cache_status_opt_idÚix_cmf_folder_cache_status_typeÚix_cmf_folder_cloned_from_idÚix_cmf_folder_company_idÚ&ix_cmf_folder_default_task_workflow_idÚix_cmf_folder_is_templateÚix_cmf_folder_responsible_idÚix_cmf_folder_status_idÚix_cmf_folder_waiting_for_idÚix_cmf_folder_workflow_idÚix_cmf_folder_workflow_typeÚcmf_workflowÚ
cmf_statusÚcmf_companyÚcmf_status_opt)r   Úcreate_tableÚsaÚColumnÚStringÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚ	TIMESTAMPÚBooleanÚIntegerÚTEXTÚcreate_foreign_key© r]   r]   ú./opt/eva-app/alembic/versions/f4d4e8cfc0e3_.pyÚupgrade   sœ    ÷÷     "                r_   c                   C   st  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  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d,¡ t  dd-¡ t  dd.¡ t  dd/¡ t jt  d0¡d1d t jt  d2¡d1d t jt  d3¡d1d t jt  d4¡d1d t  d1¡ t jt  d5¡d6d t jt  d7¡d6d t jt  d8¡d6d t jt  d9¡d6d t  d6¡ d S ):Nr   Ú
foreignkey)Útype_rK   )Ú
table_namerJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   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   Údrop_constraintÚ
drop_indexrV   Údrop_columnÚ
drop_tabler]   r]   r]   r^   Ú	downgradef   st    
rg   )Ú__doc__Úalembicr   Ú
sqlalchemyrQ   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr_   rg   r]   r]   r]   r^   Ú<module>   s   S