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 )zcasset v7

Revision ID: dba5beff556b
Revises: ac7de9ca96cd
Create Date: 2024-02-29 21:00:03.312582

é    )ÚopN)Ú
postgresqlÚdba5beff556bÚac7de9ca96cdc                   C   sB  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  dtjdtjddddtjdtjddd	dtjd
tjddd	dtjdtjddd	dtjdtjddd	dtjdt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	dd d! t j	d"d d! t j	d#d d! t j	d$d d! t  
d ¡ t  d%tjd&tjddd	d¡ t  d%tjd'tjddd	d¡ t  d%tjd(tjddd	d¡ t jd)d%d*gdd+d*d,id- t jd.d%d/gdd+d/d,id- t jd0d%d1gdd+d1d,id- t jd2d%d'gdd+d'd,id- t jd3d%d4gdd+d4d,id- t jd5d%d6gdd+d6d,id- t jd7d%d8gdd+d8d,id- t jd9d%d:gdd+d:d,id- t jd;d%d&gdd+d&d,id- t jt  d<¡d%d(gdd t jd=d%d>gdd+d>d,id- t jd?d%d@gdd+d@d,id- t jdAd%dBgdd+dBd,id- t jdCd%dDgdd+dDd,id- t  d d%dEd(gdg¡ t  dFtjdGtjddd	d¡ t  dH¡ t jdFdGtjddddI t jt  dJ¡dFdGgdd t  d dFdKdGgdg¡ d S )LNÚ cmf_asset_cat_cmf_asset_type_catÚidé€   ©ÚlengthF)ÚnullableÚ	parent_idé@   TÚroot_idÚdescriptioné   Úleft_idÚright_idÚleft_name_cacheé   Úright_name_cachezcmf_asset_cat.idzcmf_asset_type_cat.idÚ+ix_cmf_asset_cat_cmf_asset_type_cat_left_id©ÚuniqueÚ-ix_cmf_asset_cat_cmf_asset_type_cat_parent_idÚ,ix_cmf_asset_cat_cmf_asset_type_cat_right_idÚ+ix_cmf_asset_cat_cmf_asset_type_cat_root_idÚcmf_asset_cmf_assetzcmf_asset.idÚix_cmf_asset_cmf_asset_left_idÚ ix_cmf_asset_cmf_asset_parent_idÚix_cmf_asset_cmf_asset_right_idÚix_cmf_asset_cmf_asset_root_idÚ ix_cmf_asset_owner_group_left_idÚcmf_asset_owner_group©Ú
table_nameÚ"ix_cmf_asset_owner_group_parent_idÚ!ix_cmf_asset_owner_group_right_idÚ ix_cmf_asset_owner_group_root_idÚ	cmf_assetÚmarkcodeÚinv_noÚorg_unit_idÚix_cmf_asset_asset_tag_gin_trgmÚ	asset_tagÚginÚgin_trgm_ops)r   Úpostgresql_usingÚpostgresql_opsÚ!ix_cmf_asset_domain_name_gin_trgmÚdomain_nameÚix_cmf_asset_imei_gin_trgmÚimeiÚix_cmf_asset_inv_no_gin_trgmÚ$ix_cmf_asset_invoice_number_gin_trgmÚinvoice_numberÚix_cmf_asset_ip_adress_gin_trgmÚ	ip_adressÚ$ix_cmf_asset_lease_contract_gin_trgmÚlease_contractÚ*ix_cmf_asset_maintenance_contract_gin_trgmÚmaintenance_contractÚix_cmf_asset_markcode_gin_trgmÚix_cmf_asset_org_unit_idÚ ix_cmf_asset_os_version_gin_trgmÚ
os_versionÚ"ix_cmf_asset_phone_number_gin_trgmÚphone_numberÚix_cmf_asset_po_number_gin_trgmÚ	po_numberÚ#ix_cmf_asset_serial_number_gin_trgmÚserial_numberÚcmf_org_unitÚcmf_asset_catÚdefault_logic_type_idzXupdate cmf_asset_cat set default_logic_type_id = (select id from cmf_logic_type limit 1))Úexisting_typer   Ú&ix_cmf_asset_cat_default_logic_type_idÚcmf_logic_type)r   Úcreate_tableÚsaÚColumnÚStringÚForeignKeyConstraintÚPrimaryKeyConstraintÚcreate_indexÚfÚ
drop_indexÚ
drop_tableÚ
add_columnÚcreate_foreign_keyÚexecuteÚalter_column© r]   r]   ú6/opt/eva-app/alembic/versions/dba5beff556b_asset_v7.pyÚupgrade   s†    õõ
    ÿ
þr_   c                   C   st  t jdddd t jt  d¡dd t  dd¡ t jdd	dd t jd
d	dddid t jdd	dddid t jdd	dddid t jdd	dddid t jt  d¡d	d t jdd	dddid t jdd	dddid t jdd	dddid t jdd	dddid t jdd	dddid t jd d	dd!did t jd"d	dd#did t jd$d	dd%did t jd&d	dd'did t  d	d(¡ t  d	d!¡ t  d	d¡ t  d)tjd*tjd+d,d-d-d.tjd/tjd0d,d-d1d.tjd2tjd0d,d-d1d.tjd3tjd4d,d-d1d.tjd5tjd0d,d-d1d.tjd6tjd0d,d-d1d.tjd7tjd8d,d-d1d.tjd9tjd8d,d-d1d.tj	d*d:d;¡
 t j
d<d)d2gd-d= t j
d>d)d6gd-d= t j
d?d)d/gd-d= t j
d@d)d5gd-d= 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¡ d S )KNZ(cmf_asset_cat_default_logic_type_id_fkeyrJ   Ú
foreignkey)Útype_rM   r#   rK   Zcmf_asset_org_unit_id_fkeyr(   rG   r.   rH   r/   )r$   r0   r1   rE   rF   rC   rD   rA   rB   r@   r?   r)   r=   r>   r;   r<   r9   r:   r7   r8   r6   r*   r4   r5   r2   r3   r,   r-   r+   r"   r   r   r	   F)Úautoincrementr   r   r   Tr   r   r   r   r   r   r   r   Zcmf_asset_owner_group_pkey)Únamer'   r   r&   r%   r!   r    r   r   r   r   r   r   r   r   r   )r   Údrop_constraintrW   rV   Údrop_columnrO   rP   rQ   ÚVARCHARrT   rU   rX   r]   r]   r]   r^   Ú	downgradeY   s\    ÷
rg   )Ú__doc__Úalembicr   Ú
sqlalchemyrP   Zsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr_   rg   r]   r]   r]   r^   Ú<module>   s   F