
    eG                     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)zlresource_planning

Revision ID: 6268b1c272ab
Revises: f652366031d7
Create Date: 2024-01-22 12:44:43.337993

    )opN6268b1c272abf652366031d7c            	      d1   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      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                  d0t        j                  d      d      t        j                  d1t        j                  d      d      t        j                  d2t        j                  d      d      t        j                  d3t        j                  d      d      t        j                  d4t        j                  d      d      t        j                  d5t        j                  d      d      t        j                  d6t        j                  d      d      t        j                  d6gd7g      t        j                  d/gd8g      t        j                  d,gd9g      t        j                  d2gd:g      t        j                  d4gd;g      t        j                  d5gd<g      t        j                  d        t        j                  t        j                  d=      dd6gd>       t        j                  t        j                  d?      dd*gd>       t        j                  t        j                  d@      dd
gd>       t        j                  t        j                  dA      ddgd>       t        j                  t        j                  dB      dd/gd>       t        j                  t        j                  dC      ddgd>       t        j                  t        j                  dD      dd.gd>       t        j                  t        j                  dE      ddgd>       t        j                  t        j                  dF      dd-gd>       t        j                  t        j                  dG      dd+gd>       t        j                  t        j                  dH      ddgd>       t        j                  t        j                  dI      ddgd>       t        j                  t        j                  dJ      ddgd>       t        j                  t        j                  dK      ddgd>       t        j                  t        j                  dL      ddgd>       t        j                  t        j                  dM      dd,gd>       t        j                  t        j                  dN      dd2gd>       t        j                  t        j                  dO      dd3gd>       t        j                  t        j                  dP      dd4gd>       t        j                  t        j                  dQ      dd5gd>       t        j                  t        j                  dR      dd1gd>       t        j                  t        j                  dS      dd0gd>       t        j                  g dT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                  dUt        j                         d      t        j                  dVt        j                         d      t        j                  dWt        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                  d0t        j                  d      d      t        j                  d1t        j                  d      d      t        j                  d2t        j                  d      d      t        j                  d3t        j                  d      d      t        j                  d4t        j                  d      d      t        j                  d5t        j                  d      d      t        j                  dXt        j                  d      d      t        j                  d/gd8g      t        j                  d,gd9g      t        j                  d2gd:g      t        j                  d4gd;g      t        j                  dXgdYg      t        j                  d5gd<g      t        j                  d        t        j                  t        j                  dZ      dTd*gd>       t        j                  t        j                  d[      dTd
gd>       t        j                  t        j                  d\      dTdgd>       t        j                  t        j                  d]      dTd/gd>       t        j                  t        j                  d^      dTdgd>       t        j                  t        j                  d_      dTd.gd>       t        j                  t        j                  d`      dTdgd>       t        j                  t        j                  da      dTd-gd>       t        j                  t        j                  db      dTd+gd>       t        j                  t        j                  dc      dTdgd>       t        j                  t        j                  dd      dTdgd>       t        j                  t        j                  de      dTdgd>       t        j                  t        j                  df      dTdgd>       t        j                  t        j                  dg      dTdgd>       t        j                  t        j                  dh      dTd,gd>       t        j                  t        j                  di      dTd2gd>       t        j                  t        j                  dj      dTd3gd>       t        j                  t        j                  dk      dTd4gd>       t        j                  t        j                  dl      dTdXgd>       t        j                  t        j                  dm      dTd5gd>       t        j                  t        j                  dn      dTd1gd>       t        j                  t        j                  do      dTd0gd>       t        j                  dpt        j                  d6t        j                  d      d             t        j                  t        j                  dq      dpd6gd>       t        j                   d dpdrd6gdg       y )sNcmf_task_res_assign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work_contour    units
date_startdate_end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_idresource_idcalendar_idzcmf_calendar.idzcmf_import.idzcmf_task.idzcmf_access_list.idzcmf_person.idzcmf_timesheets_team_member.id"ix_cmf_task_res_assign_calendar_id)unique$ix_cmf_task_res_assign_cmf_author_id%ix_cmf_task_res_assign_cmf_created_at"ix_cmf_task_res_assign_cmf_deleted$ix_cmf_task_res_assign_cmf_import_id$ix_cmf_task_res_assign_cmf_locked_at'ix_cmf_task_res_assign_cmf_locked_by_id&ix_cmf_task_res_assign_cmf_modified_at)ix_cmf_task_res_assign_cmf_modified_by_id#ix_cmf_task_res_assign_cmf_owner_id"ix_cmf_task_res_assign_cmf_version$ix_cmf_task_res_assign_cmf_viewed_atix_cmf_task_res_assign_codeix_cmf_task_res_assign_nameix_cmf_task_res_assign_orderno ix_cmf_task_res_assign_parent_id"ix_cmf_task_res_assign_perm_acl_id%ix_cmf_task_res_assign_perm_parent_id ix_cmf_task_res_assign_person_id"ix_cmf_task_res_assign_resource_id%ix_cmf_task_res_assign_root_parent_id%ix_cmf_task_res_assign_tree_parent_idcmf_task_res_assign_timephasedate
sched_workactual_workresource_assignment_idzcmf_task_res_assign.id.ix_cmf_task_res_assign_timephase_cmf_author_id/ix_cmf_task_res_assign_timephase_cmf_created_at,ix_cmf_task_res_assign_timephase_cmf_deleted.ix_cmf_task_res_assign_timephase_cmf_import_id.ix_cmf_task_res_assign_timephase_cmf_locked_at1ix_cmf_task_res_assign_timephase_cmf_locked_by_id0ix_cmf_task_res_assign_timephase_cmf_modified_at3ix_cmf_task_res_assign_timephase_cmf_modified_by_id-ix_cmf_task_res_assign_timephase_cmf_owner_id,ix_cmf_task_res_assign_timephase_cmf_version.ix_cmf_task_res_assign_timephase_cmf_viewed_at%ix_cmf_task_res_assign_timephase_code%ix_cmf_task_res_assign_timephase_name(ix_cmf_task_res_assign_timephase_orderno*ix_cmf_task_res_assign_timephase_parent_id,ix_cmf_task_res_assign_timephase_perm_acl_id/ix_cmf_task_res_assign_timephase_perm_parent_id*ix_cmf_task_res_assign_timephase_person_id7ix_cmf_task_res_assign_timephase_resource_assignment_id,ix_cmf_task_res_assign_timephase_resource_id/ix_cmf_task_res_assign_timephase_root_parent_id/ix_cmf_task_res_assign_timephase_tree_parent_id
cmf_personix_cmf_person_calendar_idcmf_calendar)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTTEXTIntegerDATEForeignKeyConstraintPrimaryKeyConstraintcreate_indexf
add_columncreate_foreign_key     ?/opt/eva-app/alembic/versions/6268b1c272ab_resource_planning.pyupgrader      s   OO 5) 5IIdBIIR(595IIor||T:TJ5 IId ;eL5 IIt!<uM	5
 IIor||T:TJ5 IImRZZ\E:5 IImRYY[485 IIfbiis+d;5 IIfbiir*T:5 IIh

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

t<#5$ II#RZZ\DA%5& IImRZZ\D9'5( IIi5)5* IImRZZ\D9+5, IInbjjlT:-5. IInbjjlT:/50 II$biir&:TJ152 II#RYYb%9DI354 II%ryy';dK556 II5rwwy4P758 IInbjjlT:95: IInbiir2UC;5< IIgrzz|e4=5> IIlBGGI6?5@ IIj"'')e4A5B IIoryy3dCC5D IInbiir2TBE5F IIk299B/%@G5H II"BIIR$84HI5J II "))2"6FK5L IIoryy3dCM5N II		 4tDO5P II		 4tDQ5R IImRYYb1DAS5T II		 4tDU5V IIk299B/$?W5X IImRYYb1DAY5Z IImRYYb1EB[5\ ]O.?-@C]5^ _-/@C_5` [MM?=a5b ]O.B-CFc5d [MO+<?e5f ]O.M-NQg5h D!i5l OOBDD=>@UXeWfotu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;<>SVaUbkpqOOBDD=>@UXeWfotuOOBDD@ACX[kZluz{OOBDD@ACX[kZluz{OO 43 4IIdBIIR(594IIor||T:TJ4 IId ;eL4 IIt!<uM	4
 IIor||T:TJ4 IImRZZ\E:4 IImRYY[484 IIfbiis+d;4 IIfbiir*T:4 IIh

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

t<#4$ II#RZZ\DA%4& IImRZZ\D9'4( IIi5)4* IImRZZ\D9+4, IInbjjlT:-4. IInbjjlT:/40 II$biir&:TJ142 II#RYYb%9DI344 II%ryy';dK546 II5rwwy4P748 IInbjjlT:94: IIfbggi%0;4< IIlBJJL59=4> IImRZZ\E:?4@ IIoryy3dCA4B IInbiir2TBC4D IIk299B/%@E4F II"BIIR$84HG4H II "))2"6FI4J IIoryy3dCK4L II		 4tDM4N II		 4tDO4P IImRYYb1DAQ4R II		 4tDS4T IIk299B/$?U4V IImRYYb1DAW4X II&		(<uMY4Z _-/@C[4\ [MM?=]4^ ]O.B-CF_4` [MO+<?a4b 569Q8RUc4d ]O.M-NQe4f D!g4j OOBDDIJLkn}m~  HM  NOOBDDJKMlo  oA  JO  POOBDDGHJilykz  DI  JOOBDDIJLkn}m~  HM  NOOBDDIJLkn}m~  HM  NOOBDDLMOn  rD  qE  NS  TOOBDDKLNm  qB  pC  LQ  ROOBDDNOQp  tH  sI  RW  XOOBDDHIKjm{l|  FK  LOOBDDGHJilykz  DI  JOOBDDIJLkn}m~  HM  NOOBDD@ACbekdluyzOOBDD@ACbekdluz{OOBDDCDFehqgr  |A  BOOBDDEFHgjuiv  @E  FOOBDDGHJilykz  DI  JOOBDDJKMlo  oA  JO  POOBDDEFHgjuiv  @E  FOOBDDRSUt  xP  wQ  Z_  `OOBDDGHJilykz  DI  JOOBDDJKMlo  oA  JO  POOBDDJKMlo  oA  JO  PMM,		-"9MX\ ]^OOBDD45|m_]bc$n}oPTvVr   c                  x   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                  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                  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
                  d       y )5Nrm   
foreignkey)type_rn   )
table_namer:   rl   rR   rk   rj   ri   rh   rg   rf   re   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rZ   rY   rX   rW   rQ   r   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   rA   r@   r?   r>   r=   r;   )r   drop_constraint
drop_indexr}   drop_column
drop_tabler   r   r   	downgrader      s   t\>MM"$$23MNN</MM"$$HIVuvMM"$$HIVuvMM"$$EFSrsMM"$$PQ^}~MM"$$CDQpqMM"$$HIVuvMM"$$EFSrsMM"$$CDQpqMM"$$ABOnoMM"$$>?LklMM"$$>?LklMM"$$GHUtuMM"$$EFSrsMM"$$FGTstMM"$$LMZyzMM"$$IJWvwMM"$$JKXwxMM"$$GHUtuMM"$$GHUtuMM"$$EFSrsMM"$$HIVuvMM"$$GHUtuMM12MM"$$>?LabMM"$$>?LabMM"$$;<I^_MM"$$9:G\]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"$$;<I^_MM'(r   )__doc__alembicr   
sqlalchemyrq   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s5      
[W~2)r   