U
    \åGh_i  ã                   @   s<   d Z ddlmZ ddlZdZdZdZdZdd„ Z	dd	„ Z
dS )
z^fix

Revision ID: 4bf55f3f7ec7
Revises: ef9b210ec301
Create Date: 2025-05-20 15:30:07.721398

é    )ÚopNÚ4bf55f3f7ec7Zef9b210ec301c                   C   s¬  t  d¡ t  d¡ t  d¡ t  d¡ t  d¡ t  d¡ t  d¡ t  d¡ t  d	¡ t  d
¡ t  d¡ t  d¡ t  d¡ t  d¡ t jdddgddddid t jdddgddddid t jdddgddddid t jdddgddddid t jdddgddddid t jdddgddddid t jdddgddddid t jd d!dgddddid t jd"d!dgddddid t jd#d$dgddddid t jd%d&dgddddid t jd'd(dgddddid t jd)d*dgddddid t jd+d*dgddddid t jd,d-dgddddid t jd.d-dgddddid t jd/d0dgddddid t jd1d0dgddddid t jd2d3dgddddid t jd4d3dgddddid t jd5d6dgddddid t jd7d6dgddddid t jd8d9dgddddid t jd:d9dgddddid t jd;d<dgddddid t jd=d<dgddddid t jd>d?dgddddid t jd@d?dgddddid t jdAdBdgddddid t jdCdDdgddddid t jdEdDdgddddid t jdFdGdgddddid t jdHdGdgddddid t jdIdJdgddddid t jdKdJdgddddid t jdLdMdgddddid t jdNdOdgddddid t jdPdOdgddddid t jdQdRdgddddid t jdSdRdgddddid t jdTdUdgddddid t jdVdUdgddddid t jdWdXdgddddid t jdYdXdgddddid t jdZd[dgddddid t jd\d[dgddddid t jd]d^dgddddid t jd_d^dgddddid t jd`dadgddddid t jdbdcdgddddid t jdddcdgddddid t jdedfdgddddid t jdgdfdgddddid t jdhdidgddddid t jdjdidgddddid t jdkdldgddddid t jdmdldgddddid t jdndodgddddid t jdpdodgddddid t jdqdrdgddddid t jdsdrdgddddid t jdtdudgddddid t jdvdudgddddid t jdwdxdgddddid t jdydxdgddddid d S )zNzjCREATE INDEX IF NOT EXISTS ix_cmf_key_phrase_code_gin_trgm ON cmf_key_phrase USING gin (code gin_trgm_ops)zjCREATE INDEX IF NOT EXISTS ix_cmf_key_phrase_name_gin_trgm ON cmf_key_phrase USING gin (name gin_trgm_ops)zzCREATE INDEX IF NOT EXISTS ix_cmf_test_configuration_code_gin_trgm ON cmf_test_configuration USING gin (code gin_trgm_ops)zzCREATE INDEX IF NOT EXISTS ix_cmf_test_configuration_name_gin_trgm ON cmf_test_configuration USING gin (name gin_trgm_ops)zvCREATE INDEX IF NOT EXISTS ix_cmf_test_environment_code_gin_trgm ON cmf_test_environment USING gin (code gin_trgm_ops)zvCREATE INDEX IF NOT EXISTS ix_cmf_test_environment_name_gin_trgm ON cmf_test_environment USING gin (name gin_trgm_ops)zpCREATE INDEX IF NOT EXISTS ix_cmf_testcase_step_code_gin_trgm ON cmf_testcase_step USING gin (code gin_trgm_ops)zpCREATE INDEX IF NOT EXISTS ix_cmf_testcase_step_name_gin_trgm ON cmf_testcase_step USING gin (name gin_trgm_ops)zˆCREATE INDEX IF NOT EXISTS ix_cmf_testcycle_testcase_folder_code_gin_trgm ON cmf_testcycle_testcase_folder USING gin (code gin_trgm_ops)zˆCREATE INDEX IF NOT EXISTS ix_cmf_testcycle_testcase_folder_name_gin_trgm ON cmf_testcycle_testcase_folder USING gin (name gin_trgm_ops)zxCREATE INDEX IF NOT EXISTS ix_cmf_testplan_testcase_code_gin_trgm ON cmf_testplan_testcase USING gin (code gin_trgm_ops)zxCREATE INDEX IF NOT EXISTS ix_cmf_testplan_testcase_name_gin_trgm ON cmf_testplan_testcase USING gin (name gin_trgm_ops)z†CREATE INDEX IF NOT EXISTS ix_cmf_testplan_testcase_folder_code_gin_trgm ON cmf_testplan_testcase_folder USING gin (code gin_trgm_ops)z†CREATE INDEX IF NOT EXISTS ix_cmf_testplan_testcase_folder_name_gin_trgm ON cmf_testplan_testcase_folder USING gin (name gin_trgm_ops)Úix_cmf_asset_code_gin_trgmÚ	cmf_assetÚcodeFÚginÚgin_trgm_ops)ÚuniqueÚpostgresql_usingÚpostgresql_opsÚix_cmf_asset_name_gin_trgmÚnameÚix_cmf_asset_cat_code_gin_trgmÚcmf_asset_catÚix_cmf_asset_cat_name_gin_trgmÚ!ix_cmf_asset_scheme_code_gin_trgmÚcmf_asset_schemeÚ#ix_cmf_asset_type_cat_code_gin_trgmÚcmf_asset_type_catÚ#ix_cmf_asset_type_cat_name_gin_trgmÚ ix_cmf_blog_folder_code_gin_trgmÚcmf_blog_folderÚ ix_cmf_blog_folder_name_gin_trgmÚix_cmf_chat_group_code_gin_trgmÚcmf_chat_groupÚix_cmf_chat_topic_code_gin_trgmÚcmf_chat_topicÚix_cmf_company_code_gin_trgmÚcmf_companyÚix_cmf_component_code_gin_trgmÚcmf_componentÚix_cmf_component_name_gin_trgmÚix_cmf_dashboard_code_gin_trgmÚcmf_dashboardÚix_cmf_dashboard_name_gin_trgmÚix_cmf_deal_code_gin_trgmÚcmf_dealÚix_cmf_deal_name_gin_trgmÚix_cmf_folder_code_gin_trgmÚ
cmf_folderÚix_cmf_folder_name_gin_trgmÚix_cmf_invoice_code_gin_trgmÚcmf_invoiceÚix_cmf_invoice_name_gin_trgmÚix_cmf_lead_code_gin_trgmÚcmf_leadÚix_cmf_lead_name_gin_trgmÚ!ix_cmf_mail_handler_code_gin_trgmÚcmf_mail_handlerÚ!ix_cmf_mail_handler_name_gin_trgmÚix_cmf_payment_code_gin_trgmÚcmf_paymentÚix_cmf_payment_name_gin_trgmÚix_cmf_project_code_gin_trgmÚcmf_projectÚ#ix_cmf_purchase_order_code_gin_trgmÚcmf_purchase_orderÚ#ix_cmf_purchase_order_name_gin_trgmÚ)ix_cmf_purchase_order_items_code_gin_trgmÚcmf_purchase_order_itemsÚ)ix_cmf_purchase_order_items_name_gin_trgmÚix_cmf_registry_code_gin_trgmÚcmf_registryÚix_cmf_registry_name_gin_trgmÚix_cmf_roadmap_code_gin_trgmÚcmf_roadmapÚix_cmf_scheme_wf_code_gin_trgmÚcmf_scheme_wfÚix_cmf_scheme_wf_name_gin_trgmÚ)ix_cmf_stock_incoming_order_code_gin_trgmÚcmf_stock_incoming_orderÚ)ix_cmf_stock_incoming_order_name_gin_trgmÚ"ix_cmf_stock_initial_code_gin_trgmÚcmf_stock_initialÚ"ix_cmf_stock_initial_name_gin_trgmÚ$ix_cmf_stock_inventory_code_gin_trgmÚcmf_stock_inventoryÚ$ix_cmf_stock_inventory_name_gin_trgmÚix_cmf_stock_move_code_gin_trgmÚcmf_stock_moveÚix_cmf_stock_move_name_gin_trgmÚ*ix_cmf_stock_outcoming_order_code_gin_trgmÚcmf_stock_outcoming_orderÚ*ix_cmf_stock_outcoming_order_name_gin_trgmÚix_cmf_task_code_gin_trgmÚcmf_taskÚ ix_cmf_task_filter_code_gin_trgmÚcmf_task_filterÚ ix_cmf_task_filter_name_gin_trgmÚix_cmf_task_queue_code_gin_trgmÚcmf_task_queueÚix_cmf_task_queue_name_gin_trgmÚ ix_cmf_task_report_code_gin_trgmÚcmf_task_reportÚ ix_cmf_task_report_name_gin_trgmÚix_cmf_testcase_code_gin_trgmÚcmf_testcaseÚix_cmf_testcase_name_gin_trgmÚ$ix_cmf_testcase_folder_code_gin_trgmÚcmf_testcase_folderÚ$ix_cmf_testcase_folder_name_gin_trgmÚix_cmf_testcycle_code_gin_trgmÚcmf_testcycleÚix_cmf_testcycle_name_gin_trgmÚix_cmf_testplan_code_gin_trgmÚcmf_testplanÚix_cmf_testplan_name_gin_trgmÚ ix_cmf_u_work_post_code_gin_trgmÚcmf_u_work_postÚ ix_cmf_u_work_post_name_gin_trgm)r   ÚexecuteÚcreate_index© rr   rr   ú1/opt/eva-app/alembic/versions/4bf55f3f7ec7_fix.pyÚupgrade   sž    













