U
    \ÚdZ  ã                   @   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 )
zjinternal phones

Revision ID: ab72c75c388a
Revises: 06e2e3f22d20
Create Date: 2021-08-27 16:29:05.417308

é    )ÚopNZab72c75c388aZ06e2e3f22d20c                   C   s˜  t  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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 ¡ 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 ¡ ddtjdt ¡ ddt 	dgdg¡t 
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  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  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  d0¡ddgdd! t jt  d1¡ddgdd! d S )2NÚcmf_person_internal_phoneÚcache_last_commentsF)ÚnullableÚ
channel_idé@   )ÚlengthTÚcmf_author_idÚcmf_created_at)ÚtimezoneÚcmf_deletedÚcmf_import_idÚcmf_locked_atÚcmf_locked_by_idÚcmf_modified_atÚcmf_modified_by_idÚcmf_owner_assistant_idÚcmf_owner_idÚcmf_versionÚcmf_viewed_atÚcodeÚidÚnameé   Ú	parent_idÚphoneé    ÚsystemÚtextzcmf_import.idÚ'ix_cmf_person_internal_phone_channel_id)ÚuniqueÚ*ix_cmf_person_internal_phone_cmf_author_idÚ+ix_cmf_person_internal_phone_cmf_created_atÚ(ix_cmf_person_internal_phone_cmf_deletedÚ*ix_cmf_person_internal_phone_cmf_import_idÚ*ix_cmf_person_internal_phone_cmf_locked_atÚ-ix_cmf_person_internal_phone_cmf_locked_by_idÚ,ix_cmf_person_internal_phone_cmf_modified_atÚ/ix_cmf_person_internal_phone_cmf_modified_by_idÚ3ix_cmf_person_internal_phone_cmf_owner_assistant_idÚ)ix_cmf_person_internal_phone_cmf_owner_idÚ(ix_cmf_person_internal_phone_cmf_versionÚ*ix_cmf_person_internal_phone_cmf_viewed_atÚ!ix_cmf_person_internal_phone_codeÚ!ix_cmf_person_internal_phone_nameÚ&ix_cmf_person_internal_phone_parent_idÚ"ix_cmf_person_internal_phone_phone)r   Úcreate_tableÚsaÚColumnÚTEXTÚStringÚ	TIMESTAMPÚBooleanÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© r=   r=   ú=/opt/eva-app/alembic/versions/ab72c75c388a_internal_phones.pyÚupgrade   sT    ér?   c                   C   sb  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t  d¡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t  d¡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t  d¡dd t jt  d¡dd t jt  d¡dd t  d¡ d S )Nr0   r   )Ú
table_namer/   r.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r$   r#   r"   r!   r   )r   Ú
drop_indexr<   Ú
drop_tabler=   r=   r=   r>   Ú	downgradeB   s$    rC   )Ú__doc__Úalembicr   Ú
sqlalchemyr2   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr?   rC   r=   r=   r=   r>   Ú<module>   s   /