U
    xÊ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 )
zoclients spravochniki

Revision ID: 9c9521effcac
Revises: 253e667847b0
Create Date: 2024-02-12 21:05:44.658004

é    )ÚopNÚ9c9521effcacÚ253e667847b0c                .   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 ¡ 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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d0g¡t d¡¡* t jt  d1¡dd%gdd2 t jt  d3¡dd
gdd2 t jt  d4¡ddgdd2 t jt  d5¡dd*gdd2 t jt  d6¡ddgdd2 t jt  d7¡dd)gdd2 t jt  d8¡ddgdd2 t jt  d9¡dd(gdd2 t jt  d:¡dd&gdd2 t jt  d;¡ddgdd2 t jt  d<¡ddgdd2 t jt  d=¡ddgdd2 t jt  d>¡ddgdd2 t jt  d?¡ddgdd2 t jt  d@¡dd'gdd2 t jt  dA¡dd-gdd2 t jt  dB¡dd.gdd2 t jt  dC¡dd,gdd2 t jt  dD¡dd+gdd2 t  dEt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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d0g¡t d¡¡* t jt  dF¡dEd%gdd2 t jt  dG¡dEd
gdd2 t jt  dH¡dEdgdd2 t jt  dI¡dEd*gdd2 t jt  dJ¡dEdgdd2 t jt  dK¡dEd)gdd2 t jt  dL¡dEdgdd2 t jt  dM¡dEd(gdd2 t jt  dN¡dEd&gdd2 t jt  dO¡dEdgdd2 t jt  dP¡dEdgdd2 t jt  dQ¡dEdgdd2 t jt  dR¡dEdgdd2 t jt  dS¡dEdgdd2 t jt  dT¡dEd'gdd2 t jt  dU¡dEd-gdd2 t jt  dV¡dEd.gdd2 t jt  dW¡dEd,gdd2 t jt  dX¡dEd+gdd2 t  dYtjdZtjdddd¡ t jt  d[¡dYdZgdd2 t  d dYddZgdg¡ t  d\tjd]tjdddd¡ t jd\d^tjd_dtjdddd` t jd\datjd_dtjdddd` t jd\dbtjd_dtjdcddd` t jt  dd¡d\d]gdd2 t  d d\dEd]gdg¡ d S )eNÚcmf_business_sectorÚ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Ú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_idzcmf_import.idzcmf_access_list.idÚ$ix_cmf_business_sector_cmf_author_id)ÚuniqueÚ%ix_cmf_business_sector_cmf_created_atÚ"ix_cmf_business_sector_cmf_deletedÚ$ix_cmf_business_sector_cmf_import_idÚ$ix_cmf_business_sector_cmf_locked_atÚ'ix_cmf_business_sector_cmf_locked_by_idÚ&ix_cmf_business_sector_cmf_modified_atÚ)ix_cmf_business_sector_cmf_modified_by_idÚ#ix_cmf_business_sector_cmf_owner_idÚ"ix_cmf_business_sector_cmf_versionÚ$ix_cmf_business_sector_cmf_viewed_atÚix_cmf_business_sector_codeÚix_cmf_business_sector_nameÚix_cmf_business_sector_ordernoÚ ix_cmf_business_sector_parent_idÚ"ix_cmf_business_sector_perm_acl_idÚ%ix_cmf_business_sector_perm_parent_idÚ%ix_cmf_business_sector_root_parent_idÚ%ix_cmf_business_sector_tree_parent_idÚcmf_client_jobÚix_cmf_client_job_cmf_author_idÚ ix_cmf_client_job_cmf_created_atÚix_cmf_client_job_cmf_deletedÚix_cmf_client_job_cmf_import_idÚix_cmf_client_job_cmf_locked_atÚ"ix_cmf_client_job_cmf_locked_by_idÚ!ix_cmf_client_job_cmf_modified_atÚ$ix_cmf_client_job_cmf_modified_by_idÚix_cmf_client_job_cmf_owner_idÚix_cmf_client_job_cmf_versionÚix_cmf_client_job_cmf_viewed_atÚix_cmf_client_job_codeÚix_cmf_client_job_nameÚix_cmf_client_job_ordernoÚix_cmf_client_job_parent_idÚix_cmf_client_job_perm_acl_idÚ ix_cmf_client_job_perm_parent_idÚ ix_cmf_client_job_root_parent_idÚ ix_cmf_client_job_tree_parent_idÚcmf_companyÚbusiness_sector_idÚ!ix_cmf_company_business_sector_idÚ
cmf_personÚclient_job_idÚphone_internalé    ©Úexisting_typeÚtype_Úexisting_nullableÚphone_2Úemail_2é€   Úix_cmf_person_client_job_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚTEXTÚIntegerÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
add_columnÚcreate_foreign_keyÚalter_columnÚVARCHAR© rz   rz   úB/opt/eva-app/alembic/versions/9c9521effcac_clients_spravochniki.pyÚupgrade   s"   ×+×+  

ý

ý

ýr|   c                   C   sÜ  t jd ddd t jt  d¡dd t jddtjddtjd	dd
d t jddtjddtjd	dd
d t jddtjddtjd	dd
d t  dd¡ 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 jt  d&¡dd t  	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  d0¡d(d t jt  d1¡d(d t jt  d2¡d(d t jt  d3¡d(d t jt  d4¡d(d t jt  d5¡d(d t jt  d6¡d(d t jt  d7¡d(d t jt  d8¡d(d t jt  d9¡d(d t jt  d:¡d(d t  	d(¡ d S );Nr]   Ú
foreignkey)rc   rh   )Ú
table_namerf   rg   r   r`   Tra   re   r   r_   r^   rZ   r\   r[   rY   rF   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rE   r   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r5   r4   r2   )
r   Údrop_constraintÚ
drop_indexru   rx   rj   rl   ry   Údrop_columnÚ
drop_tablerz   rz   rz   r{   Ú	downgrade¦   sz    

ý

ý

ý
rƒ   )Ú__doc__Úalembicr   Ú
sqlalchemyrj   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr|   rƒ   rz   rz   rz   r{   Ú<module>   s    