U
    ]Úd  ã                   @   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 )
zeStatusCode

Revision ID: c2b2d6f77bc1
Revises: 0a2e13051c18
Create Date: 2022-12-27 11:10:05.768095

é    )ÚopNÚc2b2d6f77bc1Ú0a2e13051c18c                +   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 ¡ 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 ¡ 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jd+tjddddtjd,tjddddt 
d)gd-g¡t 
d+gd.g¡t d¡¡' t jt  d/¡dd$gdd0 t jt  d1¡dd
gdd0 t jt  d2¡ddgdd0 t jt  d3¡dd)gdd0 t jt  d4¡ddgdd0 t jt  d5¡dd(gdd0 t jt  d6¡ddgdd0 t jt  d7¡dd'gdd0 t jt  d8¡dd%gdd0 t jt  d9¡ddgdd0 t jt  d:¡ddgdd0 t jt  d;¡ddgdd0 t jt  d<¡ddgdd0 t jt  d=¡ddgdd0 t jt  d>¡dd&gdd0 t jt  d?¡dd+gdd0 t jt  d@¡dd,gdd0 t jt  dA¡dd*gdd0 t  dBtjdCtjdddd¡ t jt  dD¡dBdCgdd0 t  d dBddCgdg¡ d S )ENÚcmf_status_codeÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnameé   ÚcodeÚsystemÚtextÚimport_originalÚ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Ústatus_typeé    Úcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚperm_acl_idÚperm_parent_idzcmf_import.idzcmf_access_list.idÚ ix_cmf_status_code_cmf_author_id)ÚuniqueÚ!ix_cmf_status_code_cmf_created_atÚix_cmf_status_code_cmf_deletedÚ ix_cmf_status_code_cmf_import_idÚ ix_cmf_status_code_cmf_locked_atÚ#ix_cmf_status_code_cmf_locked_by_idÚ"ix_cmf_status_code_cmf_modified_atÚ%ix_cmf_status_code_cmf_modified_by_idÚix_cmf_status_code_cmf_owner_idÚix_cmf_status_code_cmf_versionÚ ix_cmf_status_code_cmf_viewed_atÚix_cmf_status_code_codeÚix_cmf_status_code_nameÚix_cmf_status_code_ordernoÚix_cmf_status_code_parent_idÚix_cmf_status_code_perm_acl_idÚ!ix_cmf_status_code_perm_parent_idÚ!ix_cmf_status_code_tree_parent_idÚ
cmf_statusÚstatus_code_idÚix_cmf_status_status_code_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚcreate_foreign_key© rT   rT   ú8/opt/eva-app/alembic/versions/c2b2d6f77bc1_statuscode.pyÚupgrade   sz    Ú( rV   c                   C   s¦  t jd ddd t jt  d¡dd t  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 jt  d¡dd t jt  d¡dd t  d¡ d S )NrB   Ú
foreignkey)Útype_rD   )Ú
table_namerC   rA   r   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r/   )r   Údrop_constraintÚ
drop_indexrQ   Údrop_columnÚ
drop_tablerT   rT   rT   rU   Ú	downgradeU   s,    r^   )Ú__doc__Úalembicr   Ú
sqlalchemyrF   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrV   r^   rT   rT   rT   rU   Ú<module>   s   B