U \d@s<dZddlmZddlZdZdZdZdZddZ dd Z dS) zhempty message Revision ID: e6f3638c1fe2 Revises: 77585914594c Create Date: 2020-12-02 12:31:25.131671 )opN e6f3638c1fe2 77585914594cc0Cs(tdtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtddd gd dtjtddd gd dtjtdddgd dtjtdddgd dtdtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtddd gd dtjtddd gd dtjtdddgd dtjtdddgd dtdtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtddd gd dtjtddd gd dtjtdddgd dtjtdddgd dtd tjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtd/d d!gd dtjtd0d d"gd dtjtd1d d&gd dtjtd2d d(gd dtjtd3d d)gd dtjtd4d d,gddtjtd5d d-gd dtd6tjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtd7d6d gd dtjtd8d6d gd dtjtd9d6dgd dtjtd:d6dgd dtd;tjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtd<d;d gd dtjtd=d;d gd dtjtd>d;dgd dtjtd?d;dgd dtd@tjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtdAd@d gd dtjtdBd@d gd dtjtdCd@dgd dtjtdDd@dgd dtdEtjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtdFdEd!gd dtjtdGdEd"gd dtjtdHdEd&gd dtjtdIdEd(gd dtjtdJdEd)gd dtjtdKdEd,gddtjtdLdEd-gd dtdMtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtdNdMd gd dtjtdOdMd gd dtjtdPdMdgd dtjtdQdMdgd dtdRtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtdSdRd gd dtjtdTdRd gd dtjtdUdRdgd dtjtdVdRdgd dtdWtjdtjddddtjdtjddd dtjd tjddddtjd tjd dddtjd tjddddtjdtjddddtjdtjd dddtjdtjddddtd tjtdXdWd gd dtjtdYdWd gd dtjtdZdWdgd dtjtd[dWdgd dtd\tjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtd]d\d!gd dtjtd^d\d"gd dtjtd_d\d&gd dtjtd`d\d(gd dtjtdad\d)gd dtjtdbd\d,gddtjtdcd\d-gd dtddtjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtdeddd!gd dtjtdfddd"gd dtjtdgddd&gd dtjtdhddd(gd dtjtdiddd)gd dtjtdjddd,gddtjtdkddd-gd dtdltjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtdmdld!gd dtjtdndld"gd dtjtdodld&gd dtjtdpdld(gd dtjtdqdld)gd dtjtdrdld,gddtjtdsdld-gd dtdttjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd.t ddtdtjtdudtd!gd dtjtdvdtd"gd dtjtdwdtd&gd dtjtdxdtd(gd dtjtdydtd)gd dtjtdzdtd,gddtjtd{dtd-gd dtd|tjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddd dtjd-tjd dddtjd}tj d~ddddtjdtjddddtjd.t ddtjdtjddddtdgdgtdtjtdd|d!gd dtjtdd|d"gd dtjtdd|d&gd dtjtdd|d(gd dtjtdd|d)gd dtjtdd|d,gddtjtdd|d-gd dtjtdd|dgd dtdtjdtjddddtjdtj dd#ddtjdtjddddtjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddddtjdtj dd#ddtjdtjddd dtjdt ddtjdtjddddtjd-tjd dddtjdt ddtjdt ddtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdtj dd#ddtjdtj dd#ddtjdtjddd dtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdt ddtjd.t ddtjdt ddtjdtjddddtjdtjddddtdgdgtdgdgtdgdgtdgdgtd,tjtdddgd dtjtdddgd dtjtdddgd dtjtddd!gd dtjtddd"gd dtjtddd&gd dtjtddd(gd dtjtddd)gd dtjtddd,gddtjtdddgd dtjtddd-gd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtdtjdtjddddtjdtj dd#ddtjdtjddddtjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddddtjdtj dd#ddtjdtjddd dtjdt ddtjdtjddddtjd-tjd dddtjdt ddtjdt ddtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdtj dd#ddtjdtj dd#ddtjdtjddd dtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdt ddtjd.t ddtjdt ddtjdtjddddtjdtjddddtdgdgtdgdgtdgdgtdgdgtd,tjtdddgd dtjtdddgd dtjtdddgd dtjtddd!gd dtjtd¡dd"gd dtjtdádd&gd dtjtdġdd(gd dtjtdšdd)gd dtjtdơdd,gddtjtdǡddgd dtjtdȡdd-gd dtjtdɡddgd dtjtdʡddgd dtjtdˡddgd dtjtd̡ddgd dtjtd͡ddgd dtjtdΡddgd dtjtdϡddgd dtjtdСddgd dtdtjdtjddddtjdtj dd#ddtjdtjddddtjd!tjddddtjd"tj dd#ddtjd$t d dtjd%tj dd#ddtjd&tjddddtjd'tj dd#ddtjd(tjddddtjd)tjddddtjd*t ddtjd+tj dd#ddtjd,tjddddtjdtjddddtjdtj dd#ddtjdtjddd dtjdt ddtjdtjddddtjd-tjd dddtjdt ddtjdt ddtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdtj dd#ddtjdtj dd#ddtjdtjddd dtjdtjddddtjdtjddddtjdtjddddtjdtj dd#ddtjdt ddtjd.t ddtjdt ddtjdtjddddtjdtjddddtdgdgtdgdgtdgdgtdgdgtd,tjtdҡddgd dtjtdӡddgd dtjtdԡddgd dtjtdաdd!gd dtjtd֡dd"gd dtjtdסdd&gd dtjtdءdd(gd dtjtd١dd)gd dtjtdڡdd,gddtjtdۡddgd dtjtdܡdd-gd dtjtdݡddgd dtjtdޡddgd dtjtdߡddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd dtjtdddgd ddS)Ncmf_bill_executors descriptioni)lengthT)nullableid@Fleft_idleft_name_cache parent_idright_idright_name_cacheroot_idix_cmf_bill_executors_left_id)uniqueix_cmf_bill_executors_parent_idix_cmf_bill_executors_right_idix_cmf_bill_executors_root_idcmf_bill_related_objects#ix_cmf_bill_related_objects_left_id%ix_cmf_bill_related_objects_parent_id$ix_cmf_bill_related_objects_right_id#ix_cmf_bill_related_objects_root_idcmf_bill_spectatorsix_cmf_bill_spectators_left_id ix_cmf_bill_spectators_parent_idix_cmf_bill_spectators_right_idix_cmf_bill_spectators_root_id cmf_currency cmf_author_idcmf_created_at)timezone cmf_deleted cmf_locked_atcmf_locked_by_idcmf_modified_atcmf_modified_by_id cmf_owner_id cmf_version cmf_viewed_atcodenametextix_cmf_currency_cmf_author_idix_cmf_currency_cmf_created_at ix_cmf_currency_cmf_locked_by_id"ix_cmf_currency_cmf_modified_by_idix_cmf_currency_cmf_owner_idix_cmf_currency_codeix_cmf_currency_namecmf_deal_executorsix_cmf_deal_executors_left_idix_cmf_deal_executors_parent_idix_cmf_deal_executors_right_idix_cmf_deal_executors_root_idcmf_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_idcmf_deal_spectatorsix_cmf_deal_spectators_left_id ix_cmf_deal_spectators_parent_idix_cmf_deal_spectators_right_idix_cmf_deal_spectators_root_idcmf_integration ix_cmf_integration_cmf_author_id!ix_cmf_integration_cmf_created_at#ix_cmf_integration_cmf_locked_by_id%ix_cmf_integration_cmf_modified_by_idix_cmf_integration_cmf_owner_idix_cmf_integration_codeix_cmf_integration_namecmf_lead_executorsix_cmf_lead_executors_left_idix_cmf_lead_executors_parent_idix_cmf_lead_executors_right_idix_cmf_lead_executors_root_idcmf_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_idcmf_lead_spectatorsix_cmf_lead_spectators_left_id ix_cmf_lead_spectators_parent_idix_cmf_lead_spectators_right_idix_cmf_lead_spectators_root_id cmf_priceix_cmf_price_cmf_author_idix_cmf_price_cmf_created_atix_cmf_price_cmf_locked_by_idix_cmf_price_cmf_modified_by_idix_cmf_price_cmf_owner_idix_cmf_price_codeix_cmf_price_namecmf_print_tmplix_cmf_print_tmpl_cmf_author_id ix_cmf_print_tmpl_cmf_created_at"ix_cmf_print_tmpl_cmf_locked_by_id$ix_cmf_print_tmpl_cmf_modified_by_idix_cmf_print_tmpl_cmf_owner_idix_cmf_print_tmpl_codeix_cmf_print_tmpl_namecmf_subscription!ix_cmf_subscription_cmf_author_id"ix_cmf_subscription_cmf_created_at$ix_cmf_subscription_cmf_locked_by_id&ix_cmf_subscription_cmf_modified_by_id ix_cmf_subscription_cmf_owner_idix_cmf_subscription_codeix_cmf_subscription_namecmf_unitix_cmf_unit_cmf_author_idix_cmf_unit_cmf_created_atix_cmf_unit_cmf_locked_by_idix_cmf_unit_cmf_modified_by_idix_cmf_unit_cmf_owner_idix_cmf_unit_codeix_cmf_unit_name cmf_productprice) precisionscaletax unit_idz cmf_unit.idix_cmf_product_cmf_author_idix_cmf_product_cmf_created_atix_cmf_product_cmf_locked_by_id!ix_cmf_product_cmf_modified_by_idix_cmf_product_cmf_owner_idix_cmf_product_codeix_cmf_product_nameix_cmf_product_unit_idcmf_bill activity_id alarm_datecache_status_type company_iddeadline is_penaltymark no_controlordernoparent_task_idperiod_clone_from_idperiod_intervalperiod_next_date plan_end_dateplan_start_datepriority project_idresponsible_id status_idstatus_modified_attags time_estimatetree_parent_idwaiting_for_idzcmf_activity.idzcmf_company.idzcmf_project.idz cmf_status.idix_cmf_bill_activity_idix_cmf_bill_alarm_dateix_cmf_bill_cache_status_typeix_cmf_bill_cmf_author_idix_cmf_bill_cmf_created_atix_cmf_bill_cmf_locked_by_idix_cmf_bill_cmf_modified_by_idix_cmf_bill_cmf_owner_idix_cmf_bill_codeix_cmf_bill_company_idix_cmf_bill_nameix_cmf_bill_ordernoix_cmf_bill_parent_task_id ix_cmf_bill_period_clone_from_idix_cmf_bill_project_idix_cmf_bill_responsible_idix_cmf_bill_status_idix_cmf_bill_tree_parent_idix_cmf_bill_waiting_for_idcmf_dealix_cmf_deal_activity_idix_cmf_deal_alarm_dateix_cmf_deal_cache_status_typeix_cmf_deal_cmf_author_idix_cmf_deal_cmf_created_atix_cmf_deal_cmf_locked_by_idix_cmf_deal_cmf_modified_by_idix_cmf_deal_cmf_owner_idix_cmf_deal_codeix_cmf_deal_company_idix_cmf_deal_nameix_cmf_deal_ordernoix_cmf_deal_parent_task_id ix_cmf_deal_period_clone_from_idix_cmf_deal_project_idix_cmf_deal_responsible_idix_cmf_deal_status_idix_cmf_deal_tree_parent_idix_cmf_deal_waiting_for_idcmf_leadix_cmf_lead_activity_idix_cmf_lead_alarm_dateix_cmf_lead_cache_status_typeix_cmf_lead_cmf_author_idix_cmf_lead_cmf_created_atix_cmf_lead_cmf_locked_by_idix_cmf_lead_cmf_modified_by_idix_cmf_lead_cmf_owner_idix_cmf_lead_codeix_cmf_lead_company_idix_cmf_lead_nameix_cmf_lead_ordernoix_cmf_lead_parent_task_id ix_cmf_lead_period_clone_from_idix_cmf_lead_project_idix_cmf_lead_responsible_idix_cmf_lead_status_idix_cmf_lead_tree_parent_idix_cmf_lead_waiting_for_id)r create_tablesaColumnStringCHARPrimaryKeyConstraint create_indexf TIMESTAMPBooleanIntegerTEXTNumericForeignKeyConstraintrr./opt/eva-app/alembic/versions/e6f3638c1fe2_.pyupgrades         ---rcCs tjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtd ddtjtd ddtjtd ddtjtd ddtjtd ddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtd ddtjtd!ddtjtd"ddtjtd#ddtjtd$ddtjtd%ddtjtd&ddtjtd'ddtjtd(ddtjtd)ddtdtjtd*d+dtjtd,d+dtjtd-d+dtjtd.d+dtjtd/d+dtjtd0d+dtjtd1d+dtjtd2d+dtjtd3d+dtjtd4d+dtjtd5d+dtjtd6d+dtjtd7d+dtjtd8d+dtjtd9d+dtjtd:d+dtjtd;d+dtjtd<d+dtjtd=d+dtd+tjtd>d?dtjtd@d?dtjtdAd?dtjtdBd?dtjtdCd?dtjtdDd?dtjtdEd?dtjtdFd?dtd?tjtdGdHdtjtdIdHdtjtdJdHdtjtdKdHdtjtdLdHdtjtdMdHdtjtdNdHdtdHtjtdOdPdtjtdQdPdtjtdRdPdtjtdSdPdtjtdTdPdtjtdUdPdtjtdVdPdtdPtjtdWdXdtjtdYdXdtjtdZdXdtjtd[dXdtjtd\dXdtjtd]dXdtjtd^dXdtdXtjtd_d`dtjtdad`dtjtdbd`dtjtdcd`dtjtddd`dtjtded`dtjtdfd`dtd`tjtdgdhdtjtdidhdtjtdjdhdtjtdkdhdtdhtjtdldmdtjtdndmdtjtdodmdtjtdpdmdtdmtjtdqdrdtjtdsdrdtjtdtdrdtjtdudrdtdrtjtdvdwdtjtdxdwdtjtdydwdtjtdzdwdtjtd{dwdtjtd|dwdtjtd}dwdtdwtjtd~ddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtdtjtdddtjtdddtjtdddtjtdddtddS)Nrr) table_namerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr}rrrrrrrr|rur{rzryrxrwrvrtrmrsrrrqrprornrlrerkrjrirhrgrfrdr]rcrbrar`r_r^r\rXr[rZrYrWrSrVrUrTrRrNrQrPrOrMrFrLrKrJrIrHrGrErArDrCrBr@r<r?r>r=r;r7r:r9r8r6r!r5r4r3r2r1r0r rrrrrrrrrrrrrr)r drop_indexr drop_tablerrrr downgrade sD                  r) __doc__alembicr sqlalchemyrrevision down_revision branch_labels depends_onrrrrrrs |