U
    r#hة                     @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd Zd	d
 ZdS )zbevatest

Revision ID: b50bdf52415f
Revises: 2b3e3a577edf
Create Date: 2024-12-18 10:34:40.746279

    )opN)
postgresqlZb50bdf52415fZ2b3e3a577edfc                   C   s  t jddd t jddd t jddd t jddd t d t jddd t jd	dd t jd
dd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jd d!d t jd"d!d t jd#d!d t jd$d!d t jd%d!d t jd&d!d t jd'd!d t jd(d!d t jd)d!d t jd*d!d t jd+d!d t jd,d!d t jd-d!d t jd.d!d t jd/d!d t jd0d!d t jd1d!d t jd2d!d t jd3d!d4d5 t jd6d!d4d5 t jd7d!d4d5 t jd8d!d4d5 t jd9d!d4d5 t jd:d!d4d5 t jd;d!d4d5 t jd<d!d4d5 t jd=d!d4d5 t d!d> t d!d? t d!d@ t d!dA t d!dB t d!dC t d!dD t d!dE t d!dF t d!dG t d!dH t d!dI t d!dJ t d!dK t d!dL t d!dM t d!dN t d!dO t d!dP t d!dQ t d!dR t d!dS t d!dT t d!dU t d!dV t d!dW t d!dX t d!dY t d!dZ t d!d[ t d!d\ t d!d] t d!d^ t d!d_ t d!d` t d!da t d!db t d!dc t d!dd t d!de t d!df t d!dg t d!dh t d!di t jdjdkd t jdldkd t jdmdkd t jdndkd t jdodkd t jdpdkd t jdqdkd t jdrdkd t jdsdkd t jdtdkd t jdudkd t jdvdkd t jdwdkd t jdxdkd t jdydkd t jdzdkd t jd{dkd t jd|dkd t jd}dkd t jd~dkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t jddkd4d5 t dkd> t dkd? t dkd@ t dkdA t dkdB t dkdC t dkdD t dkdE t dkdF t dkdG t dkdH t dkdI t dkdJ t dkdK t dkdL t dkdM t dkdN t dkdO t dkdP t dkdQ t dkdR t dkdS t dkdT t dkdU t dkdV t dkdW t dkd t dkdX t dkdY t dkdZ t dkd[ t dkd\ t dkd] t dkd^ t dkd_ t dkd` t dkda t dkdb t dkdc t dkdd t dkde t dkdf t dkdg t dkdh t dkdi d S )N'ix_cmf_testcase_run_local_links_left_idcmf_testcase_run_local_links)
table_name)ix_cmf_testcase_run_local_links_parent_id(ix_cmf_testcase_run_local_links_right_id'ix_cmf_testcase_run_local_links_root_id3ix_cmf_testcycle_testcase_result_spectators_left_id(cmf_testcycle_testcase_result_spectators5ix_cmf_testcycle_testcase_result_spectators_parent_id4ix_cmf_testcycle_testcase_result_spectators_right_id3ix_cmf_testcycle_testcase_result_spectators_root_id=ix_cmf_testcycle_testcase_result_cmf_owner_assistants_left_id2cmf_testcycle_testcase_result_cmf_owner_assistants?ix_cmf_testcycle_testcase_result_cmf_owner_assistants_parent_id>ix_cmf_testcycle_testcase_result_cmf_owner_assistants_right_id=ix_cmf_testcycle_testcase_result_cmf_owner_assistants_root_id0ix_cmf_testcase_run_cmf_owner_assistants_left_id%cmf_testcase_run_cmf_owner_assistants2ix_cmf_testcase_run_cmf_owner_assistants_parent_id1ix_cmf_testcase_run_cmf_owner_assistants_right_id0ix_cmf_testcase_run_cmf_owner_assistants_root_id2ix_cmf_testcycle_testcase_result_executors_left_id'cmf_testcycle_testcase_result_executors4ix_cmf_testcycle_testcase_result_executors_parent_id3ix_cmf_testcycle_testcase_result_executors_right_id2ix_cmf_testcycle_testcase_result_executors_root_id4ix_cmf_testcycle_testcase_result_local_links_left_id)cmf_testcycle_testcase_result_local_links6ix_cmf_testcycle_testcase_result_local_links_parent_id5ix_cmf_testcycle_testcase_result_local_links_right_id4ix_cmf_testcycle_testcase_result_local_links_root_idix_cmf_testcase_run_activity_idcmf_testcase_runix_cmf_testcase_run_alarm_dateix_cmf_testcase_run_approved'ix_cmf_testcase_run_cache_status_opt_id%ix_cmf_testcase_run_cache_status_type"ix_cmf_testcase_run_cloned_from_id*ix_cmf_testcase_run_cmf_owner_assistant_idix_cmf_testcase_run_company_idix_cmf_testcase_run_deadline,ix_cmf_testcase_run_default_task_workflow_idix_cmf_testcase_run_is_template ix_cmf_testcase_run_logic_prefix!ix_cmf_testcase_run_logic_type_id'ix_cmf_testcase_run_parent_logic_prefix*ix_cmf_testcase_run_perm_security_level_id!ix_cmf_testcase_run_resolution_id ix_cmf_testcase_run_scheme_wf_idix_cmf_testcase_run_workflow_id cmf_testcase_run_company_id_fkey
foreignkey)type_#cmf_testcase_run_resolution_id_fkey!cmf_testcase_run_workflow_id_fkey)cmf_testcase_run_cache_status_opt_id_fkey#cmf_testcase_run_logic_type_id_fkey,cmf_testcase_run_perm_security_level_id_fkey.cmf_testcase_run_default_task_workflow_id_fkey"cmf_testcase_run_scheme_wf_id_fkey!cmf_testcase_run_activity_id_fkeyis_templatemark	is_publiclogic_type_idui_view_form_optionsperm_security_level_id
alarm_datecloned_from_idapprovedperiod_next_dateresolution_idplan_end_dateperm_policystatus_review_at
company_idis_public_editablestatus_closed_atdeadlineplan_start_dateparent_logic_prefixdefault_task_workflow_idcmf_owner_assistant_idlogic_prefixuser_rating_count
is_penaltystatus_in_progress_startis_public_commentsui_view_formworkflow_idstatus_modified_atsharelink_hashperm_policy_guestuser_ratingperm_policy_sharelinkcache_status_typescheme_wf_idhas_children_archivedstatus_in_progress_endcache_fieldsperm_policy_anonymouscache_status_opt_idperiod_interval
no_controlactivity_id,ix_cmf_testcycle_testcase_result_activity_idcmf_testcycle_testcase_result+ix_cmf_testcycle_testcase_result_alarm_date)ix_cmf_testcycle_testcase_result_approved4ix_cmf_testcycle_testcase_result_cache_status_opt_id2ix_cmf_testcycle_testcase_result_cache_status_type/ix_cmf_testcycle_testcase_result_cloned_from_id7ix_cmf_testcycle_testcase_result_cmf_owner_assistant_id+ix_cmf_testcycle_testcase_result_company_id)ix_cmf_testcycle_testcase_result_deadline9ix_cmf_testcycle_testcase_result_default_task_workflow_id,ix_cmf_testcycle_testcase_result_is_template-ix_cmf_testcycle_testcase_result_logic_prefix.ix_cmf_testcycle_testcase_result_logic_type_id4ix_cmf_testcycle_testcase_result_parent_logic_prefix7ix_cmf_testcycle_testcase_result_perm_security_level_id.ix_cmf_testcycle_testcase_result_resolution_id-ix_cmf_testcycle_testcase_result_scheme_wf_id/ix_cmf_testcycle_testcase_result_waiting_for_id,ix_cmf_testcycle_testcase_result_workflow_id9cmf_testcycle_testcase_result_perm_security_level_id_fkey;cmf_testcycle_testcase_result_default_task_workflow_id_fkey0cmf_testcycle_testcase_result_resolution_id_fkey.cmf_testcycle_testcase_result_activity_id_fkey-cmf_testcycle_testcase_result_company_id_fkey6cmf_testcycle_testcase_result_cache_status_opt_id_fkey0cmf_testcycle_testcase_result_logic_type_id_fkey.cmf_testcycle_testcase_result_workflow_id_fkey/cmf_testcycle_testcase_result_scheme_wf_id_fkeywaiting_for_id)r   
drop_index
drop_tabledrop_constraintdrop_column r   r   5/opt/eva-app/alembic/versions/b50bdf52415f_evatest.pyupgrade   s\   





