
    ]dV                     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)zgadd_mailbox2

Revision ID: d35561c630e7
Revises: 6b541ef32465
Create Date: 2023-03-15 08:58:23.255344

    )opNd35561c630e76b541ef32465c                     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      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      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      t        j                  d/t        j
                  d	      d      t        j                  d0t        j                         d      t        j                  d1t        j                         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                  d7t        j                  d      d      t        j                  d8t        j                  d      d      t        j                  d9t        j                  d      d      t        j                  d:t        j                  d      d      t        j                  d;t        j                  d      d      t        j                  d7gd<g      t        j                  d:gd=g      t        j                  d        t        j                  t        j                  d>      dd2g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d7gd?       t        j                  t        j                  dC      ddgd?       t        j                  t        j                  dD      dd6gd?       t        j                  t        j                  dE      ddgd?       t        j                  t        j                  dF      dd5gd?       t        j                  t        j                  dG      dd3g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d4gd?       t        j                  t        j                  dN      dd:gd?       t        j                  t        j                  dO      dd;gd?       t        j                  t        j                  dP      dd9gd?       t        j                  t        j                  dQ      dd8gd?       t        j                  dRt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d[      dRdWgd?       t        j                  t        j                  d\      dRd4gd?       t        j                  t        j                  d]      dRdXgd?       t        j                  t        j                  d^      dRdTgd?       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      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      d      t        j                  dat        j                         d      t        j                  d/t        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                  d7t        j                  d      d      t        j                  d8t        j                  d      d      t        j                  d9t        j                  d      d      t        j                  d:t        j                  d      d      t        j                  d;t        j                  d      d      t        j                  d7gd<g      t        j                  d4gdbg      t        j                  d:gd=g      t        j                  d        t        j                  t        j                  dc      d_d2g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_d7gd?       t        j                  t        j                  dg      d_dgd?       t        j                  t        j                  dh      d_d6gd?       t        j                  t        j                  di      d_dgd?       t        j                  t        j                  dj      d_d5gd?       t        j                  t        j                  dk      d_d3g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_dgd?       t        j                  t        j                  do      d_dgd?       t        j                  t        j                  dp      d_d`gd?       t        j                  t        j                  dq      d_dgd?       t        j                  t        j                  dr      d_d4gd?       t        j                  t        j                  ds      d_d:gd?       t        j                  t        j                  dt      d_d;gd?       t        j                  t        j                  du      d_d9gd?       t        j                  t        j                  dv      d_d8gd?       t        j                  dwt        j                  dxt        j                  d      d             t        j                  dwt        j                  dyt        j                  d      d             t        j                  dwt        j                  dzt        j                  d      d             t        j                  dwt        j                  d{t        j                         d             t        j                  dwt        j                  d|t        j                         dd}~             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                  d      d             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                         d             t        j                  dwt        j                  dt        j                  d      d             t        j                  dwt        j                  dt        j                  d      d             t        j                  dwt        j                  dt        j                  d      d             t        j                  t        j                  d      dwdgd?       t        j                  t        j                  d      dwdgd?       t        j                  t        j                  d      dwdgd?       t        j                  t        j                  d      dwdgd?       t        j                   d dwdwdgdg       t        j                   d dwd_dgdg       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      d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d(      d      t        j                  dt        j                         d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d(      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                  d(      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d(      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d(      d      t        j                  dt        j                  d(      d      t        j                  dt        j                  d(      d      t        j                  dt        j                  d(      d      t        j                  dt        j                  d(      d      t        j                  dt        j                  d(      d      t        j                  dt        j                         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                  d7t        j                  d      d      t        j                  d8t        j                  d      d      t        j                  d9t        j                  d      d      t        j                  d:t        j                  d      d      t        j                  d;t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dgdg      t        j                  dgdg      t        j                  d7gd<g      t        j                  dgdg      t        j                  dgdg      t        j                  dgdg      t        j                  dgdbg      t        j                  dgdg      t        j                  dgdg      t        j                  d4gdg      t        j                  d:gd=g      t        j                  dgdg      t        j                  dgdg      t        j                  dgdg      t        j                  d        t        j                  t        j                  dƫ      ddgd?       t        j                  t        j                  dǫ      ddgd?       t        j                  t        j                  dȫ      ddgd?       t        j                  t        j                  dɫ      ddgd?       t        j                  t        j                  dʫ      ddgd?       t        j                  t        j                  d˫      ddgd?       t        j                  t        j                  d̫      dd2gd?       t        j                  t        j                  dͫ      dd
gd?       t        j                  t        j                  dΫ      ddgd?       t        j                  t        j                  dϫ      dd7gd?       t        j                  t        j                  dЫ      ddgd?       t        j                  t        j                  dѫ      dd6gd?       t        j                  t        j                  dҫ      ddgd?       t        j                  t        j                  dӫ      dd5gd?       t        j                  t        j                  dԫ      ddgd?       t        j                  t        j                  dի      dd3gd?       t        j                  t        j                  d֫      ddgd?       t        j                  t        j                  d׫      ddgd?       t        j                  t        j                  dث      ddgd?       t        j                  t        j                  d٫      ddgd?       t        j                  t        j                  dګ      ddgd?       t        j                  t        j                  d۫      ddgd?       t        j                  t        j                  dܫ      ddgd?       t        j                  t        j                  dݫ      ddgd?       t        j                  t        j                  dޫ      ddgd?       t        j                  t        j                  d߫      ddgd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      dd:gd?       t        j                  t        j                  d      dd;gd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      dd9gd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      dd8gd?       t        j                  t        j                  d      ddgd?       t        j                  t        j                  d      ddgd?       t        j                  dt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  dWgdg      t        j                  dXgdg      t        j                  d             t        j                  t        j                  d      ddWgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddXgd?       t        j                  t        j                  d      ddTgd?       t        j                  dt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddWgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddXgd?       t        j                  t        j                  d      ddTgd?       t        j                  dt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddWgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddXgd?       t        j                  t        j                  d      ddTgd?       t        j                  dt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d       ddWgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddXgd?       t        j                  t        j                  d      ddTgd?       t        j                  dt        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddWgd?       t        j                  t        j                  d      dd4gd?       t        j                  t        j                  d      ddXgd?       t        j                  t        j                  d      ddTgd?       t        j                  d	t        j                  dt        j                  dS      d      t        j                  d4t        j                  d      d      t        j                  dTt        j                  d      d      t        j                  dUt        j                  dV      d      t        j                  dWt        j                  d      d      t        j                  dXt        j                  d      d      t        j                  dYt        j                  d      d      t        j                  dZt        j                  d      d      t        j                  d      
       t        j                  t        j                  d
      d	dWgd?       t        j                  t        j                  d      d	d4gd?       t        j                  t        j                  d      d	dXgd?       t        j                  t        j                  d      d	dTgd?       y (  Ncmf_mailbox2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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_encryptemailloginpasswordimap_server	imap_port    
imap_cryptsmtp_server	smtp_port
smtp_cryptmaildir_pathload_from_date	last_syncsync_intervalsync_error_log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_mailbox2_cmf_author_id)uniqueix_cmf_mailbox2_cmf_created_atix_cmf_mailbox2_cmf_deletedix_cmf_mailbox2_cmf_import_idix_cmf_mailbox2_cmf_locked_at ix_cmf_mailbox2_cmf_locked_by_idix_cmf_mailbox2_cmf_modified_at"ix_cmf_mailbox2_cmf_modified_by_idix_cmf_mailbox2_cmf_owner_idix_cmf_mailbox2_cmf_versionix_cmf_mailbox2_cmf_viewed_atix_cmf_mailbox2_codeix_cmf_mailbox2_nameix_cmf_mailbox2_ordernoix_cmf_mailbox2_parent_idix_cmf_mailbox2_perm_acl_idix_cmf_mailbox2_perm_parent_idix_cmf_mailbox2_root_parent_idix_cmf_mailbox2_tree_parent_idcmf_mailbox2_executors   root_iddescriptioni   left_idright_idleft_name_cacheright_name_cache!ix_cmf_mailbox2_executors_left_id#ix_cmf_mailbox2_executors_parent_id"ix_cmf_mailbox2_executors_right_id!ix_cmf_mailbox2_executors_root_idcmf_mailbox_foldername_rawdisabledzcmf_mailbox2.id#ix_cmf_mailbox_folder_cmf_author_id$ix_cmf_mailbox_folder_cmf_created_at!ix_cmf_mailbox_folder_cmf_deleted#ix_cmf_mailbox_folder_cmf_import_id#ix_cmf_mailbox_folder_cmf_locked_at&ix_cmf_mailbox_folder_cmf_locked_by_id%ix_cmf_mailbox_folder_cmf_modified_at(ix_cmf_mailbox_folder_cmf_modified_by_id"ix_cmf_mailbox_folder_cmf_owner_id!ix_cmf_mailbox_folder_cmf_version#ix_cmf_mailbox_folder_cmf_viewed_atix_cmf_mailbox_folder_codeix_cmf_mailbox_folder_nameix_cmf_mailbox_folder_name_rawix_cmf_mailbox_folder_ordernoix_cmf_mailbox_folder_parent_id!ix_cmf_mailbox_folder_perm_acl_id$ix_cmf_mailbox_folder_perm_parent_id$ix_cmf_mailbox_folder_root_parent_id$ix_cmf_mailbox_folder_tree_parent_idcmf_mail	mail_frommail_from_namemail_tomail_to_json	is_readedfalse)r   server_default	text_htmltext_searchmail_headersimap_uid
message_idin_reply_to_rawreferences_rawmailbox_folder_idin_reply_to_idhandle_obj_idix_cmf_mail_handle_obj_idix_cmf_mail_in_reply_to_idix_cmf_mail_mailbox_folder_idix_cmf_mail_message_idcmf_mail_handler	is_publicis_public_editableis_public_commentslogic_prefixui_view_formparent_logic_prefixstatus_modified_atstatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymark
alarm_datedeadlineplan_start_dateplan_end_dateperiod_next_dateperiod_intervalis_template
is_penaltycache_status_typecache_fieldsapprovedperm_policyperm_policy_guestperm_policy_anonymousperm_policy_sharelinksharelink_hashhandler_typecreate_userworkflow_iddefault_task_workflow_idlogic_type_idscheme_wf_idcmf_owner_assistant_id	status_id
company_idresponsible_idwaiting_for_idcloned_from_idactivity_idcache_status_opt_id
mailbox_idobj_logic_type_idobj_author_idzcmf_activity.idzcmf_status_opt.idzcmf_company.idzcmf_workflow.idzcmf_logic_type.idzcmf_person.idzcmf_project.idzcmf_scheme_wf.idzcmf_status.idix_cmf_mail_handler_activity_idix_cmf_mail_handler_alarm_dateix_cmf_mail_handler_approved'ix_cmf_mail_handler_cache_status_opt_id%ix_cmf_mail_handler_cache_status_type"ix_cmf_mail_handler_cloned_from_id!ix_cmf_mail_handler_cmf_author_id"ix_cmf_mail_handler_cmf_created_atix_cmf_mail_handler_cmf_deleted!ix_cmf_mail_handler_cmf_import_id!ix_cmf_mail_handler_cmf_locked_at$ix_cmf_mail_handler_cmf_locked_by_id#ix_cmf_mail_handler_cmf_modified_at&ix_cmf_mail_handler_cmf_modified_by_id*ix_cmf_mail_handler_cmf_owner_assistant_id ix_cmf_mail_handler_cmf_owner_idix_cmf_mail_handler_cmf_version!ix_cmf_mail_handler_cmf_viewed_atix_cmf_mail_handler_codeix_cmf_mail_handler_company_id,ix_cmf_mail_handler_default_task_workflow_idix_cmf_mail_handler_is_template ix_cmf_mail_handler_logic_prefix!ix_cmf_mail_handler_logic_type_idix_cmf_mail_handler_mailbox_idix_cmf_mail_handler_name!ix_cmf_mail_handler_obj_author_id%ix_cmf_mail_handler_obj_logic_type_idix_cmf_mail_handler_ordernoix_cmf_mail_handler_parent_id'ix_cmf_mail_handler_parent_logic_prefixix_cmf_mail_handler_perm_acl_id"ix_cmf_mail_handler_perm_parent_id"ix_cmf_mail_handler_responsible_id"ix_cmf_mail_handler_root_parent_id ix_cmf_mail_handler_scheme_wf_idix_cmf_mail_handler_status_id"ix_cmf_mail_handler_tree_parent_id"ix_cmf_mail_handler_waiting_for_idix_cmf_mail_handler_workflow_id#cmf_mail_handler_cmf_mailbox_folderzcmf_mail_handler.idzcmf_mailbox_folder.id.ix_cmf_mail_handler_cmf_mailbox_folder_left_id0ix_cmf_mail_handler_cmf_mailbox_folder_parent_id/ix_cmf_mail_handler_cmf_mailbox_folder_right_id.ix_cmf_mail_handler_cmf_mailbox_folder_root_id%cmf_mail_handler_cmf_owner_assistants0ix_cmf_mail_handler_cmf_owner_assistants_left_id2ix_cmf_mail_handler_cmf_owner_assistants_parent_id1ix_cmf_mail_handler_cmf_owner_assistants_right_id0ix_cmf_mail_handler_cmf_owner_assistants_root_idcmf_mail_handler_executors%ix_cmf_mail_handler_executors_left_id'ix_cmf_mail_handler_executors_parent_id&ix_cmf_mail_handler_executors_right_id%ix_cmf_mail_handler_executors_root_idcmf_mail_handler_local_links'ix_cmf_mail_handler_local_links_left_id)ix_cmf_mail_handler_local_links_parent_id(ix_cmf_mail_handler_local_links_right_id'ix_cmf_mail_handler_local_links_root_idcmf_mail_handler_spectators&ix_cmf_mail_handler_spectators_left_id(ix_cmf_mail_handler_spectators_parent_id'ix_cmf_mail_handler_spectators_right_id&ix_cmf_mail_handler_spectators_root_idcmf_mail_referencesix_cmf_mail_references_left_id ix_cmf_mail_references_parent_idix_cmf_mail_references_right_idix_cmf_mail_references_root_id)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/d35561c630e7_add_mailbox2.pyupgrader     s0   OO 6N 6IIdBIIR$85I6IIor||T/JUYZ6 II.d0KV[\6 II/t1LW\]	6
 IIor||T/JUYZ6 IImRZZ\EJ6 IImRYY[4H6 IIfbiis&;dK6 IIfbiir&:TJ6 IIh

uE6 IIfbggi$?6 II/M6 II/TJ6 IIh		dC6 IImRZZ\DI6  II.

tL!6" II3RZZ\DQ#6$ IImRZZ\DI%6& IIiE'6( IImRZZ\DI)6* IInbjjlTJ+6, IInbjjlTJ-6. II4biir6JUYZ/60 II3RYYb5ITXY162 II5ryy7KVZ[364 IInbjjlTJ566 IIgryy';dK768 IIgryy';dK96: IIj"))3*?$O;6< IImRYYc-BTR=6> IIk299B+?$O?6@ IIlBIIR,@4PA6B IImRYYc-BTRC6D IIk299B+?$OE6F IIlBIIR,@4PG6H IInbiis.CdSI6J II.	DIK6L IIk2<<+FQUVM6N IIorzz|eLO6P II.	DIQ6R IIoryy/CdSS6T IInbiir.BTRU6V IIk299B+?$OW6X II2BIIR4HSWXY6Z II0"))22FQUV[6\ IIoryy/CdS]6^ II.		0DtT_6` II.		0DtTa6b IImRYYb-ADQc6d II.		0DtTe6f ++_,=?PSg6h ++]O>R=SVi6j ++D1k6n OOBDD89>OK\ejkOOBDD9:NM]L^glmOOBDD67-afgOOBDD89>OK\ejkOOBDD89>OK\ejkOOBDD;<nOaNbkpqOOBDD:;^N_M`inoOOBDD=>QePfotuOOBDD78.>JZchiOOBDD67-afgOOBDD89>OK\ejkOOBDD/0.6(SWXOOBDD/0.6(SXYOOBDD23^i[Y^_OOBDD45~}]bcOOBDD67-afgOOBDD9:NM]L^glmOOBDD9:NM]L^glmOOBDD9:NM]L^glmOO,IIdBIIS$9EJIIk299B+?$OIIi")=MIImRYYd-CdSIIi")=MIIj"))2*>NII/#1FQUVII0"))32GRVW++D1
 OOBDD<=?WZcYdmrsOOBDD>?AY\g[hqvwOOBDD=>@X[eZfotuOOBDD<=?WZcYdmr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, IImRZZ\D9,  II

t<!," II#RZZ\DA#,$ IImRZZ\D9%,& IIi5',( IImRZZ\D9),* IInbjjlT:+,, IInbjjlT:-,. II$biir&:TJ/,0 II#RYYb%9DI1,2 II%ryy';dK3,4 IInbjjlT:5,6 IIj"))3/%@7,8 IIj"**,69,: IIk2<<6F;,< IIoryy3dC=,> IInbiir2TB?,@ IIk299B/$?A,B II"BIIR$84HC,D II "))2"6FE,F IIoryy3dCG,H II		 4uEI,J II		 4tDK,L IImRYYb1DAM,N II		 4tDO,P _-/@CQ,R [M,=+>AS,T ]O.B-CFU,V D!W,Z OOBDD>?AUXgWhqvwOOBDD?@BVYiXjsxyOOBDD<=?SVcUdmrsOOBDD>?AUXgWhqvwOOBDD>?AUXgWhqvwOOBDDABDX[mZnw|}OOBDD@ACWZkYluz{OOBDDCDFZ]q\r  |A  BOOBDD=>@TWeVfotuOOBDD<=?SVcUdmrsOOBDD>?AUXgWhqvwOOBDD568Lvh_cdOOBDD568Lvh_deOOBDD9:<PS]R^glmOOBDD89;OR[Q\ejkOOBDD:;=QT_S`inoOOBDD<=?SVcUdmrsOOBDD?@BVYiXjsxyOOBDD?@BVYiXjsxyOOBDD?@BVYiXjsxyMM*biiRYYc5JUYZ[MM*bii(8"))3:OZ^_`MM*bii	299C3HSWXYMM*bii	DQRMM*biiRZZ\EbijkMM*biiRWWYNOMM*biirwwy4PQMM*bii	DQRMM*bii
BIIS4ITXYZMM*biibggi$OPMM*bii(92779tTUMM*bii(8"'')dSTMM*bii(;RYYb=Q\`abMM*bii(8"))2:NY]^_MM*bii"9MX\]^OOBDD45zOCT]bcOOBDD56
EUDV_deOOBDD89:H[G\ejkOOBDD12JW\]$
J9I8JTFS$
,@CVBWZ^Y_`OO c& cIIdBIIR(59cIIor||T:TJc IId ;eLc IIt!<uM	c
 IIor||T:TJc IImRZZ\E:c IImRYY[48c IIfbiis+d;c IIfbiir*T:c IIh

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

t<!c" II#RZZ\DA#c$ IImRZZ\D9%c& IIi5'c( IImRZZ\D9)c* IInbjjlT:+c, IInbjjlT:-c. II$biir&:TJ/c0 II#RYYb%9DI1c2 II%ryy';dK3c4 IInbjjlT:5c6 IIk2::<$77c8 II"BJJL4@9c: II"BJJL4@;c< IInbiikD9=c> IInbiir2UC?c@ II#RYY[4@AcB II"BLL$$?$OCcD II(",,*EPTUEcF II&d(CdSGcH II ",,"=MIcJ II ",,"=MKcL IIlBJJL48McN IIj"**,7OcP IIfbiir*T:QcR IIlBLL$7$GScT IIj",,5EUcV IIt!<tLWcX IIor||T:TJYcZ II ",,"=M[c\ II"!5E]c^ IImRZZ\D9_c` IIlBJJL48acb II!299B#7$Gccd IInbggi$7ecf IIj"**,7gch IImRYYb1EBicj II!299B#7%Hkcl II%ryy';eLmcn II%ryy';eLocp II		 4tDqcr IInbiir2UCsct IImRZZ\E:ucv IIoryy3dCwcx IInbiir2TBycz IIk299B/%@{c| II"BIIR$84H}c~ II "))2"6Fc@ IIoryy3dCAcB II		 4tDCcD II		 4tDEcF IImRYYb1DAGcH II		 4tDIcJ IImRYYb1DAKcL II("))2*>NMcN IIoryy3dCOcP IInbiir2TBQcR II&		(<tLScT IIk299B/$?UcV IIlBIIR04@WcX II		 4tDYcZ II		 4tD[c\ II		 4tD]c^ IImRYYb1DA_c` II#RYYb%9DIacb IIlBIIR05Accd II!299B#7$Gecf IIoryy3dCgch ]O.?-@Cicj 236I5JMkcl _-/@Cmcn \N-=,>Aocp 78;L:MPqcr _-0C/DGsct \N->,?Bucv _-/@Cwcx 014G3HKycz [M,<+=@{c| ]O.B-CF}c~ ^,/A.BEc@ [MO+<?AcB ]O.?-@CCcD D!EcH OOBDD:;=OR_Q`inoOOBDD9:<NQ]P^glmOOBDD78:LzlchiOOBDDBCEWZoYpy~OOBDD@ACUXkWluz{OOBDD=>@RUeTfotuOOBDD<=?QTcSdmrsOOBDD=>@RUeTfotuOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD<=?QTcSdmrsOOBDD?@BTWiVjsxyOOBDD>?ASVgUhqvwOOBDDABDVYmXnw|}OOBDDEFHZ]u\v  @E  FOOBDD;<>PSaRbkpqOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD346H6([_`OOBDD9:<NQ]P^glmOOBDDGHJ\_y^z  DI  JOOBDD:;=OR_Q`inoOOBDD;<>PSaRbkpqOOBDD<=?QTcSdmrsOOBDD9:<NQ]P^glmOOBDD346H6([`aOOBDD<=?QTcSdmrsOOBDD@ACUXkWluz{OOBDD679Ki[afgOOBDD89;MP[}ejkOOBDDBCEWZoYpy~OOBDD:;=OR_Q`inoOOBDD=>@RUeTfotuOOBDD=>@RUeTfotuOOBDD=>@RUeTfotuOOBDD;<>PSaRbkpqOOBDD89;MP[}ejkOOBDD=>@RUeTfotuOOBDD=>@RUeTfotuOOBDD:;=OR_Q`inoOO9IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GYK*?)@CZL+B*CFD! OOBDDIJLqt}s~  HM  NOOBDDKLNs  wB  vC  LQ  ROOBDDJKMru  uA  JO  POOBDDIJLqt}s~  HM  NOO;IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDKLNu  yB  xC  LQ  ROOBDDMNPw  {F  zG  PU  VOOBDDLMOv  zD  yE  NS  TOOBDDKLNu  yB  xC  LQ  ROO0IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD@AC_bkaluz{OOBDDBCEadocpy~OOBDDABD`cmbnw|}OOBDD@AC_bkaluz{OO2IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDBCEcfoepy~OOBDDDEGehsgt  ~C  DOOBDDCDFdgqfr  |A  BOOBDDBCEcfoepy~OO1IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDABDadmcnw|}OOBDDCDFcfqer  |A  BOOBDDBCEbeodpy~OOBDDABDadmcnw|}OO)IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD9:<QT]S^glmOOBDD;<>SVaUbkpqOOBDD:;=RU_T`inoOOBDD9:<QT]S^glmr  c                  )   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                  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                  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                  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                  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                  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                  dA      d!       t        j                  t        j                  dB      d!       t        j                  t        j                  dC      d!       t        j                  t        j                  dD      d!       t        j                  t        j                  dE      d!       t        j                  t        j                  dF      d!       t        j                  t        j                  dG      d!       t        j                  t        j                  dH      d!       t        j                  d!       t        j                  d dIdJK       t        j                  d dIdJK       t        j                  t        j                  dL      dI       t        j                  t        j                  dM      dI       t        j                  t        j                  dN      dI       t        j                  t        j                  dO      dI       t        j
                  dIdP       t        j
                  dIdQ       t        j
                  dIdR       t        j
                  dIdS       t        j
                  dIdT       t        j
                  dIdU       t        j
                  dIdV       t        j
                  dIdW       t        j
                  dIdX       t        j
                  dIdY       t        j
                  dIdZ       t        j
                  dId[       t        j
                  dId\       t        j
                  dId]       t        j
                  dId^       t        j                  t        j                  d_      d`       t        j                  t        j                  da      d`       t        j                  t        j                  db      d`       t        j                  t        j                  dc      d`       t        j                  t        j                  dd      d`       t        j                  t        j                  de      d`       t        j                  t        j                  df      d`       t        j                  t        j                  dg      d`       t        j                  t        j                  dh      d`       t        j                  t        j                  di      d`       t        j                  t        j                  dj      d`       t        j                  t        j                  dk      d`       t        j                  t        j                  dl      d`       t        j                  t        j                  dm      d`       t        j                  t        j                  dn      d`       t        j                  t        j                  do      d`       t        j                  t        j                  dp      d`       t        j                  t        j                  dq      d`       t        j                  t        j                  dr      d`       t        j                  t        j                  ds      d`       t        j                  d`       t        j                  t        j                  dt      du       t        j                  t        j                  dv      du       t        j                  t        j                  dw      du       t        j                  t        j                  dx      du       t        j                  du       t        j                  t        j                  dy      dz       t        j                  t        j                  d{      dz       t        j                  t        j                  d|      dz       t        j                  t        j                  d}      dz       t        j                  t        j                  d~      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  t        j                  d      dz       t        j                  dz       y )Nr  r   )
table_namer  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   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   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rw   
foreignkey)type_r   r   r   r   r   r   r   r   r   r   r   r   r   r   r|   r{   rz   ry   rx   rv   r`   ru   rt   rs   rr   rq   rp   ro   rn   rm   rl   rk   rj   ri   rh   rg   rf   re   rd   rc   r_   rT   r^   r]   r\   rS   r   rR   rQ   rP   rO   rN   rM   rL   rK   rJ   rI   rH   rG   rF   rE   rD   rC   rB   r@   )r   
drop_indexr  
drop_tabledrop_constraintdrop_columnr  r  r  	downgrader    sH   MM"$$78EZ[MM"$$89F[\MM"$$9:G\]MM"$$78EZ[MM'(MM"$$?@MjkMM"$$@ANklMM"$$ABOlmMM"$$?@MjkMM/0MM"$$@ANlmMM"$$ABOmnMM"$$BCPnoMM"$$@ANlmMM01MM"$$>?LhiMM"$$?@MijMM"$$@ANjkMM"$$>?LhiMM./MM"$$IJW~MM"$$JKX  AMM"$$KL  ZA  BMM"$$IJW~MM9:MM"$$GHUz{MM"$$HIV{|MM"$$IJW|}MM"$$GHUz{MM78MM"$$89FXYMM"$$;<I[\MM"$$;<I[\MM"$$67DVWMM"$$9:GYZMM"$$;<I[\MM"$$;<I[\MM"$$;<I[\MM"$$89FXYMM"$$@AN`aMM"$$67DVWMM"$$45BTUMM"$$>?L^_MM"$$:;HZ[MM"$$12?QRMM"$$78EWXMM"$$:;HZ[MM"$$9:GYZMM"$$89FXYMM"$$EFSefMM"$$78EWXMM"$$12?QRMM"$$:;HZ[MM"$$89FXYMM"$$9:GYZMM"$$CDQcdMM"$$?@M_`MM"$$<=J\]MM"$$=>K]^MM"$$:;HZ[MM"$$:;HZ[MM"$$89FXYMM"$$;<I[\MM"$$:;HZ[MM"$$;<I[\MM"$$>?L^_MM"$$@AN`aMM"$$56CUVMM"$$78EWXMM"$$89FXYMM$%tZ|<tZ|<MM"$$/0ZHMM"$$67JOMM"$$34LMM"$$23
KNN:/NN:/0NN:23NN:/0NN:01NN:|,NN:z*NN:~.NN:}-NN:{+NN:{+NN:~.NN:y)NN:/0NN:{+MM"$$=>K_`MM"$$=>K_`MM"$$=>K_`MM"$$:;H\]MM"$$89FZ[MM"$$67DXYMM"$$78EYZMM"$$34AUVMM"$$34AUVMM"$$<=J^_MM"$$:;H\]MM"$$;<I]^MM"$$ABOcdMM"$$>?L`aMM"$$?@MabMM"$$<=J^_MM"$$<=J^_MM"$$:;H\]MM"$$=>K_`MM"$$<=J^_MM&'MM"$$:;H`aMM"$$;<IabMM"$$<=JbcMM"$$:;H`aMM*+MM"$$78^TMM"$$78^TMM"$$78^TMM"$$45.QMM"$$23OMM"$$01nMMM"$$-.>JMM"$$-.>JMM"$$67NSMM"$$45.QMM"$$56>RMM"$$;<XMM"$$89nUMM"$$9:~VMM"$$67NSMM"$$67NSMM"$$45.QMM"$$78^TMM"$$67NSMM.!r  )__doc__alembicr   
sqlalchemyr  revisiondown_revisionbranch_labels
depends_onr  r  r  r  r  <module>r'     s6      
XnxK"r  