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_idix_cmf_task_ext_idext_idr   r!   r"   has_child_taskscache_branch_gantt_pathcache_child_tasks_countix_cmf_plugin_ext_id
cmf_pluginr   ix_cmf_person_var_ext_idcmf_person_varr   ix_cmf_person_group_ext_idcmf_person_groupr   r   Zix_cmf_person_user_localZix_cmf_person_does_not_workr   ix_cmf_person_ext_idr   Tr   r   r   ix_cmf_notify_ext_id
cmf_notifyix_cmf_link_ext_idcmf_linkix_cmf_import_ext_id
cmf_importix_cmf_global_settings_ext_idcmf_global_settingsix_cmf_filter_ext_id
cmf_filterr   ix_cmf_document_history_ext_idcmf_document_historyix_cmf_document_ext_idcmf_documentix_cmf_comment_ext_idr   r   Zix_cmf_auth_ldap_plugin_ext_idcmf_auth_ldap_pluginr   r   r   ix_cmf_access_rule_ext_idcmf_access_rule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    



















rV   )__doc__alembicr   
sqlalchemyr&   revisiondown_revisionbranch_labels
depends_onr0   rV   r.   r.   r.   r/   <module>   s   f