U
    z]fáõ  ã                   @   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 )z`asset

Revision ID: 04e5270f74a3
Revises: 183ded3722ad
Create Date: 2024-02-27 21:33:15.364821

é    )ÚopN)Ú
postgresqlZ04e5270f74a3Z183ded3722adc                ~   C   sD1  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 ¡ 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jddddtjdtjddddtjdtjddddtjdtjddddtjdtjddddtjd tjddddtjd!tjddddtjd"tjddddtjd#tjddddtjd$tjddddtjd%t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d(g¡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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d$tjddddtjd%t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  d,tjdtjddddtjdtjdd	ddtjd
tjdd	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 ¡ ddtjd#tjddddtjd$tjddddtjd%tjddddtjd&t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d/g¡t d.gd0g¡t 	d¡¡ t  d1tjdtjddddtjdtjdd	ddtjd
tjdd	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d2tjddddtjd3t ¡ ddtjd4t 
¡ ddtjd5t ¡ ddtjd6t 
¡ ddtjd7t ¡ ddtjd8t ¡ ddtjd9t ¡ ddtjd:t ¡ ddtjd;t ¡ ddtjd<t ¡ ddtjd=t ¡ ddtjd>t ¡ ddtjd?t ¡ ddtjd@t ¡ ddtjdAtjddddtjdBtjddddtjdCtjddddtjdDt 
¡ ddtjdEt ¡ ddtjdFt ¡ ddtjdGt ¡ ddtjdHt ¡ ddtjdIt ¡ ddtjdJtjd+dddtjdKt ¡ ddtjdLtjdd	ddtjdMtjdd	ddtjdNtjdd	ddtjdOtjdd	ddtjdPtjdd	ddtjdQt ¡ ddtjdRt ¡ ddtjdStjd+dddtjdTtjdd	ddtjdUtjdd	ddtjdVtjdd	ddtjdWtjdd	ddtjdXtjdd	ddtjdYtjd+dddtjdZt ¡ ddtjd[t ¡ 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datjd+dddtjdbtjd+dddtjdct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ddddtjdgtjddddtjdhtjddddtjditjddddtjdjt ¡ ddtjdkt ¡ ddtjdlt ¡ ddtjdmtjd+d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jddddtjdttjd+dddtjdutjddddtjdvt ¡ ddtjdwt ¡ ddtjdxt ¡ ddtjd#tjddddtjd$tjddddtjd%tjddddtjd&tjddddtjd'tjddddtjdytjddddtjd.t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jddddtjd}tjddddtjd~tj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jddddtjdƒtjddddtjd„tjddddtjd…tjddddtjd†tjddddtjd‡tjddddtjdˆtjddddtjd‰tjddddtjdŠt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d0g¡t d‰gdŽg¡t dygdg¡t d„gdg¡t d~gd‘g¡t dŒgd’g¡t d‹gd(g¡t dgd“g¡t d%gd/g¡t d{gd”g¡t d‚gd•g¡t d€gd–g¡t dƒgd—g¡t d}gd‘g¡t 	d¡¡z t jt  d˜¡d1dˆgdd™ t jt  dš¡d1dTgdd™ t jt  d›¡d1d^gdd™ t jt  dœ¡d1dŠgdd™ t jt  d¡d1d‰gdd™ t jt  dž¡d1d\gdd™ t jt  dŸ¡d1d‡gdd™ t jt  d ¡d1d#gdd™ t jt  d¡¡d1d
gdd™ t jt  d¢¡d1dgdd™ t jt  d£¡d1dygdd™ t jt  d¤¡d1dgdd™ t jt  d¥¡d1d'gdd™ t jt  d¦¡d1dgdd™ t jt  d§¡d1d&gdd™ t jt  d¨¡d1dgdd™ t jt  d©¡d1d$gdd™ t jt  dª¡d1dgdd™ t jt  d«¡d1dgdd™ t jt  d¬¡d1d2gdd™ t jt  d­¡d1d„gdd™ t jt  d®¡d1d~gdd™ t jt  d¯¡d1dŒgdd™ t jt  d°¡d1dZgdd™ t jt  d±¡d1d‹gdd™ t jt  d²¡d1dIgdd™ t jt  d³¡d1dgdd™ t jt  d´¡d1dgdd™ t jt  dµ¡d1d=gdd™ t jt  d¶¡d1d%gdd™ t jt  d·¡d1dKgdd™ t jt  d¸¡d1d{gdd™ t jt  d¹¡d1d|gdd™ t jt  dº¡d1d‚gdd™ t jt  d»¡d1d…gdd™ t jt  d¼¡d1dzgdd™ t jt  d½¡d1d€gdd™ t jt  d¾¡d1dƒgdd™ t jt  d¿¡d1d.gdd™ t jt  dÀ¡d1d†gdd™ t jt  dÁ¡d1d}gdd™ t jt  dÂ¡d,d#gdd™ t jt  dÃ¡d,d
gdd™ t jt  dÄ¡d,dgdd™ t jt  dÅ¡d,dgdd™ t jt  dÆ¡d,d'gdd™ t jt  dÇ¡d,dgdd™ t jt  dÈ¡d,d&gdd™ t jt  dÉ¡d,d$gdd™ t jt  dÊ¡d,dgdd™ t jt  dË¡d,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  dàtjdtjdÏdddtjd%tjddddtjdÐtjddddtjdÑtjddddtjdÒtjddddtjdÓt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 jt  dô¡d)d#gdd™ t jt  dõ¡d)d
gdd™ t jt  dö¡d)dgdd™ t jt  d÷¡d)dgdd™ t jt  dø¡d)d'gdd™ t jt  dù¡d)dgdd™ t jt  dú¡d)d&gdd™ t jt  dû¡d)d$gdd™ t jt  dü¡d)dgdd™ t jt  dý¡d)dgdd™ t jt  dþ¡d)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 ¡ 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d%tjddddtjd&t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d/g¡t d.gdg¡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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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 d"gdg¡t d%gd/g¡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dÒtjddddtjdÓt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d’g¡t dÓgd$g¡t 	d¡¡ t jt  d%¡dd"gdd™ t jt  d&¡dd#gdd™ t jt  d'¡dd
gdd™ t jt  d(¡ddgdd™ t jt  d)¡ddgdd™ t jt  d*¡dd'gdd™ t jt  d+¡ddgdd™ t jt  d,¡d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  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 jt  d4¡ddgdd™ t jt  d5¡dd'gdd™ t jt  d6¡ddg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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  dA¡d=dÐgd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dÒtjddddtjdÓt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  dC¡dBdÒgdd™ t jt  dD¡dBd%gdd™ t jt  dE¡dBdÓgdd™ t jt  dF¡dBdÐgd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dÒtjddddtjdÓt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  dH¡dGdÒgdd™ t jt  dI¡dGd%gdd™ t jt  dJ¡dGdÓgdd™ t jt  dK¡dGdÐgdd™ t jt  dL¡dd#gdd™ t jt  dM¡dd
gdd™ t jt  dN¡ddgdd™ t jt  dO¡ddgdd™ t jt  dP¡dd'gdd™ t jt  dQ¡ddgdd™ t jt  dR¡dd&gdd™ t jt  dS¡dd$gdd™ t jt  dT¡ddgdd™ t jt  dU¡ddgdd™ t jdVddgddWddXidY t jt  dZ¡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Ògd\g¡t dÓgd’g¡t 	d¡¡ t jt  d]¡d[dÒgdd™ t jt  d^¡d[d%gdd™ t 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 jt  dc¡dßdÓgdd™ t jt  dd¡dßdÐgdd™ t jt  de¡d#dÒgdd™ t jt  df¡d#d%gdd™ t jt  dg¡d#dÓgdd™ t jt  dh¡d#dÐgdd™ d S (i  NÚcmf_locationÚidé@   )ÚlengthF)ÚnullableÚcmf_locked_atT)ÚtimezoneÚcmf_created_atÚcmf_modified_atÚcmf_viewed_atÚcmf_deletedÚcmf_versionÚnamei   Úcountryé   Úcountry_codeÚzip_codeÚ	area_codeÚareaÚcityÚstreetÚdistrictÚmun_districtÚ
settlementÚcity_districtÚlocalityÚ	territoryÚhouse_numberÚfloorÚflatÚroomÚcmf_author_idÚcmf_owner_idÚ	parent_idÚcmf_modified_by_idÚcmf_locked_by_idzcmf_location.idÚcmf_asset_schemeÚcode_prefixé    Úcmf_asset_catÚis_abstractÚtree_parent_idzcmf_asset_scheme.idzcmf_asset_cat.idÚ	cmf_assetÚcodeÚsystemÚtextÚimport_originalÚimport_raw_jsonÚext_idÚcmf_archivedÚis_favoriteÚhas_tree_nodesÚtree_node_is_branchÚtree_hiddenÚordernoÚperm_publicÚperm_has_aclÚperm_inheritÚperm_parent_owner_idÚperm_inherit_acl_idÚperm_effective_acl_idÚ%perm_security_level_allowed_ids_cacheÚperm_encryptÚ	is_publicÚis_public_editableÚis_public_commentsÚlogic_prefixÚui_view_formÚparent_logic_prefixÚstatus_modified_atÚstatus_in_progress_startÚstatus_in_progress_endÚstatus_review_atÚstatus_closed_atÚ
no_controlÚpriorityÚmarkÚ
alarm_dateÚdeadlineÚplan_start_dateÚplan_end_dateÚperiod_next_dateÚperiod_intervalÚis_templateÚ
is_penaltyÚcache_status_typeÚcache_fieldsÚapprovedÚperm_policyÚperm_policy_guestÚperm_policy_anonymousÚperm_policy_sharelinkÚsharelink_hashÚ	asset_tagÚserial_numberÚ	po_numberÚinvoice_numberÚlease_contractÚmaintenance_contractÚpurchase_dateÚrefresh_dateÚlast_scan_dateÚownership_typeÚdevice_typeÚ
os_versionÚenabled_statusÚoperational_statusÚimeiÚphone_numberÚ	ip_adressÚdomain_nameÚwarranty_expirationÚrelease_dateÚwriteoff_dateÚcmf_import_idÚroot_parent_idÚperm_acl_idÚperm_parent_idÚworkflow_idÚdefault_task_workflow_idÚlogic_type_idÚscheme_wf_idÚcmf_owner_assistant_idÚperm_security_level_idÚ	status_idÚ
company_idÚresponsible_idÚwaiting_for_idÚcloned_from_idÚactivity_idÚcache_status_opt_idÚasset_cat_idÚlocation_idÚincluded_in_idzcmf_activity.idzcmf_status_opt.idzcmf_import.idzcmf_company.idzcmf_workflow.idzcmf_asset.idzcmf_logic_type.idzcmf_access_list.idzcmf_security_level.idzcmf_scheme_wf.idzcmf_status.idÚix_cmf_asset_activity_id)ÚuniqueÚix_cmf_asset_alarm_dateÚix_cmf_asset_approvedÚix_cmf_asset_asset_cat_idÚ ix_cmf_asset_cache_status_opt_idÚix_cmf_asset_cache_status_typeÚix_cmf_asset_cloned_from_idÚix_cmf_asset_cmf_author_idÚix_cmf_asset_cmf_created_atÚix_cmf_asset_cmf_deletedÚix_cmf_asset_cmf_import_idÚix_cmf_asset_cmf_locked_atÚix_cmf_asset_cmf_locked_by_idÚix_cmf_asset_cmf_modified_atÚix_cmf_asset_cmf_modified_by_idÚ#ix_cmf_asset_cmf_owner_assistant_idÚix_cmf_asset_cmf_owner_idÚix_cmf_asset_cmf_versionÚix_cmf_asset_cmf_viewed_atÚix_cmf_asset_codeÚix_cmf_asset_company_idÚ%ix_cmf_asset_default_task_workflow_idÚix_cmf_asset_included_in_idÚix_cmf_asset_is_templateÚix_cmf_asset_location_idÚix_cmf_asset_logic_prefixÚix_cmf_asset_logic_type_idÚix_cmf_asset_nameÚix_cmf_asset_ordernoÚix_cmf_asset_parent_idÚ ix_cmf_asset_parent_logic_prefixÚix_cmf_asset_perm_acl_idÚix_cmf_asset_perm_parent_idÚ#ix_cmf_asset_perm_security_level_idÚix_cmf_asset_responsible_idÚix_cmf_asset_root_parent_idÚix_cmf_asset_scheme_wf_idÚix_cmf_asset_status_idÚix_cmf_asset_tree_parent_idÚix_cmf_asset_waiting_for_idÚix_cmf_asset_workflow_idÚix_cmf_asset_cat_cmf_author_idÚix_cmf_asset_cat_cmf_created_atÚix_cmf_asset_cat_cmf_deletedÚix_cmf_asset_cat_cmf_locked_atÚ!ix_cmf_asset_cat_cmf_locked_by_idÚ ix_cmf_asset_cat_cmf_modified_atÚ#ix_cmf_asset_cat_cmf_modified_by_idÚix_cmf_asset_cat_cmf_owner_idÚix_cmf_asset_cat_cmf_versionÚix_cmf_asset_cat_cmf_viewed_atÚix_cmf_asset_cat_parent_idÚix_cmf_asset_cat_tree_parent_idÚcmf_asset_cat_role_developeré€   Úroot_idÚdescriptionÚleft_idÚright_idÚleft_name_cacheÚright_name_cacheÚ'ix_cmf_asset_cat_role_developer_left_idÚ)ix_cmf_asset_cat_role_developer_parent_idÚ(ix_cmf_asset_cat_role_developer_right_idÚ'ix_cmf_asset_cat_role_developer_root_idÚcmf_asset_cat_role_managerÚ%ix_cmf_asset_cat_role_manager_left_idÚ'ix_cmf_asset_cat_role_manager_parent_idÚ&ix_cmf_asset_cat_role_manager_right_idÚ%ix_cmf_asset_cat_role_manager_root_idÚcmf_asset_cat_role_userÚcmf_asset_cmf_owner_assistantsÚ)ix_cmf_asset_cmf_owner_assistants_left_idÚ+ix_cmf_asset_cmf_owner_assistants_parent_idÚ*ix_cmf_asset_cmf_owner_assistants_right_idÚ)ix_cmf_asset_cmf_owner_assistants_root_idÚcmf_asset_executorsÚix_cmf_asset_executors_left_idÚ ix_cmf_asset_executors_parent_idÚix_cmf_asset_executors_right_idÚix_cmf_asset_executors_root_idÚcmf_asset_local_linksÚ ix_cmf_asset_local_links_left_idÚ"ix_cmf_asset_local_links_parent_idÚ!ix_cmf_asset_local_links_right_idÚ ix_cmf_asset_local_links_root_idÚcmf_asset_owner_groupÚ ix_cmf_asset_owner_group_left_idÚ"ix_cmf_asset_owner_group_parent_idÚ!ix_cmf_asset_owner_group_right_idÚ ix_cmf_asset_owner_group_root_idÚ!ix_cmf_asset_scheme_cmf_author_idÚ"ix_cmf_asset_scheme_cmf_created_atÚix_cmf_asset_scheme_cmf_deletedÚ!ix_cmf_asset_scheme_cmf_locked_atÚ$ix_cmf_asset_scheme_cmf_locked_by_idÚ#ix_cmf_asset_scheme_cmf_modified_atÚ&ix_cmf_asset_scheme_cmf_modified_by_idÚ ix_cmf_asset_scheme_cmf_owner_idÚix_cmf_asset_scheme_cmf_versionÚ!ix_cmf_asset_scheme_cmf_viewed_atÚix_cmf_asset_scheme_code_prefixÚix_cmf_asset_scheme_parent_idÚcmf_asset_scheme_role_developerÚ*ix_cmf_asset_scheme_role_developer_left_idÚ,ix_cmf_asset_scheme_role_developer_parent_idÚ+ix_cmf_asset_scheme_role_developer_right_idÚ*ix_cmf_asset_scheme_role_developer_root_idÚcmf_asset_scheme_role_managerÚ(ix_cmf_asset_scheme_role_manager_left_idÚ*ix_cmf_asset_scheme_role_manager_parent_idÚ)ix_cmf_asset_scheme_role_manager_right_idÚ(ix_cmf_asset_scheme_role_manager_root_idÚcmf_asset_scheme_role_userÚ%ix_cmf_asset_scheme_role_user_left_idÚ'ix_cmf_asset_scheme_role_user_parent_idÚ&ix_cmf_asset_scheme_role_user_right_idÚ%ix_cmf_asset_scheme_role_user_root_idÚcmf_asset_spectatorsÚix_cmf_asset_spectators_left_idÚ!ix_cmf_asset_spectators_parent_idÚ ix_cmf_asset_spectators_right_idÚix_cmf_asset_spectators_root_idÚcmf_asset_support_groupÚ"ix_cmf_asset_support_group_left_idÚ$ix_cmf_asset_support_group_parent_idÚ#ix_cmf_asset_support_group_right_idÚ"ix_cmf_asset_support_group_root_idÚcmf_asset_type_catzcmf_asset_type_cat.idÚcmf_asset_typeÚmodel_idÚbar_codeÚproduct_informationÚ
unit_priceÚversionÚ
short_nameÚasset_type_cat_idÚcmf_asset_cmf_asset_typezcmf_asset_type.idÚ#ix_cmf_asset_type_asset_type_cat_idÚix_cmf_asset_type_cmf_author_idÚ ix_cmf_asset_type_cmf_created_atÚix_cmf_asset_type_cmf_deletedÚix_cmf_asset_type_cmf_locked_atÚ"ix_cmf_asset_type_cmf_locked_by_idÚ!ix_cmf_asset_type_cmf_modified_atÚ$ix_cmf_asset_type_cmf_modified_by_idÚix_cmf_asset_type_cmf_owner_idÚix_cmf_asset_type_cmf_versionÚix_cmf_asset_type_cmf_viewed_atÚix_cmf_asset_type_parent_idÚ#ix_cmf_asset_type_cat_cmf_author_idÚ$ix_cmf_asset_type_cat_cmf_created_atÚ!ix_cmf_asset_type_cat_cmf_deletedÚ#ix_cmf_asset_type_cat_cmf_locked_atÚ&ix_cmf_asset_type_cat_cmf_locked_by_idÚ%ix_cmf_asset_type_cat_cmf_modified_atÚ(ix_cmf_asset_type_cat_cmf_modified_by_idÚ"ix_cmf_asset_type_cat_cmf_owner_idÚ!ix_cmf_asset_type_cat_cmf_versionÚ#ix_cmf_asset_type_cat_cmf_viewed_atÚix_cmf_asset_type_cat_parent_idÚ$ix_cmf_asset_type_cat_tree_parent_idÚ!cmf_asset_type_cat_role_developerÚ,ix_cmf_asset_type_cat_role_developer_left_idÚ.ix_cmf_asset_type_cat_role_developer_parent_idÚ-ix_cmf_asset_type_cat_role_developer_right_idÚ,ix_cmf_asset_type_cat_role_developer_root_idÚcmf_asset_type_cat_role_managerÚ*ix_cmf_asset_type_cat_role_manager_left_idÚ,ix_cmf_asset_type_cat_role_manager_parent_idÚ+ix_cmf_asset_type_cat_role_manager_right_idÚ*ix_cmf_asset_type_cat_role_manager_root_idÚcmf_asset_type_cat_role_userÚ'ix_cmf_asset_type_cat_role_user_left_idÚ)ix_cmf_asset_type_cat_role_user_parent_idÚ(ix_cmf_asset_type_cat_role_user_right_idÚ'ix_cmf_asset_type_cat_role_user_root_idÚix_cmf_location_cmf_author_idÚix_cmf_location_cmf_created_atÚix_cmf_location_cmf_deletedÚix_cmf_location_cmf_locked_atÚ ix_cmf_location_cmf_locked_by_idÚix_cmf_location_cmf_modified_atÚ"ix_cmf_location_cmf_modified_by_idÚix_cmf_location_cmf_owner_idÚix_cmf_location_cmf_versionÚix_cmf_location_cmf_viewed_atÚix_cmf_location_name_gin_trgmÚginÚgin_trgm_ops)r‹   Úpostgresql_usingÚpostgresql_opsÚix_cmf_location_parent_idÚcmf_task_cmf_assetzcmf_task.idÚix_cmf_task_cmf_asset_left_idÚix_cmf_task_cmf_asset_parent_idÚix_cmf_task_cmf_asset_right_idÚix_cmf_task_cmf_asset_root_idÚ"ix_cmf_asset_cat_role_user_left_idÚ$ix_cmf_asset_cat_role_user_parent_idÚ#ix_cmf_asset_cat_role_user_right_idÚ"ix_cmf_asset_cat_role_user_root_idÚ#ix_cmf_asset_cmf_asset_type_left_idÚ%ix_cmf_asset_cmf_asset_type_parent_idÚ$ix_cmf_asset_cmf_asset_type_right_idÚ#ix_cmf_asset_cmf_asset_type_root_id)r   Úcreate_tableÚsaÚColumnÚStringÚ	TIMESTAMPÚBooleanÚBIGINTÚForeignKeyConstraintÚPrimaryKeyConstraintÚTEXTÚIntegerÚDATEÚcreate_indexÚf© rg  rg  ú3/opt/eva-app/alembic/versions/04e5270f74a3_asset.pyÚupgrade   s¦   à"òï‡{÷÷÷÷÷÷÷÷÷÷÷÷ïêõ ÷÷÷$õri  c                   C   s   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d	dd
ddi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  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  d'¡d(d t jt  d)¡d(d t jt  d*¡d(d t jt  d+¡d(d t jt  d,¡d(d t jt  d-¡d(d t jt  d.¡d(d t jt  d/¡d(d t jt  d0¡d(d t jt  d1¡d(d t jt  d2¡d(d t jt  d3¡d(d t  d(¡ t jt  d4¡d5d t jt  d6¡d5d t jt  d7¡d5d t jt  d8¡d5d t jt  d9¡d5d t jt  d:¡d5d t jt  d;¡d5d t jt  d<¡d5d t jt  d=¡d5d t jt  d>¡d5d t jt  d?¡d5d t jt  d@¡d5d t  d5¡ t jt  dA¡dBd t jt  dC¡dBd t jt  dD¡dBd t jt  dE¡dBd t  dB¡ t jt  dF¡dGd t jt  dH¡dGd t jt  dI¡dGd t jt  dJ¡dGd t  dG¡ t jt  dK¡dLd t jt  dM¡dLd t jt  dN¡dLd t jt  dO¡dLd t  dL¡ t jt  dP¡dQd t jt  dR¡dQd t jt  dS¡dQd t jt  dT¡dQd t  dQ¡ t jt  dU¡dVd t jt  dW¡dVd t jt  dX¡dVd t jt  dY¡dVd t  dV¡ t jt  dZ¡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  da¡d[d t jt  db¡d[d t jt  dc¡d[d t jt  dd¡d[d t jt  de¡d[d t jt  df¡d[d t  d[¡ 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¡ 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  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 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¡ d S )ÆNrP  rL  )Ú
table_namerO  rN  rM  rK  r   rF  rG  r   rH  )rj  rI  rJ  rE  rD  rC  rB  rA  r@  r?  r>  r=  r<  r;  r7  r:  r9  r8  r6  r2  r5  r4  r3  r1  r-  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Ó   rX  r  rW  rV  rU  rT  rÑ   rS  rR  rQ  rÐ   rÌ   rÏ   rÎ   rÍ   rË   rÀ   rÊ   rÉ   rÈ   r¿   r+   r¾   r½   r¼   r»   rº   r¹   r¸   r·   r¶   rµ   r´   r³   r.   r²   r±   r°   r¯   r®   r­   r¬   r«   rª   r©   r¨   r§   r¦   r¥   r¤   r£   r¢   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_indexrf  Ú
drop_tablerg  rg  rg  rh  Ú	downgradel  s€   





















rm  )Ú__doc__Úalembicr   Ú
sqlalchemyrZ  Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onri  rm  rg  rg  rg  rh  Ú<module>   s       ]