
    <E}f!                     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)zhstaff_control

Revision ID: f0f802302606
Revises: 4b51cd621a47
Create Date: 2024-06-25 19:48:00.616341

    )opNf0f8023026064b51cd621a47c                     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                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd
gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d       d!dgd       t        j                  t        j                  d"      d#dgd       t        j                  t        j                  d$      d%dgd       t        j                  t        j                  d&      d'dgd       t        j                  t        j                  d(      d)dgd       t        j                  t        j                  d*      d+dgd       t        j                  t        j                  d,      d-dgd       t        j                  t        j                  d.      d/dgd       t        j                  t        j                  d0      d1dgd       t        j                  t        j                  d2      d3dgd       t        j                  t        j                  d4      d5dgd       t        j                  t        j                  d6      d7dgd       t        j                  d8t        j                  d9t        j                         dd:;             t        j                  d8t        j                  d<t        j                  d	=      d	             t        j                  t        j                  d>      d?dgd       t        j                  t        j                  d@      dAdgd       t        j                  t        j                  dB      dCdgd       t        j                  t        j                  dD      dEdgd       t        j                  t        j                  dF      dGdgd       t        j                  t        j                  dH      dIdgd       t        j                  t        j                  dJ      dKdgd       t        j                  t        j                  dL      dMdgd       t        j                  t        j                  dN      dOdgd       t        j                  t        j                  dP      dQdgd       t        j                  t        j                  dR      dSdgd       t        j                  t        j                  dT      dUdgd       t        j                  t        j                  dV      dWdgd       t        j                  t        j                  dX      dYdgd       t        j                  t        j                  dZ      d[dgd       t        j                  t        j                  d\      d]dgd       y )^N&cmf_person_staff_control_blocked_tasksid   )lengthF)nullable	parent_id@   Troot_iddescriptioni   left_idright_idleft_name_cache   right_name_cache1ix_cmf_person_staff_control_blocked_tasks_left_id)unique3ix_cmf_person_staff_control_blocked_tasks_parent_id2ix_cmf_person_staff_control_blocked_tasks_right_id1ix_cmf_person_staff_control_blocked_tasks_root_idix_cmf_asset_deadline	cmf_assetdeadlineix_cmf_chat_group_deadlinecmf_chat_groupix_cmf_chat_topic_deadlinecmf_chat_topicix_cmf_company_deadlinecmf_companyix_cmf_component_deadlinecmf_componentix_cmf_dashboard_deadlinecmf_dashboardix_cmf_deal_deadlinecmf_dealix_cmf_document_deadlinecmf_documentix_cmf_folder_deadline
cmf_folderix_cmf_import_deadline
cmf_importix_cmf_invoice_deadlinecmf_invoiceix_cmf_kanban_board_deadlinecmf_kanban_boardix_cmf_lead_deadlinecmf_leadix_cmf_list_deadlinecmf_listix_cmf_mail_handler_deadlinecmf_mail_handlerix_cmf_payment_deadlinecmf_payment
cmf_personno_staff_control_todayfalse)r   server_defaultstaff_control_blocked_date)timezoneix_cmf_pipeline_deadlinecmf_pipelineix_cmf_project_deadlinecmf_projectix_cmf_purchase_order_deadlinecmf_purchase_order$ix_cmf_purchase_order_items_deadlinecmf_purchase_order_itemsix_cmf_roadmap_deadlinecmf_roadmapix_cmf_scheme_wf_deadlinecmf_scheme_wf$ix_cmf_stock_incoming_order_deadlinecmf_stock_incoming_orderix_cmf_stock_initial_deadlinecmf_stock_initialix_cmf_stock_inventory_deadlinecmf_stock_inventoryix_cmf_stock_move_deadlinecmf_stock_move%ix_cmf_stock_outcoming_order_deadlinecmf_stock_outcoming_orderix_cmf_task_deadlinecmf_taskix_cmf_task_filter_deadlinecmf_task_filterix_cmf_task_queue_deadlinecmf_task_queueix_cmf_task_report_deadlinecmf_task_reportix_cmf_u_work_post_deadlinecmf_u_work_post)r   create_tablesaColumnStringPrimaryKeyConstraintcreate_indexf
add_columnBoolean	TIMESTAMP     ;/opt/eva-app/alembic/versions/f0f802302606_staff_control.pyupgradern      s   OO<IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDLMOw  {D  zE  NS  TOOBDDNOQy  }H  |I  RW  XOOBDDMNPx  |F  {G  PU  VOOBDDLMOw  {D  zE  NS  TOOBDD01;UZ[OOBDD568H:,_deOOBDD568H:,_deOOBDD23]ZLY^_OOBDD45]bcOOBDD45]bcOOBDD/0*zlSXYOOBDD34nzl[`aOOBDD12L:,W\]OOBDD12L:,W\]OOBDD23]ZLY^_OOBDD78:LzlchiOOBDD/0*zlSXYOOBDD/0*zlSXYOOBDD78:LzlchiOOBDD23]ZLY^_MM,		*BBJJL[`qx yzMM,		*F^bHcnr stOOBDD34nzl[`aOOBDD23]ZLY^_OOBDD9:<PS]R^glmOOBDD?@B\_i^jsxyOOBDD23]ZLY^_OOBDD45]bcOOBDD?@B\_i^jsxyOOBDD89;NQ[P\ejkOOBDD:;=RU_T`inoOOBDD568H:,_deOOBDD@AC^ak`luz{OOBDD/0*zlSXYOOBDD679JZLafgOOBDD568H:,_deOOBDD679JZLafgOOBDD679JZLafgrl   c                  V   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"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/      d0       t        j                  t        j                  d1      d2       t        j                  t        j                  d3      d4       t        j                  t        j                  d5      d6       t        j                  t        j                  d7      d8       t        j                  t        j                  d9      d:       t        j                  t        j                  d;      d<       t        j                  t        j                  d=      d>       t        j                  t        j                  d?      d@       t        j                  t        j                  dA      dB       t        j                  t        j                  dC      dD       t        j                  t        j                  dE      dF       t        j                  t        j                  dG      dF       t        j                  t        j                  dH      dF       t        j                  t        j                  dI      dF       t        j                  dF       y )JNr_   r`   )
table_namer]   r^   r[   r\   rY   rZ   rW   rX   rU   rV   rS   rT   rQ   rR   rO   rP   rM   rN   rK   rL   rI   rJ   rG   rH   rE   rF   rC   rD   rA   rB   r;   r?   r<   r9   r:   r7   r8   r5   r6   r3   r4   r1   r2   r/   r0   r-   r.   r+   r,   r)   r*   r'   r(   r%   r&   r#   r$   r!   r"   r   r    r   r   r   r   r   r   r   r   r   )r   
drop_indexrg   drop_column
drop_tablerk   rl   rm   	downgradert   I   s   MM"$$45BSTMM"$$45BSTMM"$$34AQRMM"$$45BSTMM"$$-.:FMM"$$>?LghMM"$$34AQRMM"$$89F[\MM"$$67DWXMM"$$=>KefMM"$$23PMM"$$01mLMM"$$=>KefMM"$$78EYZMM"$$01mLMM"$$12~NNN<!=>NN<!9:MM"$$01mLMM"$$56CUVMM"$$-.:FMM"$$-.:FMM"$$56CUVMM"$$01mLMM"$$/0\JMM"$$/0\JMM"$$12~NMM"$$-.:FMM"$$23PMM"$$23PMM"$$01mLMM"$$34AQRMM"$$34AQRMM"$$./KHMM"$$JK  YA  BMM"$$KL  ZB  CMM"$$LM  [C  DMM"$$JK  YA  BMM:;rl   )__doc__alembicr   
sqlalchemyrb   revisiondown_revisionbranch_labels
depends_onrn   rt   rk   rl   rm   <module>r|      s4      
2hl(<rl   