
    \d8                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zfadd roadmap

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

    )opNdc393dadb8439a573fb87308c                  P+   t        j                  g dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  d t        j                  d      d      t        j                  d!t        j
                  d	      d      t        j                  d"t        j
                  d	      d      t        j                  d#t        j                         d      t        j                  d$t        j
                  d	      d      t        j                  d%t        j
                  d	      d      t        j                  d&t        j
                  d	      d      t        j                  d't        j                  d      d      t        j                  d(t        j                         d      t        j                  d)t        j                         d      t        j                  d*t        j                  d      d      t        j                  d+t        j                         d      t        j                  d,t        j                         d      t        j                  d-t        j                         d      t        j                  d.t        j                         d      t        j                  d/t        j                         d      t        j                  d0t        j                  d      d      t        j                  d1t        j                         d      t        j                  d2t        j                  d      d      t        j                  d3t        j                  d      d      t        j                  d4t        j                  d      d      t        j                  d5t        j                  d      d      t        j                  d6t        j                  d      d      t        j                  d7t        j                  d      d      t        j                  d8t        j                  d      d      t        j                  d9t        j                  d      d      t        j                  d:t        j                  d      d      t        j                  d;t        j                  d      d      t        j                  d<t        j                  d      d      t        j                  d=t        j                  d      d      t        j                  d>t        j                  d      d      t        j                  d?t        j                  d      d      t        j                  d@t        j                  d      d      t        j                  d?gdAg      t        j                  d@gdBg      t        j                  d8gdCg      t        j                  d;gdDg      t        j                  d:gdEg      t        j                  d        t        j                  t        j                  dF      dd?gdG       t        j                  t        j                  dH      dd!gdG       t        j                  t        j                  dI      dd,gdG       t        j                  t        j                  dJ      dd@gdG       t        j                  t        j                  dK      dd*gdG       t        j                  t        j                  dL      dd>gdG       t        j                  t        j                  dM      dd2gdG       t        j                  t        j                  dN      dd
