
    &i                         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)zjsmart inv start

Revision ID: c43c088686d5
Revises: 7268a22148b7
Create Date: 2025-11-26 10:40:13.618486

    )SequenceUnion)opNc43c088686d5revision7268a22148b7down_revisionbranch_labels
depends_onc                     t        j                  dt        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  dt        j
                  d	
      d      t        j                  dt        j                  d      t        j                  d      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       t        j                  dt        j                  dt        j                         dd      t        j                  dt        j                         d      t        j                  dt        j
                  d	
      d      t        j                  dt        j                  d      t        j                  d      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       t        j                  dt        j                  dt        j                         d      t        j                  dt        j
                  d	
      d      t        j                  dt        j
                  d
      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                  d      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                  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       t        j                  d)t        j                  dt        j                         dd      t        j                  d*t        j                         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      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       t        j                  d0t        j                  dt        j                         dd      t        j                  d1t        j                         d      t        j                  d2t        j
                  d3
      d      t        j                  d4t        j
                  d	
      d      t        j                  d5t        j                         d      t        j                  d6t        j
                  d	
      d      t        j                  d7t        j                         d      t        j                  d8t        j                         d      t        j                  d9t        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                  dAt        j
                  dB
      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dt        j                  d      t        j                  d      d      t        j                  d7gdCg      t        j                  d             t        j                  t        j                  dD      d0dgd       t        j                  t        j                  dE      d0d1gd       t        j                  dFt        j                  dt        j                         dd      t        j                  d1t        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgdGg      t        j                  d1gdHg      t        j                  d             t        j                  t        j                  dI      dFdgd       t        j                  dJt        j                  dt        j                         dd      t        j                  d1t        j                         d      t        j                  d*t        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  d1gdHg      t        j                  d*gdKg      t        j                  d             t        j                  t        j                  dL      dJdgd       y )MN
categoriesidTF)autoincrementnullablecategory_id)r   category_name   )length
created_at)timezoneznow())server_defaultr   
updated_atix_categories_category_id)uniqueix_categories_id	locationslocation_idlocation_nameix_locations_idix_locations_location_idproduct_fetch_cron_logstask_idstatus2   
company_idtotal_pages	page_sizetotal_itemsprocessed_itemserror_count
started_atcompleted_atduration_secondserror_messagetask_resultix_product_fetch_cron_logs_id"ix_product_fetch_cron_logs_task_idvendors	vendor_idvendor_namevendor_coded   ix_vendors_idix_vendors_vendor_idproducts
product_idproduct_namei  
short_namedescription
brand_namefk_product_category_ideligible_for_returndisplay_on_posdisplay_on_online_storeis_perishableproduct_price_idcost_price_per_unitmarkup_valuemargin_valueretail_price_excl_tax
image_pathi  zcategories.category_idix_products_idix_products_product_idproduct_locationszlocations.location_idzproducts.product_idix_product_locations_idproduct_vendorszvendors.vendor_idix_product_vendors_id)r   create_tablesaColumnIntegerStringDateTimetextPrimaryKeyConstraintcreate_indexfTextJSONBooleanFloatForeignKeyConstraint     L/var/www/html/hubwallet-dev/alembic/versions/c43c088686d5_smart_inv_start.pyupgraderb      s   OOLIIdBJJLuEIImRZZ\E:IIoryy4uEIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfgD! OOBDD45|m_]abOOBDD+,lTF5QOOKIIdBJJLuEIImRZZ\E:IIoryy4uEIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfgD! OOBDD*+[4&OOOBDD34kM?[_`OO-IIdBJJL51IIi#.>IIh		,u=IIlBJJL59IImRZZ\E:IIk2::<%8IImRZZ\D9II=IImRZZ\D9IIlBKK6rwwwGWbghIInbkk484HII "**,>IIorwwy48IImRWWY6IIlBKK6rwwwGWbghIIlBKK6rwwwGWbghD!#& OOBDD89;TW[V\ejkOOBDD=>@Y\e[fotuOOIIIdBJJLuEIIk2::<%8IImRYYc2UCIImRYYc2TBIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfgD! OOBDD)9tfUKOOBDD/0)k]SWXOOJIIdBJJLuEIIlBJJL59IInbiis3eDIIlBIIS1DAIImRWWY6IIlBIIS1DAII&

tDII#RZZ\DAII

t<II'EIIorzz|d;II "**,>II#RXXZ$?IInbhhj48IInbhhj48II%rxxzDAIIlBIIT2TBIIlBKK6rwwwGWbfgIIlBKK6rwwwGWbfg569Q8RUD!+. OOBDD)*JuMOOBDD12JW[\OO'IIdBJJLuEIIlBJJL59IImRZZ\E:IIlBKK6rwwwGWbfg]O.E-FI\N-B,CFD! OOBDD235H4&Y^_OO%IIdBJJLuEIIlBJJL59IIk2::<%8IIlBKK6rwwwGWbfg\N-B,CF[M,?+@CD! OOBDD013DtfUZ[r`   c                     t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d	      d
       t        j                  t        j                  d      d
       t        j                  d
       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       y )NrO   rN   )
table_namerM   rL   rK   r9   rJ   r8   r2   r7   r1   r!   r0   r    r   r   r   r   r   )r   
drop_indexrY   
drop_tabler_   r`   ra   	downgraderg   {   s|   MM"$$./<MNMM#$MM"$$01>QRMM%&MM"$$/0ZHMM"$$'(Z@MM*MM"$$-.9EMM"$$'I>MM)MM"$$;<IbcMM"$$67D]^MM+,MM"$$12{KMM"$$()kBMM+MM"$$)*|DMM"$$23MMM,r`   )returnN)__doc__typingr   r   alembicr   
sqlalchemyrQ   r   str__annotations__r	   r
   r   rb   rg   r_   r`   ra   <module>ro      su    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2b\L r`   