r   c                   C   s  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d t dtjdtjddd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d t dtjdt ddd t dtjdtjddddd t dtjdtjd
dddd t dtjdtjd
dddd t dtjdtj	dddddd t dtjdtjd
dddd t dtjdtjd
dddd t dtjdtjddddd t dtjdtjddd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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
 ddd t dtjd"t ddd t dtjd#tjddd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d t dtjd'tjddd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d t dtjd+tjddddd t dtjd,tjd
dddd t dtjd-tjddddd t dtjd.tjddddd t dtjd/tjddddd t dtjd0t ddd t dtjd1tjddddd t dtjd2tjddddd t dtjd3tjddddd t dtjd4t ddd t dtjd5tjddddd t dtjd6t ddd t dtjd7tjd
dddd t dtjd8t ddd t d9dd:dgd;g t d<dd=dgd;g t d>dd?d5gd;g t d@ddAdgd;g t dBddCd*gd;g t dDddEdgd;g t dFddGd.gd;g t dHdd=d$gd;g t dIddJd3gd;g t jdKddgddL t jdMddgddL t jdNddgddL t jdOdd.gddL t jdPdd3gddL t jdQdd%gddL t jdRdd5gddL t jdSdd"gddL t jdTdd8gddL t jdUdd$gddL t jdVdd'gddL t jdWdd*gddL t jdXdd#gddL t jdYdd1gddL t jdZddgddL t jd[ddgddL t jd\dd0gddL t jd]dd2gddL t jd^ddgddL 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d t d_tjdtjddd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d t d_tjdt ddd t d_tjdtjddddd t d_tjdtjd
dddd t d_tjdtjd
dddd t d_tjdtj	dddddd t d_tjdtjd
dddd t d_tjdtjd
dddd t d_tjdtjddddd t d_tjdtjddd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d t d_tjd t ddd t d_tjd!t
 ddd t d_tjd"t ddd t d_tjd#tjddd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d t d_tjd'tjddd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d t d_tjd+tjddddd t d_tjd,tjd
