
    =gY                     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)zbcmf_ver

Revision ID: bc898ab12e81
Revises: ea31e38f2481
Create Date: 2024-10-29 14:51:12.806101

    )opNbc898ab12e81ea31e38f2481c                  B   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      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      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      t        j                  d-t        j                         d      t        j                  d.t        j
                  d	      d      t        j                  d/t        j
                  d	      d      t        j                  d0t        j
                  d	      d      t        j                  d1t        j
                  d	      d      t        j                  d2t        j
                  d	      d      t        j                  d3t        j                         d      t        j                  d4t        j                         d      t        j                  d5t        j                  d+      d      t        j                  d6t        j                  d7d89      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	      d      t        j                  d@t        j                  d+      d      t        j                  dAt        j                         d      t        j                  dBt        j                         d      t        j                  dCt        j                  d+      d      t        j                  dDt        j                         d      t        j                  dEt        j                         d      t        j                  dFt        j                  d+      d      t        j                  dGt        j                  d+      d      t        j                  dHt        j                  d+      d      t        j                  dIt        j                  d+      d      t        j                  dJt        j                  d+      d      t        j                  dKt        j                         d      t        j                  dLt        j                         d      t        j                  dMt        j                  d      d      t        j                  dNt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dPt        j                  d      d      t        j                  dQt        j                  d      d      t        j                  dRt        j                  d      d      t        j                  dSt        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  d      d      t        j                  dVt        j                  d      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        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                  dat        j                  d      d      t        j                  dbt        j                  d      d      t        j                  dct        j                  d      d      t        j                  ddt        j                  d      d      t        j                  det        j                  d      d      t        j                  dft        j                  d      d      t        j                  dgt        j                  d      d      t        j                  ddgdhg      t        j                  degdig      t        j                  dRgdjg      t        j                  dggdkg      t        j                  dfgdkg      t        j                  d`gdlg      t        j                  dYgdmg      t        j                  dZgdng      t        j                  dVgdog      t        j                  d]gdpg      t        j                  dUgdqg      t        j                  d^gdrg      t        j                  d[gdsg      t        j                  d_gdtg      t        j                  dXgdmg      t        j                  d        t        j                  t        j                  du      dddgdv       t        j                  t        j                  dw      dd;gdv       t        j                  t        j                  dx      ddEgdv       t        j                  t        j                  dy      ddegdv       t        j                  t        j                  dz      ddCgdv       t        j                  t        j                  d{      ddcgdv       t        j                  t        j                  d|      ddMgdv       t        j                  t        j                  d}      dd
gdv       t        j                  t        j                  d~      ddgdv       t        j                  t        j                  d      ddRgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddQgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddPgdv       t        j                  t        j                  d      dd\gdv       t        j                  t        j                  d      ddNgdv       t        j                  t        j                  d      ddggdv       t        j                  t        j                  d      ddfgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      dd`gdv       t        j                  t        j                  d      dd<gdv       t        j                  t        j                  d      ddYgdv       t        j                  t        j                  d      ddAgdv       t        j                  t        j                  d      dd)gdv       t        j                  t        j                  d      ddZgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddOgdv       t        j                  t        j                  d      dd,gdv       t        j                  t        j                  d      ddVgdv       t        j                  t        j                  d      ddWgdv       t        j                  t        j                  d      dd]gdv       t        j                  t        j                  d      ddUgdv       t        j                  t        j                  d      dd^gdv       t        j                  t        j                  d      ddagdv       t        j                  t        j                  d      ddTgdv       t        j                  t        j                  d      dd[gdv       t        j                  t        j                  d      dd_gdv       t        j                  t        j                  d      ddSgdv       t        j                  t        j                  d      ddbgdv       t        j                  t        j                  d      ddXgdv       t        j                  dt        j                  dt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddOgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  dt        j                  dt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddOgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  dt        j                  dt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddOgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       t        j                  dt        j                  dt        j                  d      d      t        j                  dOt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddOgdv       t        j                  t        j                  d      ddgdv       t        j                  t        j                  d      ddgdv       y )Ncmf_test_caseid@   )lengthF)nullablecmf_locked_atT)timezonecmf_created_atcmf_modified_atcmf_viewed_atcmf_deletedcmf_versionname   codesystemtextimport_originalimport_raw_jsonext_idcmf_archivedis_favoritehas_tree_nodestree_node_is_branchtree_hiddenordernoperm_publicperm_has_aclperm_inheritperm_parent_owner_idperm_inherit_acl_idperm_effective_acl_id%perm_security_level_allowed_ids_cacheperm_encrypt	is_publicis_public_editableis_public_commentshas_children_archivedlogic_prefixui_view_form    parent_logic_prefixui_view_form_optionsstatus_modified_atstatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymarkuser_rating      )	precisionscaleuser_rating_count
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cmf_ver_numbercmf_ver_curcmf_author_idcmf_owner_id	parent_idcmf_modified_by_idcmf_locked_by_idcmf_import_idtree_parent_idroot_parent_id
project_idperm_acl_idperm_parent_idworkflow_iddefault_task_workflow_idlogic_type_idscheme_wf_idcmf_owner_assistant_idperm_security_level_idresolution_id	status_id
company_idresponsible_idwaiting_for_idcloned_from_idactivity_idcache_status_opt_idcmf_ver_head_idcmf_ver_head2cur_idzcmf_activity.idzcmf_status_opt.idzcmf_import.idzcmf_test_case.idzcmf_company.idzcmf_workflow.idzcmf_logic_type.idzcmf_access_list.idzcmf_security_level.idzcmf_project.idzcmf_resolution.idzcmf_scheme_wf.idzcmf_status.idix_cmf_test_case_activity_id)uniqueix_cmf_test_case_alarm_dateix_cmf_test_case_approved$ix_cmf_test_case_cache_status_opt_id"ix_cmf_test_case_cache_status_typeix_cmf_test_case_cloned_from_idix_cmf_test_case_cmf_author_idix_cmf_test_case_cmf_created_atix_cmf_test_case_cmf_deletedix_cmf_test_case_cmf_import_idix_cmf_test_case_cmf_locked_at!ix_cmf_test_case_cmf_locked_by_id ix_cmf_test_case_cmf_modified_at#ix_cmf_test_case_cmf_modified_by_id'ix_cmf_test_case_cmf_owner_assistant_idix_cmf_test_case_cmf_owner_id$ix_cmf_test_case_cmf_ver_head2cur_id ix_cmf_test_case_cmf_ver_head_idix_cmf_test_case_cmf_versionix_cmf_test_case_cmf_viewed_atix_cmf_test_case_codeix_cmf_test_case_company_idix_cmf_test_case_deadline)ix_cmf_test_case_default_task_workflow_idix_cmf_test_case_is_templateix_cmf_test_case_logic_prefixix_cmf_test_case_logic_type_idix_cmf_test_case_nameix_cmf_test_case_ordernoix_cmf_test_case_parent_id$ix_cmf_test_case_parent_logic_prefixix_cmf_test_case_perm_acl_idix_cmf_test_case_perm_parent_id'ix_cmf_test_case_perm_security_level_idix_cmf_test_case_project_idix_cmf_test_case_resolution_idix_cmf_test_case_responsible_idix_cmf_test_case_root_parent_idix_cmf_test_case_scheme_wf_idix_cmf_test_case_status_idix_cmf_test_case_tree_parent_idix_cmf_test_case_waiting_for_idix_cmf_test_case_workflow_id"cmf_test_case_cmf_owner_assistants   root_iddescriptioni   left_idright_idleft_name_cacheright_name_cache-ix_cmf_test_case_cmf_owner_assistants_left_id/ix_cmf_test_case_cmf_owner_assistants_parent_id.ix_cmf_test_case_cmf_owner_assistants_right_id-ix_cmf_test_case_cmf_owner_assistants_root_idcmf_test_case_executors"ix_cmf_test_case_executors_left_id$ix_cmf_test_case_executors_parent_id#ix_cmf_test_case_executors_right_id"ix_cmf_test_case_executors_root_idcmf_test_case_local_links$ix_cmf_test_case_local_links_left_id&ix_cmf_test_case_local_links_parent_id%ix_cmf_test_case_local_links_right_id$ix_cmf_test_case_local_links_root_idcmf_test_case_spectators#ix_cmf_test_case_spectators_left_id%ix_cmf_test_case_spectators_parent_id$ix_cmf_test_case_spectators_right_id#ix_cmf_test_case_spectators_root_id)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerNumericForeignKeyConstraintPrimaryKeyConstraintcreate_indexf     5/opt/eva-app/alembic/versions/bc898ab12e81_cmf_ver.pyupgrader      sc   OO lO lIIdBIIR(59lIIor||T:TJl IId ;eLl IIt!<uM	l
 IIor||T:TJl IImRZZ\E:l IImRYY[48l IIfbiis+d;l IIfbiir*T:l IIh

u5l IIfbggi$/l II>l IIT:l IIh		d3l IInbjjlU;l  IImRZZ\E:!l" II

u=#l$ II#RZZ\EB%l& IImRZZ\E:'l( IIi5)l* IImRZZ\E:+l, IInbjjlU;-l. IInbjjlU;/l0 II$biir&:TJ1l2 II#RYYb%9DI3l4 II%ryy';dK5l6 II5rwwy4P7l8 IInbjjlU;9l: IIk2::<%8;l< II"BJJL5A=l> II"BJJL5A?l@ II%rzz|eDAlB IInbiikD9ClD IInbiir2UCElF II#RYY[4@GlH II$bggi%@IlJ II"BLL$$?$OKlL II(",,*EPTUMlN II&d(CdSOlP II ",,"=MQlR II ",,"=MSlT IIlBJJL59UlV IIj"**,7WlX IIfbiir*T:YlZ IImRZZ"A>N[l\ II!2::<%@]l^ IIlBLL$7$G_l` IIj",,5Ealb IIt!<tLcld IIor||T:TJelf II ",,"=Mglh II"!5Eilj IImRZZ\E:kll IIlBJJL59mln II!299B#7$Golp IInbggi$7qlr IIj"**,7slt IImRYYb1EBulv II!299B#7%Hwlx II%ryy';eLylz II%ryy';eL{l| II		 4tD}l~ II

t<l@ IImRZZ\E:AlB IIoryy3dCClD IInbiir2TBElF IIk299B/$?GlH II"BIIR$84HIlJ II "))2"6FKlL IIoryy3dCMlN II		 4tDOlP II		 4tDQlR IIlBIIR04@SlT IImRYYb1DAUlV II		 4tDWlX IImRYYb1DAYlZ II("))2*>N[l\ IIoryy3dC]l^ IInbiir2TB_l` II&		(<tLalb II&		(<tLcld IIoryy3dCelf IIk299B/$?glh IIlBIIR04@ilj II		 4tDkll II		 4tDmln II		 4tDolp IImRYYb1DAqlr II#RYYb%9DIslt II"!5Eulv II#RYYb%9DIwlx ]O.?-@Cylz 236I5JM{l| _-/@C}l~ 236H5ILl@ ./2D1EHAlB \N-=,>AClD 78;L:MPElF _-0C/DGGlH ]O.B-CFIlJ 569P8QTKlL \N-=,>AMlN _-0C/DGOlP ^,/A.BEQlR [MO+<?SlT ]O.?-@CUlV D!WlZ OOBDD78/M?chiOOBDD67<.afgOOBDD45]bcOOBDD?@/TiSjsxyOOBDD=>ReQfotuOOBDD:;_O_N`inoOOBDD9:OoM^glmOOBDD:;_O_N`inoOOBDD78/M?chiOOBDD9:OoM^glmOOBDD9:OoM^glmOOBDD<=QcPdmrsOOBDD;<oPaObkpqOOBDD>?SgRhqvwOOBDDBC_WoVpy~OOBDD89?^L\ejkOOBDD?@/TiSjsxyOOBDD;<oPaObkpqOOBDD78/M?chiOOBDD9:OoM^glmOOBDD01?VHUYZOOBDD67<.afgOOBDD45]bcOOBDDDEYsXt  ~C  DOOBDD78/M?chiOOBDD89?^L\ejkOOBDD9:OoM^glmOOBDD01?VHUZ[OOBDD34o	{[`aOOBDD56+_deOOBDD?@/TiSjsxyOOBDD78/M?chiOOBDD:;_O_N`inoOOBDDBC_WoVpy~OOBDD67<.afgOOBDD9:OoM^glmOOBDD:;_O_N`inoOOBDD:;_O_N`inoOOBDD89?^L\ejkOOBDD56+_deOOBDD:;_O_N`inoOOBDD:;_O_N`inoOOBDD78/M?chiOO8IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDHIKor{q|  FK  LOOBDDJKMqt  tA  JO  POOBDDIJLps}r~  HM  NOOBDDHIKor{q|  FK  LOO-IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD=>@Y\e[fotuOOBDD?@B[^i]jsxyOOBDD>?AZ]g\hqvwOOBDD=>@Y\e[fotuOO/IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD?@B]`i_jsxyOOBDDABD_bmanw|}OOBDD@AC^ak`luz{OOBDD?@B]`i_jsxyOO.IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD>?A[^g]hqvwOOBDD@AC]`k_luz{OOBDD?@B\_i^jsxyOOBDD>?A[^g]hqvwr   c                  2   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                  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                  d0      d       t        j                  t        j                  d1      d       t        j                  t        j                  d2      d       t        j                  t        j                  d3      d       t        j                  t        j                  d4      d       t        j                  t        j                  d5      d       t        j                  t        j                  d6      d       t        j                  t        j                  d7      d       t        j                  t        j                  d8      d       t        j                  t        j                  d9      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                  dA      d       t        j                  d       y )BNr   r   )
table_namer   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   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r~   r}   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rm   )r   
drop_indexr   
drop_tabler   r   r   	downgrader      s   MM"$$<=JdeMM"$$=>KefMM"$$>?LfgMM"$$<=JdeMM,-MM"$$=>KfgMM"$$>?LghMM"$$?@MhiMM"$$=>KfgMM-.MM"$$;<IbcMM"$$<=JcdMM"$$=>KdeMM"$$;<IbcMM+,MM"$$FGTxyMM"$$GHUyzMM"$$HIVz{MM"$$FGTxyMM67MM"$$56?SMM"$$89oVMM"$$89oVMM"$$34QMM"$$67OTMM"$$89oVMM"$$89oVMM"$$78_UMM"$$45/RMM"$$@Ao^MM"$$89oVMM"$$56?SMM"$$=>?[MM"$$34QMM"$$12OMM"$$./OLMM"$$78_UMM"$$67OTMM"$$56?SMM"$$BCP_`MM"$$23PMM"$$45/RMM"$$./OLMM"$$78_UMM"$$56?SMM"$$9:WMM"$$=>?[MM"$$67OTMM"$$@Ao^MM"$$<=/ZMM"$$9:WMM"$$:;XMM"$$78_UMM"$$78_UMM"$$56?SMM"$$89oVMM"$$78_UMM"$$89oVMM"$$;<YMM"$$=>?[MM"$$23PMM"$$45/RMM"$$56?SMM/"r   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s6      
UxrA#r   