o
    i%#                     @   s@   d Z ddlmZ ddlZdZdZdZdZd
ddZ	d
dd	Z
dS )z_
Initial assets schema
Revision ID: 0001_assets
Revises: None
Create Date: 2025-12-10 00:00:00
    )opN0001_assetsreturnc                  C   s  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dtjdtjdddd	tjdtjdddd	tjddd t jdddgdd t dddg t dtjdtjddddtjdtjdddddtjdtjdddd	tjdtjddtj	dd d!dd	tjd"tjddtj	d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ddd'd t d(ddg t d)ddg t d*ddg t d+ddg t d,dd&g t d-dddg t d.tjdtjddddtjd/tjd0ddd1dtjd2d3d t d4d.d/g t d5tjd6tjddtj	d7d8d!dd	tjd9tjddtj	d:d d!dd	tjd;tjd0ddd<dtjd=tjdddd	tjd6d9d>d t d?d5d9g t d@d5d6g t dAtjdt dddBtjdtjddtj	dd8d!dd	tjdCt dd	tjdDt dd	tjdEt dtdFdtjdGdHdtjdCdId t dJdAdCg t dKdAdg t dLtjd6tjddtj	d7d8d!dd	tjdMtjdddd	tjdNt dddtjdOtjdPddd	tjdQtdRdSdd	tjdTt dd	tjdUt
 dd	tjd6dMdNdVd	 t dWdLdMg t dXdLdMdOg t dYdLdMdQg t dZdLdMdTg td.tdtjddtd/t } t | d[d\d]d^d\d]d_d\d]d`d\d]dad\d]dbd\d]dcd\d]ddd\d]ded\d]dfd\d]dgd\d]dhd\d]did\d]djd\d]dkd\d]dld\d]dmd\d]dnd\d]dod\d]dpd\d]dqd\d]drd\d]dsd\d]dtd\d]g d S )uNassetsid$   )lengthT)primary_keyhash   )nullable
size_bytesF0)r   server_default	mime_type   
created_at)timezonezsize_bytes >= 0ck_assets_size_nonneg)nameuq_assets_hash)uniqueix_assets_mime_typeassets_infoowner_id    r   i   asset_idz	assets.idRESTRICT)ondelete
preview_idzSET NULLuser_metadata
updated_atlast_access_timeuq_assets_info_asset_owner_nameix_assets_info_owner_idix_assets_info_asset_idix_assets_info_nameix_assets_info_created_atix_assets_info_last_access_timeix_assets_info_owner_nametagstag_type    userzname = lower(name)ck_tags_lowercaseix_tags_tag_typeasset_info_tagsasset_info_idzassets_info.idCASCADEtag_namez	tags.nameoriginmanualadded_atpk_asset_info_tagsix_asset_info_tags_tag_name ix_asset_info_tags_asset_info_idasset_cache_state)r	   autoincrement	file_pathmtime_nsneeds_verifyfalsez%(mtime_ns IS NULL) OR (mtime_ns >= 0)ck_acs_mtime_nonneguq_asset_cache_state_file_pathix_asset_cache_state_file_pathix_asset_cache_state_asset_idasset_info_metakeyordinalval_stri   val_num&   
   val_boolval_jsonpk_asset_info_metaix_asset_info_meta_keyix_asset_info_meta_key_val_strix_asset_info_meta_key_val_numix_asset_info_meta_key_val_boolmodelssystem)r   r,   inputoutputconfigscheckpointslorasvaetext_encodersdiffusion_modelsclip_visionstyle_models
embeddings	diffusers
vae_approx
controlnetgligenupscale_modelshypernetworks
photomakerclassifiersencoderdecodermissingrescan)r   create_tablesaColumnString
BigIntegerDateTimeCheckConstraintcreate_index
ForeignKeyJSONUniqueConstraintPrimaryKeyConstraintIntegerTextBooleantextNumerictablecolumnbulk_insert)
tags_table r   =/mnt/c/Users/fbmor/ComfyUI/alembic_db/versions/0001_assets.pyupgrade   s   	"""""
"r   c                   C   sJ  t jddd t jddd t jddd t jddd t d t jddd t jd	dd t jd
dd t d t jddd t jddd t d t jddd t d t jddd t jddd t jd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 jddd t jddd t d d S )NrR   rE   )
table_namerQ   rP   rO   rD   r;   rC   rB   r:   r1   r9   r0   r+   r$   r   r*   r)   r(   r'   r&   r%   r   r   r   )r   
drop_index
drop_tabledrop_constraintr   r   r   r   	downgrade   s2   




r   )r   N)__doc__alembicr   
sqlalchemyrm   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   r   <module>   s    
