
    xe>                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zoclients spravochniki

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

    )opN9c9521effcac253e667847b0c            	      ,   t        j                  g dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                  d      d      t        j                  d#t        j                         d      t        j                  d$t        j                         d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d(t        j                  d      d      t        j                  d)t        j                  d      d      t        j                  d*t        j                  d      d      t        j                  d+t        j                  d      d      t        j                  d,t        j                  d      d      t        j                  d-t        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d*gd/g      t        j                  d-gd0g      t        j                  d        t        j                  t        j                  d1      dd%gd2       t        j                  t        j                  d3      dd
gd2       t        j                  t        j                  d4      ddgd2       t        j                  t        j                  d5      dd*gd2       t        j                  t        j                  d6      ddgd2       t        j                  t        j                  d7      dd)gd2       t        j                  t        j                  d8      ddgd2       t        j                  t        j                  d9      dd(gd2       t        j                  t        j                  d:      dd&gd2       t        j                  t        j                  d;      ddgd2       t        j                  t        j                  d<      ddgd2       t        j                  t        j                  d=      ddgd2       t        j                  t        j                  d>      ddgd2       t        j                  t        j                  d?      ddgd2       t        j                  t        j                  d@      dd'gd2       t        j                  t        j                  dA      dd-gd2       t        j                  t        j                  dB      dd.gd2       t        j                  t        j                  dC      dd,gd2       t        j                  t        j                  dD      dd+gd2       t        j                  g dEt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                  d      d      t        j                  d#t        j                         d      t        j                  d$t        j                         d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d(t        j                  d      d      t        j                  d)t        j                  d      d      t        j                  d*t        j                  d      d      t        j                  d+t        j                  d      d      t        j                  d,t        j                  d      d      t        j                  d-t        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d*gd/g      t        j                  d-gd0g      t        j                  d        t        j                  t        j                  dF      dEd%gd2       t        j                  t        j                  dG      dEd
gd2       t        j                  t        j                  dH      dEdgd2       t        j                  t        j                  dI      dEd*gd2       t        j                  t        j                  dJ      dEdgd2       t        j                  t        j                  dK      dEd)gd2       t        j                  t        j                  dL      dEdgd2       t        j                  t        j                  dM      dEd(gd2       t        j                  t        j                  dN      dEd&gd2       t        j                  t        j                  dO      dEdgd2       t        j                  t        j                  dP      dEdgd2       t        j                  t        j                  dQ      dEdgd2       t        j                  t        j                  dR      dEdgd2       t        j                  t        j                  dS      dEdgd2       t        j                  t        j                  dT      dEd'gd2       t        j                  t        j                  dU      dEd-gd2       t        j                  t        j                  dV      dEd.gd2       t        j                  t        j                  dW      dEd,gd2       t        j                  t        j                  dX      dEd+gd2       t        j                  dYt        j                  dZt        j                  d      d             t        j                  t        j                  d[      dYdZgd2       t        j                  d dYddZgdg       t        j                  d\t        j                  d]t        j                  d      d             t        j                   d\d^t        j"                  d_      t        j                  d      d`       t        j                   d\dat        j"                  d_      t        j                  d      d`       t        j                   d\dbt        j"                  d_      t        j                  dc      d`       t        j                  t        j                  dd      d\d]gd2       t        j                  d d\dEd]gdg       y )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     B/opt/eva-app/alembic/versions/9c9521effcac_clients_spravochniki.pyupgrader      sv   OO *) *IIdBIIR(59*IIor||T:TJ* IId ;eL* IIt!<uM	*
 IIor||T:TJ* IImRZZ\E:* IImRYY[48* IIfbiis+d;* IIfbiir*T:* IIh

u5* IIfbggi$/* II=* IIT:* IIh		d3* IInbjjlU;*  IImRZZ\D9!*" II

t<#*$ II#RZZ\DA%*& IImRZZ\D9'*( IIi5)** IImRZZ\D9+*, IInbjjlT:-*. IInbjjlT:/*0 II$biir&:TJ1*2 II#RYYb%9DI3*4 II%ryy';dK5*6 II5rwwy4P7*8 IInbjjlT:9*: IIoryy3dC;*< IInbiir2TB=*> IIk299B/$??*@ II"BIIR$84HA*B II "))2"6FC*D IIoryy3dCE*F II		 4tDG*H II		 4tDI*J IImRYYb1DAK*L II		 4tDM*N _-/@CO*P ]O.B-CFQ*R D!S*V OOBDD?@BWZiYjsxyOOBDD@ACX[kZluz{OOBDD=>@UXeWfotuOOBDD?@BWZiYjsxyOOBDD?@BWZiYjsxyOOBDDBCEZ]o\py~OOBDDABDY\m[nw|}OOBDDDEG\_s^t  ~C  DOOBDD>?AVYgXhqvwOOBDD=>@UXeWfotuOOBDD?@BWZiYjsxyOOBDD679NQWPXaefOOBDD679NQWPXafgOOBDD9:<QT]S^glmOOBDD;<>SVaUbkpqOOBDD=>@UXeWfotuOOBDD@ACX[kZluz{OOBDD@ACX[kZluz{OOBDD@ACX[kZluz{OO *$ *IIdBIIR(59*IIor||T:TJ* IId ;eL* IIt!<uM	*
 IIor||T:TJ* IImRZZ\E:* IImRYY[48* IIfbiis+d;* IIfbiir*T:* IIh

u5* IIfbggi$/* II=* IIT:* IIh		d3* IInbjjlU;*  IImRZZ\D9!*" II

t<#*$ II#RZZ\DA%*& IImRZZ\D9'*( IIi5)** IImRZZ\D9+*, IInbjjlT:-*. IInbjjlT:/*0 II$biir&:TJ1*2 II#RYYb%9DI3*4 II%ryy';dK5*6 II5rwwy4P7*8 IInbjjlT:9*: IIoryy3dC;*< IInbiir2TB=*> IIk299B/$??*@ II"BIIR$84HA*B II "))2"6FC*D IIoryy3dCE*F II		 4tDG*H II		 4tDI*J IImRYYb1DAK*L II		 4tDM*N _-/@CO*P ]O.B-CFQ*R D!S*V OOBDD:;=MP_O`inoOOBDD;<>NQaPbkpqOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD:;=MP_O`inoOOBDD=>@PSeRfotuOOBDD<=?ORcQdmrsOOBDD?@BRUiTjsxyOOBDD9:<L~N^glmOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD124DvhW[\OOBDD124DvhW\]OOBDD457G)]bcOOBDD679IK=afgOOBDD89;Km_ejkOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpqMM-+?RTAU`d!efOOBDD<=}OcNdmrs$/DG[F\_c^deMM,		/299B;OZ^ _`OOL"2ZZr2YYc*!%' OOL)ZZr2YYc*!%' OOL)ZZr2YYc*!%' OOBDD67GXafg$.>@QTXSYZr}   c                     t        j                  d dd       t        j                  t        j                  d      d       t        j                  ddt        j                  d      t        j                  d	      d
       t        j                  ddt        j                  d      t        j                  d	      d
       t        j                  ddt        j                  d      t        j                  d	      d
       t        j                  dd       t        j                  d dd       t        j                  t        j                  d      d       t        j                  dd       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d       d       t        j                  t        j                  d!      d       t        j                  t        j                  d"      d       t        j                  t        j                  d#      d       t        j                  t        j                  d$      d       t        j                  t        j                  d%      d       t        j                  t        j                  d&      d       t        j                  d       t        j                  t        j                  d'      d(       t        j                  t        j                  d)      d(       t        j                  t        j                  d*      d(       t        j                  t        j                  d+      d(       t        j                  t        j                  d,      d(       t        j                  t        j                  d-      d(       t        j                  t        j                  d.      d(       t        j                  t        j                  d/      d(       t        j                  t        j                  d0      d(       t        j                  t        j                  d1      d(       t        j                  t        j                  d2      d(       t        j                  t        j                  d3      d(       t        j                  t        j                  d4      d(       t        j                  t        j                  d5      d(       t        j                  t        j                  d6      d(       t        j                  t        j                  d7      d(       t        j                  t        j                  d8      d(       t        j                  t        j                  d9      d(       t        j                  t        j                  d:      d(       t        j                  d(       y );Nr_   
foreignkey)re   rj   )
table_namerh   ri   r
   rb   Trc   rg   r   ra   r`   r\   r^   r]   r[   rH   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rG   r   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r7   r6   r4   )
r   drop_constraint
drop_indexrw   rz   rl   rn   r{   drop_column
drop_tabler|   r}   r~   	downgrader      s   t\>MM"$$45,OOOL)YYc2ZZr*!%' OOL)YYc2ZZr*!%' OOL"2YYc2ZZr*!%' NN<1t],?MM"$$:;VNN="67MM"$$9:GWXMM"$$9:GWXMM"$$9:GWXMM"$$67DTUMM"$$45BRSMM"$$23@PQMM"$$/0=MNMM"$$/0=MNMM"$$89FVWMM"$$67DTUMM"$$78EUVMM"$$=>K[\MM"$$:;HXYMM"$$;<IYZMM"$$89FVWMM"$$89FVWMM"$$67DTUMM"$$9:GWXMM"$$89FVWMM"#MM"$$>?LabMM"$$>?LabMM"$$>?LabMM"$$;<I^_MM"$$9:G\]MM"$$78EZ[MM"$$45BWXMM"$$45BWXMM"$$=>K`aMM"$$;<I^_MM"$$<=J_`MM"$$BCPefMM"$$?@MbcMM"$$@ANcdMM"$$=>K`aMM"$$=>K`aMM"$$;<I^_MM"$$>?LabMM"$$=>K`aMM'(r}   )__doc__alembicr   
sqlalchemyrl   revisiondown_revisionbranch_labels
depends_onr   r   r|   r}   r~   <module>r      s5      
O[f;)r}   