U
    \dC                    @   sH   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
dd Zd	d
 ZdS )zhempty message

Revision ID: 5da0a12f74d1
Revises: 1843bb2d7b77
Create Date: 2020-12-16 18:28:49.780215

    )opN)mysql5da0a12f74d13850a2b469aec                8   C   s:7  t dtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt ddd
gd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t dtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt ddd
gd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t dtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt ddd
gd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t d tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d!d d
gd	d t jt d"d dgd	d t jt d#d dgd	d t jt d$d dgd	d t d%tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d&d%d
gd	d t jt d'd%dgd	d t jt d(d%dgd	d t jt d)d%dgd	d t d*tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d+d*d
gd	d t jt d,d*dgd	d t jt d-d*dgd	d t jt d.d*dgd	d t d/tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d0d/d
gd	d t jt d1d/dgd	d t jt d2d/dgd	d t jt d3d/dgd	d t d4tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d5d4d
gd	d t jt d6d4dgd	d t jt d7d4dgd	d t jt d8d4dgd	d t d9tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d:d9d
gd	d t jt d;d9dgd	d t jt d<d9dgd	d t jt d=d9dgd	d t d>tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt d?d>d
gd	d t jt d@d>dgd	d t jt dAd>dgd	d t jt dBd>dgd	d t dCtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt dDdCd
gd	d t jt dEdCdgd	d t jt dFdCdgd	d t jt dGdCdgd	d t dHtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt dIdHd
gd	d t jt dJdHdgd	d t jt dKdHdgd	d t jt dLdHdgd	d t dMtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt dNdMd
gd	d t jt dOdMdgd	d t jt dPdMdgd	d t jt dQdMdgd	d t dRtjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtd
 t jt dSdRd