gdG       t        j                  t        j                  dO      ddgdG       t        j                  t        j                  dP      dd8gdG       t        j                  t        j                  dQ      ddgdG       t        j                  t        j                  dR      dd7gdG       t        j                  t        j                  dS      ddgdG       t        j                  t        j                  dT      dd6gdG       t        j                  t        j                  dU      dd4gdG       t        j                  t        j                  dV      dd3gdG       t        j                  t        j                  dW      ddgdG       t        j                  t        j                  dX      ddgdG       t        j                  t        j                  dY      ddgdG       t        j                  t        j                  dZ      dd;gdG       t        j                  t        j                  d[      dd(gdG       t        j                  t        j                  d\      ddgdG       t        j                  t        j                  d]      ddgdG       t        j                  t        j                  d^      dd5gdG       t        j                  t        j                  d_      dd<gdG       t        j                  t        j                  d`      dd:gdG       t        j                  t        j                  da      dd9gdG       t        j                  t        j                  db      dd=gdG       t        j                  t        j                  dc      dd0gdG       t        j                  ddt        j                  dt        j                  d      d      t        j                  d5t        j                  d      d      t        j                  det        j                  d      d      t        j                  dft        j                  dg      d      t        j                  dht        j                  d      d      t        j                  dit        j                  d      d      t        j                  djt        j                  d      d      t        j                  dkt        j                  d      d      t        j                  d      
       t        j                  t        j                  dl      dddhgdG       t        j                  t        j                  dm      ddd5gdG       t        j                  t        j                  dn      dddigdG       t        j                  t        j                  do      dddegdG       t        j                  dpt        j                  dt        j                  d      d      t        j                  d5t        j                  d      d      t        j                  det        j                  d      d      t        j                  dft        j                  dg      d      t        j                  dht        j                  d      d      t        j                  dit        j                  d      d      t        j                  djt        j                  d      d      t        j                  dkt        j                  d      d      t        j                  d      
       t        j                  t        j                  dq      dpdhgdG       t        j                  t        j                  dr      dpd5gdG       t        j                  t        j                  ds      dpdigdG       t        j                  t        j                  dt      dpdegdG       t        j                  dut        j                  dt        j                  d      d      t        j                  d5t        j                  d      d      t        j                  det        j                  d      d      t        j                  dft        j                  dg      d      t        j                  dht        j                  d      d      t        j                  dit        j                  d      d      t        j                  djt        j                  d      d      t        j                  dkt        j                  d      d      t        j                  d      
       t        j                  t        j                  dv      dudhgdG       t        j                  t        j                  dw      dud5gdG       t        j                  t        j                  dx      dudigdG       t        j                  t        j                  dy      dudegdG       y )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     9/opt/eva-app/alembic/versions/dc393dadb843_add_roadmap.pyupgrader      s   OO >M >IIdBIIR(59>IIor||T:TJ> IId ;eL> IIt!<uM	>
 IIor||T:TJ> IImRZZ\E:> IImRYY[48> IIfbiis+d;> IIfbiir*T:> IIh

u5> IIfbggi$/> II#RWWY?> IImRZZ\D9> IIi6> II

t<>  IImRZZ\D9!>" II"BLL$$?$O#>$ II(",,*EPTU%>& II&d(CdS'>( IIlBJJL48)>* IInbiir2UC+>, IIj"**,7->. IIfbiir*T:/>0 IIlBLL$7$G1>2 IIj",,5E3>4 IIorzz|d;5>6 IIt!<tL7>8 IIor||T:TJ9>: II ",,"=M;>< II"!5E=>> IImRZZ\D9?>@ IIlBJJL48A>B II!299B#7$GC>D IInbggi$7E>F IIj"**,7G>H IIorzz|d;I>J IInbjjlT:K>L IInbjjlT:M>N IIoryy3dCO>P II#RZZ\EBQ>R IIoryy3dCS>T IInbiir2TBU>V II&		(<tLW>X IIk299B/$?Y>Z II"BIIR$84H[>\ II "))2"6F]>^ IIoryy3dC_>` II		 4tDa>b IIk299B/$?c>d IIlBIIR04@e>f II		 4tDg>h II		 4tDi>j II		 4tDk>l IImRYYb1DAm>n II#RYYb%9DIo>p ]O.?-@Cq>r 236I5JMs>t _-/@Cu>v \N-=,>Aw>x [MO+<?y>z D!{>~ OOBDD56_deOOBDD45}|n]bcOOBDD23]ZLY^_OOBDD=>PeOfotuOOBDD;<mNaMbkpqOOBDD89=K[J\ejkOOBDD78-/IZchiOOBDD89=K[J\ejkOOBDD56_deOOBDD78-/IZchiOOBDD78-/IZchiOOBDD:;]M_L`inoOOBDD9:ML]K^glmOOBDD<=}OcNdmrsOOBDD@A=SkRluz{OOBDD67HXafgOOBDD56_deOOBDD78-/IZchiOOBDD./QUVOOBDD45}|n]bcOOBDD56_deOOBDD./QVWOOBDD12MI;W\]OOBDD34mk][`aOOBDD89=K[J\ejkOOBDD34mk][`aOOBDD89=K[J\ejkOOBDD89=K[J\ejkOOBDD78-/IZchiOO+IIdBIIR(59IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD;<>UXaWbkpqOOBDD=>@WZeYfotuOOBDD<=?VYcXdmrsOOBDD;<>UXaWbkpqOO)IIdBIIR(59IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD9:<QT]S^glmOOBDD;<>SVaUbkpqOOBDD:;=RU_T`inoOOBDD9:<QT]S^glmOO,IIdBIIR(59IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD<=?WZcYdmrsOOBDD>?AY\g[hqvwOOBDD=>@X[eZfotuOOBDD<=?WZcYdmrsr   c                      t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d	      d       t        j                  t        j                  d
      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d       d       t        j                  t        j                  d!      d       t        j                  t        j                  d"      d       t        j                  t        j                  d#      d       t        j                  t        j                  d$      d       t        j                  t        j                  d%      d       t        j                  t        j                  d&      d       t        j                  t        j                  d'      d       t        j                  t        j                  d(      d       t        j                  t        j                  d)      d       t        j                  t        j                  d*      d       t        j                  t        j                  d+      d       t        j                  t        j                  d,      d       t        j                  t        j                  d-      d       t        j                  t        j                  d.      d       t        j                  d       y )/Nrw   rs   )
table_namerv   ru   rt   rr   rn   rq   rp   ro   rm   rc   rl   rk   rj   rb   r   ra   r`   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   rE   )r   
drop_indexr   
drop_tabler   r   r   	downgrader      s   MM"$$:;H`aMM"$$;<IabMM"$$<=JbcMM"$$:;H`aMM*+MM"$$78EZ[MM"$$89F[\MM"$$9:G\]MM"$$78EZ[MM'(MM"$$9:G^_MM"$$:;H_`MM"$$;<I`aMM"$$9:G^_MM)*MM"$$56=QMM"$$67MRMM"$$67MRMM"$$12}MMM"$$67MRMM"$$12}MMM"$$/0]KMM"$$,--HMM"$$34OMM"$$23NMM"$$,--HMM"$$56=QMM"$$34OMM"$$45-PMM"$$>?MZMM"$$:;VMM"$$78]SMM"$$89mTMM"$$56=QMM"$$56=QMM"$$34OMM"$$67MRMM"$$56=QMM"$$67MRMM"$$9:}UMM"$$;<WMM"$$01mLMM"$$23NMM"$$34OMM- r   )__doc__alembicr   
sqlalchemyry   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s5      
Jt\.!r   