
    <g:                     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)zremailloops_createfields

Revision ID: 1202da379e84
Revises: 4884b3c90d9e
Create Date: 2024-09-04 12:40:01.817750

    )opN1202da379e844884b3c90d9ec            	      R+   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                  d0t        j                  d      d      t        j                  d1t        j                  d      d      t        j                  d,gd2g      t        j                  d)gd3g      t        j                  d0gd4g      t        j                  d/gd3g      t        j                  d        t        j                  t        j                  d5      dd'gd6       t        j                  t        j                  d7      dd
gd6       t        j                  t        j                  d8      ddgd6       t        j                  t        j                  d9      dd,gd6       t        j                  t        j                  d:      ddgd6       t        j                  t        j                  d;      dd+gd6       t        j                  t        j                  d<      ddgd6       t        j                  t        j                  d=      dd*gd6       t        j                  t        j                  d>      dd(gd6       t        j                  t        j                  d?      ddgd6       t        j                  t        j                  d@      ddgd6       t        j                  t        j                  dA      ddgd6       t        j                  t        j                  dB      ddgd6       t        j                  t        j                  dC      ddgd6       t        j                  t        j                  dD      dd)gd6       t        j                  t        j                  dE      dd0gd6       t        j                  t        j                  dF      dd1gd6       t        j                  t        j                  dG      dd/gd6       t        j                  t        j                  dH      dd.gd6       t        j                  t        j                  dI      dd-gd6       t        j                  g dJ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                  d0t        j                  d      d      t        j                  d1t        j                  d      d      t        j                  d,gd2g      t        j                  d)gdKg      t        j                  d0gd4g      t        j                  d/gd3g      t        j                  d        t        j                  t        j                  dL      dJd'gd6       t        j                  t        j                  dM      dJd
gd6       t        j                  t        j                  dN      dJdgd6       t        j                  t        j                  dO      dJd,gd6       t        j                  t        j                  dP      dJdgd6       t        j                  t        j                  dQ      dJd+gd6       t        j                  t        j                  dR      dJdgd6       t        j                  t        j                  dS      dJd*gd6       t        j                  t        j                  dT      dJd(gd6       t        j                  t        j                  dU      dJdgd6       t        j                  t        j                  dV      dJdgd6       t        j                  t        j                  dW      dJdgd6       t        j                  t        j                  dX      dJdgd6       t        j                  t        j                  dY      dJdgd6       t        j                  t        j                  dZ      dJd)gd6       t        j                  t        j                  d[      dJd0gd6       t        j                  t        j                  d\      dJd1gd6       t        j                  t        j                  d]      dJd/gd6       t        j                  t        j                  d^      dJd.gd6       t        j                  t        j                  d_      dJd-gd6       t        j                  d`t        j                  dat        j                         ddbc             y )dNcmf_email_list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type    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
project_idperm_acl_idperm_parent_idzcmf_import.idzcmf_project.idzcmf_access_list.idix_cmf_email_list_cmf_author_id)unique ix_cmf_email_list_cmf_created_atix_cmf_email_list_cmf_deletedix_cmf_email_list_cmf_import_idix_cmf_email_list_cmf_locked_at"ix_cmf_email_list_cmf_locked_by_id!ix_cmf_email_list_cmf_modified_at$ix_cmf_email_list_cmf_modified_by_idix_cmf_email_list_cmf_owner_idix_cmf_email_list_cmf_versionix_cmf_email_list_cmf_viewed_atix_cmf_email_list_codeix_cmf_email_list_nameix_cmf_email_list_ordernoix_cmf_email_list_parent_idix_cmf_email_list_perm_acl_id ix_cmf_email_list_perm_parent_idix_cmf_email_list_project_id ix_cmf_email_list_root_parent_id ix_cmf_email_list_tree_parent_idcmf_email_list_itemzcmf_email_list.id$ix_cmf_email_list_item_cmf_author_id%ix_cmf_email_list_item_cmf_created_at"ix_cmf_email_list_item_cmf_deleted$ix_cmf_email_list_item_cmf_import_id$ix_cmf_email_list_item_cmf_locked_at'ix_cmf_email_list_item_cmf_locked_by_id&ix_cmf_email_list_item_cmf_modified_at)ix_cmf_email_list_item_cmf_modified_by_id#ix_cmf_email_list_item_cmf_owner_id"ix_cmf_email_list_item_cmf_version$ix_cmf_email_list_item_cmf_viewed_atix_cmf_email_list_item_codeix_cmf_email_list_item_nameix_cmf_email_list_item_orderno ix_cmf_email_list_item_parent_id"ix_cmf_email_list_item_perm_acl_id%ix_cmf_email_list_item_perm_parent_id!ix_cmf_email_list_item_project_id%ix_cmf_email_list_item_root_parent_id%ix_cmf_email_list_item_tree_parent_idcmf_global_settingsemail_loop_detector_threshold0)r   server_default)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerForeignKeyConstraintPrimaryKeyConstraintcreate_indexf
add_column     E/opt/eva-app/alembic/versions/1202da379e84_emailloops_createfields.pyupgraderu      s   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\E:!." II

u=#.$ II#RZZ\EB%.& IImRZZ\E:'.( IIi5).* IImRZZ\E:+., IInbjjlU;-.. IInbjjlU;/.0 II$biir&:TJ1.2 II#RYYb%9DI3.4 II%ryy';dK5.6 II5rwwy4P7.8 IInbjjlU;9.: IIfbiir*U;;.< IIoryy3dC=.> IInbiir2TB?.@ IIk299B/$?A.B II"BIIR$84HC.D II "))2"6FE.F IIoryy3dCG.H II		 4tDI.J II		 4tDK.L IIlBIIR04@M.N IImRYYb1DAO.P II		 4tDQ.R _-/@CS.T [M,<+=@U.V ]O.B-CFW.X \N-=,>AY.Z D![.^ 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78:J\NchiOOBDD;<>NQaPbkpqOOBDD;<>NQaPbkpq 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\E:!-" II

u=#-$ II#RZZ\EB%-& IImRZZ\E:'-( IIi5)-* IImRZZ\E:+-, IInbjjlU;--. IInbjjlU;/-0 II$biir&:TJ1-2 II#RYYb%9DI3-4 II%ryy';dK5-6 II5rwwy4P7-8 IInbjjlU;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 IIlBIIR04@K-L IImRYYb1DAM-N II		 4tDO-P _-/@CQ-R [M,?+@CS-T ]O.B-CFU-V \N-=,>AW-X D!Y-\ 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<=?TWcVdmrsOOBDD@ACX[kZluz{OOBDD@ACX[kZluz{MM'3RTVT^T^T`kp  BE  *F  Grs   c                     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                  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                  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       y ).Nr`   ra   r_   rK   )
table_namer^   r]   r\   r[   rZ   rY   rX   rW   rV   rU   rT   rS   rR   rQ   rP   rO   rN   rM   rL   rJ   r   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r<   r;   r:   r9   r8   r6   )r   drop_column
drop_indexrp   
drop_tablerr   rs   rt   	downgrader{      s   NN(*IJMM"$$>?LabMM"$$>?LabMM"$$:;H]^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'(MM"$$9:GWXMM"$$9:GWXMM"$$56CST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"#rs   )__doc__alembicr   
sqlalchemyre   revisiondown_revisionbranch_labels
depends_onru   r{   rr   rs   rt   <module>r      s5      
JG\,$rs   