
    úhi	                         U d Z ddlmZmZ ddlmZ ddl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)zlstore perofrmance

Revision ID: 7268a22148b7
Revises: ea9af0313019
Create Date: 2025-09-05 11:05:07.687672

    )SequenceUnion)opN7268a22148b7revisionea9af0313019down_revisionbranch_labels
depends_onc                     t        j                  dt        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j
                         d      t        j                  d	t        j
                         d      t        j                  d
t        j
                         d      t        j                  dt        j
                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                         dd      t        j                  d             t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       y )Nstore_performance_scoresidF)nullablestore_id	branch_idToverall_scoreengagement_ratereach_efficiencyposting_consistencyplatform_scorestotal_poststotal_engagementtotal_impressionstotal_followersconnected_accounts_countscore_month
score_year
created_at
updated_at	is_activetrue)server_defaultr   %ix_store_performance_scores_branch_id)unique$ix_store_performance_scores_store_id)r   create_tablesaColumn
BigIntegerFloatTextIntegerDateTimeBooleanPrimaryKeyConstraintcreate_indexf     N/var/www/html/hubwallet-dev/alembic/versions/7268a22148b7_store_perofrmance.pyupgrader5      s   OO.IIdBMMOe4IIj"--/E:IIk2==?T:IIorxxzE:IIe<II "((*u=II#RXXZ%@IIT:IImRZZ\E:II "--/EBII!2==?UCII5AII("**,GIImRZZ\E:IIlBJJL59IIlBKKME:IIlBKKME:IIk2::<OD!'* OOBDD@AC]`k_luz{OOBDD?@B\_i^jsxyr3   c                      t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       y )Nr%   r   )
table_namer#   )r   
drop_indexr1   
drop_tabler2   r3   r4   	downgrader:   1   sA    MM"$$=>KefMM"$$>?LfgMM,-r3   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr'   r   str__annotations__r	   r
   r   r5   r:   r2   r3   r4   <module>rB      ss    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2z8.r3   