+j2>dZddlmZddlZdZdZdZdZd dZ d dZ dS) 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 )opN0002_merge_to_asset_references 0001_assetsreturnctjddtjddtjddtjddtjdtjddtjd dtjdtjd d tjd d tjd tjd dtjddtjddtjddtjddtjddtjdtjdtjdt jdt jddt jdt jdt jddd t jd!t j d t jd"t j d t jd#t j dt j d$%t jd&t j dt j d$%t jd't j dd(%t jd)t jd*dd+%t jd,t jd-d t jd.t jdt jdd/d t jd0t jd t jd1t jd2d t jd3t jd2d t jd4t jd2d t jd5t jd2d t jd6d78t jd9d:8tjd;dd!gd<tjd=ddgtjd>dd)gtjd?dd,gtjd@dd&gtjdAdd'gtjdBdd1gtjdCdd4gtjdDdd)d,gtjdEdd5gtjdFt jdGt jdt jdHdd t jdIt jd-t jdJdKd t jdLt jdMddN%t jdOt jd2d t jdGdIdP8tjdQdFdIgtjdRdFdGgtjdSt jdGt jdt jdHdd t jdTt jdUd t jdVt j dd(%t jdWt jdXd t jdYt jdZd[d t jd\t j d t jd]t jd t jdGdTdVd^8 tjd_dSdTgtjd`dSdTdWgtjdadSdTdYgtjdbdSdTd\gdS)cNix_asset_info_meta_key_val_boolasset_info_meta table_nameix_asset_info_meta_key_val_numix_asset_info_meta_key_val_strix_asset_info_meta_key ix_asset_info_tags_asset_info_idasset_info_tagsix_asset_info_tags_tag_nameix_asset_cache_state_asset_idasset_cache_stateix_asset_cache_state_file_pathix_assets_info_owner_name assets_infoix_assets_info_last_access_timeix_assets_info_created_atix_assets_info_nameix_assets_info_asset_idix_assets_info_owner_idDELETE FROM assetsasset_referencesid$lengthT primary_keyasset_id assets.idCASCADEondeleteFnullable file_pathmtime_ns needs_verifyfalser*server_default is_missingenrichment_level0owner_idname preview_idSET NULL user_metadata created_attimezone updated_atlast_access_time deleted_at%(mtime_ns IS NULL) OR (mtime_ns >= 0)ck_ar_mtime_nonnegr7z/enrichment_level >= 0 AND enrichment_level <= 2ck_ar_enrichment_level_rangeuq_asset_references_file_path)uniqueix_asset_references_asset_idix_asset_references_owner_idix_asset_references_nameix_asset_references_is_missing$ix_asset_references_enrichment_levelix_asset_references_created_at$ix_asset_references_last_access_timeix_asset_references_owner_nameix_asset_references_deleted_atasset_reference_tagsasset_reference_idzasset_references.idtag_name tags.nameRESTRICTorigin manualadded_atpk_asset_reference_tags ix_asset_reference_tags_tag_name*ix_asset_reference_tags_asset_reference_idasset_reference_metakeyordinalval_strval_num& val_boolval_jsonpk_asset_reference_metaix_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_tableexecute create_tablesaColumnString ForeignKeyText BigIntegerBooleantextIntegerJSONDateTimeCheckConstraint create_indexPrimaryKeyConstraintNumericR/home/wildlama/comfy/ComfyUI/alembic_db/versions/0002_merge_to_asset_references.pyupgraders3M3@QRRRRM2?PQQQQM2?PQQQQM*7HIIIIM#$$$M4ARSSSSM/QRRRRM2?RSSSSM%&&&M--HHHHM3 NNNNM--HHHHM'MBBBBM+ FFFFM+ FFFFM-   J#$$$O $ ,,,$???  IR M+ : : :    +rwyy4888 *bmoo===  JLL77++    "*,,rwwGWGW    $bjllUSVWWW *bis333eTVWWW &")3///%@@@  IR M+ ; ; ;    /2799t<<< , U ; ; ;eLLL , U ; ; ;eLLL $bk5&A&A&AERRR , U ; ; ;dKKK  3:N     =/   K)))TO');k]SWO24F UUUO24F UUUO.0BVHMMMO46H<.YYYO.0BEWDXO46H<.YYYO.0BEWDXO(*RO46H<.YYYO IR M/) D D D     IS ! ! ! M+ ; ; ;    bir***U8    *bk5999EJJJ  *3L   %,O*,BZLO4 O IR M/) D D D    %#...??? )RZ\\E#NNN )RYd333dCCC )RZB//$??? *bjllT::: *bgii$777  %9R   $O13IE7SSSO-/EyGYO-/EyGYO.  rcztjddtjddtjddtjddtjdtjddtjd dtjdtjd d tjd d tjd d tjdd tjdd tjdd tjdd tjdd tjdd tjdd tjd tjdtjdt jdt jddt jdt jddd t jd!t jd"d#t jd$t jdt jd%d&'d#t jd(t jdt jd%d)'d#t jd*t j d#t jd+t j d,d#t jd-t j d,d#t jd.t j d,d#t j d$dd!d/0 tj d1ddgtj d2dd$gtj d3dd!gtj d4dd+gtj d5dd.gtj d6ddd!gtjd7t jdt j dd8t jd$t jdt jd%d9'd#t jd:t jd#t jd;t jd#t jdd?0t j d:d@0tj dAd7d:gtj dBd7d$gtjdCt jdDt jdt jdEd9'd#t jdFt jd"t jdGd&'d#t jdHt jdIddJ t jdKt j d,d#t jdDdFdL0tj dMdCdFgtj dNdCdDgtjdOt jdDt jdt jdEd9'd#t jdPt jdQd#t jdRt j ddS t jdTt jdUd#t jdVt jdWdXd#t jdYt jd#t jdZt j d#t jdDdPdRd[0 tj d\dOdPgtj d]dOdPdTgtj d^dOdPdVgtj d_dOdPdYgd`S)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. rlr]r rkrjrir\rQr[rPrrOrNrMrLrKrJrIrHrFrrrrr Tr"r4r5Fr6r/r7r8r)r$r%rUr'r9r:r;r<r=r?r@uq_assets_info_asset_owner_namerDrrrrrrr)r# autoincrementr&r+r,r-r.rBck_acs_mtime_nonneguq_asset_cache_state_file_pathrrr asset_info_idzassets_info.idrSrTrVrWrXrYpk_asset_info_tagsrrr r^r_r`r3rarbrcrdrerfrgpk_asset_info_metarr r rN)rrmrnrorprqrrrsrtrzr{UniqueConstraintr}ryrurvrwrxr|r~rrrr downgraders}M8E[\\\\M7DZ[[[[M7DZ[[[[M/KabbbbM4AWXXXXM()))M2?QRRRRM2?QRRRRM8EWXXXXM2?QRRRRM8EWXXXXM2?QRRRRM,9KLLLLM0=OPPPPM0=OPPPPM1>PQQQQM$%%%J#$$$O $ ,,,$??? *bis333eTVWWW &")3///%@@@ *bir222BM+Xb4c4c4cnsttt ,  4 4 4bmKZd6e6e6eptuuu /2799t<<< , U ; ; ;eLLL , U ; ; ;eLLL $bk5&A&A&AERRR J FAbccc   O-}zlKKKO-}zlKKKO)=6(CCCO/OOOO5}GYFZ[[[O/V@TUUUO $ $dKKK *bir222BM+Xa4b4b4bmrsss +rwyy5999 *bmoo=== ."*,,rwW^O_O_``` BI^___ K.NOOO   O46IK=YYYO35H:,WWWO /29B#7#7#7GWbk9l9l9lw|}}} *bis333R];Yc5d5d5dotuuu (BIR0005QYZZZ *bk5999EJJJ BVWWW O13DzlSSSO68IOK\]]]O /29B#7#7#7GWbk9l9l9lw|}}} %#...??? )RZ\\E#NNN )RYd333dCCC )RZB//$??? *bjllT::: *bgii$777  H\]]]   O,.?%IIIO46G%QZI[\\\O46G%QZI[\\\O57H5R\J]^^^^^r)rN) __doc__alembicr sqlalchemyrqrevision down_revision branch_labels depends_onrrrrrrs   +   WWWWt\_\_\_\_\_\_r