dddd t d_tjd-tjddddd t d_tjd.tjddddd t d_tjd/tjddddd t d_tjd0t ddd t d_tjd1tjddddd t d_tjd2tjddddd t d_tjd3tjddddd t d_tjd4t ddd t d_tjd5tjddddd t d_tjd6t ddd t d_tjd7tjd
dddd t d_tjd8t ddd t d`d_dEdgd;g t dad_d:dgd;g t dbd_d=d$gd;g t dcd_dJd3gd;g t ddd_d?d5gd;g t ded_dAdgd;g t dfd_d=dgd;g t dgd_dGd.gd;g t dhd_dCd*gd;g t jdid_dgddL t jdjd_dgddL t jdkd_d.gddL t jdld_d3gddL t jdmd_d%gddL t jdnd_d5gddL t jdod_d"gddL t jdpd_d8gddL t jdqd_d$gddL t jdrd_d'gddL t jdsd_d*gddL t jdtd_d#gddL t jdud_d1gddL t jdvd_dgddL t jdwd_dgddL t jdxd_d0gddL t jdyd_d2gddL t jdzd_dgddL t d{tjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jdd{d~gddL t jdd{dgddL t jdd{d}gddL t jdd{dgddL t dtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jddd~gddL t jdddgddL t jddd}gddL t jdddgddL t dtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jddd~gddL t jdddgddL t jddd}gddL t jdddgddL t dtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jddd~gddL t jdddgddL t jddd}gddL t jdddgddL t dtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jddd~gddL t jdddgddL t jddd}gddL t jdddgddL t dtjd;tjd|ddddtjd}tjdddddtjd~tjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtjd;dd
 t jddd~gddL t jdddgddL t jddd}gddL t jdddgddL d S )Nrn   rl   @   )lengthFT)autoincrementnullablerk   rj       ri   rh   rg   rf   )timezonere   rd   rc   rb   ra         )	precisionscaler`   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   rF   rE   rD   rC   rB   rA   r   cmf_scheme_wfidr   cmf_workflowr   cmf_logic_typer   cmf_status_optr   cmf_companyr   cmf_activityr   cmf_resolutionr   r   cmf_security_levelr   )uniquer   r~   r}   r|   r{   rz   ry   rx   rw   rv   ru   rt   rs   rr   rq   rp   ro   rm   r$   r@   r?   r>   r=   r<   r;   r:   r9   r6   r5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r#   r      	parent_idroot_iddescriptioni   left_idright_idleft_name_cache   right_name_cacheZ.cmf_testcycle_testcase_result_local_links_pkey)namer"   r!   r    r   r   Z,cmf_testcycle_testcase_result_executors_pkeyr   r   r   r   r   Z*cmf_testcase_run_cmf_owner_assistants_pkeyr   r   r   r   r   Z7cmf_testcycle_testcase_result_cmf_owner_assistants_pkeyr   r   r   r   r   Z-cmf_testcycle_testcase_result_spectators_pkeyr   r   r   r
   r   Z!cmf_testcase_run_local_links_pkeyr	   r   r   r   )r   
add_columnsaColumnVARCHARBOOLEANTEXTr   	TIMESTAMPNUMERICINTEGERcreate_foreign_keycreate_indexcreate_tablePrimaryKeyConstraintr   r   r   r   	downgrade   s   """"""""$"""""""""""""""""""""""""""""""$""""""""""""""""""""""r   )__doc__alembicr   
sqlalchemyr   Zsqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   r   <module>   s    4