U
    \ÚdG  ã                   @   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 )
zfadd_refbook

Revision ID: e7af56f72e86
Revises: 73e1d50a5428
Create Date: 2022-06-07 05:38:42.199815

é    )ÚopNÚe7af56f72e86Ú73e1d50a5428c                   C   sÊ  t  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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jdt ¡ ddtjdt ¡ ddtjdt ¡ ddtjdt ¡ 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jdd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  d0¡ddgdd# t jt  d1¡ddgdd# t jt  d2¡ddgdd# t jt  d3¡dd gdd# d S )4NÚcmf_refbookÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚordernoÚcmf_author_idÚcmf_owner_idÚcmf_owner_assistant_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idzcmf_import.idÚix_cmf_refbook_cmf_author_id)ÚuniqueÚix_cmf_refbook_cmf_created_atÚix_cmf_refbook_cmf_deletedÚix_cmf_refbook_cmf_import_idÚix_cmf_refbook_cmf_locked_atÚix_cmf_refbook_cmf_locked_by_idÚix_cmf_refbook_cmf_modified_atÚ!ix_cmf_refbook_cmf_modified_by_idÚ%ix_cmf_refbook_cmf_owner_assistant_idÚix_cmf_refbook_cmf_owner_idÚix_cmf_refbook_cmf_versionÚix_cmf_refbook_cmf_viewed_atÚix_cmf_refbook_codeÚix_cmf_refbook_nameÚix_cmf_refbook_ordernoÚix_cmf_refbook_parent_idÚix_cmf_refbook_tree_parent_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© rB   rB   ú9/opt/eva-app/alembic/versions/e7af56f72e86_add_refbook.pyÚupgrade   sZ    ærD   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 )Nr4   r   )Ú
table_namer3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r)   r(   r'   r&   r%   r#   )r   Ú
drop_indexrA   Ú
drop_tablerB   rB   rB   rC   Ú	downgradeE   s$    rH   )Ú__doc__Úalembicr   Ú
sqlalchemyr6   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrD   rH   rB   rB   rB   rC   Ú<module>   s   2