U
    \dn                    @   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: f0b5bf93cfe6
Revises: 5da0a12f74d1
Create Date: 2020-12-18 10:19:31.091984

    )opN)mysqlZf0b5bf93cfe6Z5da0a12f74d1c                8   C   sF  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dt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 dXdWd
gd	d t jt dYdWdgd	d t jt dZdWdgd	d t jt d[dWd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 datjdt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 dbdad
gd	d t jt dcdadgd	d t jt dddadgd	d t jt dedadgd	d t dftjdt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 dgdfd
gd	d t jt dhdfdgd	d t jt didfdgd	d t jt djdfdgd	d t dktjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddn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dnddtjdtjddd	dtjd~t
 ddtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtj	ddnddtjdtj	ddnddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdt 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dlgdgtd|gdgtdgdgtdgdgtd- t jt ddkdlgd	d t jt ddkdmgd	d t jt ddkdogd	d t jt ddkdqgd	d t jt ddkdrgd	d t jt ddkdsgd	d t jt ddkdtgd	d t jt ddkdugd	d t jt ddkdvgd	d t jt ddkdwgd	d t jt ddkdxgd	d t jt ddkdygd	d t jt ddkdzgd	d t jt ddkd{gdd t jt ddkd|gd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t jt ddkdgd	d t dtjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddn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dnddtjdtjddd	dtjd~t
 ddtjdtjdpdd	dtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtj	ddnddtjdtj	ddnddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdt 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dlgdgtd|gdgtdgdgtdgdgtd- t jt dddlgd	d t jt dddmgd	d t jt dddogd	d t jt dddqgd	d t jt dddrgd	d t jt dddsgd	d t jt dddtgd	d t jt dddugd	d t jt dddvg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ddzgd	d t jt ddd{gdd t jt ddd|gd	d t jt dddgd	d t jt d¡ddgd	d t jt dáddgd	d t jt dġddgd	d t jt dšddgd	d t jt dơddgd	d t jt dǡddgd	d t jt dȡddgd	d t jt dɡddgd	d t dtjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjd|tjddddtjdtjddddtjd}tj	ddnddtjdtjddd	dtjd~t
 ddtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtjddddtjdtj	ddnddtjdtj	ddnddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdtjdddЍddtjdt 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dlgdgtd|gdgtdgdgtdgdgtdgdgtdgdgtd1 t jt dӡddlgd	d t jt dԡddmgd	d t jt dաddogd	d t jt d֡ddqgd	d t jt dסddrgd	d t jt dءddsgd	d t jt d١ddtgd	d t jt dڡddugd	d t jt dۡddvg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ߡddzgd	d t jt ddd{gdd t jt ddd|gd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddg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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dd
gd	d t jt dddgd	d t 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d
gdgtdgdgtd
 t jt ddd
gd	d t jt dddgd	d t dtjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjd|tjddddtjdtjddddtjdtjddddtjd}tj	ddnddtjdtjddddtjdtjdddЍddtjdtjddd	dtjd~t
 ddtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtj	ddnddtjdtj	ddnddtjdtjddddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdt 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dlgdgtd|gdgtdgdgtdgdgtdgdgtdgdgtdgdgtd4 t jt dddlgd	d t jt dddmgd	d t jt dddogd	d t jt dddqgd	d t jt dddrgd	d t jt d ddsgd	d t jt dddtgd	d t jt dddugd	d t jt dddvg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ddzgd	d t jt ddd{gdd t jt d	dd|gd	d t jt d
ddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t jt dddgd	d t dtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjdtjdddЍddtjdtjddddtjdtjddd	dtjdtjddddtjdtjdddЍddtjdtjddddtjdt ddtdgdgtdgdgtd t jt dddqgd	d t jt dddrgd	d t jt dddsgd	d t jt dddtgd	d t jt d ddugd	d t jt d!ddvg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dzgd	d t jt d&dd{gdd t jt d'ddgd	d t jt d(ddgd	d t d)tjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjd|tjddddtjdtjddddtjdtjddddtjd}tj	ddnddtjdtjddddtjdtjddd	dtjd~t
 ddtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtj	ddnddtjdtj	ddnddtjdtjddddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdt 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dlgdgtd|gdgtdgdgtdgdgtdgdgtdgdgtdgdgtd3 t jt d*d)dlgd	d t jt d+d)dmgd	d t jt d,d)dogd	d t jt d-d)dqgd	d t jt d.d)drgd	d t jt d/d)dsgd	d t jt d0d)dtgd	d t jt d1d)dugd	d t jt d2d)dvgd	d t jt d3d)dwgd	d t jt d4d)dxgd	d t jt d5d)dygd	d t jt d6d)dzgd	d t jt d7d)d{gdd t jt d8d)d|gd	d t jt d9d)dgd	d t jt d:d)dgd	d t jt d;d)dgd	d t jt d<d)dgd	d t jt d=d)dgd	d t jt d>d)dgd	d t jt d?d)dgd	d t jt d@d)dgd	d t jt dAd)dgd	d t jt dBd)dgd	d t jt dCd)dgd	d t jt dDd)dgd	d t jt dEd)dgd	d t dFtjdltjddddtjdmtj	ddnddtjdotjdpdddtjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjd|tjddddtjdtjddddtjdtjddddtjd}tj	ddnddtjdtjddddtjdtjdddЍddtjdtjddd	dtjd~t
 ddtjdtjdpdddtjdtjdd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jdtjdpdddtjdtj	ddnddtjdtj	ddnddtjdtj	ddnddtjdtjddddtjdtjdpdd	dtjdtjddddtjdtjddddtjdtjddddtjdtj	ddnddtjdt 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dlgdgtd|gdgtdgdgtdgdgtdgdgtdgdgtdgdgtd4 t jt dGdFdlgd	d t jt dHdFdmgd	d t jt dIdFdogd	d t jt dJdFdqgd	d t jt dKdFdrgd	d t jt dLdFdsgd	d t jt dMdFdtgd	d t jt dNdFdugd	d t jt dOdFdvgd	d t jt dPdFdwgd	d t jt dQdFdxgd	d t jt dRdFdygd	d t jt dSdFdzgd	d t jt dTdFd{gdd t jt dUdFd|gd	d t jt dVdFdgd	d t jt dWdFdgd	d t jt dXdFdgd	d t jt dYdFdgd	d t jt dZdFdgd	d t jt d[dFdgd	d t jt d\dFdgd	d t jt d]dFdgd	d t jt d^dFdgd	d t jt d_dFdgd	d t jt d`dFdgd	d t jt dadFdgd	d t jt dbdFdgd	d t dctjdqtjddddtjdrtj	ddnddtjdst
 d	dtjdttj	ddnddtjdutjddddtjdvtj	ddnddtjdwtjddddtjdxtjddddtjdyt ddtjdztj	ddnddtjd{tjddddtjdtjdddЍddtjdtjddddtjdtjddd	dtjdtjddddtjdtjdddЍddtjdtjddddtjdt ddtdgdgtdgdgtd t jt dddcdqgd	d t jt dedcdrgd	d t jt dfdcdsgd	d t jt dgdcdtgd	d t jt dhdcdugd	d t jt didcdvgd	d t jt djdcdwgd	d t jt dkdcdxgd	d t jt dldcdygd	d t jt dmdcdzgd	d t jt dndcd{gdd t jt dodcdgd	d t jt dpdcdgd	d t dq t dr t ds t dt t du t dv t dw t dx t dy t dz t d{ t d| t d} t d~ t d t d t d t d t d t d t d t d t dtjdtjdddd t jt dddgd	d t d dddgdg d S (  Ncmf_deal_executorsdescription   lengthTnullableid@   Fleft_idleft_name_cache   	parent_idright_idright_name_cacheroot_idix_cmf_deal_executors_left_iduniqueix_cmf_deal_executors_parent_idix_cmf_deal_executors_right_idix_cmf_deal_executors_root_idcmf_deal_related_objects#ix_cmf_deal_related_objects_left_id%ix_cmf_deal_related_objects_parent_id$ix_cmf_deal_related_objects_right_id#ix_cmf_deal_related_objects_root_idcmf_deal_spectatorsix_cmf_deal_spectators_left_id ix_cmf_deal_spectators_parent_idix_cmf_deal_spectators_right_idix_cmf_deal_spectators_root_idcmf_invoice_executors ix_cmf_invoice_executors_left_id"ix_cmf_invoice_executors_parent_id!ix_cmf_invoice_executors_right_id ix_cmf_invoice_executors_root_idcmf_invoice_related_objects&ix_cmf_invoice_related_objects_left_id(ix_cmf_invoice_related_objects_parent_id'ix_cmf_invoice_related_objects_right_id&ix_cmf_invoice_related_objects_root_idcmf_invoice_spectators!ix_cmf_invoice_spectators_left_id#ix_cmf_invoice_spectators_parent_id"ix_cmf_invoice_spectators_right_id!ix_cmf_invoice_spectators_root_idcmf_lead_executorsix_cmf_lead_executors_left_idix_cmf_lead_executors_parent_idix_cmf_lead_executors_right_idix_cmf_lead_executors_root_idcmf_lead_related_objects#ix_cmf_lead_related_objects_left_id%ix_cmf_lead_related_objects_parent_id$ix_cmf_lead_related_objects_right_id#ix_cmf_lead_related_objects_root_idcmf_lead_spectatorsix_cmf_lead_spectators_left_id ix_cmf_lead_spectators_parent_idix_cmf_lead_spectators_right_idix_cmf_lead_spectators_root_idcmf_payment_executors ix_cmf_payment_executors_left_id"ix_cmf_payment_executors_parent_id!ix_cmf_payment_executors_right_id ix_cmf_payment_executors_root_idcmf_payment_related_objects&ix_cmf_payment_related_objects_left_id(ix_cmf_payment_related_objects_parent_id'ix_cmf_payment_related_objects_right_id&ix_cmf_payment_related_objects_root_idcmf_payment_spectators!ix_cmf_payment_spectators_left_id#ix_cmf_payment_spectators_parent_id"ix_cmf_payment_spectators_right_id!ix_cmf_payment_spectators_root_idcmf_pipeline_executors!ix_cmf_pipeline_executors_left_id#ix_cmf_pipeline_executors_parent_id"ix_cmf_pipeline_executors_right_id!ix_cmf_pipeline_executors_root_idcmf_pipeline_related_objects'ix_cmf_pipeline_related_objects_left_id)ix_cmf_pipeline_related_objects_parent_id(ix_cmf_pipeline_related_objects_right_id'ix_cmf_pipeline_related_objects_root_idcmf_pipeline_spectators"ix_cmf_pipeline_spectators_left_id$ix_cmf_pipeline_spectators_parent_id#ix_cmf_pipeline_spectators_right_id"ix_cmf_pipeline_spectators_root_idcmf_sales_order_executors$ix_cmf_sales_order_executors_left_id&ix_cmf_sales_order_executors_parent_id%ix_cmf_sales_order_executors_right_id$ix_cmf_sales_order_executors_root_idcmf_sales_order_related_objects*ix_cmf_sales_order_related_objects_left_id,ix_cmf_sales_order_related_objects_parent_id+ix_cmf_sales_order_related_objects_right_id*ix_cmf_sales_order_related_objects_root_idcmf_sales_order_spectators%ix_cmf_sales_order_spectators_left_id'ix_cmf_sales_order_spectators_parent_id&ix_cmf_sales_order_spectators_right_id%ix_cmf_sales_order_spectators_root_idcmf_lead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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tagstexttime_estimatetree_parent_idutm_markwaiting_for_idcmf_activity.idcmf_company.idcmf_project.idcmf_status.idix_cmf_lead_activity_idix_cmf_lead_alarm_dateix_cmf_lead_cache_status_typeix_cmf_lead_cmf_author_idix_cmf_lead_cmf_created_atix_cmf_lead_cmf_deletedix_cmf_lead_cmf_locked_atix_cmf_lead_cmf_locked_by_idix_cmf_lead_cmf_modified_atix_cmf_lead_cmf_modified_by_idix_cmf_lead_cmf_owner_idix_cmf_lead_cmf_versionix_cmf_lead_cmf_viewed_atix_cmf_lead_codeix_cmf_lead_company_idix_cmf_lead_nameix_cmf_lead_ordernoix_cmf_lead_parent_task_id ix_cmf_lead_period_clone_from_idix_cmf_lead_project_idix_cmf_lead_responsible_idix_cmf_lead_status_idix_cmf_lead_tree_parent_idix_cmf_lead_waiting_for_idcmf_pipeline	list_typeix_cmf_pipeline_activity_idix_cmf_pipeline_alarm_date!ix_cmf_pipeline_cache_status_typeix_cmf_pipeline_cmf_author_idix_cmf_pipeline_cmf_created_atix_cmf_pipeline_cmf_deletedix_cmf_pipeline_cmf_locked_at ix_cmf_pipeline_cmf_locked_by_idix_cmf_pipeline_cmf_modified_at"ix_cmf_pipeline_cmf_modified_by_idix_cmf_pipeline_cmf_owner_idix_cmf_pipeline_cmf_versionix_cmf_pipeline_cmf_viewed_atix_cmf_pipeline_codeix_cmf_pipeline_company_idix_cmf_pipeline_nameix_cmf_pipeline_ordernoix_cmf_pipeline_parent_task_id$ix_cmf_pipeline_period_clone_from_idix_cmf_pipeline_project_idix_cmf_pipeline_responsible_idix_cmf_pipeline_status_idix_cmf_pipeline_tree_parent_idix_cmf_pipeline_waiting_for_idcmf_dealcurrency_idpipeline_idsumma      	precisionscalecmf_currency.idzcmf_pipeline.idix_cmf_deal_activity_idix_cmf_deal_alarm_dateix_cmf_deal_cache_status_typeix_cmf_deal_cmf_author_idix_cmf_deal_cmf_created_atix_cmf_deal_cmf_deletedix_cmf_deal_cmf_locked_atix_cmf_deal_cmf_locked_by_idix_cmf_deal_cmf_modified_atix_cmf_deal_cmf_modified_by_idix_cmf_deal_cmf_owner_idix_cmf_deal_cmf_versionix_cmf_deal_cmf_viewed_atix_cmf_deal_codeix_cmf_deal_company_idix_cmf_deal_currency_idix_cmf_deal_nameix_cmf_deal_ordernoix_cmf_deal_parent_task_id ix_cmf_deal_period_clone_from_idix_cmf_deal_pipeline_idix_cmf_deal_project_idix_cmf_deal_responsible_idix_cmf_deal_status_idix_cmf_deal_tree_parent_idix_cmf_deal_waiting_for_idcmf_deal_cmf_companyzcmf_deal.idix_cmf_deal_cmf_company_left_id ix_cmf_deal_cmf_company_right_idcmf_deal_cmf_personcmf_person.idix_cmf_deal_cmf_person_left_idix_cmf_deal_cmf_person_right_idcmf_invoicecustomer_iddeal_iddiscountprint_tmpl_idcmf_print_tmpl.idix_cmf_invoice_activity_idix_cmf_invoice_alarm_date ix_cmf_invoice_cache_status_typeix_cmf_invoice_cmf_author_idix_cmf_invoice_cmf_created_atix_cmf_invoice_cmf_deletedix_cmf_invoice_cmf_locked_atix_cmf_invoice_cmf_locked_by_idix_cmf_invoice_cmf_modified_at!ix_cmf_invoice_cmf_modified_by_idix_cmf_invoice_cmf_owner_idix_cmf_invoice_cmf_versionix_cmf_invoice_cmf_viewed_atix_cmf_invoice_codeix_cmf_invoice_company_idix_cmf_invoice_currency_idix_cmf_invoice_customer_idix_cmf_invoice_deal_idix_cmf_invoice_nameix_cmf_invoice_ordernoix_cmf_invoice_parent_task_id#ix_cmf_invoice_period_clone_from_idix_cmf_invoice_print_tmpl_idix_cmf_invoice_project_idix_cmf_invoice_responsible_idix_cmf_invoice_status_idix_cmf_invoice_tree_parent_idix_cmf_invoice_waiting_for_idcmf_invoice_itemscountprice
product_idcmf_product.id"ix_cmf_invoice_items_cmf_author_id#ix_cmf_invoice_items_cmf_created_at ix_cmf_invoice_items_cmf_deleted"ix_cmf_invoice_items_cmf_locked_at%ix_cmf_invoice_items_cmf_locked_by_id$ix_cmf_invoice_items_cmf_modified_at'ix_cmf_invoice_items_cmf_modified_by_id!ix_cmf_invoice_items_cmf_owner_id ix_cmf_invoice_items_cmf_version"ix_cmf_invoice_items_cmf_viewed_atix_cmf_invoice_items_codeix_cmf_invoice_items_deal_idix_cmf_invoice_items_product_idcmf_paymentix_cmf_payment_activity_idix_cmf_payment_alarm_date ix_cmf_payment_cache_status_typeix_cmf_payment_cmf_author_idix_cmf_payment_cmf_created_atix_cmf_payment_cmf_deletedix_cmf_payment_cmf_locked_atix_cmf_payment_cmf_locked_by_idix_cmf_payment_cmf_modified_at!ix_cmf_payment_cmf_modified_by_idix_cmf_payment_cmf_owner_idix_cmf_payment_cmf_versionix_cmf_payment_cmf_viewed_atix_cmf_payment_codeix_cmf_payment_company_idix_cmf_payment_currency_idix_cmf_payment_customer_idix_cmf_payment_deal_idix_cmf_payment_nameix_cmf_payment_ordernoix_cmf_payment_parent_task_id#ix_cmf_payment_period_clone_from_idix_cmf_payment_print_tmpl_idix_cmf_payment_project_idix_cmf_payment_responsible_idix_cmf_payment_status_idix_cmf_payment_tree_parent_idix_cmf_payment_waiting_for_idcmf_sales_orderix_cmf_sales_order_activity_idix_cmf_sales_order_alarm_date$ix_cmf_sales_order_cache_status_type ix_cmf_sales_order_cmf_author_id!ix_cmf_sales_order_cmf_created_atix_cmf_sales_order_cmf_deleted ix_cmf_sales_order_cmf_locked_at#ix_cmf_sales_order_cmf_locked_by_id"ix_cmf_sales_order_cmf_modified_at%ix_cmf_sales_order_cmf_modified_by_idix_cmf_sales_order_cmf_owner_idix_cmf_sales_order_cmf_version ix_cmf_sales_order_cmf_viewed_atix_cmf_sales_order_codeix_cmf_sales_order_company_idix_cmf_sales_order_currency_idix_cmf_sales_order_customer_idix_cmf_sales_order_deal_idix_cmf_sales_order_nameix_cmf_sales_order_orderno!ix_cmf_sales_order_parent_task_id'ix_cmf_sales_order_period_clone_from_id ix_cmf_sales_order_print_tmpl_idix_cmf_sales_order_project_id!ix_cmf_sales_order_responsible_idix_cmf_sales_order_status_id!ix_cmf_sales_order_tree_parent_id!ix_cmf_sales_order_waiting_for_idcmf_sales_order_items&ix_cmf_sales_order_items_cmf_author_id'ix_cmf_sales_order_items_cmf_created_at$ix_cmf_sales_order_items_cmf_deleted&ix_cmf_sales_order_items_cmf_locked_at)ix_cmf_sales_order_items_cmf_locked_by_id(ix_cmf_sales_order_items_cmf_modified_at+ix_cmf_sales_order_items_cmf_modified_by_id%ix_cmf_sales_order_items_cmf_owner_id$ix_cmf_sales_order_items_cmf_version&ix_cmf_sales_order_items_cmf_viewed_atix_cmf_sales_order_items_code ix_cmf_sales_order_items_deal_id#ix_cmf_sales_order_items_product_idcmf_u_work_deal_related_objectscmf_u_work_billcmf_deal_productcmf_u_work_sales_list_executorscmf_u_work_deal_cmf_personcmf_u_work_bill_executorscmf_u_work_lead_spectatorscmf_u_work_deal_cmf_companycmf_u_work_deal%cmf_u_work_sales_list_related_objectscmf_kanban_sales_statuscmf_u_work_sales_list cmf_u_work_sales_list_spectatorscmf_u_work_leadcmf_u_work_bill_related_objectscmf_u_work_lead_related_objectscmf_u_work_sales_list_memberscmf_u_work_lead_executorscmf_u_work_deal_executorscmf_u_work_deal_spectatorscmf_kanban_sales_status_objectscmf_u_work_bill_spectators	cmf_priceix_cmf_price_currency_idcmf_currency)r   create_tablesaColumnStringCHARPrimaryKeyConstraintcreate_indexf	TIMESTAMPBooleanIntegerTEXTForeignKeyConstraintNumeric
drop_table
add_columncreate_foreign_key r  r  ./opt/eva-app/alembic/versions/f0b5bf93cfe6_.pyupgrade   s   ..25 45 ""r  c                ;   C   sI  t jd ddd t jt ddd t dd t ddd	d
gdg 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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	 ddtjd+t	j
d,dddtjd-t	jddddtjd.t	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 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	 ddtjd>t	jddddtjd?t	jd@dAdBddtjdt	jddddtjdCt	jd0d1ddd2tjdDt	j
d,dddtjdEt	j
ddddtjdFt	jd0d1ddd2tjdGt	 ddd2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	jddddtjdOt	j
d,d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	 ddtjdTt	 ddtjdUt	 ddtjdVt	 ddd2tjdWt	jddddtjdXt	jddddtjdYdZd[tjd\d]d[tjd^d_d[tjd)gd`gdad[tjd;gdbgdcd[tjdgddgded[tjd>gdfgdgd[tjdNgdhgdid[tjdPgdjgdkd[tjdRgdlgdmd[tdddd9 t jdnd(dXgdd t jdod(dWgdd t jdpd(dRgdd t jdqd(dQgdd t jdrd(dPgdd t jdsd(dNgdd t jdtd(dIgdd t jdud(dHgdd t jdvd(dGgdd t jdwd(dEgdd t jdxd(d>gdd t jdyd(d<gdd t jdzd(dgdd t jd{d(d;gdd t jd|d(d:gdd t jd}d(d9gdd t jd~d(d8gdd t jdd(d7gdd t jdd(d6gdd t jdd(d5gdd t jdd(d4gdd t jdd(d3gdd t jdd(d/gdd t jdd(d.gdd t jdd(d-gdd t jdd(d+gdd t jdd(d*gdd t jdd(d)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dt	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dt	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	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 ddtjd:t	j
ddddtjdt	j
d,dddtjdt	jddddtjdEt	j
ddddtjdGt	 ddd2tjdPt	jddddtjdt	jddddtjdRt	jddddtjdUt	 ddtjdYdd[tjdPgdjgdd[tjdgdgdd[tjdRgdlgdd[tdddd t jdddRgdd t jdddgdd t jdddPgdd t jdddGgdd t jdddEgdd t jddd:gdd t jddd9gdd t jddd8gdd t jddd7gdd t jddd6gdd t jddd5gdd t jddd4gdd t jddd3g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	 ddtjd+t	j
d,dddtjd-t	jddddtjd.t	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 ddtjd:t	j
ddddtjd;t	jddddtjd=t	 ddtjdt	jddddtjdCt	jd0d1ddd2tjdDt	j
d,dddtjdEt	j
ddddtjdFt	jd0d1ddd2tjdGt	 ddd2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dOt	j
d,d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	 ddtjdTt	 ddtjdUt	 ddtjdVt	 ddd2tjdWt	jddddtjdXt	jddddtjdYdd[tjd\dd[tjd^dd[tjd)gd`gdd[tjd;gdbgdd[tjdPgdjgdd[tjdRgdlgdd[tdddd1 t jdddXgdd t jdddWgdd t jdddRgdd t jdddQgdd t jdddPgdd t jdddIgdd t jdddHgdd t jdddGgdd t jdddEgdd t jddd;gdd t jddd:gdd t jddd9gdd t jddd8gdd t jddd7gdd t jddd6gdd t jddd5gdd t jddd4gdd t jddd3g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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	 ddtjd+t	j
d,dddtjd-t	jddddtjd.t	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 ddtjd:t	j
ddddtjd;t	jddddtjd=t	 ddtjdt	jddddtjdCt	jd0d1ddd2tjdt	j
d,dddtjdDt	j
d,dddtjdEt	j
ddddtjdFt	jd0d1ddd2tjdGt	 ddd2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dOt	j
d,d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	 ddtjdTt	 ddtjdUt	 ddtjdVt	 ddd2tjdWt	jddddtjdXt	jddddtjdYdd[tjd\dd[tjd^dd[tjd)gd`gdd[tjd;gdbgdd[tjdPgdjgdd[tjdRgdlgdd[tdddd2 t jdddXgdd t jdddWgdd t jdddRgdd t jdddQgdd t jdddPgdd t jdddIgdd t jdddHgdd t jdddGgdd t jdddEgdd t jddd;gdd t jddd:gdd t jddd9gdd t jddd8gdd t jddd7gdd t jddd6gdd t jddd5gdd t jddd4gdd t jddd3gdd t jd dd/gdd t jddd.gdd t jddd-gdd t jddd+gdd t jddd*gdd t jddd)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gdfgdd[tjdgdbg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tjdt	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	 ddtjd+t	j
d,dddtjd-t	jddddtjd.t	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 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	 ddtjdt	jddddtjdCt	jd0d1ddd2tjdDt	j
d,dddtjdEt	j
ddddtjdFt	jd0d1ddd2tjdGt	 ddd2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dOt	j
d,d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	 ddtjdt	jd@dAdBddtjdTt	 ddtjdUt	 ddtjdVt	 ddd2tjdWt	jddddtjdt	 ddtjdXt	jddddtjdYdd[tjd\dd[tjd^dd[tjd)gd`gdd[tjd;gdbgdd[tjdgddgdd[tjdPgdjgdd[tjdRgdlgdd[tdddd5 t jdddXgdd t jdddWgdd t jdddRgdd t jdddQgdd t jdddPgdd t jd ddIgdd t jd!ddHgdd t jd"ddGgdd t jd#ddEg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d9gdd t jd(dd8gdd t jd)dd7gdd t jd*dd6gdd t jd+dd5gdd t jd,dd4gdd t jd-dd3gdd t jd.dd/gdd t jd/dd.gdd t jd0dd-gdd t jd1dd+gdd t jd2dd*gdd t jd3dd)gdd t j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ddd t jd5d4dgdd t jd6d4dgdd t jd7d4dgdd t jd8d4dgdd t j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ddd t jd:d9dgdd t jd;d9dgdd t jd<d9dgdd t jd=d9d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gdfgd?d[tjdgd@gdAd[tdddd t jdBd>dgdd t jdCd>dgdd t jdDtjdt	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dEdDdgdd t jdFdDdgdd t jdGdDdgdd t jdHdDdgdd t jdItjdJt	j
ddddtjd-t	jddddtjd.t	 ddtjd/t	jd0d1ddd2tjd3t	 ddtjd4t	jddddtjd5t	 ddtjd6t	jddddtjd7t	jddddtjd8t	 ddd2tjd9t	 ddtjd:t	j
ddddtjdKt	jd@dAdBddtjd>t	jddddtjdt	jddddtjdEt	j
ddddtjdLt	jd@dAdBddtjdMt	jddddtjdUt	 ddtjdYdNd[tjd>gdfgdOd[tjdMgdPgdQd[tdddd t jdRdIdMgdd t jdSdIdEgdd t jdTdId>gdd t jdUdId:gdd t jdVdId9gdd t jdWdId8gdd t jdXdId7gdd t jdYdId6gdd t jdZdId5gdd t jd[dId4gdd t jd\dId3gdd t jd]dId/gdd t jd^dId.gdd t jd_dId-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dad`dgdd t jdbd`dgdd t jdcd`dgdd t jddd`dgdd t jt dedfd t jt dgdfd t jt dhdfd t jt didfd t jt djdfd t jt dkdfd t jt dldfd t jt dmdfd t jt dndfd t jt dodfd t jt dpdfd t jt dqdfd t jt drdfd t df t jt dsdtd t jt dudtd t jt dvdtd t jt dwdtd t jt dxdtd t jt dydtd t jt dzdtd t jt d{dtd t jt d|dtd t jt d}dtd t jt d~dtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t jt ddtd t dt 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 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 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 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 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 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 d, t jt d0d1d t jt d2d1d t jt d3d1d t jt d4d1d t d1 t jt d5d6d t jt d7d6d t jt d8d6d t jt d9d6d t d6 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 dAd@d t jt dBd@d t jt dCd@d t d@ t jt dDdEd t jt dFdEd t jt dGdEd t jt dHdEd t dE t jt dIdJd t jt dKdJd t jt dLdJd t jt dMdJd t dJ t jt dNdOd t jt dPdOd t jt dQdOd t jt dRdOd t dO t jt dSdTd t jt dUdTd t jt dVdTd t jt dWdTd t dT t jt dXdYd t jt dZdYd t jt d[dYd t jt d\dYd t dY t jt d]d^d t jt d_d^d t jt d`d^d t jt dad^d t d^ t jt dbdcd t jt dddcd t jt dedcd t jt dfdcd t dc t jt dgdhd t jt didhd t jt djdhd t jt dkdhd t dh t jt dldmd t jt dndmd t jt dodmd t jt dpdmd t dm t jt dqdrd t jt dsdrd t jt dtdrd t jt dudrd t dr t jt dvdwd t jt dxdwd t jt dydwd t jt dzdwd t dw 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 d S (  Nr  
foreignkey)type_r  )
table_namer   Zcmf_kanban_status_ibfk_2cmf_kanban_statuscmf_u_work_listwork_list_idr   r  r   r   r   Tr	   r   Fr   r   r   r   r   r   r   utf8ZInnoDB)Zmysql_default_charsetZmysql_engineZ%ix_cmf_u_work_bill_spectators_root_idr   Z&ix_cmf_u_work_bill_spectators_right_idZ'ix_cmf_u_work_bill_spectators_parent_idZ%ix_cmf_u_work_bill_spectators_left_idr  Z*ix_cmf_kanban_sales_status_objects_root_idZ+ix_cmf_kanban_sales_status_objects_right_idZ,ix_cmf_kanban_sales_status_objects_parent_idZ*ix_cmf_kanban_sales_status_objects_left_idrv  rp   rq   rs   rt   ru   rv   rw      )display_width)autoincrementr
   rx   ry   rz   r{   r|   r}   r~   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   z(`cmf_deleted` in (0,1))Zcmf_u_work_bill_chk_1)r   z(`is_penalty` in (0,1))Zcmf_u_work_bill_chk_2z(`no_control` in (0,1))Zcmf_u_work_bill_chk_3r   Zcmf_u_work_bill_ibfk_1r   Zcmf_u_work_bill_ibfk_2r   Zcmf_u_work_bill_ibfk_3zcmf_u_work_deal.idZcmf_u_work_bill_ibfk_4r   Zcmf_u_work_bill_ibfk_5r   Zcmf_u_work_bill_ibfk_6r   Zcmf_u_work_bill_ibfk_7Z!ix_cmf_u_work_bill_waiting_for_idZ!ix_cmf_u_work_bill_tree_parent_idZix_cmf_u_work_bill_status_idZ!ix_cmf_u_work_bill_responsible_idZix_cmf_u_work_bill_project_idZ ix_cmf_u_work_bill_print_tmpl_idZ'ix_cmf_u_work_bill_period_clone_from_idZ!ix_cmf_u_work_bill_parent_task_idZix_cmf_u_work_bill_ordernoZix_cmf_u_work_bill_nameZix_cmf_u_work_bill_deal_idZix_cmf_u_work_bill_customer_idZix_cmf_u_work_bill_currency_idZix_cmf_u_work_bill_company_idZix_cmf_u_work_bill_codeZ ix_cmf_u_work_bill_cmf_viewed_atZix_cmf_u_work_bill_cmf_versionZix_cmf_u_work_bill_cmf_owner_idZ%ix_cmf_u_work_bill_cmf_modified_by_idZ"ix_cmf_u_work_bill_cmf_modified_atZ#ix_cmf_u_work_bill_cmf_locked_by_idZ ix_cmf_u_work_bill_cmf_locked_atZix_cmf_u_work_bill_cmf_deletedZ!ix_cmf_u_work_bill_cmf_created_atZ ix_cmf_u_work_bill_cmf_author_idZ$ix_cmf_u_work_bill_cache_status_typeZix_cmf_u_work_bill_alarm_dateZix_cmf_u_work_bill_activity_idr  Z%ix_cmf_u_work_deal_spectators_root_idZ&ix_cmf_u_work_deal_spectators_right_idZ'ix_cmf_u_work_deal_spectators_parent_idZ%ix_cmf_u_work_deal_spectators_left_idr  Z$ix_cmf_u_work_deal_executors_root_idZ%ix_cmf_u_work_deal_executors_right_idZ&ix_cmf_u_work_deal_executors_parent_idZ$ix_cmf_u_work_deal_executors_left_idr  Z$ix_cmf_u_work_lead_executors_root_idZ%ix_cmf_u_work_lead_executors_right_idZ&ix_cmf_u_work_lead_executors_parent_idZ$ix_cmf_u_work_lead_executors_left_idr  Z(ix_cmf_u_work_sales_list_members_root_idZ)ix_cmf_u_work_sales_list_members_right_idZ*ix_cmf_u_work_sales_list_members_parent_idZ(ix_cmf_u_work_sales_list_members_left_idr  Z*ix_cmf_u_work_lead_related_objects_root_idZ+ix_cmf_u_work_lead_related_objects_right_idZ,ix_cmf_u_work_lead_related_objects_parent_idZ*ix_cmf_u_work_lead_related_objects_left_idr  Z*ix_cmf_u_work_bill_related_objects_root_idZ+ix_cmf_u_work_bill_related_objects_right_idZ,ix_cmf_u_work_bill_related_objects_parent_idZ*ix_cmf_u_work_bill_related_objects_left_idr  colorZsales_list_idZcmf_kanban_sales_status_chk_1Zcmf_kanban_sales_status_ibfk_1zcmf_u_work_sales_list.idZcmf_kanban_sales_status_ibfk_2Zcmf_kanban_sales_status_ibfk_3Z$ix_cmf_kanban_sales_status_status_idZ(ix_cmf_kanban_sales_status_sales_list_idZ%ix_cmf_kanban_sales_status_project_idZ"ix_cmf_kanban_sales_status_ordernoZix_cmf_kanban_sales_status_nameZix_cmf_kanban_sales_status_codeZ(ix_cmf_kanban_sales_status_cmf_viewed_atZ&ix_cmf_kanban_sales_status_cmf_versionZ'ix_cmf_kanban_sales_status_cmf_owner_idZ-ix_cmf_kanban_sales_status_cmf_modified_by_idZ*ix_cmf_kanban_sales_status_cmf_modified_atZ+ix_cmf_kanban_sales_status_cmf_locked_by_idZ(ix_cmf_kanban_sales_status_cmf_locked_atZ&ix_cmf_kanban_sales_status_cmf_deletedZ)ix_cmf_kanban_sales_status_cmf_created_atZ(ix_cmf_kanban_sales_status_cmf_author_idr  Zcmf_u_work_lead_chk_1Zcmf_u_work_lead_chk_2Zcmf_u_work_lead_chk_3Zcmf_u_work_lead_ibfk_1Zcmf_u_work_lead_ibfk_2Zcmf_u_work_lead_ibfk_3Zcmf_u_work_lead_ibfk_4Z!ix_cmf_u_work_lead_waiting_for_idZ!ix_cmf_u_work_lead_tree_parent_idZix_cmf_u_work_lead_status_idZ!ix_cmf_u_work_lead_responsible_idZix_cmf_u_work_lead_project_idZ'ix_cmf_u_work_lead_period_clone_from_idZ!ix_cmf_u_work_lead_parent_task_idZix_cmf_u_work_lead_ordernoZix_cmf_u_work_lead_nameZix_cmf_u_work_lead_company_idZix_cmf_u_work_lead_codeZ ix_cmf_u_work_lead_cmf_viewed_atZix_cmf_u_work_lead_cmf_versionZix_cmf_u_work_lead_cmf_owner_idZ%ix_cmf_u_work_lead_cmf_modified_by_idZ"ix_cmf_u_work_lead_cmf_modified_atZ#ix_cmf_u_work_lead_cmf_locked_by_idZ ix_cmf_u_work_lead_cmf_locked_atZix_cmf_u_work_lead_cmf_deletedZ!ix_cmf_u_work_lead_cmf_created_atZ ix_cmf_u_work_lead_cmf_author_idZ$ix_cmf_u_work_lead_cache_status_typeZix_cmf_u_work_lead_alarm_dateZix_cmf_u_work_lead_activity_idr  Z+ix_cmf_u_work_sales_list_spectators_root_idZ,ix_cmf_u_work_sales_list_spectators_right_idZ-ix_cmf_u_work_sales_list_spectators_parent_idZ+ix_cmf_u_work_sales_list_spectators_left_idr  r   Zcmf_u_work_sales_list_chk_1Zcmf_u_work_sales_list_chk_2Zcmf_u_work_sales_list_chk_3Zcmf_u_work_sales_list_ibfk_1Zcmf_u_work_sales_list_ibfk_2Zcmf_u_work_sales_list_ibfk_3Zcmf_u_work_sales_list_ibfk_4Z'ix_cmf_u_work_sales_list_waiting_for_idZ'ix_cmf_u_work_sales_list_tree_parent_idZ"ix_cmf_u_work_sales_list_status_idZ'ix_cmf_u_work_sales_list_responsible_idZ#ix_cmf_u_work_sales_list_project_idZ-ix_cmf_u_work_sales_list_period_clone_from_idZ'ix_cmf_u_work_sales_list_parent_task_idZ ix_cmf_u_work_sales_list_ordernoZix_cmf_u_work_sales_list_nameZ#ix_cmf_u_work_sales_list_company_idZix_cmf_u_work_sales_list_codeZ&ix_cmf_u_work_sales_list_cmf_viewed_atZ$ix_cmf_u_work_sales_list_cmf_versionZ%ix_cmf_u_work_sales_list_cmf_owner_idZ+ix_cmf_u_work_sales_list_cmf_modified_by_idZ(ix_cmf_u_work_sales_list_cmf_modified_atZ)ix_cmf_u_work_sales_list_cmf_locked_by_idZ&ix_cmf_u_work_sales_list_cmf_locked_atZ$ix_cmf_u_work_sales_list_cmf_deletedZ'ix_cmf_u_work_sales_list_cmf_created_atZ&ix_cmf_u_work_sales_list_cmf_author_idZ*ix_cmf_u_work_sales_list_cache_status_typeZ#ix_cmf_u_work_sales_list_alarm_dateZ$ix_cmf_u_work_sales_list_activity_idr|  Z"cmf_u_work_deal_cmf_company_ibfk_1Z"cmf_u_work_deal_cmf_company_ibfk_2Z'ix_cmf_u_work_deal_cmf_company_right_idZ&ix_cmf_u_work_deal_cmf_company_left_idr~  Z0ix_cmf_u_work_sales_list_related_objects_root_idZ1ix_cmf_u_work_sales_list_related_objects_right_idZ2ix_cmf_u_work_sales_list_related_objects_parent_idZ0ix_cmf_u_work_sales_list_related_objects_left_idr}  r   r   Zcmf_u_work_deal_chk_1Zcmf_u_work_deal_chk_2Zcmf_u_work_deal_chk_3Zcmf_u_work_deal_ibfk_1Zcmf_u_work_deal_ibfk_2Zcmf_u_work_deal_ibfk_3Zcmf_u_work_deal_ibfk_4Zcmf_u_work_deal_ibfk_5Z!ix_cmf_u_work_deal_waiting_for_idZ!ix_cmf_u_work_deal_tree_parent_idZix_cmf_u_work_deal_status_idZ!ix_cmf_u_work_deal_responsible_idZix_cmf_u_work_deal_project_idZ'ix_cmf_u_work_deal_period_clone_from_idZ!ix_cmf_u_work_deal_parent_task_idZix_cmf_u_work_deal_ordernoZix_cmf_u_work_deal_nameZix_cmf_u_work_deal_currency_idZix_cmf_u_work_deal_company_idZix_cmf_u_work_deal_codeZ ix_cmf_u_work_deal_cmf_viewed_atZix_cmf_u_work_deal_cmf_versionZix_cmf_u_work_deal_cmf_owner_idZ%ix_cmf_u_work_deal_cmf_modified_by_idZ"ix_cmf_u_work_deal_cmf_modified_atZ#ix_cmf_u_work_deal_cmf_locked_by_idZ ix_cmf_u_work_deal_cmf_locked_atZix_cmf_u_work_deal_cmf_deletedZ!ix_cmf_u_work_deal_cmf_created_atZ ix_cmf_u_work_deal_cmf_author_idZ$ix_cmf_u_work_deal_cache_status_typeZix_cmf_u_work_deal_alarm_dateZix_cmf_u_work_deal_activity_idr{  Z%ix_cmf_u_work_lead_spectators_root_idZ&ix_cmf_u_work_lead_spectators_right_idZ'ix_cmf_u_work_lead_spectators_parent_idZ%ix_cmf_u_work_lead_spectators_left_idrz  Z$ix_cmf_u_work_bill_executors_root_idZ%ix_cmf_u_work_bill_executors_right_idZ&ix_cmf_u_work_bill_executors_parent_idZ$ix_cmf_u_work_bill_executors_left_idry  Z!cmf_u_work_deal_cmf_person_ibfk_1r   Z!cmf_u_work_deal_cmf_person_ibfk_2Z&ix_cmf_u_work_deal_cmf_person_right_idZ%ix_cmf_u_work_deal_cmf_person_left_idrx  Z*ix_cmf_u_work_sales_list_executors_root_idZ+ix_cmf_u_work_sales_list_executors_right_idZ,ix_cmf_u_work_sales_list_executors_parent_idZ*ix_cmf_u_work_sales_list_executors_left_idrw  Zcache_product_namer  r  r  Zcmf_deal_product_chk_1Zcmf_deal_product_ibfk_1r  Zcmf_deal_product_ibfk_2Zix_cmf_deal_product_product_idZix_cmf_deal_product_nameZix_cmf_deal_product_deal_idZix_cmf_deal_product_codeZ!ix_cmf_deal_product_cmf_viewed_atZix_cmf_deal_product_cmf_versionZ ix_cmf_deal_product_cmf_owner_idZ&ix_cmf_deal_product_cmf_modified_by_idZ#ix_cmf_deal_product_cmf_modified_atZ$ix_cmf_deal_product_cmf_locked_by_idZ!ix_cmf_deal_product_cmf_locked_atZix_cmf_deal_product_cmf_deletedZ"ix_cmf_deal_product_cmf_created_atZ!ix_cmf_deal_product_cmf_author_idru  Z*ix_cmf_u_work_deal_related_objects_root_idZ+ix_cmf_u_work_deal_related_objects_right_idZ,ix_cmf_u_work_deal_related_objects_parent_idZ*ix_cmf_u_work_deal_related_objects_left_idrt  rg  rs  rr  rq  rp  ro  rn  rm  rl  rk  rj  ri  rh  rf  rJ  re  rd  rc  rb  ra  r`  r_  r^  r]  r\  r[  rZ  rY  rX  rW  rV  rU  rT  rS  rR  rQ  rP  rO  rN  rM  rL  rK  rI  r-  rH  rG  rF  rE  rD  rC  rB  rA  r@  r?  r>  r=  r<  r;  r:  r9  r8  r7  r6  r5  r4  r3  r2  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  r  r  r  r  r  r  r
  r	  r  r  r  r  r  r  r  r  r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   ro   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rn   rj   rm   rl   rk   ri   re   rh   rg   rf   rd   r`   rc   rb   ra   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   drop_constraint
drop_indexr  drop_columnr  r  r  r  r   VARCHARr  r  r  r  TINYINTINTEGERDECIMALr  CheckConstraintr  r  r  r  r  r  	downgrade.  s~   :236r  )__doc__alembicr   
sqlalchemyr  Zsqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr  r  r  r  r  r  <module>   s"           #