U
    \Údt   ã                   @   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 )
zhempty message

Revision ID: 0f5c44e5e07f
Revises: 3e33cc123e7e
Create Date: 2021-01-11 14:45:43.860755

é    )ÚopNÚ0f5c44e5e07fÚ3e33cc123e7ec                -   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 ¡ 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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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 ¡ 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 ¡ ddtjd0tjd"dddt 	d&gd1g¡t 
d¡¡) t jt  d2¡ddgd
d3 t jt  d4¡ddgd
d3 t jt  d5¡dd	gd
d3 t jt  d6¡ddgd
d3 t jt  d7¡ddgd
d3 t jt  d8¡ddgd
d3 t jt  d9¡ddgd
d3 t jt  d:¡ddgd
d3 t jt  d;¡ddgd
d3 t jt  d<¡ddgd
d3 t jt  d=¡ddgdd3 t jt  d>¡ddgd
d3 t jt  d?¡ddgd
d3 t jt  d@¡ddgd
d3 t jt  dA¡ddgd
d3 t jt  dB¡ddgd
d3 t jt  dC¡ddgd
d3 t jt  dD¡ddgd
d3 t jt  dE¡ddgd
d3 t jt  dF¡ddgd
d3 t jt  dG¡dd#gd
d3 t jt  dH¡dd$gd
d3 t jt  dI¡dd%gd
d3 t jt  dJ¡dd&gd
d3 t jt  dK¡dd+gd
d3 t jt  dL¡dd,gd
d3 t jt  dM¡dd-gd
d3 t jt  dN¡dd.gd
d3 t jt  dO¡dd0gd
d3 d S )PNÚcmf_cardÚcmf_author_idé@   )ÚlengthT)ÚnullableÚcmf_created_at)ÚtimezoneÚcmf_deletedFÚcmf_locked_atÚcmf_locked_by_idÚcmf_modified_atÚcmf_modified_by_idÚcmf_owner_idÚcmf_versionÚcmf_viewed_atÚcodeÚidÚnameé   Úobj_alarm_dateZobj_cmf_owner_idZobj_cmf_owner_loginZobj_cmf_owner_nameÚobj_codeZobj_deadlineÚobj_idÚobj_nameÚobj_ordernoZobj_plan_end_dateZobj_plan_start_dateÚobj_priorityé    Zobj_responsible_idZobj_responsible_loginZobj_responsible_nameÚobj_status_idÚobj_status_typeZobj_time_estimateÚobj_urli   ÚordernoÚ	person_idÚpinnedÚstatusÚtextÚtypezcmf_status.idÚix_cmf_card_cmf_author_id)ÚuniqueÚix_cmf_card_cmf_created_atÚix_cmf_card_cmf_deletedÚix_cmf_card_cmf_locked_atÚix_cmf_card_cmf_locked_by_idÚix_cmf_card_cmf_modified_atÚix_cmf_card_cmf_modified_by_idÚix_cmf_card_cmf_owner_idÚix_cmf_card_cmf_versionÚix_cmf_card_cmf_viewed_atÚix_cmf_card_codeÚix_cmf_card_nameÚix_cmf_card_obj_alarm_dateÚix_cmf_card_obj_cmf_owner_idÚix_cmf_card_obj_cmf_owner_loginÚix_cmf_card_obj_cmf_owner_nameÚix_cmf_card_obj_codeÚix_cmf_card_obj_idÚix_cmf_card_obj_nameÚix_cmf_card_obj_ordernoÚix_cmf_card_obj_responsible_idÚ!ix_cmf_card_obj_responsible_loginÚ ix_cmf_card_obj_responsible_nameÚix_cmf_card_obj_status_idÚix_cmf_card_ordernoÚix_cmf_card_person_idÚix_cmf_card_pinnedÚix_cmf_card_statusÚix_cmf_card_type)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚIntegerÚTEXTÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© rR   rR   ú./opt/eva-app/alembic/versions/0f5c44e5e07f_.pyÚupgrade   sŽ    Ø*rT   c                   C   sR  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 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 ) NrE   r   )Ú
table_namerD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r3   r2   r1   r0   r/   r.   r-   r,   r+   r*   r(   )r   Ú
drop_indexrQ   Ú
drop_tablerR   rR   rR   rS   Ú	downgrade_   s<    rX   )Ú__doc__Úalembicr   Ú
sqlalchemyrG   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrT   rX   rR   rR   rR   rS   Ú<module>   s   L