U
    \d                     @   s<   d Z ddlmZ ddlZdZdZdZdZdd Z	dd Z
dS )	z\empty message

Revision ID: 88e485ebc3ab
Revises: 
Create Date: 2020-09-11 08:40:57.703618

    )opN88e485ebc3abc                :   C   s^F  t 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dddtjdtjdd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d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
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 d
dtjdtjddddtjdtjddddtjdtjdd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dddtjdtjdd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
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 d
dtjdtjddddtjdtjddddtjdtjdd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!dddtjd"tjddddtjd#tjd!dddtjd$tjddddtjdtjddd
dtjd%tjddddtjdtjdd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 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 jt d/dd*gdd t d0t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dddtjdtjdd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dddtjdtjddd
dtjd1t ddtjd2t ddtjd3t	 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d4tjddddtjd5t	 ddtd4gd6gt
d t jt d7d0dgdd t jt d8d0d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 d
dtjdtjddddtjdtjddddtjdtjdd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dddtjdtjddd
dtjd:t ddtjd;t ddtjdtjddddtjdt	 ddt
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dAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t 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dAtjddddtjdBtjddddt
d t dEt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dddtjdtjdd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dddtjdtjddd
dtjdtjddddtjdFt ddtjdGtjd(dddtjdt	 ddtjd4tjddddt
d t jt dHdEdgdd t jt dIdEdgd
d t jt dJdEdFgd
d t dKt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dddtjdtjdd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d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
d t jt dLdKdgdd t jt dMdKdgd
d t dNtjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dOt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dddtjdtjdd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d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
d t jt dPdOdgdd t jt dQdOdgd
d t dRtjdStjdd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dddtjdtjdd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dddtjdtjddd
dtjdtjddddtjdTtjd(dddtjdUt ddtjdVt ddtjdWt ddtjdXt ddtjdYt ddtjdZt ddtjd[t ddtjd\t ddtjdt	 ddt
d t jt d]dRdgdd t jt d^dRd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dAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t 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dAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t 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dAtjddddtjdBtjddddt
d t detjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t dgtjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t ditjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t djtjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dktjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dltjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
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dAtjddddtjdBtjddddt
d t dntjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dotjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dptjd tjd!dddtjdtjddd
dtjd?tjddddtjd@tjddddtjdAtjddddtjdBtjddddt
d t dqtjdStjdd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dddtjdtjdd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dddtjdtjddd
dtjdtjddddtjdFt ddtjdGtjd(dddtjdt	 ddtjd4tjddddtdSgdrgt
d t jt dsdqdgdd t jt dtdqdgd
d t jt dudqdFgd
d t dvtjdStjddddtjdwtjdd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dddtjdtjdd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dddtjdxtjddddtjd"tjddddtjdytjd(dddtjdztjd{dddtjd|tjddddtjd}t 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dtjd(dddtjd:t ddtjdtjdd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ddddtjdtjd{dddtjdt 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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d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{dddtjdtjd{dddtjdt	 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d{dddtjdtjd{dddtdSgdrgtdxgdgtdgdgt
d6 t jt ddvdgdd t jt ddvd%gdd t jt ddvdgd
d t jt ddvdg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 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d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dddtjdtjd(dddtjdt ddtjdtjddd
dtjdtjddddtjdt ddtjdt	 ddtjdFt ddtjdtjd(dddtjdt	 ddtdgdrgt
d t jt dddgd
d t jt dddgd
d t dtjdStjdd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dddtjdtjdd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dddtjdtjddd
dtjdtjddddtjdFt ddtjdt	 ddtdSgdrgt
d t jt dddgdd t jt dddgd
d t dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxt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dd
dtjdt ddtjdtjd(dddtjdtjddddtjdt ddtjdFt 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d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dddtjdtjddddtjdtjddddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjd(dddtjdtjddddtdSgdrgtdxgdg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ddFg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 d
dtjdtjddddtjdtjddddtjdtjdd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d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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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(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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dddtjdtjddddtjdt	 ddtjdt ddtjdtjddddtdgdgt
d$ t jt d֡ddgdd t jt dסddgd
d t jt dءddgd
d t dtjdStjdd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dddtjdtjdd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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d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dt	 ddtdSgdrgtdgdg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 dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxtjddddtjdtjddddtjdtjddd
dtjdt ddtjdtjd(dddtjdtjddddtjdt ddtjdFt 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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d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dddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjddddtdSgdrgtdxgdg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ddFgd
d t dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxtjddddtjdtjddddtjdtjdd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dtjddddtjdt ddtjdFt 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d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dddtjdtjddddtjdtjddddtjdGtjd(dddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjddddtdSgdrgtdxgdg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ddFgd
d t dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxtjddddtjdtjddddtjdtjddd
dtjdt ddtjdtjd(dddtjdtjddddtjdt ddtjdFt 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d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dddtjdtjddddtjdtjddddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjddddtdSgdrgtdxgdg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ddFgd
d t dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxtjddddtjdtjddddtjdtjddd
dtjdt ddtjdtjd(dddtjdtjddddtjdt ddtjdFt 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d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dddtjdtjddddtjdtjddddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjddddtjdtjddddtdSgdrgtdxgdgtdgdg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ddFg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dAtjddddtjdBtjddddtd?gdgtdAgdgt
d
 t dt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dddtjdtjdd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dddtjdtjdd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	 ddtdg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 d
dtjdtjddddtjdtjddddtjdtjdd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dddtjdtjdd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dgdgt
d t jt dddgdd t jt d ddgd
d t dtjdStjddddtjdtjdd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dddtjdtjdd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dddtjdxtjddddtjdtjddddtjdtjddddtjdtjddd
dtjdt ddtjdtjd(dddtjdtjddddtjdt ddtjdFt 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d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dddtjdtjddddtjdtjddddtjdt	 ddtjdt	 ddtjdt ddtjd4tjddddtjdtjddddtdSgdrgtdxgdgtdgdgtdgdgtdgdg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dFgd
d d S (  Ncmf_activitycmf_author_id@   )lengthT)nullablecmf_created_at)timezonecmf_deletedFcmf_locked_atcmf_locked_by_idcmf_modified_atcmf_modified_by_idcmf_owner_idcmf_versioncmf_viewed_atcodeidname   textix_cmf_activity_code)uniqueix_cmf_activity_namecmf_attachment	parent_idurlix_cmf_attachment_codeix_cmf_attachment_namecmf_authdescriptioni   emailgroupshash_ntlmv2login	pass_hashphone    	posix_gid	posix_uidix_cmf_auth_emailix_cmf_auth_loginix_cmf_auth_nameix_cmf_auth_posix_gidix_cmf_auth_posix_uidcmf_comment	importantis_auditlikestree_parent_idviewszcmf_comment.idix_cmf_comment_codeix_cmf_comment_namecmf_companyis_internalis_penalty_blockix_cmf_company_codeix_cmf_company_namecmf_document_executorsleft_idleft_name_cacheright_idright_name_cachecmf_document_related_objectscmf_document_spectatorscmf_feedordernosys_typeix_cmf_feed_codeix_cmf_feed_nameix_cmf_feed_ordernocmf_jobix_cmf_job_codeix_cmf_job_namecmf_person_group_rg_memberscmf_planix_cmf_plan_codeix_cmf_plan_namecmf_projectactivity_idproject_typeshow_archive	show_docsZ	show_feedshow_in_workZ
show_inboxshow_meetings	show_todo
show_trashix_cmf_project_codeix_cmf_project_namecmf_project_executorscmf_project_spectatorscmf_u_work_chat_group_executors%cmf_u_work_chat_group_related_objects cmf_u_work_chat_group_spectatorscmf_u_work_chat_topic_executors%cmf_u_work_chat_topic_related_objects cmf_u_work_chat_topic_spectatorscmf_u_work_list_executorscmf_u_work_list_memberscmf_u_work_list_related_objectscmf_u_work_list_spectatorscmf_u_work_post_executorscmf_u_work_post_related_objectscmf_u_work_post_spectatorscmf_u_work_task_executorscmf_u_work_task_related_objectscmf_u_work_task_spectators
cmf_folderzcmf_activity.idix_cmf_folder_codeix_cmf_folder_nameix_cmf_folder_orderno
cmf_personbirthday
company_idemail_2facebook   
first_namegidhas_penalty	instagram
ip_address	last_namelinkedin	messengerokpenalty_promise_hourpenalty_reasonphone_2phone_assistantphone_internalphone_mobile
project_idsecond_nameskypeslacksnapchattelegramuidvibervkwhatsappzoomzcmf_company.idzcmf_project.idix_cmf_person_codeix_cmf_person_loginix_cmf_person_nameix_cmf_person_uid
cmf_status	cmf_modelcmf_model_activity_idcolordefault_deadline_shift
next_alarmoptionsstatus_typeix_cmf_status_codeix_cmf_status_namecmf_u_work_typeix_cmf_u_work_type_codeix_cmf_u_work_type_namecmf_document
alarm_datedeadline	file_path
is_penaltymark
no_controlparent_task_idperiod_clone_from_idperiod_intervalperiod_next_dateplan_end_dateplan_start_datepriorityresponsible_id	status_idtagstime_estimatetypewaiting_for_idzcmf_status.idix_cmf_document_codeix_cmf_document_nameix_cmf_document_orderno	cmf_eventevent_alarm_dateevent_person_idevent_statusmsg_alarm_datemsg_body	msg_classmsg_frommsg_iconmsg_importantmsg_ordernomsg_penalty
msg_statusmsg_subjectmsg_tomsg_typemsg_url	object_id
unread_cntview_object_idzcmf_person.idix_cmf_event_codeix_cmf_event_msg_ordernoix_cmf_event_namecmf_rolejob_idjob_instructionou_parent_id	person_idsupervisor_idz
cmf_job.idzcmf_role.idix_cmf_role_codeix_cmf_role_namecmf_u_work_chat_groupp2pix_cmf_u_work_chat_group_codeix_cmf_u_work_chat_group_name ix_cmf_u_work_chat_group_ordernocmf_u_work_list	list_typeix_cmf_u_work_list_codeix_cmf_u_work_list_nameix_cmf_u_work_list_ordernocmf_u_work_postix_cmf_u_work_post_codeix_cmf_u_work_post_nameix_cmf_u_work_post_ordernocmf_u_work_taskuwork_type_idzcmf_u_work_type.idix_cmf_u_work_task_codeix_cmf_u_work_task_nameix_cmf_u_work_task_ordernocmf_feed_cmf_eventzcmf_feed.idzcmf_event.idcmf_org_unithead_idix_cmf_org_unit_codeix_cmf_org_unit_namecmf_person_groupix_cmf_person_group_codeix_cmf_person_group_namecmf_u_work_chat_topicgroup_idzcmf_u_work_chat_group.idix_cmf_u_work_chat_topic_codeix_cmf_u_work_chat_topic_name ix_cmf_u_work_chat_topic_orderno)r   create_tablesaColumnCHAR	TIMESTAMPBooleanIntegerStringTEXTPrimaryKeyConstraintcreate_indexfForeignKeyConstraint r  r  ./opt/eva-app/alembic/versions/88e485ebc3ab_.pyupgrade   sd   																						7-%,-+--r  c                   C   s  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 d t jt d	d
d t jt dd
d t d
 t 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 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 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 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 d) t jt d+d,d t jt d-d,d t 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 d/ t jt d3d4d t jt d5d4d t jt d6d4d t d4 t d7 t d8 t d9 t d: t d; t d< t d= t d> t d? t d@ t dA t dB t dC t dD t dE t dF t dG t dH t jt dIdJd t jt dKdJd t dJ t jt dLdMd t jt dNdMd t dM t dO t jt dPdQd t jt dRdQd t dQ t jt dSdTd t jt dUdTd t jt dVdTd t dT t dW t dX t dY t jt dZd[d t jt d\d[d t d[ t jt d]d^d t jt d_d^d t d^ t jt d`dad t jt dbdad t jt dcdad t jt dddad t jt dedad t da t jt dfdgd t jt dhdgd t dg t jt didjd t jt dkdjd t dj d S )lNr   r   )
table_namer   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rr   r   r   r   rq   rn   rp   ro   rm   rl   rk   rj   ri   rh   rg   rf   re   rd   rc   rb   ra   r`   r_   r^   r]   r\   r[   rQ   rZ   rP   rN   rO   rM   rL   rJ   rK   rI   rD   rH   rG   rC   rB   r=   r<   r8   r;   r7   r0   r6   r/   r    r.   r-   r,   r+   r   r   r   r   r   r   )r   
drop_indexr  
drop_tabler  r  r  r  	downgrade  s    












































r  )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr  r  r  r  r  r  <module>   s          >