gd	d t jt dTdRdgd	d t jt dUdRdgd	d t jt dVdRdgd	d t dWtjdXtjddddtjdYtj	ddZddtjd[tjd\dddtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdhtjddddtjditjddddtjdjtj	ddZddtjdtjddd	dtjdkt
 ddtjdltjd\dddtjdmtjddddtjdnt
 ddtjdot ddtjdptjddddtjdqtjddddtjdrtjd\dddtjdstj	ddZddtjdttj	ddZddtjdutj	ddZddtjdvtjd\dd	dtjdwtjddddtjdxtjddddtjdytjddddtjdztj	ddZddtjd{tjd|d}d~ddtjdt ddtjdt ddtjdt ddtjdtjddddtjdt ddtjdtjddddtdXgdgtdhgdgtdigdgtdwgdgtdygdgtd0 t jt ddWdXgd	d t jt ddWdYgd	d t jt ddWd[gd	d t jt ddWd]gd	d t jt ddWd^gd	d t jt ddWd_gd	d t jt ddWd`gd	d t jt ddWdagd	d t jt ddWdbgd	d t jt ddWdcgd	d t jt ddWddgd	d t jt ddWdegd	d t jt ddWdfgd	d t jt ddWdggdd t jt ddWdhgd	d t jt ddWdigd	d t jt ddWdmgd	d t jt ddWdogd	d t jt ddWdpgd	d t jt ddWdqgd	d t jt ddWdwgd	d t jt ddWdxgd	d t jt ddWdygd	d t jt ddWdgd	d t jt ddWdgd	d t dtjdXtjddddtjdYtj	ddZddtjd[tjd\dddtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdhtjddddtjdjtj	ddZddtjdtjddd	dtjdkt
 ddtjdltjd\dddtjdmtjddddtjdnt
 ddtjdot ddtjdptjddddtjdqtjddddtjdrtjd\dddtjdstj	ddZddtjdttj	ddZddtjdutj	ddZddtjdvtjd\dd	dtjdwtjddddtjdxtjddddtjdytjddddtjdztj	ddZddtjdt ddtjdt ddtjdt ddtjdtjddddtjdtjddddtdXgdgtdhgdgtdwgdgtdygdgtd, t jt dddXgd	d t jt dddYgd	d t jt ddd[gd	d t jt ddd]gd	d t jt ddd^gd	d t jt ddd_gd	d t jt ddd`gd	d t jt dddagd	d t jt dddbgd	d t jt dddcgd	d t jt ddddgd	d t jt dddegd	d t jt dddfgd	d t jt dddggdd t jt dddhgd	d t jt dddmgd	d t jt dddogd	d t jt dddpgd	d t jt dddqgd	d t jt dddwgd	d t jt dddxgd	d t jt dddygd	d t jt dddgd	d t jt dddgd	d t dtjdXtjddddtjdYtj	ddZddtjd[tjd\dddtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdhtjddddtjdjtj	ddZddtjdtjddd	dtjdkt
 ddtjdtjd\dd	dtjdltjd\dddtjdmtjddddtjdnt
 ddtjdot ddtjdptjddddtjdqtjddddtjdrtjd\dddtjdstj	ddZddtjdttj	ddZddtjdutj	ddZddtjdvtjd\dd	dtjdwtjddddtjdxtjddddtjdytjddddtjdztj	ddZddtjdt ddtjdt ddtjdt ddtjdtjddddtjdtjddddtdXgdgtdhgdgtdwgdgtdygdgtd- t jt dddXgd	d t jt dddYgd	d t jt ddd[gd	d t jt ddd]gd	d t jt d¡dd^gd	d t jt dádd_gd	d t jt dġdd`gd	d t jt dšddagd	d t jt dơddbgd	d t jt dǡddcgd	d t jt dȡdddgd	d t jt dɡddegd	d t jt dʡddfgd	d t jt dˡddggdd t jt d̡ddhgd	d t jt d͡ddmgd	d t jt dΡddogd	d t jt dϡddpgd	d t jt dСddqgd	d t jt dѡddwgd	d t jt dҡddxgd	d t jt dӡddygd	d t jt dԡddgd	d t jt dաddgd	d t dtjdtjddddtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdtjd|d}d~ddtjdtjddddtjdtjddd	dtjdmtjddddtjdtjd|d}d~ddtjdtjddddtjdt ddtdgdgtdgdgtd t jt dޡdd]gd	d t jt dߡdd^gd	d t jt ddd_gd	d t jt ddd`gd	d t jt dddagd	d t jt dddbgd	d t jt dddcgd	d t jt ddddgd	d t jt dddegd	d t jt dddfgd	d t jt dddggdd t jt dddgd	d t jt dddmgd	d t jt dddgd	d t dtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdtjd\dddtjdtjddd	dtjdmtjddddtjdot ddtjdwtjddddtjdtjddddtjdytjddddtjdt ddtdwgdgtdgdgtdygdgtd t jt ddd]gd	d t jt ddd^gd	d t jt ddd_gd	d t jt ddd`gd	d t jt dddagd	d t jt dddbgd	d t jt dddcgd	d t jt ddddgd	d t jt dddegd	d t jt dddfgd	d t jt dddggdd t jt dddmgd	d t jt dddogd	d t jt dddwgd	d t jt dddgd	d t jt dddygd	d t d tjdXtjddddtjdYtj	ddZddtjd[tjd\dddtjd]tjddddtjd^tj	ddZddtjd_t
 d	dtjd`tj	ddZddtjdatjddddtjdbtj	ddZddtjdctjddddtjddtjddddtjdet ddtjdftj	ddZddtjdgtjddddtjdhtjddddtjditjddddtjdtjddddtjdjtj	ddZddtjdtjddddtjdtjd|d}d~ddtjdtjddd	dtjdkt
 ddtjdltjd\dddtjdmtjddddtjdnt
 ddtjdot ddtjdptjddddtjdqtjddddtjdrtjd\dddtjdstj	ddZddtjdttj	ddZddtjdutj	ddZddtjdtjddddtjdvtjd\dd	dtjdwtjddddtjdxtjddddtjdytjddddtjdztj	ddZddtjdt ddtjdt ddtjdt ddtjdtjddddtjdtjddddtdXgdgtdhgdgtdigdgtdgdgtdgdgtdwgdgtdygdgtd4 t jt dd dXgd	d t jt dd dYgd	d t jt dd d[gd	d t jt dd d]gd	d t jt d	d d^gd	d t jt d
