U
    \Údì8  ã                   @   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 )
zfadd roadmap

Revision ID: dc393dadb843
Revises: 9a573fb87308
Create Date: 2022-04-05 11:36:32.900206

é    )ÚopNZdc393dadb843Z9a573fb87308c                B   C   s6  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 ¡ ddtjdt ¡ ddtjdtjddddtjdtjddddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt 	¡ ddtjdt ¡ ddtjdt ¡ 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 ¡ ddtjdtjddddtjdt 	¡ 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 	¡ 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 ¡ ddtjd)t ¡ ddtjd*tjddddtjd+t ¡ ddtjd,t ¡ ddtjd-t ¡ ddtjd.t ¡ ddtjd/t ¡ ddtjd0tjddddtjd1t 	¡ ddtjd2tjddddtjd3tjddddtjd4tjddddtjd5tjddddtjd6tjddddtjd7tjddddtjd8tjddddtjd9t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?gdAg¡t 
d@gdBg¡t 
d8gdCg¡t 
d;gdDg¡t 
d:gdEg¡t d¡¡> t jt  dF¡dd?gddG t jt  dH¡dd!gddG t jt  dI¡dd,gddG t jt  dJ¡dd@gddG t jt  dK¡dd*gddG t jt  dL¡dd>gddG t jt  dM¡dd2gddG t jt  dN¡dd
gddG t jt  dO¡ddgddG t jt  dP¡dd8gddG t jt  dQ¡ddgddG t jt  dR¡dd7gddG t jt  dS¡ddgddG t jt  dT¡dd6gddG t jt  dU¡dd4gddG t jt  dV¡dd3gddG t jt  dW¡ddgddG t jt  dX¡ddgddG t jt  dY¡ddgddG t jt  dZ¡dd;gddG t jt  d[¡dd(gddG t jt  d\¡ddgddG t jt  d]¡ddgddG t jt  d^¡dd5gddG t jt  d_¡dd<gddG t jt  d`¡dd:gddG t jt  da¡dd9gddG t jt  db¡dd=gddG t jt  dc¡dd0gddG t  ddtjdtjddddtjd5tjddddtjdetjddddtjdftjdgdddtjdhtjddddtjditjddddtjdjtjddddtjdktjddddt d¡¡
 t jt  dl¡dddhgddG t jt  dm¡ddd5gddG t jt  dn¡dddigddG t jt  do¡dddegddG t  dptjdtjddddtjd5tjddddtjdetjddddtjdftjdgdddtjdhtjddddtjditjddddtjdjtjddddtjdktjddddt d¡¡
 t jt  dq¡dpdhgddG t jt  dr¡dpd5gddG t jt  ds¡dpdigddG t jt  dt¡dpdegddG t  dutjdtjddddtjd5tjddddtjdetjddddtjdftjdgdddtjdhtjddddtjditjddddtjdjtjddddtjdktjddddt d¡¡
 t jt  dv¡dudhgddG t jt  dw¡dud5gddG t jt  dx¡dudigddG t jt  dy¡dudegddG d S )zNÚcmf_roadmapÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚcache_last_commentsÚis_favoriteÚordernoÚhas_tree_nodesÚtree_hiddenÚstatus_modified_atÚstatus_in_progress_startÚstatus_in_progress_endÚ
no_controlÚpriority_oldé    ÚpriorityÚ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Úperm_readonlyÚperm_privateÚperm_encryptÚworkflow_typeÚcache_members_countÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚ	status_idÚ
company_idÚresponsible_idÚwaiting_for_idÚcloned_from_idÚactivity_idÚcache_status_opt_idzcmf_activity.idzcmf_status_opt.idzcmf_import.idzcmf_company.idzcmf_status.idÚix_cmf_roadmap_activity_id)ÚuniqueÚix_cmf_roadmap_alarm_dateÚix_cmf_roadmap_approvedÚ"ix_cmf_roadmap_cache_status_opt_idÚ ix_cmf_roadmap_cache_status_typeÚix_cmf_roadmap_cloned_from_idÚix_cmf_roadmap_cmf_author_idÚix_cmf_roadmap_cmf_created_atÚix_cmf_roadmap_cmf_deletedÚix_cmf_roadmap_cmf_import_idÚix_cmf_roadmap_cmf_locked_atÚix_cmf_roadmap_cmf_locked_by_idÚix_cmf_roadmap_cmf_modified_atÚ!ix_cmf_roadmap_cmf_modified_by_idÚ%ix_cmf_roadmap_cmf_owner_assistant_idÚix_cmf_roadmap_cmf_owner_idÚix_cmf_roadmap_cmf_versionÚix_cmf_roadmap_cmf_viewed_atÚix_cmf_roadmap_codeÚix_cmf_roadmap_company_idÚix_cmf_roadmap_is_templateÚix_cmf_roadmap_nameÚix_cmf_roadmap_ordernoÚix_cmf_roadmap_parent_idÚix_cmf_roadmap_responsible_idÚix_cmf_roadmap_status_idÚix_cmf_roadmap_tree_parent_idÚix_cmf_roadmap_waiting_for_idÚix_cmf_roadmap_workflow_typeÚcmf_roadmap_executorsÚroot_idÚdescriptioni   Úleft_idÚright_idÚleft_name_cacheÚright_name_cacheÚ ix_cmf_roadmap_executors_left_idÚ"ix_cmf_roadmap_executors_parent_idÚ!ix_cmf_roadmap_executors_right_idÚ ix_cmf_roadmap_executors_root_idÚcmf_roadmap_membersÚix_cmf_roadmap_members_left_idÚ ix_cmf_roadmap_members_parent_idÚix_cmf_roadmap_members_right_idÚix_cmf_roadmap_members_root_idÚcmf_roadmap_spectatorsÚ!ix_cmf_roadmap_spectators_left_idÚ#ix_cmf_roadmap_spectators_parent_idÚ"ix_cmf_roadmap_spectators_right_idÚ!ix_cmf_roadmap_spectators_root_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© r   r   ú9/opt/eva-app/alembic/versions/dc393dadb843_add_roadmap.pyÚupgrade   s   Ã?÷÷÷rƒ   c                   C   s`  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¡ 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¡ 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¡ 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 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 S )/Nrs   ro   )Ú
table_namerr   rq   rp   rn   rj   rm   rl   rk   ri   r_   rh   rg   rf   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   rA   )r   Ú
drop_indexr€   Ú
drop_tabler   r   r   r‚   Ú	downgrade¡   sZ    


r‡   )Ú__doc__Úalembicr   Ú
sqlalchemyru   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrƒ   r‡   r   r   r   r‚   Ú<module>   s    