U
    g*                    @   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: c94a6ce1b5b5
Revises: c54cb4a84585
Create Date: 2025-02-06 13:53:32.196062

    )opN)
postgresqlZc94a6ce1b5b5Zc54cb4a84585c                ?   C   s%  t jdd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 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 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 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d0t d	d
tjd1tjdd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d6gdBgtd>gdCgtd:gdDgtd9gdEgtd=gdFgtd; t jt dGdd<gd	dH t jt dIdd1gd	dH t jt dJddgd	dH t jt dKddgd	dH t jt dLdd6gd	dH t jt dMddgd	dH t jt dNdd5gd	dH t jt dOddgd	dH t jt dPdd4gd	dH t jt dQdd2gd	dH t jt dRddgd	dH t jt dSddgd	dH t jt dTddgddH t jt dUddgd	dH t jt dVdd!gd	dH t jt dWdd>gd	dH t jt dXdd3gd	dH t jt dYdd:gd	dH t jt dZdd;gd	dH t jt d[dd9gd	dH t jt d\dd=gd	dH t jt d]dd?gd	dH t jt d^dd8gd	dH t jt d_dd7gd	dH t jt d`dd@gd	dH t datjdtjdbdd	d
tjd3tjdddd
tjdctjdddd
tjddtjdeddd
tjdftjdddd
tjdgtjdddd
tjdhtjdddd
tjditjdddd
tdfgdjgtdggdkgtd t jt dldadfgd	dH t jt dmdad3gd	dH t jt dndadggd	dH t jt dodadcgd	dH t dptjdtjdbdd	d
tjd3tjdddd
tjdctjdddd
tjddtjdeddd
tjdftjdddd
tjdgtjdddd
tjdhtjdddd
tjditjdddd
td
 t jt dqdpdfgd	dH t jt drdpd3gd	dH t jt dsdpdggd	dH t jt dtdpdcgd	dH t dutjdtjdbdd	d
tjd3tjdddd
tjdctjdddd
tjddtjdeddd
tjdftjdddd
tjdgtjdddd
tjdhtjdddd
tjditjdddd
td
 t jt dvdudfgd	dH t jt dwdud3gd	dH t jt dxdudggd	dH t jt dydudcgd	dH t dzt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 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 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jd,ddd
tjd1tjdd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dtjdddd
td6gdBgtd:gdDgtd9gdEgtdgdgtd6 t jt ddzd1gd	dH t jt ddzdgd	dH t jt ddzdgd	dH t jt ddzd6gd	dH t jt ddzdgd	dH t jt ddzd5gd	dH t jt ddzdgd	dH t jt ddzd4gd	dH t jt ddzd2gd	dH t jt ddzdgd	dH t jt ddzdgd	dH t jt ddzdgddH t jt ddzdgd	dH t jt ddzd!gd	dH t jt ddzd3gd	dH t jt ddzd:gd	dH t jt ddzd;gd	dH t jt ddzd9gd	dH t jt ddzd8gd	dH t jt ddzdgd	dH t jt ddzd7gd	dH t dtjdtjdbdd	d
tjd3tjdddd
tjdctjdddd
tjddtjdeddd
tjdftjdddd
tjdgtjdddd
tjdhtjdddd
tjditjdddd
tdfgdgtdggdkgtd t jt dddfgd	dH t jt ddd3gd	dH t jt dddggd	dH t jt dddcgd	dH t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t dš t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jddd t jdddd t dʡ t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jddd t d t jddd t jddd t jddd t jd dd t d t jddd t jddd t jddd t jddd 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 dd t d t dtjd<tjddd	d
 t jddd t jt ddd<gd	dH t jdddd t d ddd<gdg t dd t j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 jddtjddd	d t jd dd t jd!dd t jd"dd t jt d#ddgd	dH t jt d$ddgd	dH t jd%ddd t d dddgdg t d dd&dgdg t dd@ t dd' t dd= t d(tjd)t	 dd
 t d(d* t jd+d,d t jd-d,d t jd.d,d t jd/d,d t jd0d,d t jd1d,d t jd2d,d t jd3d,d t jd4d,d t jd5d,d t jd6d,d t jd7d,d t jd8d,d t jd9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dAd,dd t jdBd,dd t jdCd,dd t jdDd,dd t jdEd,dd t jdFd,dd t jdGd,dd t jdHd,dd t jdId,dd t jdJd,dd 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 d,d- 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,d? t d,ds t d,dt t d,du t d,d@ t d,dv t d,dw t jdxdyd t jdzdyd t jd{dyd t jd|dyd t jd}dyd t jd~dyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddyd t jddydd t jddydd t jddydd t jddydd t jddydd t jddydd t jddydd t jddydd t jddydd t jddydd t dydK t dydL t dydM t dydN t dydO t dydP t dydQ t dydR t dydS t dydT t dydU t dydV t dydW t dydX t dydY t dydZ t dyd[ t dyd\ t dyd] t dyd^ t dyd_ t dyd` t dyda t dydb t dydc t dydd t dyde t dydf t dydg t dydh t dydi t dyd- t dydj t dydk t dydl t dydm t dydn t dydo t dydp t dydq t dydr t dyd? t dyds t dydt t dydu t dyd@ t dydv t dydw d S (  N2cmf_testcase_run_testcycle_testcase_result_id_fkeycmf_testcase_run
foreignkeytype_cmf_testcase_run_history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sl_owner_lock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perm_encrypt_helpstatus    priorityestimate_time
spent_timeZ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cache_testcase_id
release_idparams_row_idresponsible_idwaiting_for_idcmf_testcase.idcmf_import.idcmf_testcase_params_row.idcmf_access_list.idcmf_project.idzcmf_list.id-ix_cmf_testcase_run_history_cache_testcase_idunique)ix_cmf_testcase_run_history_cmf_author_id*ix_cmf_testcase_run_history_cmf_created_at'ix_cmf_testcase_run_history_cmf_deleted)ix_cmf_testcase_run_history_cmf_import_id)ix_cmf_testcase_run_history_cmf_locked_at,ix_cmf_testcase_run_history_cmf_locked_by_id+ix_cmf_testcase_run_history_cmf_modified_at.ix_cmf_testcase_run_history_cmf_modified_by_id(ix_cmf_testcase_run_history_cmf_owner_id'ix_cmf_testcase_run_history_cmf_version)ix_cmf_testcase_run_history_cmf_viewed_at ix_cmf_testcase_run_history_code ix_cmf_testcase_run_history_name#ix_cmf_testcase_run_history_orderno)ix_cmf_testcase_run_history_params_row_id%ix_cmf_testcase_run_history_parent_id'ix_cmf_testcase_run_history_perm_acl_id*ix_cmf_testcase_run_history_perm_parent_id&ix_cmf_testcase_run_history_project_id&ix_cmf_testcase_run_history_release_id*ix_cmf_testcase_run_history_responsible_id*ix_cmf_testcase_run_history_root_parent_id*ix_cmf_testcase_run_history_tree_parent_id*ix_cmf_testcase_run_history_waiting_for_id!cmf_testcase_run_history_cmf_task   root_iddescription   left_idright_idleft_name_cacheright_name_cachezcmf_testcase_run_history.idcmf_task.id,ix_cmf_testcase_run_history_cmf_task_left_id.ix_cmf_testcase_run_history_cmf_task_parent_id-ix_cmf_testcase_run_history_cmf_task_right_id,ix_cmf_testcase_run_history_cmf_task_root_id"cmf_testcase_run_history_executors-ix_cmf_testcase_run_history_executors_left_id/ix_cmf_testcase_run_history_executors_parent_id.ix_cmf_testcase_run_history_executors_right_id-ix_cmf_testcase_run_history_executors_root_id#cmf_testcase_run_history_spectators.ix_cmf_testcase_run_history_spectators_left_id0ix_cmf_testcase_run_history_spectators_parent_id/ix_cmf_testcase_run_history_spectators_right_id.ix_cmf_testcase_run_history_spectators_root_idcmf_testcase_run_history_stepstep_sectionexpected_resultactual_result	test_datacommenttestcase_step_idcmf_testcase_step.id.ix_cmf_testcase_run_history_step_cmf_author_id/ix_cmf_testcase_run_history_step_cmf_created_at,ix_cmf_testcase_run_history_step_cmf_deleted.ix_cmf_testcase_run_history_step_cmf_import_id.ix_cmf_testcase_run_history_step_cmf_locked_at1ix_cmf_testcase_run_history_step_cmf_locked_by_id0ix_cmf_testcase_run_history_step_cmf_modified_at3ix_cmf_testcase_run_history_step_cmf_modified_by_id-ix_cmf_testcase_run_history_step_cmf_owner_id,ix_cmf_testcase_run_history_step_cmf_version.ix_cmf_testcase_run_history_step_cmf_viewed_at%ix_cmf_testcase_run_history_step_code%ix_cmf_testcase_run_history_step_name(ix_cmf_testcase_run_history_step_orderno*ix_cmf_testcase_run_history_step_parent_id,ix_cmf_testcase_run_history_step_perm_acl_id/ix_cmf_testcase_run_history_step_perm_parent_id+ix_cmf_testcase_run_history_step_project_id/ix_cmf_testcase_run_history_step_root_parent_id1ix_cmf_testcase_run_history_step_testcase_step_id/ix_cmf_testcase_run_history_step_tree_parent_id&cmf_testcase_run_history_step_cmf_taskz cmf_testcase_run_history_step.id1ix_cmf_testcase_run_history_step_cmf_task_left_id3ix_cmf_testcase_run_history_step_cmf_task_parent_id2ix_cmf_testcase_run_history_step_cmf_task_right_id1ix_cmf_testcase_run_history_step_cmf_task_root_id.ix_cmf_testcycle_testcase_result_cmf_author_idcmf_testcycle_testcase_result
table_name/ix_cmf_testcycle_testcase_result_cmf_created_at,ix_cmf_testcycle_testcase_result_cmf_deleted.ix_cmf_testcycle_testcase_result_cmf_import_id.ix_cmf_testcycle_testcase_result_cmf_locked_at1ix_cmf_testcycle_testcase_result_cmf_locked_by_id0ix_cmf_testcycle_testcase_result_cmf_modified_at3ix_cmf_testcycle_testcase_result_cmf_modified_by_id-ix_cmf_testcycle_testcase_result_cmf_owner_id,ix_cmf_testcycle_testcase_result_cmf_version.ix_cmf_testcycle_testcase_result_cmf_viewed_at%ix_cmf_testcycle_testcase_result_code4ix_cmf_testcycle_testcase_result_cur_testcase_run_id/ix_cmf_testcycle_testcase_result_environment_id%ix_cmf_testcycle_testcase_result_name(ix_cmf_testcycle_testcase_result_orderno.ix_cmf_testcycle_testcase_result_params_row_id*ix_cmf_testcycle_testcase_result_parent_id,ix_cmf_testcycle_testcase_result_perm_acl_id/ix_cmf_testcycle_testcase_result_perm_parent_id+ix_cmf_testcycle_testcase_result_project_id/ix_cmf_testcycle_testcase_result_responsible_id/ix_cmf_testcycle_testcase_result_root_parent_id6ix_cmf_testcycle_testcase_result_test_configuration_id,ix_cmf_testcycle_testcase_result_testcase_id=ix_cmf_testcycle_testcase_result_testcycle_testcase_folder_id/ix_cmf_testcycle_testcase_result_tree_parent_id2ix_cmf_testplan_testcase_folder_spectators_left_id'cmf_testplan_testcase_folder_spectators4ix_cmf_testplan_testcase_folder_spectators_parent_id3ix_cmf_testplan_testcase_folder_spectators_right_id2ix_cmf_testplan_testcase_folder_spectators_root_id%ix_cmf_testcase_run_executors_left_idcmf_testcase_run_executors'ix_cmf_testcase_run_executors_parent_id&ix_cmf_testcase_run_executors_right_id%ix_cmf_testcase_run_executors_root_id4ix_cmf_testcycle_testcase_folder_local_links_left_id)cmf_testcycle_testcase_folder_local_links6ix_cmf_testcycle_testcase_folder_local_links_parent_id5ix_cmf_testcycle_testcase_folder_local_links_right_id4ix_cmf_testcycle_testcase_folder_local_links_root_id&ix_cmf_testcase_run_step_cmf_author_idcmf_testcase_run_step'ix_cmf_testcase_run_step_cmf_created_at$ix_cmf_testcase_run_step_cmf_deleted&ix_cmf_testcase_run_step_cmf_import_id&ix_cmf_testcase_run_step_cmf_locked_at)ix_cmf_testcase_run_step_cmf_locked_by_id(ix_cmf_testcase_run_step_cmf_modified_at+ix_cmf_testcase_run_step_cmf_modified_by_id%ix_cmf_testcase_run_step_cmf_owner_id$ix_cmf_testcase_run_step_cmf_version&ix_cmf_testcase_run_step_cmf_viewed_atix_cmf_testcase_run_step_codeix_cmf_testcase_run_step_name ix_cmf_testcase_run_step_orderno"ix_cmf_testcase_run_step_parent_id'ix_cmf_testcase_run_step_parent_step_id$ix_cmf_testcase_run_step_perm_acl_id'ix_cmf_testcase_run_step_perm_parent_id#ix_cmf_testcase_run_step_project_id'ix_cmf_testcase_run_step_root_parent_id$ix_cmf_testcase_run_step_testcase_id)ix_cmf_testcase_run_step_testcase_step_id'ix_cmf_testcase_run_step_tree_parent_id+cmf_testcase_run_step_cmf_task_left_id_fkeycmf_testcase_run_step_cmf_task3ix_cmf_testcycle_testcase_folder_spectators_left_id(cmf_testcycle_testcase_folder_spectators5ix_cmf_testcycle_testcase_folder_spectators_parent_id4ix_cmf_testcycle_testcase_folder_spectators_right_id3ix_cmf_testcycle_testcase_folder_spectators_root_id3ix_cmf_testplan_testcase_folder_local_links_left_id(cmf_testplan_testcase_folder_local_links5ix_cmf_testplan_testcase_folder_local_links_parent_id4ix_cmf_testplan_testcase_folder_local_links_right_id3ix_cmf_testplan_testcase_folder_local_links_root_id&ix_cmf_testcase_run_spectators_left_idcmf_testcase_run_spectators(ix_cmf_testcase_run_spectators_parent_id'ix_cmf_testcase_run_spectators_right_id&ix_cmf_testcase_run_spectators_root_id=ix_cmf_testcycle_testcase_folder_cmf_owner_assistants_left_id2cmf_testcycle_testcase_folder_cmf_owner_assistants?ix_cmf_testcycle_testcase_folder_cmf_owner_assistants_parent_id>ix_cmf_testcycle_testcase_folder_cmf_owner_assistants_right_id=ix_cmf_testcycle_testcase_folder_cmf_owner_assistants_root_id1ix_cmf_testplan_testcase_folder_executors_left_id&cmf_testplan_testcase_folder_executors3ix_cmf_testplan_testcase_folder_executors_parent_id2ix_cmf_testplan_testcase_folder_executors_right_id1ix_cmf_testplan_testcase_folder_executors_root_id$ix_cmf_testcase_run_cmf_task_left_idcmf_testcase_run_cmf_task&ix_cmf_testcase_run_cmf_task_parent_id%ix_cmf_testcase_run_cmf_task_right_id$ix_cmf_testcase_run_cmf_task_root_id)ix_cmf_testcase_run_step_cmf_task_left_id+ix_cmf_testcase_run_step_cmf_task_parent_id*ix_cmf_testcase_run_step_cmf_task_right_id)ix_cmf_testcase_run_step_cmf_task_root_id2ix_cmf_testcycle_testcase_folder_executors_left_id'cmf_testcycle_testcase_folder_executors4ix_cmf_testcycle_testcase_folder_executors_parent_id3ix_cmf_testcycle_testcase_folder_executors_right_id2ix_cmf_testcycle_testcase_folder_executors_root_id<ix_cmf_testplan_testcase_folder_cmf_owner_assistants_left_id1cmf_testplan_testcase_folder_cmf_owner_assistants>ix_cmf_testplan_testcase_folder_cmf_owner_assistants_parent_id=ix_cmf_testplan_testcase_folder_cmf_owner_assistants_right_id<ix_cmf_testplan_testcase_folder_cmf_owner_assistants_root_idcmf_test_configuration	variablesz!TRUNCATE TABLE cmf_testcase_paramcmf_testcase_param!ix_cmf_testcase_param_testcase_id'ix_cmf_testcase_param_cache_testcase_id#cmf_testcase_param_testcase_id_fkeycmf_testcasetestcase_id&cmf_testcase_params_row_parent_id_fkeycmf_testcase_params_row	iteration0)r   server_defaultenvironment_idcur_testcase_run_idexisting_typer   ix_cmf_testcase_run_release_id0ix_cmf_testcase_run_testcycle_testcase_result_id"ix_cmf_testcase_run_waiting_for_id'ix_cmf_testcase_run_cur_testcase_run_id"ix_cmf_testcase_run_environment_id cmf_testcase_run_release_id_fkeyZcmf_test_environmenttestcycle_testcase_result_idcmf_testcycletestcase_run_cachetestcase_result_cache,ix_cmf_testcycle_testcase_folder_activity_idcmf_testcycle_testcase_folder+ix_cmf_testcycle_testcase_folder_alarm_date)ix_cmf_testcycle_testcase_folder_approved4ix_cmf_testcycle_testcase_folder_cache_status_opt_id2ix_cmf_testcycle_testcase_folder_cache_status_type/ix_cmf_testcycle_testcase_folder_cloned_from_id7ix_cmf_testcycle_testcase_folder_cmf_owner_assistant_id+ix_cmf_testcycle_testcase_folder_company_id)ix_cmf_testcycle_testcase_folder_deadline9ix_cmf_testcycle_testcase_folder_default_task_workflow_id,ix_cmf_testcycle_testcase_folder_is_template-ix_cmf_testcycle_testcase_folder_logic_prefix.ix_cmf_testcycle_testcase_folder_logic_type_id4ix_cmf_testcycle_testcase_folder_parent_logic_prefix7ix_cmf_testcycle_testcase_folder_perm_security_level_id.ix_cmf_testcycle_testcase_folder_resolution_id/ix_cmf_testcycle_testcase_folder_responsible_id-ix_cmf_testcycle_testcase_folder_scheme_wf_id*ix_cmf_testcycle_testcase_folder_status_id/ix_cmf_testcycle_testcase_folder_waiting_for_id,ix_cmf_testcycle_testcase_folder_workflow_id;cmf_testcycle_testcase_folder_default_task_workflow_id_fkey0cmf_testcycle_testcase_folder_resolution_id_fkey0cmf_testcycle_testcase_folder_logic_type_id_fkey.cmf_testcycle_testcase_folder_activity_id_fkey/cmf_testcycle_testcase_folder_scheme_wf_id_fkey6cmf_testcycle_testcase_folder_cache_status_opt_id_fkey,cmf_testcycle_testcase_folder_status_id_fkey-cmf_testcycle_testcase_folder_company_id_fkey.cmf_testcycle_testcase_folder_workflow_id_fkey9cmf_testcycle_testcase_folder_perm_security_level_id_fkeyplan_end_datecloned_from_idparent_logic_prefixis_public_commentsapprovedcache_fields
is_penaltyactivity_idmarkhas_children_archivedui_view_form	status_id
alarm_dateperiod_next_datecache_status_opt_iduser_rating_countis_public_editablestatus_modified_atstatus_review_atuser_ratingperiod_intervalperm_policy_guestperm_policy_sharelinkperm_security_level_idworkflow_idlogic_type_id
company_idstatus_in_progress_startlogic_prefixplan_start_datedefault_task_workflow_idui_view_form_options
no_controlstatus_closed_at	is_publicperm_policystatus_in_progress_endis_templatecache_status_typeperm_policy_anonymousdeadlinecmf_owner_assistant_idsharelink_hashresolution_idscheme_wf_id+ix_cmf_testplan_testcase_folder_activity_idcmf_testplan_testcase_folder*ix_cmf_testplan_testcase_folder_alarm_date(ix_cmf_testplan_testcase_folder_approved3ix_cmf_testplan_testcase_folder_cache_status_opt_id1ix_cmf_testplan_testcase_folder_cache_status_type.ix_cmf_testplan_testcase_folder_cloned_from_id6ix_cmf_testplan_testcase_folder_cmf_owner_assistant_id*ix_cmf_testplan_testcase_folder_company_id(ix_cmf_testplan_testcase_folder_deadline8ix_cmf_testplan_testcase_folder_default_task_workflow_id+ix_cmf_testplan_testcase_folder_is_template,ix_cmf_testplan_testcase_folder_logic_prefix-ix_cmf_testplan_testcase_folder_logic_type_id3ix_cmf_testplan_testcase_folder_parent_logic_prefix6ix_cmf_testplan_testcase_folder_perm_security_level_id-ix_cmf_testplan_testcase_folder_resolution_id.ix_cmf_testplan_testcase_folder_responsible_id,ix_cmf_testplan_testcase_folder_scheme_wf_id)ix_cmf_testplan_testcase_folder_status_id.ix_cmf_testplan_testcase_folder_waiting_for_id+ix_cmf_testplan_testcase_folder_workflow_id-cmf_testplan_testcase_folder_workflow_id_fkey,cmf_testplan_testcase_folder_company_id_fkey8cmf_testplan_testcase_folder_perm_security_level_id_fkey:cmf_testplan_testcase_folder_default_task_workflow_id_fkey+cmf_testplan_testcase_folder_status_id_fkey/cmf_testplan_testcase_folder_logic_type_id_fkey.cmf_testplan_testcase_folder_scheme_wf_id_fkey5cmf_testplan_testcase_folder_cache_status_opt_id_fkey-cmf_testplan_testcase_folder_activity_id_fkey/cmf_testplan_testcase_folder_resolution_id_fkey)r   drop_constraintcreate_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerForeignKeyConstraintPrimaryKeyConstraintcreate_indexf
drop_index
drop_tabledrop_columnexecute
add_columncreate_foreign_keyalter_columnVARCHAR r  r  5/opt/eva-app/alembic/versions/c94a6ce1b5b5_evatest.pyupgrade   s   <7











