U
    nÀ­g#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: 1f5c20582665
Revises: 54b935d64887
Create Date: 2025-02-13 10:22:02.693658

é    )ÚopN)Ú
postgresqlÚ1f5c20582665Z54b935d64887c                7   C   sJ  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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jd0t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 
d,gd4g¡t 
d2gd5g¡t 
d3gd6g¡t 
d)gd7g¡t 
d0gd8g¡t 
d/gd9g¡t d¡¡3 t jt  d:¡dd'gdd; t jt  d<¡dd
gdd; t jt  d=¡ddgdd; t jt  d>¡dd,gdd; t jt  d?¡ddgdd; t jt  d@¡dd+gdd; t jt  dA¡ddgdd; t jt  dB¡dd*gdd; t jt  dC¡dd(gdd; t jt  dD¡ddgdd; t jt  dE¡ddgdd; t jt  dF¡ddgdd; t jt  dG¡ddgdd; t jt  dH¡ddgdd; t jt  dI¡dd2gdd; t jt  dJ¡dd3gdd; t jt  dK¡dd)gdd; t jt  dL¡dd0gdd; t jt  dM¡dd1gdd; t jt  dN¡dd/gdd; t jt  dO¡dd.gdd; t jt  dP¡dd-gdd; t jdQdRdS t jdTdRdS t jdUdRdS t jdVdRdS t jdWdRdS t jdXdRdS t jdYdRdS t jdZdRdS t jd[dRdS t jd\dRdS t jd]dRdS t jd^dRdS t jd_dRdS t jd`dRdS t jdadRdS t jdbdRdS t jdcdRdS t jdddRdS t jdedRdS t jdfdRdS t jdgdRdS t jdhdRdS t  dR¡ d S )iNÚcmf_test_param_row_valueÚ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Ú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Úparam_idÚparam_value_idúcmf_import.idúcmf_test_param.idúcmf_test_param_value.idúcmf_testcase_params_row.idúcmf_access_list.idúcmf_project.idÚ)ix_cmf_test_param_row_value_cmf_author_id©ÚuniqueÚ*ix_cmf_test_param_row_value_cmf_created_atÚ'ix_cmf_test_param_row_value_cmf_deletedÚ)ix_cmf_test_param_row_value_cmf_import_idÚ)ix_cmf_test_param_row_value_cmf_locked_atÚ,ix_cmf_test_param_row_value_cmf_locked_by_idÚ+ix_cmf_test_param_row_value_cmf_modified_atÚ.ix_cmf_test_param_row_value_cmf_modified_by_idÚ(ix_cmf_test_param_row_value_cmf_owner_idÚ'ix_cmf_test_param_row_value_cmf_versionÚ)ix_cmf_test_param_row_value_cmf_viewed_atÚ ix_cmf_test_param_row_value_codeÚ ix_cmf_test_param_row_value_nameÚ#ix_cmf_test_param_row_value_ordernoÚ$ix_cmf_test_param_row_value_param_idÚ*ix_cmf_test_param_row_value_param_value_idÚ%ix_cmf_test_param_row_value_parent_idÚ'ix_cmf_test_param_row_value_perm_acl_idÚ*ix_cmf_test_param_row_value_perm_parent_idÚ&ix_cmf_test_param_row_value_project_idÚ*ix_cmf_test_param_row_value_root_parent_idÚ*ix_cmf_test_param_row_value_tree_parent_idÚ#ix_cmf_testcase_param_cmf_author_idÚcmf_testcase_param©Ú
table_nameÚ$ix_cmf_testcase_param_cmf_created_atÚ!ix_cmf_testcase_param_cmf_deletedÚ#ix_cmf_testcase_param_cmf_import_idÚ#ix_cmf_testcase_param_cmf_locked_atÚ&ix_cmf_testcase_param_cmf_locked_by_idÚ%ix_cmf_testcase_param_cmf_modified_atÚ(ix_cmf_testcase_param_cmf_modified_by_idÚ"ix_cmf_testcase_param_cmf_owner_idÚ!ix_cmf_testcase_param_cmf_versionÚ#ix_cmf_testcase_param_cmf_viewed_atÚix_cmf_testcase_param_codeÚix_cmf_testcase_param_nameÚix_cmf_testcase_param_ordernoÚix_cmf_testcase_param_param_idÚ$ix_cmf_testcase_param_param_value_idÚix_cmf_testcase_param_parent_idÚ!ix_cmf_testcase_param_perm_acl_idÚ$ix_cmf_testcase_param_perm_parent_idÚ ix_cmf_testcase_param_project_idÚ$ix_cmf_testcase_param_root_parent_idÚ$ix_cmf_testcase_param_tree_parent_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
drop_indexÚ
drop_table© r~   r~   ú5/opt/eva-app/alembic/versions/1f5c20582665_evatest.pyÚupgrade   sÂ    Î4r€   c                8   C   s¼  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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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 ¡ 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 ¡ 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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d0tjdddddtjd1tjdddddtjd2tjdddddtjd3tjdddddtjd,gd4gd5d6tjd2gd7gd8d6tjd3gd9gd:d6tjd)gd;gd<d6tjd0gd=gd>d6tjd/gd?gd@d6tjddAd6¡3 t jdBdd-gddC t jdDdd.gddC t jdEdd/gddC t jdFdd1gddC t jdGdd0gddC t jdHdd)gddC t jdIdd3gddC t jdJdd2gddC t jdKddgddC t jdLddgddC t jdMddgddC t jdNddgddC t jdOddgddC t jdPdd(gddC t jdQdd*gddC t jdRddgddC t jdSdd+gddC t jdTddgddC t jdUdd,gddC t jdVddgddC t jdWdd
gddC t jdXdd'gddC t jt  dY¡dZd[ t jt  d\¡dZd[ t jt  d]¡dZd[ t jt  d^¡dZd[ t jt  d_¡dZd[ t jt  d`¡dZd[ t jt  da¡dZd[ t jt  db¡dZd[ t jt  dc¡dZd[ t jt  dd¡dZd[ t jt  de¡dZd[ t jt  df¡dZd[ t jt  dg¡dZd[ t jt  dh¡dZd[ t jt  di¡dZd[ t jt  dj¡dZd[ t jt  dk¡dZd[ t jt  dl¡dZd[ t jt  dm¡dZd[ t jt  dn¡dZd[ t jt  do¡dZd[ t jt  dp¡dZd[ t  dZ¡ d S )qNrW   r   r   r   F)Úautoincrementr
   r   Tr   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/   r0   r1   r2   r3   r4   r5   r6   r7   r8   Z%cmf_testcase_param_cmf_import_id_fkey)r   r9   Z cmf_testcase_param_param_id_fkeyr:   Z&cmf_testcase_param_param_value_id_fkeyr;   Z!cmf_testcase_param_parent_id_fkeyr<   Z#cmf_testcase_param_perm_acl_id_fkeyr=   Z"cmf_testcase_param_project_id_fkeyZcmf_testcase_param_pkeyrn   r?   rm   rl   rk   rj   ri   rh   rg   rf   re   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rV   rU   r   rX   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r>   )r   ro   rp   rq   ÚVARCHARr   rs   ÚBOOLEANru   rv   ÚINTEGERrx   ry   rz   r|   r{   r}   r~   r~   r~   r   Ú	downgradey   sÂ    Î4r…   )Ú__doc__Úalembicr   Ú
sqlalchemyrp   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr€   r…   r~   r~   r~   r   Ú<module>   s   f