U
    ´–¢e¤  ã                   @   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 )
zkanswertempl_init

Revision ID: 93dd8c5b1d28
Revises: f5911ed880a1
Create Date: 2023-11-15 16:22:05.719585

é    )ÚopNZ93dd8c5b1d28Úf5911ed880a1c                1   C   sr  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 ¡ 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 ¡ ddtjd%tjd&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d0tjddddtjd1tjddddtjd2tjddddtjd3tjddddt 
d.gd4g¡t 
d1gd5g¡t 
d3gd6g¡t d¡¡- t jt  d7¡dd)gdd8 t jt  d9¡dd
gdd8 t jt  d:¡ddgdd8 t jt  d;¡dd.gdd8 t jt  d<¡ddgdd8 t jt  d=¡dd-gdd8 t jt  d>¡ddgdd8 t jt  d?¡dd,gdd8 t jt  d@¡dd*gdd8 t jt  dA¡ddgdd8 t jt  dB¡ddgdd8 t jt  dC¡ddgdd8 t jt  dD¡ddgdd8 t jt  dE¡ddgdd8 t jt  dF¡dd+gdd8 t jt  dG¡dd1gdd8 t jt  dH¡dd2gdd8 t jt  dI¡dd3gdd8 t jt  dJ¡dd0gdd8 t jt  dK¡dd/gdd8 d S )LNÚcmf_answer_templateÚ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Úimport_raw_jsonÚext_idÚcmf_archivedÚ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_security_level_allowed_ids_cacheÚperm_encryptÚanswer_typeé    Úprivate)r   Úserver_defaultÚcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idÚcmf_import_idÚtree_parent_idÚroot_parent_idÚperm_acl_idÚperm_parent_idÚ	person_idzcmf_import.idzcmf_access_list.idzcmf_person.idÚ$ix_cmf_answer_template_cmf_author_id)ÚuniqueÚ%ix_cmf_answer_template_cmf_created_atÚ"ix_cmf_answer_template_cmf_deletedÚ$ix_cmf_answer_template_cmf_import_idÚ$ix_cmf_answer_template_cmf_locked_atÚ'ix_cmf_answer_template_cmf_locked_by_idÚ&ix_cmf_answer_template_cmf_modified_atÚ)ix_cmf_answer_template_cmf_modified_by_idÚ#ix_cmf_answer_template_cmf_owner_idÚ"ix_cmf_answer_template_cmf_versionÚ$ix_cmf_answer_template_cmf_viewed_atÚix_cmf_answer_template_codeÚix_cmf_answer_template_nameÚix_cmf_answer_template_ordernoÚ ix_cmf_answer_template_parent_idÚ"ix_cmf_answer_template_perm_acl_idÚ%ix_cmf_answer_template_perm_parent_idÚ ix_cmf_answer_template_person_idÚ%ix_cmf_answer_template_root_parent_idÚ%ix_cmf_answer_template_tree_parent_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚf© rW   rW   ú>/opt/eva-app/alembic/versions/93dd8c5b1d28_answertempl_init.pyÚupgrade   s„    Ô.rY   c                   C   sž  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 )NrI   r   )Ú
table_namerH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r5   )r   Ú
drop_indexrV   Ú
drop_tablerW   rW   rW   rX   Ú	downgradeZ   s*    r]   )Ú__doc__Úalembicr   Ú
sqlalchemyrK   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onrY   r]   rW   rW   rW   rX   Ú<module>   s   G