d d_gd	d t jt dd d`gd	d t jt dd dagd	d t jt dd dbgd	d t jt dd dcgd	d t jt dd ddgd	d t jt dd degd	d t jt dd dfgd	d t jt dd dggdd t jt dd dhgd	d t jt dd digd	d t jt dd dgd	d t jt dd dgd	d t jt dd dmgd	d t jt dd dogd	d t jt dd dpgd	d t jt dd dqgd	d t jt dd dgd	d t jt dd dwgd	d t jt dd dxgd	d t jt dd dygd	d t jt dd dgd	d t jt d d dgd	d t d!tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtd
gdgtdgdgtd
 t jt d"d!d
gd	d t jt d#d!dgd	d t d$tjdtjddddtjdtjddd	dtjd
tjddddtjdtjddddtjdtjddddtjdtjddddtd
gdgtdgd%gtd
 t jt d&d$d
gd	d t jt d'd$dgd	d t d( t d) t jd*d+d, t jd-d+d, t jd.d+d, t jd/d+d, t d+ t jd0d1d, t jd2d1d, t jd3d1d, t jd4d1d, t d1 t jd5d6d, t jd7d6d, t jd8d6d, t jd9d6d, t d6 t d: t jd;d<d, t jd=d<d, t jd>d<d, t jd?d<d, t d< t jd@dAd, t jdBdAd, t jdCdAd, t jdDdAd, t dA t jdEdFd, t jdGdFd, t jdHdFd, t jdIdFd, t dF t jdJdKd, t jdLdKd, t jdMdKd, t jdNdKd, t dK t jdOdPd, t jdQdPd, t jdRdPd, t jdSdPd, t dP t jdTdUd, t jdVdUd, t jdWdUd, t jdXdUd, t dU t dYtjdZt
 dd t dYtjd[tjd|d}d~dd t d\tjd]tjd|d}d~dd t d\tjd^tjd|d}d~dd t d\tjdtjd|d}d~dd t d\tjdtjdddd t d\tjd_tjdddd t jt d`d\dgd	d t jt dad\d_gd	d t d d\dbdgdg t d d\dcd_gdg t dbdڡ t dbd_ d S (d  Ncmf_kanban_sales_status_objectsdescription   lengthTnullableid@   Fleft_idleft_name_cache   	parent_idright_idright_name_cacheroot_id*ix_cmf_kanban_sales_status_objects_left_idunique,ix_cmf_kanban_sales_status_objects_parent_id+ix_cmf_kanban_sales_status_objects_right_id*ix_cmf_kanban_sales_status_objects_root_idcmf_u_work_bill_executors$ix_cmf_u_work_bill_executors_left_id&ix_cmf_u_work_bill_executors_parent_id%ix_cmf_u_work_bill_executors_right_id$ix_cmf_u_work_bill_executors_root_idcmf_u_work_bill_related_objects*ix_cmf_u_work_bill_related_objects_left_id,ix_cmf_u_work_bill_related_objects_parent_id+ix_cmf_u_work_bill_related_objects_right_id*ix_cmf_u_work_bill_related_objects_root_idcmf_u_work_bill_spectators%ix_cmf_u_work_bill_spectators_left_id'ix_cmf_u_work_bill_spectators_parent_id&ix_cmf_u_work_bill_spectators_right_id%ix_cmf_u_work_bill_spectators_root_idcmf_u_work_deal_executors$ix_cmf_u_work_deal_executors_left_id&ix_cmf_u_work_deal_executors_parent_id%ix_cmf_u_work_deal_executors_right_id$ix_cmf_u_work_deal_executors_root_idcmf_u_work_deal_related_objects*ix_cmf_u_work_deal_related_objects_left_id,ix_cmf_u_work_deal_related_objects_parent_id+ix_cmf_u_work_deal_related_objects_right_id*ix_cmf_u_work_deal_related_objects_root_idcmf_u_work_deal_spectators%ix_cmf_u_work_deal_spectators_left_id'ix_cmf_u_work_deal_spectators_parent_id&ix_cmf_u_work_deal_spectators_right_id%ix_cmf_u_work_deal_spectators_root_idcmf_u_work_lead_executors$ix_cmf_u_work_lead_executors_left_id&ix_cmf_u_work_lead_executors_parent_id%ix_cmf_u_work_lead_executors_right_id$ix_cmf_u_work_lead_executors_root_idcmf_u_work_lead_related_objects*ix_cmf_u_work_lead_related_objects_left_id,ix_cmf_u_work_lead_related_objects_parent_id+ix_cmf_u_work_lead_related_objects_right_id*ix_cmf_u_work_lead_related_objects_root_idcmf_u_work_lead_spectators%ix_cmf_u_work_lead_spectators_left_id'ix_cmf_u_work_lead_spectators_parent_id&ix_cmf_u_work_lead_spectators_right_id%ix_cmf_u_work_lead_spectators_root_idcmf_u_work_sales_list_executors*ix_cmf_u_work_sales_list_executors_left_id,ix_cmf_u_work_sales_list_executors_parent_id+ix_cmf_u_work_sales_list_executors_right_id*ix_cmf_u_work_sales_list_executors_root_idcmf_u_work_sales_list_members(ix_cmf_u_work_sales_list_members_left_id*ix_cmf_u_work_sales_list_members_parent_id)ix_cmf_u_work_sales_list_members_right_id(ix_cmf_u_work_sales_list_members_root_id%cmf_u_work_sales_list_related_objects0ix_cmf_u_work_sales_list_related_objects_left_id2ix_cmf_u_work_sales_list_related_objects_parent_id1ix_cmf_u_work_sales_list_related_objects_right_id0ix_cmf_u_work_sales_list_related_objects_root_id cmf_u_work_sales_list_spectators+ix_cmf_u_work_sales_list_spectators_left_id-ix_cmf_u_work_sales_list_spectators_parent_id,ix_cmf_u_work_sales_list_spectators_right_id+ix_cmf_u_work_sales_list_spectators_root_idcmf_u_work_dealactivity_id
alarm_date)timezonecache_status_type    cmf_author_idcmf_created_atcmf_deletedcmf_locked_atcmf_locked_by_idcmf_modified_atcmf_modified_by_idcmf_owner_idcmf_versioncmf_viewed_atcode
company_idcurrency_iddeadline
is_penaltymarkname
no_controlordernoparent_task_idperiod_clone_from_idperiod_intervalperiod_next_dateplan_end_dateplan_start_datepriority
project_idresponsible_id	status_idstatus_modified_atsumma      	precisionscaletagstexttime_estimatetree_parent_idutm_markwaiting_for_idcmf_activity.idcmf_company.idzcmf_currency.idcmf_project.idcmf_status.idix_cmf_u_work_deal_activity_idix_cmf_u_work_deal_alarm_date$ix_cmf_u_work_deal_cache_status_type ix_cmf_u_work_deal_cmf_author_id!ix_cmf_u_work_deal_cmf_created_atix_cmf_u_work_deal_cmf_deleted ix_cmf_u_work_deal_cmf_locked_at#ix_cmf_u_work_deal_cmf_locked_by_id"ix_cmf_u_work_deal_cmf_modified_at%ix_cmf_u_work_deal_cmf_modified_by_idix_cmf_u_work_deal_cmf_owner_idix_cmf_u_work_deal_cmf_version ix_cmf_u_work_deal_cmf_viewed_atix_cmf_u_work_deal_codeix_cmf_u_work_deal_company_idix_cmf_u_work_deal_currency_idix_cmf_u_work_deal_nameix_cmf_u_work_deal_orderno!ix_cmf_u_work_deal_parent_task_id'ix_cmf_u_work_deal_period_clone_from_idix_cmf_u_work_deal_project_id!ix_cmf_u_work_deal_responsible_idix_cmf_u_work_deal_status_id!ix_cmf_u_work_deal_tree_parent_id!ix_cmf_u_work_deal_waiting_for_idcmf_u_work_leadix_cmf_u_work_lead_activity_idix_cmf_u_work_lead_alarm_date$ix_cmf_u_work_lead_cache_status_type ix_cmf_u_work_lead_cmf_author_id!ix_cmf_u_work_lead_cmf_created_atix_cmf_u_work_lead_cmf_deleted ix_cmf_u_work_lead_cmf_locked_at#ix_cmf_u_work_lead_cmf_locked_by_id"ix_cmf_u_work_lead_cmf_modified_at%ix_cmf_u_work_lead_cmf_modified_by_idix_cmf_u_work_lead_cmf_owner_idix_cmf_u_work_lead_cmf_version ix_cmf_u_work_lead_cmf_viewed_atix_cmf_u_work_lead_codeix_cmf_u_work_lead_company_idix_cmf_u_work_lead_nameix_cmf_u_work_lead_orderno!ix_cmf_u_work_lead_parent_task_id'ix_cmf_u_work_lead_period_clone_from_idix_cmf_u_work_lead_project_id!ix_cmf_u_work_lead_responsible_idix_cmf_u_work_lead_status_id!ix_cmf_u_work_lead_tree_parent_id!ix_cmf_u_work_lead_waiting_for_idcmf_u_work_sales_list	list_type$ix_cmf_u_work_sales_list_activity_id#ix_cmf_u_work_sales_list_alarm_date*ix_cmf_u_work_sales_list_cache_status_type&ix_cmf_u_work_sales_list_cmf_author_id'ix_cmf_u_work_sales_list_cmf_created_at$ix_cmf_u_work_sales_list_cmf_deleted&ix_cmf_u_work_sales_list_cmf_locked_at)ix_cmf_u_work_sales_list_cmf_locked_by_id(ix_cmf_u_work_sales_list_cmf_modified_at+ix_cmf_u_work_sales_list_cmf_modified_by_id%ix_cmf_u_work_sales_list_cmf_owner_id$ix_cmf_u_work_sales_list_cmf_version&ix_cmf_u_work_sales_list_cmf_viewed_atix_cmf_u_work_sales_list_code#ix_cmf_u_work_sales_list_company_idix_cmf_u_work_sales_list_name ix_cmf_u_work_sales_list_orderno'ix_cmf_u_work_sales_list_parent_task_id-ix_cmf_u_work_sales_list_period_clone_from_id#ix_cmf_u_work_sales_list_project_id'ix_cmf_u_work_sales_list_responsible_id"ix_cmf_u_work_sales_list_status_id'ix_cmf_u_work_sales_list_tree_parent_id'ix_cmf_u_work_sales_list_waiting_for_idcmf_deal_productcache_product_namecountdeal_idprice
product_idzcmf_u_work_deal.idzcmf_product.id!ix_cmf_deal_product_cmf_author_id"ix_cmf_deal_product_cmf_created_atix_cmf_deal_product_cmf_deleted!ix_cmf_deal_product_cmf_locked_at$ix_cmf_deal_product_cmf_locked_by_id#ix_cmf_deal_product_cmf_modified_at&ix_cmf_deal_product_cmf_modified_by_id ix_cmf_deal_product_cmf_owner_idix_cmf_deal_product_cmf_version!ix_cmf_deal_product_cmf_viewed_atix_cmf_deal_product_codeix_cmf_deal_product_deal_idix_cmf_deal_product_nameix_cmf_deal_product_product_idcmf_kanban_sales_statuscolorsales_list_idzcmf_u_work_sales_list.id(ix_cmf_kanban_sales_status_cmf_author_id)ix_cmf_kanban_sales_status_cmf_created_at&ix_cmf_kanban_sales_status_cmf_deleted(ix_cmf_kanban_sales_status_cmf_locked_at+ix_cmf_kanban_sales_status_cmf_locked_by_id*ix_cmf_kanban_sales_status_cmf_modified_at-ix_cmf_kanban_sales_status_cmf_modified_by_id'ix_cmf_kanban_sales_status_cmf_owner_id&ix_cmf_kanban_sales_status_cmf_version(ix_cmf_kanban_sales_status_cmf_viewed_atix_cmf_kanban_sales_status_codeix_cmf_kanban_sales_status_name"ix_cmf_kanban_sales_status_orderno%ix_cmf_kanban_sales_status_project_id(ix_cmf_kanban_sales_status_sales_list_id$ix_cmf_kanban_sales_status_status_idcmf_u_work_billcustomer_iddiscountprint_tmpl_idzcmf_print_tmpl.idix_cmf_u_work_bill_activity_idix_cmf_u_work_bill_alarm_date$ix_cmf_u_work_bill_cache_status_type ix_cmf_u_work_bill_cmf_author_id!ix_cmf_u_work_bill_cmf_created_atix_cmf_u_work_bill_cmf_deleted ix_cmf_u_work_bill_cmf_locked_at#ix_cmf_u_work_bill_cmf_locked_by_id"ix_cmf_u_work_bill_cmf_modified_at%ix_cmf_u_work_bill_cmf_modified_by_idix_cmf_u_work_bill_cmf_owner_idix_cmf_u_work_bill_cmf_version ix_cmf_u_work_bill_cmf_viewed_atix_cmf_u_work_bill_codeix_cmf_u_work_bill_company_idix_cmf_u_work_bill_currency_idix_cmf_u_work_bill_customer_idix_cmf_u_work_bill_deal_idix_cmf_u_work_bill_nameix_cmf_u_work_bill_orderno!ix_cmf_u_work_bill_parent_task_id'ix_cmf_u_work_bill_period_clone_from_id ix_cmf_u_work_bill_print_tmpl_idix_cmf_u_work_bill_project_id!ix_cmf_u_work_bill_responsible_idix_cmf_u_work_bill_status_id!ix_cmf_u_work_bill_tree_parent_id!ix_cmf_u_work_bill_waiting_for_idcmf_u_work_deal_cmf_company&ix_cmf_u_work_deal_cmf_company_left_id'ix_cmf_u_work_deal_cmf_company_right_idcmf_u_work_deal_cmf_personzcmf_person.id%ix_cmf_u_work_deal_cmf_person_left_id&ix_cmf_u_work_deal_cmf_person_right_idcmf_billcmf_dealix_cmf_bill_executors_left_idcmf_bill_executors
table_nameix_cmf_bill_executors_parent_idix_cmf_bill_executors_right_idix_cmf_bill_executors_root_idix_cmf_deal_executors_left_idcmf_deal_executorsix_cmf_deal_executors_parent_idix_cmf_deal_executors_right_idix_cmf_deal_executors_root_idix_cmf_bill_spectators_left_idcmf_bill_spectators ix_cmf_bill_spectators_parent_idix_cmf_bill_spectators_right_idix_cmf_bill_spectators_root_idcmf_lead#ix_cmf_lead_related_objects_left_idcmf_lead_related_objects%ix_cmf_lead_related_objects_parent_id$ix_cmf_lead_related_objects_right_id#ix_cmf_lead_related_objects_root_idix_cmf_deal_spectators_left_idcmf_deal_spectators ix_cmf_deal_spectators_parent_idix_cmf_deal_spectators_right_idix_cmf_deal_spectators_root_id#ix_cmf_bill_related_objects_left_idcmf_bill_related_objects%ix_cmf_bill_related_objects_parent_id$ix_cmf_bill_related_objects_right_id#ix_cmf_bill_related_objects_root_idix_cmf_lead_executors_left_idcmf_lead_executorsix_cmf_lead_executors_parent_idix_cmf_lead_executors_right_idix_cmf_lead_executors_root_idix_cmf_lead_spectators_left_idcmf_lead_spectators ix_cmf_lead_spectators_parent_idix_cmf_lead_spectators_right_idix_cmf_lead_spectators_root_id#ix_cmf_deal_related_objects_left_idcmf_deal_related_objects%ix_cmf_deal_related_objects_parent_id$ix_cmf_deal_related_objects_right_id#ix_cmf_deal_related_objects_root_idcmf_currencymainrate	cmf_pricecostdirect_costsunit_idix_cmf_price_product_idix_cmf_price_unit_idcmf_productcmf_unit)r   create_tablesaColumnStringCHARPrimaryKeyConstraintcreate_indexf	TIMESTAMPBooleanIntegerNumericTEXTForeignKeyConstraint
drop_table
drop_index
add_columncreate_foreign_keydrop_column rz  rz  ./opt/eva-app/alembic/versions/5da0a12f74d1_.pyupgrade   s<   1-.5   &&&$"$ r|  c                0   C   s&-  t dtjdtjdddd t dtjdtjdd	d
dd t ddddgdg t jdddgdd t j	d ddd t j	d ddd t j
t ddd t j
t ddd t dd t dd t dd t dd t dd t dd t dd t jdtjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jd*dd&gdd t jd+dd$gdd t jd,dd#gdd t jd-dd gdd t jd.tjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jd/d.d&gdd t jd0d.d$gdd t jd1d.d#gdd t jd2d.d gdd t jd3tjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jd4d3d&gdd t jd5d3d$gdd t jd6d3d#gdd t jd7d3d gdd t jd8tjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jd9d8d&gdd t jd:d8d$gdd t jd;d8d#gdd t jd<d8d gdd t jd=tjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jd>d=d&gdd t jd?d=d$gdd t jd@d=d#gdd t jdAd=d gdd t jdBtjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jdCdBd&gdd t jdDdBd$gdd t jdEdBd#gdd t jdFdBd gdd t jdGtjdHtjddddtjdIt ddtjdJtjdKdddtjdLtjddddtjdMt ddtjdNtjdOdPdddQtjdRt ddtjdStjddddtjdTt ddtjdUtjddddtjdVtjddddtjdWt dddQtjdXt ddtjdYtjddddtjdZtjddddtjd[t ddtjdtjddddtjd\tjdOdPdddQtjd]tjdKdddtjd^tjd"dddtjd_tjdOdPdddQtjd`t dddQtjdatjddddtjdbtjddddtjdctjdKdddtjddt ddtjdet ddtjdft ddtjdgtjdKdddtjdhtjddddtjditjddddtjdjtjddddtjdkt ddtjdlt ddtjdmt ddtjdnt dddQtjdotjddddtjdptjddddtjdHgdqgdrdstjdZgdtgdudstjdhgdvgdwdstjdjgdxgdydstdd'd(d). t jdzdGdpgdd t jd{dGdogdd t jd|dGdjgdd t jd}dGdigdd t jd~dGdhgdd t jddGdbgdd t jddGdagdd t jddGd`gdd t jddGd^gdd t jddGdZgdd t jddGdYgdd t jddGdXgdd t jddGdWgdd t jddGdVgdd t jddGdUgdd t jddGdTgdd t jddGdSgdd t jddGdRgdd t jddGdNgdd t jddGdMgdd t jddGdLgdd t jddGdJgdd t jddGdIgdd t jddGdHgdd t jdtjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jddd&gdd t jddd$gdd t jddd#gdd t jddd gdd t jdtjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jddd&gdd t jddd$gdd t jddd#gdd t jddd gdd t jdtjdtjddddtjdtjddddtjd tjddddtjd!tjd"dddtjd#tjddddtjd$tjddddtjd%tjd"dddtjd&tjddddtdd'd(d) t jddd&gdd t jddd$gdd t jddd#gdd t jddd gdd t jdtjdHtjddddtjdIt ddtjdJtjdKdddtjdLtjddddtjdMt ddtjdNtjdOdPdddQtjdRt ddtjdStjddddtjdTt ddtjdUtjddddtjdVtjddddtjdWt dddQtjdXt ddtjdYtjddddtjdZtjddddtjd[t ddtjdtjddddtjd\tjdOdPdddQtjd]tjdKdddtjd^tjd"dddtjd_tjdOdPdddQtjd`t dddQtjdatjddddtjdbtjddddtjdctjdKdddtjddt ddtjdet ddtjdft ddtjdgtjdKdddtjdhtjddddtjditjddddtjdjtjddddtjdkt ddtjdlt ddtjdmt ddtjdnt dddQtjdotjddddtjdptjddddtjdHgdqgddstjdZgdtgddstjdhgdvgddstjdjgdxgddstdd'd(d). t jdddpgdd t jdddogdd t jdddjgdd t jdddigdd t jdddhgdd t jdddbgdd t jdddagdd t jddd`gdd t jddd^gdd t jdddZgdd t jdddYgdd t jdddXgdd t jdddWgdd t jdddVgdd t jdddUgdd t jdddTgdd t jdddSgdd t jdddRgdd t jdddNgdd t jdddMgdd t jdddLgdd t jdddJgdd t jdddIgdd t jdddHgdd t jdtjdHtjddddtjdIt ddtjdJtjdKdddtjdLtjddddtjdMt ddtjdNtjdOdPdddQtjdRt ddtjdStjddddtjdTt ddtjdUtjddddtjdVtjddddtjdWt dddQtjdXt ddtjdYtjddddtjdZtjddddtjd[t ddtjdtjddddtjd\tjdOdPdddQtjd]tjdKdddtjd^tjd"dddtjd_tjdOdPdddQtjd`t dddQtjdatjddddtjdbtjddddtjdctjdKdddtjddt ddtjdet ddtjdft ddtjdgtjdKdddtjdhtjddddtjditjddddtjdjtjddddtjdkt ddtjdlt ddtjdmt ddtjdnt dddQtjdotjddddtjdptjddddtjdHgdqgddstjdZgdtgddstjdhgdvgddstjdjgdxgddstdd'd(d). t jdddpgdd t jdddogdd t jdddjgdd t jdddigdd t jdddhgdd t jdddbgdd t jdddagdd t jddd`gdd t jddd^gdd t jdddZgdd t jdddYgdd t jdddXgdd t jdddWgdd t jdddVgdd t jdddUgdd t jdddTgdd t jdddSgdd t jdddRgdd t jdddNgdd t jdddMgdd t jdddLgdd t jdddJgdd t jdddIgdd t jdddHgdd t j
t dۡdd t j
t dݡdd t dܡ t j
t dޡdd t j
t ddd t dߡ t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t d dd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t d	dd t j
t d
dd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t d dd t j
t d!dd t j
t d"dd t j
t d#dd t j
t d$dd t j
t d%dd t j
t d&dd t j
t d'dd t j
t d(dd t j
t d)dd t j
t d*dd t j
t d+dd t j
t d,dd t j
t d-dd t j
t d.dd t j
t d/dd t j
t d0dd t j
t d1dd t j
t d2dd t j
t d3dd t j
t d4dd t j
t d5dd t j
t d6dd t d t j
t d7d8d t j
t d9d8d t j
t d:d8d t j
t d;d8d t j
t d<d8d t j
t d=d8d t j
t d>d8d t j
t d?d8d t j
t d@d8d t j
t dAd8d t j
t dBd8d t j
t dCd8d t j
t dDd8d t j
t dEd8d t j
t dFd8d t j
t dGd8d t j
t dHd8d t j
t dId8d t j
t dJd8d t j
t dKd8d t j
t dLd8d t j
t dMd8d t j
t dNd8d t j
t dOd8d t d8 t j
t dPdQd t j
t dRdQd t j
t dSdQd t j
t dTdQd t j
t dUdQd t j
t dVdQd t j
t dWdQd t j
t dXdQd t j
t dYdQd t j
t dZdQd t j
t d[dQd t j
t d\dQd t j
t d]dQd t j
t d^dQd t j
t d_dQd t j
t d`dQd t j
t dadQd t j
t dbdQd t j
t dcdQd t j
t dddQd t j
t dedQd t j
t dfdQd t j
t dgdQd t j
t dhdQd t j
t didQd t dQ t j
t djdkd t j
t dldkd t j
t dmdkd t j
t dndkd t dk t j
t dodpd t j
t dqdpd t j
t drdpd t j
t dsdpd t dp t j
t dtdud t j
t dvdud t j
t dwdud t j
t dxdud t du t j
t dydzd t j
t d{dzd t j
t d|dzd t j
t d}dzd t dz t j
t d~dd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d t j
t ddd t j
t ddd t j
t ddd t j
t ddd t d d S (  Nre  rb  r   r	   Tr   r   r   r   r   Zcmf_product_ibfk_1rf  r   ix_cmf_product_unit_idFr   r_  
foreignkey)type_rd  r.  rc  r   ra  r`  r\  r^  r]  rX  r   r   r   r   r   r   r   r   r   utf8InnoDB)mysql_default_charsetmysql_enginer[  rZ  rY  rW  rS  rV  rU  rT  rR  rN  rQ  rP  rO  rM  rI  rL  rK  rJ  rH  rD  rG  rF  rE  rC  r?  rB  rA  r@  r>  r=  r^   r_   ra   rb   rc   rd   re      )display_width)autoincrementr   rf   rg   rh   ri   rj   rk   rl   rm   rn   rp   rq   rr   rs   rt   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r   r   r   r   r   r   r   Zcmf_lead_ibfk_1)rs   r   Zcmf_lead_ibfk_2r   Zcmf_lead_ibfk_3r   Zcmf_lead_ibfk_4ix_cmf_lead_waiting_for_idix_cmf_lead_tree_parent_idix_cmf_lead_status_idix_cmf_lead_responsible_idix_cmf_lead_project_id ix_cmf_lead_period_clone_from_idix_cmf_lead_parent_task_idix_cmf_lead_ordernoix_cmf_lead_nameix_cmf_lead_company_idix_cmf_lead_codeix_cmf_lead_cmf_viewed_atix_cmf_lead_cmf_versionix_cmf_lead_cmf_owner_idix_cmf_lead_cmf_modified_by_idix_cmf_lead_cmf_modified_atix_cmf_lead_cmf_locked_by_idix_cmf_lead_cmf_locked_atix_cmf_lead_cmf_deletedix_cmf_lead_cmf_created_atix_cmf_lead_cmf_author_idix_cmf_lead_cache_status_typeix_cmf_lead_alarm_dateix_cmf_lead_activity_idr9  r<  r;  r:  r8  r4  r7  r6  r5  r3  r-  r2  r1  r0  r,  r+  Zcmf_deal_ibfk_1Zcmf_deal_ibfk_2Zcmf_deal_ibfk_3Zcmf_deal_ibfk_4ix_cmf_deal_waiting_for_idix_cmf_deal_tree_parent_idix_cmf_deal_status_idix_cmf_deal_responsible_idix_cmf_deal_project_id ix_cmf_deal_period_clone_from_idix_cmf_deal_parent_task_idix_cmf_deal_ordernoix_cmf_deal_nameix_cmf_deal_company_idix_cmf_deal_codeix_cmf_deal_cmf_viewed_atix_cmf_deal_cmf_versionix_cmf_deal_cmf_owner_idix_cmf_deal_cmf_modified_by_idix_cmf_deal_cmf_modified_atix_cmf_deal_cmf_locked_by_idix_cmf_deal_cmf_locked_atix_cmf_deal_cmf_deletedix_cmf_deal_cmf_created_atix_cmf_deal_cmf_author_idix_cmf_deal_cache_status_typeix_cmf_deal_alarm_dateix_cmf_deal_activity_idr*  Zcmf_bill_ibfk_1Zcmf_bill_ibfk_2Zcmf_bill_ibfk_3Zcmf_bill_ibfk_4ix_cmf_bill_waiting_for_idix_cmf_bill_tree_parent_idix_cmf_bill_status_idix_cmf_bill_responsible_idix_cmf_bill_project_id ix_cmf_bill_period_clone_from_idix_cmf_bill_parent_task_idix_cmf_bill_ordernoix_cmf_bill_nameix_cmf_bill_company_idix_cmf_bill_codeix_cmf_bill_cmf_viewed_atix_cmf_bill_cmf_versionix_cmf_bill_cmf_owner_idix_cmf_bill_cmf_modified_by_idix_cmf_bill_cmf_modified_atix_cmf_bill_cmf_locked_by_idix_cmf_bill_cmf_locked_atix_cmf_bill_cmf_deletedix_cmf_bill_cmf_created_atix_cmf_bill_cmf_author_idix_cmf_bill_cache_status_typeix_cmf_bill_alarm_dateix_cmf_bill_activity_idr)  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   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   r   r   r   r   r   r   r\   rX   r[   rZ   rY   rW   rS   rV   rU   rT   rR   rN   rQ   rP   rO   rM   rI   rL   rK   rJ   rH   rD   rG   rF   rE   rC   r?   rB   rA   r@   r>   r:   r=   r<   r;   r9   r5   r8   r7   r6   r4   r0   r3   r2   r1   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  rh  ri  r   rk  DECIMALrx  rm  drop_constraintrv  rn  ry  rg  VARCHARrl  ro  TINYINTINTEGERrs  rt  ru  rz  rz  rz  r{  	downgrade   s    "///



r  )__doc__alembicr   
sqlalchemyrh  Zsqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr|  r  rz  rz  rz  r{  <module>   s        r