U
    ]Úd;(  ã                   @   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 )zhevent options

Revision ID: 860455f7b8a2
Revises: a671f07faa59
Create Date: 2023-07-21 17:37:53.179984

é    )ÚopN)Ú
postgresqlÚ860455f7b8a2Úa671f07faa59c                	   C   sØ  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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dd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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 ¡ ddd¡ t  dtjdt ¡ ddd¡ t jd dd t jd!dd"d# t  dd$¡ t  d¡ d S )%NÚ&ix_cmf_person_notify_opt_cmf_author_idÚcmf_person_notify_opt)Ú
table_nameÚ'ix_cmf_person_notify_opt_cmf_created_atÚ$ix_cmf_person_notify_opt_cmf_deletedÚ&ix_cmf_person_notify_opt_cmf_import_idÚ&ix_cmf_person_notify_opt_cmf_locked_atÚ)ix_cmf_person_notify_opt_cmf_locked_by_idÚ(ix_cmf_person_notify_opt_cmf_modified_atÚ+ix_cmf_person_notify_opt_cmf_modified_by_idÚ%ix_cmf_person_notify_opt_cmf_owner_idÚ$ix_cmf_person_notify_opt_cmf_versionÚ&ix_cmf_person_notify_opt_cmf_viewed_atÚix_cmf_person_notify_opt_codeÚix_cmf_person_notify_opt_nameÚ ix_cmf_person_notify_opt_ordernoÚ"ix_cmf_person_notify_opt_parent_idÚ$ix_cmf_person_notify_opt_perm_acl_idÚ'ix_cmf_person_notify_opt_perm_parent_idÚ'ix_cmf_person_notify_opt_root_parent_idÚ'ix_cmf_person_notify_opt_tree_parent_idÚ
cmf_personÚemail_if_spectatorFÚtrue)ÚnullableÚserver_defaultÚemail_if_authorÚfalseÚemail_if_responsibleÚemail_if_mentionsÚemail_if_self_changesÚix_cmf_person_notify_opt_idÚcmf_person_notify_opt_id_fkeyÚ
foreignkey)Útype_Únotify_opt_id)	r   Ú
drop_indexÚ
add_columnÚsaÚColumnÚBooleanÚdrop_constraintÚdrop_columnÚ
drop_table© r2   r2   ú;/opt/eva-app/alembic/versions/860455f7b8a2_event_options.pyÚupgrade   s8    r4   c                3   C   s  t  dtjdtjddddd¡ t  ddd	dgd
g¡ t jdddgdd t  dd¡ t  dd¡ t  dd¡ t  dd¡ t  dd¡ 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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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d4tjdddddtjd5tjdddddtjd6tjdddddtjd7t ¡ dddtjdt ¡ t d8¡ddd9tjdt ¡ t d8¡ddd9tjdt ¡ t d8¡ddd9tjdt ¡ t d8¡ddd9tjdt ¡ t d:¡ddd9tjd2gd;gd<d=tjd5gd>gd?d=tjd
d@d=¡. t jdAd	d3gdd t jdBd	d4gdd t jdCd	d6gdd t jdDd	d5gdd t jdEd	d/gdd t jdFd	d%gdd t jdGd	dgdd t jdHd	dgdd t jdId	dgdd t jdJd	dgdd t jdKd	d.gdd t jdLd	d0gdd t jdMd	dgdd t jdNd	d1gdd t jdOd	dgdd t jdPd	d2gdd t jdQd	dgdd t jdRd	dgdd t jdSd	d-gdd d S )TNr   r)   é@   )ÚlengthFT)Úautoincrementr   r&   r   Úidr%   )Úuniquer$   r#   r"   r    r   Úcmf_locked_at)Ú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Úis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚordernoÚperm_publicÚperm_has_aclÚperm_inheritÚperm_parent_owner_idÚperm_inherit_acl_idÚperm_effective_acl_idÚperm_encryptÚ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Úperm_acl_idÚperm_parent_idÚ%perm_security_level_allowed_ids_cacher   )r   r7   r   r!   zcmf_import.idZ(cmf_person_notify_opt_cmf_import_id_fkey)rA   zcmf_access_list.idZ&cmf_person_notify_opt_perm_acl_id_fkeyZcmf_person_notify_opt_pkeyr   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r
   r	   r   )r   r+   r,   r-   ÚVARCHARÚcreate_foreign_keyÚcreate_indexr0   Úcreate_tabler   Ú	TIMESTAMPÚBOOLEANÚBIGINTÚTEXTÚINTEGERrE   ÚForeignKeyConstraintÚPrimaryKeyConstraintr2   r2   r2   r3   Ú	downgrade4   s”    "Ó/rk   )Ú__doc__Úalembicr   Ú
sqlalchemyr,   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr4   rk   r2   r2   r2   r3   Ú<module>   s   !