U
    \ÚdÃ,  ã                   @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd„ Zd	d
„ ZdS )zgchange cards

Revision ID: 7b90b3cdc22b
Revises: fa389856020a
Create Date: 2021-04-27 14:56:14.554093

é    )ÚopN)Ú
postgresqlÚ7b90b3cdc22bÚfa389856020ac                   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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 ¡ 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 ¡ ddtjd t ¡ ddtjd!t ¡ dd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# t j
t  d4¡ddgd	d# t j
t  d5¡dd!gd	d# t  d6tjdt ¡ dd¡ t  d6tjd7t ¡ dd¡ t jd8d6d9 t jd:d6d9 t jd;d6d9 t jd<d6d9 t jd=d6d9 t jd>d6d9 t jd?d6d9 t jd@d6d9 t jdAd6d9 t jdBd6d9 t jdCd6d9 t jdDd6d9 t jdEd6dFdG t  d6dH¡ t  d6dI¡ t  d6dJ¡ t  d6dK¡ t  d6dL¡ t  d6dM¡ t  d6dN¡ t  d6dO¡ t  d6d¡ t  d6d¡ t  d6dP¡ t  d6dQ¡ t  d6dR¡ t  d6dS¡ t  d6dT¡ t  d6dU¡ t  d6dV¡ t  d6dW¡ t  d6dX¡ t  d6dY¡ d S )ZNÚ
cmf_notifyÚcmf_author_idé@   ©ÚlengthT)ÚnullableÚcmf_created_at©ÚtimezoneFÚcmf_deletedÚ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Úconfirm_closeÚidÚnameé   Úobj_commentsÚobj_idÚobj_status_typeé    Ú	parent_idÚ	person_idÚstatusÚstrikethroughÚtextÚ
unread_cntÚix_cmf_notify_cmf_author_id©ÚuniqueÚix_cmf_notify_cmf_created_atÚix_cmf_notify_cmf_deletedÚix_cmf_notify_cmf_locked_atÚix_cmf_notify_cmf_locked_by_idÚix_cmf_notify_cmf_modified_atÚ ix_cmf_notify_cmf_modified_by_idÚ$ix_cmf_notify_cmf_owner_assistant_idÚix_cmf_notify_cmf_owner_idÚix_cmf_notify_cmf_versionÚix_cmf_notify_cmf_viewed_atÚix_cmf_notify_codeÚix_cmf_notify_confirm_closeÚix_cmf_notify_nameÚix_cmf_notify_obj_idÚix_cmf_notify_parent_idÚix_cmf_notify_person_idÚix_cmf_notify_statusÚix_cmf_notify_unread_cntÚcmf_cardÚ
obj_fieldsÚix_cmf_card_confirm_close©Ú
table_nameÚ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_nameÚ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_obj_ui_nameÚix_cmf_card_ordernoÚcmf_card_obj_status_id_fkeyÚ
foreignkey)Útype_ÚordernoÚobj_responsible_idÚobj_codeÚobj_deadlineÚobj_status_idÚobj_cmf_owner_nameÚobj_cmf_owner_idÚobj_time_estimateÚobj_responsible_nameÚobj_nameÚobj_ui_nameÚobj_plan_start_dateÚbodyÚicon_svgÚobj_cmf_owner_loginÚobj_plan_end_dateÚobj_urlÚobj_responsible_login)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚIntegerÚTEXTÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚ
drop_indexÚdrop_constraintÚdrop_column© rp   rp   ú:/opt/eva-app/alembic/versions/7b90b3cdc22b_change_cards.pyÚupgrade   s¢    çrr   c                	   C   s<  t  dtjdtjddddd¡ t  dtjdtjd	dddd¡ t  dtjd
tjddddd¡ t  dtjdtjddddd¡ t  dtjdt ¡ ddd¡ t  dtjdt ¡ ddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdt ¡ ddd¡ t  dtjdt 	¡ ddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdtjddddd¡ t  dtjdt 	¡ ddd¡ t  
ddd dgd!g¡ t jd"ddgdd# t jd$ddgdd# t jd%ddgdd# t jd&ddgdd# t jd'ddgdd# t jd(ddgdd# t jd)ddgdd# t jd*ddgdd# t jd+ddgdd# t jd,ddgdd# t jd-ddgdd# t jd.ddgdd# t  dd/¡ t  dd0¡ t jt  d1¡d2d3 t jt  d4¡d2d3 t jt  d5¡d2d3 t jt  d6¡d2d3 t jt  d7¡d2d3 t jt  d8¡d2d3 t jt  d9¡d2d3 t jt  d:¡d2d3 t jt  d;¡d2d3 t jt  d<¡d2d3 t jt  d=¡d2d3 t jt  d>¡d2d3 t jt  d?¡d2d3 t jt  d@¡d2d3 t jt  dA¡d2d3 t jt  dB¡d2d3 t jt  dC¡d2d3 t jt  dD¡d2d3 t jt  dE¡d2d3 t  d2¡ d S )FNr<   r`   r   r	   FT)Úautoincrementr   r_   i   r^   r   r]   r\   r[   rZ   rY   rX   r   rW   r   r    r   rV   rU   rT   rS   rR   rQ   rP   rO   rL   Ú
cmf_statusr   rK   r(   rJ   rI   rH   rG   rF   rE   rD   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   rl   rb   rc   ÚVARCHARr   re   rh   ÚBOOLEANÚINTEGERÚcreate_foreign_keyrj   ro   rm   rk   Ú
drop_tablerp   rp   rp   rq   Ú	downgradei   sn    """""""""""""""rz   )Ú__doc__Úalembicr   Ú
sqlalchemyrb   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrr   rz   rp   rp   rp   rq   Ú<module>   s   V