
    \dG                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zfadd_refbook

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

    )opNe7af56f72e8673e1d50a5428c                   j   t        j                  dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d t        j                  d      d      t        j                  dgd!g      t        j                  d             t        j                  t        j                  d"      ddgd#       t        j                  t        j                  d$      dd
gd#       t        j                  t        j                  d%      ddgd#       t        j                  t        j                  d&      ddgd#       t        j                  t        j                  d'      ddgd#       t        j                  t        j                  d(      ddgd#       t        j                  t        j                  d)      ddgd#       t        j                  t        j                  d*      ddgd#       t        j                  t        j                  d+      ddgd#       t        j                  t        j                  d,      ddgd#       t        j                  t        j                  d-      ddgd#       t        j                  t        j                  d.      ddgd#       t        j                  t        j                  d/      ddgd#       t        j                  t        j                  d0      ddgd#       t        j                  t        j                  d1      ddgd#       t        j                  t        j                  d2      ddgd#       t        j                  t        j                  d3      dd gd#       y )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     9/opt/eva-app/alembic/versions/e7af56f72e86_add_refbook.pyupgraderG      s   OOMIIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRYY[48IIfbiis+d;IIfbiir*T:IIh

u5IIfbggi$/IImRZZ\D9II

t<II#RZZ\DAIImRZZ\D9IIi5IIoryy3dCIInbiir2TBII&		(<tLIIk299B/$?II"BIIR$84HII "))2"6FIIoryy3dCII		 4tD_-/@CD!58 OOBDD78-/IZchiOOBDD89=K[J\ejkOOBDD56_deOOBDD78-/IZchiOOBDD78-/IZchiOOBDD:;]M_L`inoOOBDD9:ML]K^glmOOBDD<=}OcNdmrsOOBDD@A=SkRluz{OOBDD67HXafgOOBDD56_deOOBDD78-/IZchiOOBDD./QUVOOBDD./QVWOOBDD12MI;W\]OOBDD34mk][`aOOBDD89=K[J\ejkrE   c                     t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d	      d       t        j                  t        j                  d
      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       y )Nr6   r   )
table_namer5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r)   r(   r'   r%   )r   
drop_indexrC   
drop_tablerD   rE   rF   	downgraderL   E   s   MM"$$67MRMM"$$12}MMM"$$/0]KMM"$$,--HMM"$$,--HMM"$$56=QMM"$$34OMM"$$45-PMM"$$>?MZMM"$$:;VMM"$$78]SMM"$$89mTMM"$$56=QMM"$$56=QMM"$$34OMM"$$67MRMM"$$56=QMM- rE   )__doc__alembicr   
sqlalchemyr8   revisiondown_revisionbranch_labels
depends_onrG   rL   rD   rE   rF   <module>rT      s4      
.ld!rE   