
    +jw"                     >    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_
Initial assets schema
Revision ID: 0001_assets
Revises: None
Create Date: 2025-12-10 00:00:00
    )opN0001_assetsreturnc                  4   t          j        dt          j        dt          j        d          d          t          j        dt          j        d          d	          t          j        d
t          j                    dd          t          j        dt          j        d          d	          t          j        dt          j        d          d	          t          j        dd                     t          j        dddgd           t          j        dddg           t          j        dt          j        dt          j        d          d          t          j        dt          j        d          dd          t          j        dt          j        d          d	          t          j        dt          j        d          t          j	        dd !          d	          t          j        d"t          j        d          t          j	        dd#!          d	          t          j        d$t          j
                    d	          t          j        dt          j        d          d	          t          j        d%t          j        d          d	          t          j        d&t          j        d          d	          t          j        dddd'                     t          j        d(ddg           t          j        d)ddg           t          j        d*ddg           t          j        d+ddg           t          j        d,dd&g           t          j        d-dddg           t          j        d.t          j        dt          j        d          d          t          j        d/t          j        d0          dd1          t          j        d2d3                     t          j        d4d.d/g           t          j        d5t          j        d6t          j        d          t          j	        d7d8!          d	          t          j        d9t          j        d          t          j	        d:d !          d	          t          j        d;t          j        d0          dd<          t          j        d=t          j        d          d	          t          j        d6d9d>                     t          j        d?d5d9g           t          j        d@d5d6g           t          j        dAt          j        dt          j                    ddB          t          j        dt          j        d          t          j	        dd8!          d	          t          j        dCt          j                    d	          t          j        dDt          j                    d	          t          j        dEt          j                    dt          j        dF                    t          j        dGdH          t          j        dCdI                     t          j        dJdAdCg           t          j        dKdAdg           t          j        dLt          j        d6t          j        d          t          j	        d7d8!          d	          t          j        dMt          j        d          d	          t          j        dNt          j                    dd          t          j        dOt          j        dP          d	          t          j        dQt          j        dRdS          d	          t          j        dTt          j                    d	          t          j        dUt          j
                    d	          t          j        d6dMdNdV          	  	         t          j        dWdLdMg           t          j        dXdLdMdOg           t          j        dYdLdMdQg           t          j        dZdLdMdTg           t          j        d.t          j        dt          j        d                    t          j        d/t          j                                        } t          j        | 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_tables    ?/home/wildlama/comfy/ComfyUI/alembic_db/versions/0001_assets.pyupgrader      s   O
	$	,,,$???
	&")3///$???
	,%PSTTT
	+ry444tDDD
	,U ; ; ;eLLL
,3JKKK   O$hFFFFO)8k]CCC O
	$	,,,$???
	*bis333eTVWWW
	&")3///%@@@
	*bir222BM+Xb4c4c4cnsttt
	,	 4 4 4bmKZd6e6e6eptuuu
	/2799t<<<
	,U ; ; ;eLLL
	,U ; ; ;eLLL
	$bk5&A&A&AERRR
J
FAbccc   O-}zlKKKO-}zlKKKO)=6(CCCO/OOOO5}GYFZ[[[O/V@TUUU O
	&")3///TBBB
	*bir222USYZZZ
/6IJJJ	   O&=== O
	/29B#7#7#7GWbk9l9l9lw|}}}
	*bis333R];Yc5d5d5dotuuu
	(BIR0005QYZZZ
	*bk5999EJJJ
BVWWW   O13DzlSSSO68IOK\]]] O
	$
$dKKK
	*bir222BM+Xa4b4b4bmrsss
	+rwyy5999
	*bmoo===
	."*,,rwW^O_O_```
BI^___
K.NOOO	 	 	 O46IK=YYYO35H:,WWW O
	/29B#7#7#7GWbk9l9l9lw|}}}
	%#...???
	)RZ\\E#NNN
	)RYd333dCCC
	)RZB//$???
	*bjllT:::
	*bgii$777
	H\]]]
 
 
 O,.?%IIIO46G%QZI[\\\O46G%QZI[\\\O57H5R\J]^^^ 
	&")3///00
	*bikk** J
 N844(33844H55"99(3311$(;;'X>>"99#::!x88 h77!x88!x88844%8<<$(;;!x88"99H55H55H558447	
        c                  :   t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        d           t          j        dd           t          j        d	d           t          j        d
d           t          j        d           t          j        dd           t          j        dd           t          j        d           t          j        dd           t          j        d           t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        d           t          j        dd           t          j        dd           t          j        d           d S )NrT   rG   )
table_namerS   rR   rQ   rF   r=   rE   rD   r<   r3   r;   r2   r-   r&   r   r,   r+   r*   r)   r(   r'   r   r   r   )r   
drop_index
drop_tabledrop_constraint r   r   	downgrader      s   M3@QRRRRM2?PQQQQM2?PQQQQM*7HIIIIM#$$$M1>QRRRRM2?RSSSS7DWXXXXM%&&&M4ARSSSSM/<MNNNNM#$$$M$8888M&8]SSSSM--HHHHM3NNNNM--HHHHM'MBBBBM+FFFFM+FFFFM-   M"x8888M'H====M(r   )r   N)__doc__alembicr   
sqlalchemyro   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      sz              
| | | |~     r   