U
    ¢ü’c,  ã                   @   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 )
zhempty message

Revision ID: a729a66b91f1
Revises: 15d726bb1cf2
Create Date: 2022-12-06 16:14:18.806785

é    )ÚopNÚa729a66b91f1Ú15d726bb1cf2c                   C   s  t  d¡ t  d¡ t jddtjddtjdddd	 t jd
dtjddtjdddd	 t jd
dtjddtjdddd	 t  d¡ t jddtjddtjdddd	 t  d¡ t  d¡ t  d¡ t jddtjddtjdddd	 t  d¡ t  d¡ t  d¡ t  d¡ t  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tjdddd	 t jddtjddtjdddd	 t  d¡ t jt  	d ¡ddgdd! t  d"¡ t  d#¡ t jt  	d$¡ddgdd! t  d%¡ t jd&dtjddtjdddd	 t  d'¡ t jd(dtjddtjdddd	 t  d)¡ t  d*¡ t  d+¡ t  d,¡ t  d-¡ t  d.¡ t  d/¡ t  d0¡ t  d1¡ t  
d d2d2d3gdg¡ t  
d d2d2d4gdg¡ t jd5dtjddtjdddd	 d S )6Nz.DROP INDEX IF EXISTS ix_cmf_access_list_ext_idz.DROP INDEX IF EXISTS ix_cmf_access_rule_ext_idÚcmf_access_rule_subjectsÚidé@   ©Úlengthé€   F©Úexisting_typeÚtype_Úexisting_nullableÚcmf_authÚloginTÚemailz3DROP INDEX IF EXISTS ix_cmf_auth_ldap_plugin_ext_idÚcmf_commentÚcache_cmf_author_loginz*DROP INDEX IF EXISTS ix_cmf_comment_ext_idz+DROP INDEX IF EXISTS ix_cmf_document_ext_idz3DROP INDEX IF EXISTS ix_cmf_document_history_ext_idÚcmf_document_history_cmf_signz)DROP INDEX IF EXISTS ix_cmf_filter_ext_idz2DROP INDEX IF EXISTS ix_cmf_global_settings_ext_idz)DROP INDEX IF EXISTS ix_cmf_import_ext_idz'DROP INDEX IF EXISTS ix_cmf_link_ext_idz)DROP INDEX IF EXISTS ix_cmf_notify_ext_idÚ
cmf_personÚapi_token_hash)ÚnullableÚwebhook_token_hashÚdeleted_loginz)DROP INDEX IF EXISTS ix_cmf_person_ext_idÚix_cmf_person_api_token_hash©ÚuniquezTCREATE INDEX IF NOT EXISTS ix_cmf_person_does_not_work ON cmf_person (does_not_work)zNCREATE INDEX IF NOT EXISTS ix_cmf_person_user_local ON cmf_person (user_local)Ú ix_cmf_person_webhook_token_hashz/DROP INDEX IF EXISTS ix_cmf_person_group_ext_idÚcmf_person_group_rg_membersz-DROP INDEX IF EXISTS ix_cmf_person_var_ext_idÚcmf_person_var_favoritesz)DROP INDEX IF EXISTS ix_cmf_plugin_ext_idzVALTER TABLE cmf_task ADD COLUMN IF NOT EXISTS cache_child_tasks_count INTEGER NOT NULLzJALTER TABLE cmf_task ADD COLUMN IF NOT EXISTS cache_branch_gantt_path TEXTzEALTER TABLE cmf_task ADD COLUMN IF NOT EXISTS has_child_tasks BOOLEANzAALTER TABLE cmf_task ADD COLUMN IF NOT EXISTS epic_id VARCHAR(64)zGALTER TABLE cmf_task ADD COLUMN IF NOT EXISTS subproject_id VARCHAR(64)z'DROP INDEX IF EXISTS ix_cmf_task_ext_idzDCREATE INDEX IF NOT EXISTS ix_cmf_task_epic_id ON cmf_task (epic_id)zPCREATE INDEX IF NOT EXISTS ix_cmf_task_subproject_id ON cmf_task (subproject_id)Úcmf_taskÚsubproject_idÚepic_idÚcmf_task_cmf_task)r   ÚexecuteÚalter_columnÚsaÚVARCHARÚStringÚ
add_columnÚColumnÚcreate_indexÚfÚcreate_foreign_key© r.   r.   ú./opt/account/alembic/versions/a729a66b91f1_.pyÚupgrade   s¢    



ý

ý

ý


ý




ý




  

ý

ý





ý


ý










ýr0   c                   C   s˜  t jddtjddtjdddd t jd dd	d
 t jd dd	d
 t jt  d¡dd t jt  d¡dd t jdddgdd t  	dd¡ t  	dd¡ t  	dd¡ t  	dd¡ t  	dd¡ t jdddgdd t jddtjddtjdddd t jdddgdd t jddtjddtjdddd t jdddgdd t jt  d¡dd t jt  d ¡dd t jt  d!¡dd t jt  d"¡dd t jd#ddgdd t jdd$tjddtjddd%d t jdd&tjddtjddd%d t  	dd'¡ t  	dd(¡ t jd)d*dgdd t jd+d,dgdd t jd-d.dgdd t jd/d0dgdd t jd1d2dgdd t jd3dtjddtjdddd t jd4d5dgdd t jd6d7dgdd t jd8d9dgdd t jd9d:tjddtjddd%d t jd;d<dgdd t jd=d>tjddtjddd%d t jd=d&tjddtjddd%d t jd?dtjddtjdddd t jd@dAdgdd t jdBdCdgdd d S )DNr#   r   r
   r   r   Fr   r    Ú
foreignkey)r   Zix_cmf_task_subproject_id)Ú
table_nameZix_cmf_task_epic_idZix_cmf_task_ext_idÚext_idr   r!   r"   Úhas_child_tasksÚcache_branch_gantt_pathÚcache_child_tasks_countZix_cmf_plugin_ext_idÚ
cmf_pluginr   Zix_cmf_person_var_ext_idÚcmf_person_varr   Zix_cmf_person_group_ext_idÚcmf_person_groupr   r   Zix_cmf_person_user_localZix_cmf_person_does_not_workr   Zix_cmf_person_ext_idr   Tr   r   r   Zix_cmf_notify_ext_idÚ
cmf_notifyZix_cmf_link_ext_idÚcmf_linkZix_cmf_import_ext_idÚ
cmf_importZix_cmf_global_settings_ext_idÚcmf_global_settingsZix_cmf_filter_ext_idÚ
cmf_filterr   Zix_cmf_document_history_ext_idÚcmf_document_historyZix_cmf_document_ext_idÚcmf_documentZix_cmf_comment_ext_idr   r   Zix_cmf_auth_ldap_plugin_ext_idÚcmf_auth_ldap_pluginr   r   r   Zix_cmf_access_rule_ext_idÚcmf_access_ruleZix_cmf_access_list_ext_idÚcmf_access_list)
r   r%   r&   r(   r'   Údrop_constraintÚ
drop_indexr,   r+   Údrop_columnr.   r.   r.   r/   Ú	downgradey   s¢    

ý

ý

ý

ý

ý

ý

ý

ý

ý

ýrG   )Ú__doc__Úalembicr   Ú
sqlalchemyr&   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr0   rG   r.   r.   r.   r/   Ú<module>   s   f