U
    VcC                    @   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)mysqlZ5da0a12f74d1Z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_idZ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_productZ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colorZ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_billZcustomer_iddiscountZ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 rs  rs  */opt/crm/alembic/versions/5da0a12f74d1_.pyupgrade   s<   1-.5   &&&$"$ ru  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 (  Nr^  r[  r   r   Tr	   r   r   r   r   Zcmf_product_ibfk_1r_  r   Zix_cmf_product_unit_idFr   rX  
foreignkey)type_r]  r'  r\  r   rZ  rY  rU  rW  rV  rQ  r   r   r   r   r   r   r   r   r   utf8ZInnoDB)Zmysql_default_charsetZmysql_enginerT  rS  rR  rP  rL  rO  rN  rM  rK  rG  rJ  rI  rH  rF  rB  rE  rD  rC  rA  r=  r@  r?  r>  r<  r8  r;  r:  r9  r7  r6  r\   r]   r_   r`   ra   rb   rc      )Zdisplay_width)autoincrementr
   rd   re   rf   rg   rh   ri   rj   rk   rl   rn   ro   rp   rq   rr   rs   rt   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r   r   r   r   r   Zcmf_lead_ibfk_1)rq   r   Zcmf_lead_ibfk_2r   Zcmf_lead_ibfk_3r   Zcmf_lead_ibfk_4Zix_cmf_lead_waiting_for_idZix_cmf_lead_tree_parent_idZix_cmf_lead_status_idZix_cmf_lead_responsible_idZix_cmf_lead_project_idZ ix_cmf_lead_period_clone_from_idZix_cmf_lead_parent_task_idZix_cmf_lead_ordernoZix_cmf_lead_nameZix_cmf_lead_company_idZix_cmf_lead_codeZix_cmf_lead_cmf_viewed_atZix_cmf_lead_cmf_versionZix_cmf_lead_cmf_owner_idZix_cmf_lead_cmf_modified_by_idZix_cmf_lead_cmf_modified_atZix_cmf_lead_cmf_locked_by_idZix_cmf_lead_cmf_locked_atZix_cmf_lead_cmf_deletedZix_cmf_lead_cmf_created_atZix_cmf_lead_cmf_author_idZix_cmf_lead_cache_status_typeZix_cmf_lead_alarm_dateZix_cmf_lead_activity_idr2  r5  r4  r3  r1  r-  r0  r/  r.  r,  r&  r+  r*  r)  r%  r$  Zcmf_deal_ibfk_1Zcmf_deal_ibfk_2Zcmf_deal_ibfk_3Zcmf_deal_ibfk_4Zix_cmf_deal_waiting_for_idZix_cmf_deal_tree_parent_idZix_cmf_deal_status_idZix_cmf_deal_responsible_idZix_cmf_deal_project_idZ ix_cmf_deal_period_clone_from_idZix_cmf_deal_parent_task_idZix_cmf_deal_ordernoZix_cmf_deal_nameZix_cmf_deal_company_idZix_cmf_deal_codeZix_cmf_deal_cmf_viewed_atZix_cmf_deal_cmf_versionZix_cmf_deal_cmf_owner_idZix_cmf_deal_cmf_modified_by_idZix_cmf_deal_cmf_modified_atZix_cmf_deal_cmf_locked_by_idZix_cmf_deal_cmf_locked_atZix_cmf_deal_cmf_deletedZix_cmf_deal_cmf_created_atZix_cmf_deal_cmf_author_idZix_cmf_deal_cache_status_typeZix_cmf_deal_alarm_dateZix_cmf_deal_activity_idr#  Zcmf_bill_ibfk_1Zcmf_bill_ibfk_2Zcmf_bill_ibfk_3Zcmf_bill_ibfk_4Zix_cmf_bill_waiting_for_idZix_cmf_bill_tree_parent_idZix_cmf_bill_status_idZix_cmf_bill_responsible_idZix_cmf_bill_project_idZ ix_cmf_bill_period_clone_from_idZix_cmf_bill_parent_task_idZix_cmf_bill_ordernoZix_cmf_bill_nameZix_cmf_bill_company_idZix_cmf_bill_codeZix_cmf_bill_cmf_viewed_atZix_cmf_bill_cmf_versionZix_cmf_bill_cmf_owner_idZix_cmf_bill_cmf_modified_by_idZix_cmf_bill_cmf_modified_atZix_cmf_bill_cmf_locked_by_idZix_cmf_bill_cmf_locked_atZix_cmf_bill_cmf_deletedZix_cmf_bill_cmf_created_atZix_cmf_bill_cmf_author_idZix_cmf_bill_cache_status_typeZix_cmf_bill_alarm_dateZ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   rZ   rV   rY   rX   rW   rU   rQ   rT   rS   rR   rP   rL   rO   rN   rM   rK   rG   rJ   rI   rH   rF   rB   rE   rD   rC   rA   r=   r@   r?   r>   r<   r8   r;   r:   r9   r7   r3   r6   r5   r4   r2   r.   r1   r0   r/   r-   r)   r,   r+   r*   r(   r$   r'   r&   r%   r#   r   r"   r!   r    r   r   r   r   r   r   r   r   r   r   )r   rp  ra  rb  r   rd  DECIMALrq  rf  drop_constraintro  rg  rr  r`  VARCHARre  rh  TINYINTINTEGERrl  rm  rn  rs  rs  rs  rt  	downgrade   s    "///



r  )__doc__alembicr   
sqlalchemyra  Zsqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onru  r  rs  rs  rs  rt  <module>   s        r