rt   c                   C   sì  t jdddddid t jdddddid t jd	d
dddid t jdd
dddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jdddddid t jd ddddid t jd!d"dddid t jd#d"dddid t jd$d%dddid t jd&d%dddid t jd'd(dddid t jd)d(dddid t jd*d+dddid t jd,d+dddid t jd-d.dddid t jd/d0dddid t jd1d0dddid t jd2d3dddid t jd4d3dddid t jd5d6dddid t jd7d6dddid t jd8d9dddid t jd:d9dddid t jd;d<dddid t jd=d<dddid t jd>d?dddid t jd@d?dddid t jdAdBdddid t jdCdBdddid t jdDdEdddid t jdFdGdddid t jdHdGdddid t jdIdJdddid t jdKdJdddid t jdLdMdddid t jdNdMdddid t jdOdPdddid t jdQdPdddid t jdRdSdddid t jdTdSdddid t jdUdVdddid t jdWdVdddid t jdXdYdddid t jdZd[dddid t jd\d[dddid t jd]d^dddid t jd_d^dddid t jd`dadddid t jdbdadddid t jdcdddddid t jdedfdddid t jdgdfdddid t jdhdidddid t jdjdidddid t jdkdldddid t jdmdldddid t jdndodddid t jdpdodddid t jdqdrdddid t jdsdrdddid t jdtdudddid t jdvdudddid t jdwdxdddid t jdydxdddid t jdzd{dddid t jd|d{dddid t jd}d~dddid t jdd~dddid t jd€ddddid t jd‚dƒdddid t jd„d…dddid t jd†d‡dddid t jdˆd‡dddid t jd‰dŠdddid t jd‹dŠdddid t jdŒddddid t jdŽddddid t jdddddid t jd‘d’dddid t jd“d’dddid d S )”Nro   rn   r   r   r   )Ú
table_namer
   r   rm   r   Z-ix_cmf_testplan_testcase_folder_name_gin_trgmÚcmf_testplan_testcase_folderZ-ix_cmf_testplan_testcase_folder_code_gin_trgmZ&ix_cmf_testplan_testcase_name_gin_trgmÚcmf_testplan_testcaseZ&ix_cmf_testplan_testcase_code_gin_trgmrl   rk   rj   Z.ix_cmf_testcycle_testcase_folder_name_gin_trgmÚcmf_testcycle_testcase_folderZ.ix_cmf_testcycle_testcase_folder_code_gin_trgmri   rh   rg   Z"ix_cmf_testcase_step_name_gin_trgmÚcmf_testcase_stepZ"ix_cmf_testcase_step_code_gin_trgmZ.ix_cmf_testcase_run_history_step_name_gin_trgmÚcmf_testcase_run_history_stepZ.ix_cmf_testcase_run_history_step_code_gin_trgmZ)ix_cmf_testcase_run_history_name_gin_trgmÚcmf_testcase_run_historyZ)ix_cmf_testcase_run_history_code_gin_trgmZ!ix_cmf_testcase_run_name_gin_trgmÚcmf_testcase_runZ!ix_cmf_testcase_run_code_gin_trgmrf   re   rd   rc   rb   ra   Z$ix_cmf_test_params_row_name_gin_trgmÚcmf_test_params_rowZ$ix_cmf_test_params_row_code_gin_trgmZ%ix_cmf_test_param_value_code_gin_trgmÚcmf_test_param_valueZ)ix_cmf_test_param_row_value_name_gin_trgmÚcmf_test_param_row_valueZ)ix_cmf_test_param_row_value_code_gin_trgmZix_cmf_test_param_name_gin_trgmÚcmf_test_paramZix_cmf_test_param_code_gin_trgmZ%ix_cmf_test_environment_name_gin_trgmÚcmf_test_environmentZ%ix_cmf_test_environment_code_gin_trgmZ'ix_cmf_test_configuration_name_gin_trgmÚcmf_test_configurationZ'ix_cmf_test_configuration_code_gin_trgmr`   r_   r^   r]   r\   r[   rZ   rY   rX   rV   rW   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rB   rC   rA   r@   r?   r>   r=   r<   r;   r:   r9   r7   r8   r6   r5   r4   r3   r2   r1   r0   r/   r.   Zix_cmf_key_phrase_name_gin_trgmÚcmf_key_phraseZix_cmf_key_phrase_code_gin_trgmr-   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   Ú
drop_indexrr   rr   rr   rs   Ú	downgradef   s¸    r…   )Ú__doc__Úalembicr   Ú
sqlalchemyÚsaÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrt   r…   rr   rr   rr   rs   Ú<module>   s   S