
    +jz                     J    d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
d
dZd
d	ZdS )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_referencesreturnc            	         t          j        d          5 } |                     t          j        dt          j                    d                     |                     t          j        dt          j        d          d                     d d d            n# 1 swxY w Y   t          j        d           t          j        dt          	          5 } | 	                    d
d           | 
                    dddgdgd           |                     ddg           d d d            n# 1 swxY w Y   t          j        d           t          j        d          5 } |                     dd           d d d            d S # 1 swxY w Y   d S )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-      s|   		0	1	1 
XI'TBBB	
 	
 	
 	Ih	 4 4 4tDDD	
 	
 	
	
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 J[\\\		.?
 
 
 
	  3< 	! 	
 	
 	
 	##=NF 	$ 	
 	
 	
 	,|n	
 	
 	

 
 
 
 
 
 
 
 
 
 
 
 
 
 
$ J	_   
	4	5	5 
((/h	
 	
 	

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
s7   A9BB!BAD++D/2D/FF	Fc                  ^   t          j        dt          j        dd          g          5 } |                     dd           d d d            n# 1 swxY w Y   t          j        dt
          	          5 } |                     d
           |                     dd           |                     dddgdgd           d d d            n# 1 swxY w Y   t          j        d          5 } |                     d           |                     d           d d d            d S # 1 swxY w Y   d S )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,   	downgrader6   ?   s0   
 
	l8  

 
 
 
 
  /w 	! 	
 	
 	

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
	.?
 
 
 
	<===  =\ 	! 	
 	
 	
 	##3NF 	$ 	
 	
 	

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
	0	1	1 0XX&&&.///0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0s6   AAA6A	CCC*+D""D&)D&)r   N)__doc__alembicr   
sqlalchemyr!   app.database.modelsr   revisiondown_revisionbranch_labels
depends_onr-   r6        r,   <module>rA      s               1 1 1 1 1 1%0
'
 '
 '
 '
T#0 #0 #0 #0 #0 #0r@   