"$""

 r  c                E   C   s7  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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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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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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jddddd t dtjd1tjddddd t dtjd2t ddd t dtjd3tjddddd t dtjd4tjddddd t dtjd5t ddd t dtjd6t ddd t dtjd7t ddd t dtjd8t ddd t dtjd9t 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<dd=dgd>g t d?dd@d4gd>g t dAddBd-gd>g t dCddDdgd>g t dEddFdgd>g t dGddHd0gd>g t dIddJdgd>g t dKddLd!gd>g t dMddNdgd>g t dOddJd gd>g t jdPdd gddQ t jdRdd	gddQ t jdSdd0gddQ t jdTddgddQ t jdUddgddQ t jdVddgddQ t jdWdd!gddQ t jdXdd9gddQ t jdYddgddQ t jdZddgddQ t jd[ddgddQ t jd\ddgddQ t jd]ddgddQ t jd^ddgddQ t jd_ddgddQ t jd`dd:gddQ t jdaddgddQ t jdbdd-gddQ t jdcdd7gddQ t jdddd/gddQ t jdedd4gddQ t dftjdtjddddd t dftjdtjddddd t dftjd	tjddddd t dftjd
tjddddd t dftjdtjddddd t dftjdtjddddd t dftjdtjddddd t dftjdtjddddd t dftjdtjddddd t dftjdt ddd t dftjdtjddddd t dftjdtjddddd t dftjdt ddd t dftjdtjddddd t dftjdt ddd t dftjdt ddd t dftjdt	 ddd t dftjdtjddddd t dftjdtjddddd t dftjdt ddd t dftjdtjddddd t dftjdtjddddd t dftjdtjddddd t dftjd tjddddd t dftjd!tjddddd t dftjd"tjddddd t dftjd#tjddddd t dftjd$tjddddd t dftjd%tj
d&d'd(ddd t dftjd)tjddddd t dftjd*tjddddd t dftjd+t ddd t dftjd,t	 ddd t dftjd-tjddddd t dftjd.tjddddd t dftjd/tjddddd t dftjd0tjddddd t dftjd1tjddddd t dftjd2t ddd t dftjd3tjddddd t dftjd4tjddddd t dftjd5t ddd t dftjd6t ddd t dftjd7t ddd t dftjd8t ddd t dftjd9t ddd t dftjd:tjddddd t dftjd;tjddddd t dgdfdLd!gd>g t dhdfdJd gd>g t didfdNdgd>g t djdfdHd0gd>g t dkdfdBd-gd>g t dldfdDdgd>g t dmdfd@d4gd>g t dndfdFdgd>g t dodfd=dgd>g t dpdfdJdgd>g t jdqdfd gddQ t jdrdfd	gddQ t jdsdfd0gddQ t jdtdfdgddQ t jdudfdgddQ t jdvdfdgddQ t jdwdfd!gddQ t jdxdfd9gddQ t jdydfdgddQ t jdzdfdgddQ t jd{dfdgddQ t jd|dfdgddQ t jd}dfdgddQ t jd~dfdgddQ t jddfdgddQ t jddfd:gddQ t jddfdgddQ t jddfd-gddQ t jddfd7gddQ t jddfd/gddQ t jddfd4gddQ t dtjdt ddd t dd t dtjdtjddddd t dtjdtjddddd t dtjd	tjddddd t jd ddd t jd ddd t ddddgd>g t ddddgd>g t jt ddd t jt ddd t jddd	gddQ t jdddgddQ t jdddgddQ t jddtjdddd t dd t dd t dd t ddddgd>g t dtjdtjddddd t jd ddd t ddddgd>g t jt ddd t jdddgddQ t dd t dtjdt ddd t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dgdgddtjdgdgddtjd>dd t jdddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dgdgddtjdgdgddtjd>dd t jdddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dt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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dddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t dtjd>tjdd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dddddtjdtjdddddtjdt dddtjdt dddtjdtjdddddtjdtjdddddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjd t dddtjdt dddtjdt	 dddtjdt dddtjdt dddtjdt 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dddddtjd	t dddtjd
t dddtjdtjdddddtjdtjddtddddtjdt dddtjdt dddtjdt dddtjdt 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dddddtjdt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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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dt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 dddtjdgd!gd"dtjdgdgd#dtjdgd$gd%dtjdgd&gd'dtjdgd(gd)dtjdgd*gd+dtjd>d,d: t jd-ddgddQ t jd.ddgddQ t jd/ddgddQ t jd0ddgddQ t jd1ddgddQ t jd2ddgddQ t jd3ddgddQ t jd4ddgddQ t jd5ddgddQ t jd6ddgddQ t jd7ddgddQ t jd8ddgddQ t jd9ddgddQ t jd:ddgddQ t jd;ddgddQ t jd<ddgddQ t jd=ddgddQ t jd>ddgddQ t jd?ddgddQ t jd@ddgddQ t jdAddgddQ t jdBddgddQ t jdCddgddQ t dDt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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>dEd
 t jdFdDdgddQ t jdGdDdgddQ t jdHdDdgddQ t jdIdDdgddQ t dJt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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>dKd
 t jdLdJdgddQ t jdMdJdgddQ t jdNdJdgddQ t jdOdJdgddQ t dPt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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>dQd
 t jdRdPdgddQ t jdSdPdgddQ t jdTdPdgddQ t jdUdPdgddQ t dtjd>tjdd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dddddtjdtjdddddtjdt dddtjdt dddtjdtjdddddtjdtjdddddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjdt dddtjd t dddtjdt dddtjdt	 dddtjdt dddtjdt dddtjdt 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dddddtjd	t dddtjd
t dddtjdtjdddddtjdt	 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dt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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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dddddtjdVtjdddddtjdtjdddddtjdWtjdddddtjdtjdddddtjdtjdddddtjdt	 dddtjdXtjdddddtjdtjdddddtjdYt	 tdZdddtjd[t	 tdZdddtjd t dddtjdgd!gd\dtjdgdgd]dtjdgd^gd_dtjdXgd`gdadtjdgd$gdbdtjdgd&gdcdtjdWgddgdedtjdgd(gdfdtjdVgdggdhdtjd>did@ t jdjddgddQ t jdkddVgddQ t jdlddgddQ t jdmddWgddQ t jdnddgddQ t jdoddgddQ t jdpddgddQ t jdqddgddQ t jdrddgddQ t jdsddgddQ t jdtddXgddQ t jduddgddQ t jdvddgddQ t jdwddgddQ t jdxddgddQ t jdyddgddQ t jdzddgddQ t jd{ddgddQ t jd|ddgddQ t jd}ddgddQ t jd~ddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t jdddgddQ t jt ddd t jt ddd t jt ddd t jt ddd t d t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t d t jt ddd t jt ddd t jt ddd t jt ddd t d t jt ddd t jt ddd t jt ddd t jt ddd t d t jt ddd t jt ddd t jt ddd t jt ddd t d t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt ddd t jt d¡dd t jt dádd t jt dġdd t jt dšdd t jt dơdd t jt dǡdd t jt dȡdd t d d S (  Nrz  rx  r   r   FT)autoincrementr   rw  rC   rv  r0   ru  rt  r   rB   rs  rr  rq  rp  ro  rn  rm  rl  rk  r1   rj  ri  rh  rg  rf  re  rd  rc  rb  ra  r`  r_        )	precisionscaler^  r]  r\  r[  rZ  rY  rX  rW  rV  rU  rT  rS  rR  rQ  rP  rO  rN  rM  rL  r  Zcmf_resolutionr
   r  cmf_activityr  cmf_status_optr  cmf_scheme_wfr  Zcmf_logic_typer  
cmf_statusr  cmf_workflowr  cmf_security_levelr  cmf_companyr  r  rJ   r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r~  r}  r|  r{  ry  r-  rK  rJ  rI  rH  rG  rF  rE  rD  rC  rB  rA  r@  r?  r>  r=  r<  r;  r:  r9  r8  r7  r6  r5  r4  r3  r2  r1  r0  r/  r.  r,  r)  r+  r*  r   r@   r(  r   r   r   r   r'  cmf_listr&  r   r%  r$  r#  r"  r  r   r  r  r  r  r  r  r6   r  r  r  r  r?   r  r  r  re   rf   rg   rh   ri   rj   rk   r   rl   Z6cmf_testplan_testcase_folder_cmf_owner_assistants_pkey)r   r  r  r  r  r  Z,cmf_testcycle_testcase_folder_executors_pkeyr  r
  r	  r  r   zcmf_testcase_run_step.idr   rm   Z,cmf_testcase_run_step_cmf_task_right_id_fkeyZ#cmf_testcase_run_step_cmf_task_pkeyr  r  r  r  r   zcmf_testcase_run.idZ&cmf_testcase_run_cmf_task_left_id_fkeyZ'cmf_testcase_run_cmf_task_right_id_fkeyZcmf_testcase_run_cmf_task_pkeyr  r  r   r   r   Z+cmf_testplan_testcase_folder_executors_pkeyr   r   r   r   r   Z7cmf_testcycle_testcase_folder_cmf_owner_assistants_pkeyr   r   r   r   r   Z cmf_testcase_run_spectators_pkeyr   r   r   r   r   Z-cmf_testplan_testcase_folder_local_links_pkeyr   r   r   r   r   Z-cmf_testcycle_testcase_folder_spectators_pkeyr   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}   z'main'::character varying)r  r  r   r~   r   r   r   r/   r4   r5   r7   r8   r9   r:   r;   r<   r=   r>   r   Zparent_step_idr$   rE   Z(cmf_testcase_run_step_cmf_import_id_fkeyZ)cmf_testcase_run_step_parent_step_id_fkeyrG   Z&cmf_testcase_run_step_perm_acl_id_fkeyrH   Z%cmf_testcase_run_step_project_id_fkeyrD   Z&cmf_testcase_run_step_testcase_id_fkeyr   Z+cmf_testcase_run_step_testcase_step_id_fkeyZcmf_testcase_run_step_pkeyr   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   Z.cmf_testcycle_testcase_folder_local_links_pkeyr   r   r   r   r   Zcmf_testcase_run_executors_pkeyr   r   r   r   r   Z,cmf_testplan_testcase_folder_spectators_pkeyr   r   r   r   Ztestcycle_testcase_folder_idZtest_configuration_idrA   r2   r  r3   Z0cmf_testcycle_testcase_result_cmf_import_id_fkeyZ6cmf_testcycle_testcase_result_cur_testcase_run_id_fkeyzcmf_test_environment.idZ1cmf_testcycle_testcase_result_environment_id_fkeyrF   Z0cmf_testcycle_testcase_result_params_row_id_fkeyZ.cmf_testcycle_testcase_result_perm_acl_id_fkeyZ-cmf_testcycle_testcase_result_project_id_fkeyzcmf_test_configuration.idZ8cmf_testcycle_testcase_result_test_configuration_id_fkeyZ.cmf_testcycle_testcase_result_testcase_id_fkeyz cmf_testcycle_testcase_folder.idZ?cmf_testcycle_testcase_result_testcycle_testcase_folder_id_fkeyZ"cmf_testcycle_testcase_result_pkeyr   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   r   r   r   r   r   r{   rw   rz   ry   rx   rv   rr   ru   rt   rs   rq   rd   rp   ro   rn   rc   r	   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rI   )r   r  r  r  r  r   r  BOOLEANr  INTEGERNUMERICr  r  r  r  r  r  r  r  r  r  r  r   r  r  r  r  r  	downgrade*  s   """"""""""""""""""""""$"""""""""""""""""""""""""""""""""$""""""""""""""
"&;""Ar  )__doc__alembicr   
sqlalchemyr  Zsqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr  r  r  r  r  r  <module>   s       