
    +jz                     L    S r SSKJr  SSKrSSKJr  SrSrSr	Sr
S	S jrS	S jrg)
z
Add system_metadata and job_id columns to asset_references.
Change preview_id FK from assets.id to asset_references.id.

Revision ID: 0003_add_metadata_job_id
Revises: 0002_merge_to_asset_references
Create Date: 2026-03-09
    )opN)NAMING_CONVENTION0003_add_metadata_job_id0002_merge_to_asset_referencesc            
         [         R                  " S5       n U R                  [        R                  " S[        R
                  " 5       SS95        U R                  [        R                  " S[        R                  " SS9SS95        S S S 5        [         R                  " S5        [         R                  " S[        S	9 n U R                  S
SS9  U R                  SSS/S/SS9  U R                  SS/5        S S S 5        [         R                  " S5        [         R                  " S5       n U R                  SS5        S S S 5        g ! , (       d  f       N= f! , (       d  f       Ng= f! , (       d  f       g = f)Nasset_referencessystem_metadataT)nullablejob_id$   )lengthzJUPDATE asset_references SET preview_id = NULL WHERE preview_id IS NOT NULLnaming_convention%fk_asset_references_preview_id_assets
foreignkeytype_/fk_asset_references_preview_id_asset_references
preview_ididSET NULLondeleteix_asset_references_preview_idztDELETE FROM asset_reference_meta WHERE val_str IS NULL AND val_num IS NULL AND val_bool IS NULL AND val_json IS NULLasset_reference_meta!ck_asset_reference_meta_has_valueZval_str IS NOT NULL OR val_num IS NOT NULL OR val_bool IS NOT NULL OR val_json IS NOT NULL)r   batch_alter_table
add_columnsaColumnJSONStringexecuter   drop_constraintcreate_foreign_keycreate_indexcreate_check_constraintbatch_ops    L/home/wildlama/comfy/ComfyUI/alembic_db/versions/0003_add_metadata_job_id.pyupgrader,      sI   			0	1XII'TB	
 	IIh		 4tD	
	 
2 JJ[\			.?
	  3< 	! 	
 	##=NF 	$ 	
 	,|n	

$ JJ	_ 
		4	5((/h	
 
6	5E 
2	1
 
, 
6	5s$   A0E>9E+E)
E
E&)
E7c            	          [         R                  " S[        R                  " SSS9/S9 n U R	                  SSS9  S S S 5        [         R                  " S[
        S	9 n U R                  S
5        U R	                  SSS9  U R                  SSS/S/SS9  S S S 5        [         R                  " S5       n U R                  S5        U R                  S5        S S S 5        g ! , (       d  f       N= f! , (       d  f       Na= f! , (       d  f       g = f)Nr   r   r   )name)
table_argscheckr   r   r   r   r   r   r   assetsr   r   r   r   r   r	   )	r   r   r    CheckConstraintr%   r   
drop_indexr&   drop_columnr)   s    r+   	downgrader5   ?   s   
 
		l8

 
  /w 	! 	

 
		.?
	<=  =\ 	! 	
 	##3NF 	$ 	

 
		0	1XX&./ 
2	19
 

 
 
2	1s#   C7C.1#C?
C+.
C<?
D)returnN)__doc__alembicr   
sqlalchemyr    app.database.modelsr   revisiondown_revisionbranch_labels
depends_onr,   r5        r+   <module>rA      s4      1%0
'
T#0r@   