
    +j2                     @    S r SSKJr  SSKrSrSrSrSrSS jr	SS jr
g)	a	  
Merge AssetInfo and AssetCacheState into unified asset_references table.

This migration drops old tables and creates the new unified schema.
All existing data is discarded.

Revision ID: 0002_merge_to_asset_references
Revises: 0001_assets
Create Date: 2025-02-11
    )opN0002_merge_to_asset_references0001_assetsc                     [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " S5        [         R                  " SSS9  [         R                  " S	SS9  [         R                  " S5        [         R                  " S
SS9  [         R                  " SSS9  [         R                  " S5        [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " S5        [         R                  " S5        [         R                  " S[
        R                  " S[
        R                  " SS9SS9[
        R                  " S[
        R                  " SS9[
        R                  " SSS9SS 9[
        R                  " S![
        R                  " 5       SS 9[
        R                  " S"[
        R                  " 5       SS 9[
        R                  " S#[
        R                  " 5       S[
        R                  " S$5      S%9[
        R                  " S&[
        R                  " 5       S[
        R                  " S$5      S%9[
        R                  " S'[
        R                  " 5       SS(S%9[
        R                  " S)[
        R                  " S*S9SS+S%9[
        R                  " S,[
        R                  " S-S9SS 9[
        R                  " S.[
        R                  " SS9[
        R                  " SS/S9SS 9[
        R                  " S0[
        R                  " 5       SS 9[
        R                  " S1[
        R                  " SS29SS 9[
        R                  " S3[
        R                  " SS29SS 9[
        R                  " S4[
        R                  " SS29SS 9[
        R                  " S5[
        R                  " SS29SS 9[
        R                   " S6S7S89[
        R                   " S9S:S895        [         R"                  " S;SS!/SS<9  [         R"                  " S=SS/5        [         R"                  " S>SS)/5        [         R"                  " S?SS,/5        [         R"                  " S@SS&/5        [         R"                  " SASS'/5        [         R"                  " SBSS1/5        [         R"                  " SCSS4/5        [         R"                  " SDSS)S,/5        [         R"                  " SESS5/5        [         R                  " SF[
        R                  " SG[
        R                  " SS9[
        R                  " SHSS9SS 9[
        R                  " SI[
        R                  " S-S9[
        R                  " SJSKS9SS 9[
        R                  " SL[
        R                  " SMS9SSNS%9[
        R                  " SO[
        R                  " SS29SS 9[
        R$                  " SGSISPS895        [         R"                  " SQSFSI/5        [         R"                  " SRSFSG/5        [         R                  " SS[
        R                  " SG[
        R                  " SS9[
        R                  " SHSS9SS 9[
        R                  " ST[
        R                  " SUS9SS 9[
        R                  " SV[
        R                  " 5       SS(S%9[
        R                  " SW[
        R                  " SXS9SS 9[
        R                  " SY[
        R&                  " SZS[5      SS 9[
        R                  " S\[
        R                  " 5       SS 9[
        R                  " S][
        R                  " 5       SS 9[
        R$                  " SGSTSVS^S895	        [         R"                  " S_SSST/5        [         R"                  " S`SSSTSW/5        [         R"                  " SaSSSTSY/5        [         R"                  " SbSSSTS\/5        g )cNix_asset_info_meta_key_val_boolasset_info_meta
table_nameix_asset_info_meta_key_val_numix_asset_info_meta_key_val_strix_asset_info_meta_key ix_asset_info_tags_asset_info_idasset_info_tagsix_asset_info_tags_tag_nameix_asset_cache_state_asset_idasset_cache_stateix_asset_cache_state_file_pathix_assets_info_owner_nameassets_infoix_assets_info_last_access_timeix_assets_info_created_atix_assets_info_nameix_assets_info_asset_idix_assets_info_owner_idDELETE FROM assetsasset_referencesid$   lengthTprimary_keyasset_id	assets.idCASCADEondeleteFnullable	file_pathmtime_nsneeds_verifyfalser)   server_default
is_missingenrichment_level0owner_id    name   
preview_idSET NULLuser_metadata
created_attimezone
updated_atlast_access_time
deleted_at%(mtime_ns IS NULL) OR (mtime_ns >= 0)ck_ar_mtime_nonnegr6   z/enrichment_level >= 0 AND enrichment_level <= 2ck_ar_enrichment_level_rangeuq_asset_references_file_path)uniqueix_asset_references_asset_idix_asset_references_owner_idix_asset_references_nameix_asset_references_is_missing$ix_asset_references_enrichment_levelix_asset_references_created_at$ix_asset_references_last_access_timeix_asset_references_owner_nameix_asset_references_deleted_atasset_reference_tagsasset_reference_idzasset_references.idtag_name	tags.nameRESTRICTorigin    manualadded_atpk_asset_reference_tags ix_asset_reference_tags_tag_name*ix_asset_reference_tags_asset_reference_idasset_reference_metakey   ordinalval_str   val_num&   
   val_boolval_jsonpk_asset_reference_metaix_asset_reference_meta_key#ix_asset_reference_meta_key_val_str#ix_asset_reference_meta_key_val_num$ix_asset_reference_meta_key_val_bool)r   
drop_index
drop_tableexecutecreate_tablesaColumnString
ForeignKeyText
BigIntegerBooleantextIntegerJSONDateTimeCheckConstraintcreate_indexPrimaryKeyConstraintNumeric     R/home/wildlama/comfy/ComfyUI/alembic_db/versions/0002_merge_to_asset_references.pyupgrader      s7   MM3@QRMM2?PQMM2?PQMM*7HIMM#$MM4ARSMM/<MNMM#$MM1>QRMM2?RSMM%&MM--HMM3NMM--HMM'MBMM+FMM+FMM-  JJ#$ OO
		$		,$?
		IIR MM+	:		
 			+rwwy48
		*bmmo=
		JJL777+		
 			"**,rwwwGW	
 			$bjjlUSVW
		*biis3eTVW
		&"))3/%@
		IIR MM+
;		
 			/2779t<
		,U ;eL
		,U ;eL
		$bkk5&AER
		,U ;dK
3:N	
 	=/	
K)T OO');k]SW OO24FUOO24FUOO.0BVHMOO46H<.YOO.0BEWDX OO46H<.YOO.0BEWDX OO(*<z6>R OO46H<.Y OO
		 IIR MM/)D		
 			IIS!MM+
;		
 			biir*U8	
 			*bkk59EJ
 *3L	
%, OO*,BZL OO4	 OO
		 IIR MM/)D		
 			%#.?
		)RZZ\E#N
		)RYYd3dC
		)RZZB/$?
		*bjjlT:
		*bggi$7
 %9R	
$ OO13IE7SOO-/EyGY OO-/EyGY OO.	
r   c                  p   [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " S5        [         R                  " SSS9  [         R                  " S	SS9  [         R                  " S5        [         R                  " S
SS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " SSS9  [         R                  " S5        [         R                  " S5        [         R                  " S[
        R                  " S[
        R                  " SS9SS9[
        R                  " S[
        R                  " SS9SSS 9[
        R                  " S![
        R                  " S"S9SS#9[
        R                  " S$[
        R                  " SS9[
        R                  " S%S&S'9SS#9[
        R                  " S([
        R                  " SS9[
        R                  " S%S)S'9SS#9[
        R                  " S*[
        R                  " 5       SS#9[
        R                  " S+[
        R                  " SS,9SS#9[
        R                  " S-[
        R                  " SS,9SS#9[
        R                  " S.[
        R                  " SS,9SS#9[
        R                  " S$SS!S/S095        [         R                  " S1SS/5        [         R                  " S2SS$/5        [         R                  " S3SS!/5        [         R                  " S4SS+/5        [         R                  " S5SS./5        [         R                  " S6SSS!/5        [         R                  " S7[
        R                  " S[
        R                  " 5       SSS89[
        R                  " S$[
        R                  " SS9[
        R                  " S%S9S'9SS#9[
        R                  " S:[
        R                  " 5       SS#9[
        R                  " S;[
        R                  " 5       SS#9[
        R                  " S<[
        R                   " 5       S[
        R"                  " S=5      S 9[
        R$                  " S>S?S09[
        R                  " S:S@S095        [         R                  " SAS7S:/5        [         R                  " SBS7S$/5        [         R                  " SC[
        R                  " SD[
        R                  " SS9[
        R                  " SES9S'9SS#9[
        R                  " SF[
        R                  " S"S9[
        R                  " SGS&S'9SS#9[
        R                  " SH[
        R                  " SIS9SSJS 9[
        R                  " SK[
        R                  " SS,9SS#9[
        R&                  " SDSFSLS095        [         R                  " SMSCSF/5        [         R                  " SNSCSD/5        [         R                  " SO[
        R                  " SD[
        R                  " SS9[
        R                  " SES9S'9SS#9[
        R                  " SP[
        R                  " SQS9SS#9[
        R                  " SR[
        R                  " 5       SSSS 9[
        R                  " ST[
        R                  " SUS9SS#9[
        R                  " SV[
        R(                  " SWSX5      SS#9[
        R                  " SY[
        R                   " 5       SS#9[
        R                  " SZ[
        R                  " 5       SS#9[
        R&                  " SDSPSRS[S095	        [         R                  " S\SOSP/5        [         R                  " S]SOSPST/5        [         R                  " S^SOSPSV/5        [         R                  " S_SOSPSY/5        g`)aa-  Reverse 0002_merge_to_asset_references: drop new tables, recreate old schema.

NOTE: Data is not recoverable. The upgrade discards all rows from the old
tables and truncates assets. After downgrade the old schema will be empty.
A filesystem rescan will repopulate data once the older code is running.
rk   r\   r	   rj   ri   rh   r[   rP   rZ   rO   r   rN   rM   rL   rK   rJ   rI   rH   rG   rE   r   r   r   r   r   Tr!   r3   r4   Fr5   r.   r6   r7   r(   r#   r$   rT   r&   r8   r9   r:   r;   r<   r>   r?   uq_assets_info_asset_owner_namerC   r   r   r   r   r   r   r   )r"   autoincrementr%   r*   r+   r,   r-   rA   ck_acs_mtime_nonneguq_asset_cache_state_file_pathr   r   r   asset_info_idzassets_info.idrR   rS   rU   rV   rW   rX   pk_asset_info_tagsr   r   r   r]   r^   r_   r2   r`   ra   rb   rc   rd   re   rf   pk_asset_info_metar   r   r   r   N)r   rl   rm   rn   ro   rp   rq   rr   rs   ry   rz   UniqueConstraintr|   rx   rt   ru   rv   rw   r{   r}   r~   r   r   r   	downgrader      s    MM8E[\MM7DZ[MM7DZ[MM/<RSMM()MM>KabMM4AWXMM()MM2?QRMM2?QRMM8EWXMM2?QRMM8EWXMM2?QRMM,9KLMM0=OPMM0=OPMM1>PQMM$% JJ#$ OO
		$		,$?
		*biis3eTVW
		&"))3/%@
		*biir2BMM+Xb4cnst
		,		 4bmmKZd6eptu
		/2779t<
		,U ;eL
		,U ;eL
		$bkk5&AER
J
FAbc OO-}zlKOO-}zlKOO)=6(COO/OOO5}GYFZ[OO/V@TUOO
		$

$dK
		*biir2BMM+Xa4bmrs
		+rwwy59
		*bmmo=
		."**,rwwW^O_`
BI^_
K.NO	 OO46IK=YOO35H:,WOO
		/299B#7GWbk9lw|}
		*biis3R]];Yc5dotu
		(BIIR05QYZ
		*bkk59EJ
BVW OO13DzlSOO68IOK\]OO
		/299B#7GWbk9lw|}
		%#.?
		)RZZ\E#N
		)RYYd3dC
		)RZZB/$?
		*bjjlT:
		*bggi$7
	H\]
 OO,.?%IOO46G%QZI[\OO46G%QZI[\OO57H5R\J]^r   )returnN)__doc__alembicr   
sqlalchemyrp   revisiondown_revisionbranch_labels
depends_onr   r   r   r   r   <module>r      s4   	  +
Wt\_r   