
    Cir                         U d Z ddlmZmZ ddlmZ ddlZddlm	Z	 dZ
eed<   dZeedf   ed	<   dZeeee   df   ed
<   dZeeee   df   ed<   ddZddZy)ziimage url chat

Revision ID: ea9af0313019
Revises: 6a790c90ae30
Create Date: 2025-09-05 10:42:39.581336

    )SequenceUnion)opN)
postgresqlea9af0313019revision6a790c90ae30down_revisionbranch_labels
depends_onc            	         t        j                  dd       t        j                  dd       t        j                  dd       t        j                  dd       t        j                  ddd	       t        j                  d       t        j                  d
t	        j
                  dt	        j                  d      d             y )N&idx_store_performance_scores_branch_idstore_performance_scores)
table_name'idx_store_performance_scores_month_year/idx_store_performance_scores_store_branch_month%idx_store_performance_scores_store_id#idx_store_performance_scores_unique(is_active = true))r   postgresql_wherechat_messages	image_urli  )lengthT)nullable)r   
drop_index
drop_table
add_columnsaColumnString     K/var/www/html/hubwallet-dev/alembic/versions/ea9af0313019_image_url_chat.pyupgrader$      s    MM:GabMM;HbcMMCPjkMM9F`aMM7D^  rF  GMM,-MM/299["))3:OZ^#_`r"   c                     t        j                  d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
t        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                  d      dd      t        j                  dt        j                         dd      t        j                  dt        j                         t        j                  d      dd      t        j                  dt        j
                         t        j                  d      dd      t        j                  dt        j
                         t        j                  d      dd      t        j                  dt        j
                         t        j                  d      dd      t        j                  dt        j                         t        j                  d      dd      t        j                  dt        j                         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                         t        j                  d      dd      t        j                  dd !             t        j                  d"ddt        j                  d#      ddgdd$%       t        j                  d&ddgd'       t        j                  d(dg d)d'       t        j                  d*dddgd'       t        j                  d+dd	gd'       y ),Nr   r   r   idTF)autoincrementr   store_id	branch_idoverall_score5   )	precisionengagement_ratereach_efficiencyposting_consistencyplatform_scorestotal_posts0)server_defaultr'   r   total_engagementtotal_impressionstotal_followersconnected_accounts_countscore_month
score_year
created_at)timezoneCURRENT_TIMESTAMP
updated_at	is_activetruestore_performance_scores_pkey)namer   zCOALESCE(branch_id, 0::bigint)r   )uniquer   r   )rB   r   )r(   r)   r9   r8   r   r   )r   drop_columncreate_tabler   r   BIGINTDOUBLE_PRECISIONTEXTINTEGERtextr   	TIMESTAMPBOOLEANPrimaryKeyConstraintcreate_indexr!   r"   r#   	downgraderN   !   sV   NN?K0OO.IIdBIIKteDIIj"))+UUKIIk299;edKIIor22R@PU`efII!4!4r!BRWbghII ""5"5"CSXchiII#R%8%82%FV[fklII%$OIImRZZ\"''#,V[fjkII "))+bggclZ_jnoII!299;rwws|[`kopIIRWWS\Y^imnII("**,rwws|chswxIImRZZ\OIIlBJJLNIIlJ00$?PRPWPWXkPl  }B  MQ  RIIlJ00$?PRPWPWXkPl  }B  MQ  RIIk2::<W\gklD'FG'* OO9;UXbdfdkdk  mM  eN  P\  ^k  Xl  uy  L`  aOO;=WZdYenstOOEGa  dZ  ch  iOO=?Y\hjw[x  BG  HOO<>X[fZgpuvr"   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r$   rN   r!   r"   r#   <module>rW      sw    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2awr"   