
    <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	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)z`Initial migration

Revision ID: b16cc0fafacf
Revises: 
Create Date: 2025-12-13 02:05:48.182494

    )SequenceUnion)opNb16cc0fafacfrevision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                  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      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                  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      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d      t        j                  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      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gd g      t        j                  dgd!g      t        j                  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      t        j                  d$t        j                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd g      t        j                  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      t        j                  dt        j
                         d      t        j                  dt        j                  d      t        j                  d      d      t        j                  dgd g      t        j                  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      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)gd,g      t        j                  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      t        j                  d0t        j                          d      t        j                  d1t        j                  d      t        j                  d      d      t        j                  d/gd2g      t        j                  d             t        j                  t        j                  d3      d.dgd       y4)5zUpgrade schema.adminsidF)nullableemailhashed_password	full_nameT	is_activeix_admins_email)uniqueix_admins_id	companiescompany_namephone_numbertokens_balanceix_companies_emailix_companies_idsubscription_packsnametokenspriceix_subscription_packs_idcompany_subscriptions
company_idpack_id
created_at)timezoneznow())server_defaultr   
price_paidzcompanies.idzsubscription_packs.idix_company_subscriptions_idsearchesinitial_promptix_searches_id
shortlistsix_shortlists_idsearch_messages	search_idrolecontentzsearches.idix_search_messages_idshortlist_candidatesshortlist_idcandidate_dataadded_atzshortlists.idix_shortlist_candidates_idN)r   create_tablesaColumnIntegerStringBooleanPrimaryKeyConstraintcreate_indexfFloatUniqueConstraintDateTimetextForeignKeyConstraintTextJSON     R/home/www/utuvibe.miabetepe.com/alembic/versions/b16cc0fafacf_initial_migration.pyupgraderK      sP    OOHIIdBJJL51IIgryy{U3IIu=IIk299;6IIk2::<$7D! OOBDD*+XyNOOBDD((TF5IOOKIIdBJJL51IInbiikE:IIgryy{U3IInbiikD9IIu=IIk2::<$7II

t<D!	 OOBDD-.gYtTOOBDD*+[4&OOO(IIdBJJL51IIfbiikE2IIh

u5IIgrxxzE2D! OOBDD346JTF[`aOO+IIdBJJL51IIlBJJL48IIi5IIlBKK6rwwwGWbfgIIlBHHJ6\N^,<?YK*A)BED!	 OOBDD679PSWRXafgOOJIIdBJJL51IIlBJJL48II	E:IIlBKK6rwwwGWbfg\N^,<?D! OOBDD)*JuMOOLIIdBJJL51IIlBJJL48IIfbiikE2IIlBKK6rwwwGWbfg\N^,<?D! OOBDD+,lTF5QOO%IIdBJJL51IIk2::<$7IIfbiikE2IIiU3IIlBKK6rwwwGWbfg[MM?=D! OOBDD013DtfUZ[OO*IIdBJJL51IInbjjlT:II	E:IIj"++t4RWWWEU`de^,.?BD! OOBDD568NQUPV_derI   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                  d       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                  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)zDowngrade schema.r7   r3   )
table_namer2   r.   r-   r,   r+   r)   r(   r!   r    r   r   r   r   r   r   r   N)r   
drop_indexr@   
drop_tablerH   rI   rJ   	downgraderP   j   s[    MM"$$34AWXMM()MM"$$./<MNMM#$MM"$$)*|DMM,MM"$$'(Z@MM*MM"$$45BYZMM)*MM"$$12?STMM&'MM"$$()kBMM"$$+,EMM+MM"$$~&8<MM"$$()h?MM(rI   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr9   r   str__annotations__r   r	   r
   rK   rP   rH   rI   rJ   <module>rX      s|    #   # 15uS(3--. 515uS(3--. 5.2
E#x}d*+ 2QfjrI   