
    <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)zzadd_job_offers_and_applications

Revision ID: 765a69d5bfe2
Revises: 57cbc574176d
Create Date: 2026-02-10 04:16:48.677132

    )SequenceUnion)opN765a69d5bfe2revision57cbc574176d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      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                  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       y!)"zUpgrade schema.
job_offersidF)nullable
company_idTtagtitledescriptionrequirementsresponsibilitieslocationsalary_rangecontract_type	image_url	is_active
created_at)timezoneznow())server_defaultr   
updated_atzcompanies.idix_job_offers_id)uniqueix_job_offers_tagjob_applicationsjob_offer_iduser_idstatus
applied_atzjob_offers.idix_job_applications_idN)r   create_tablesaColumnIntegerStringTextJSONBooleanDateTimetextForeignKeyConstraintPrimaryKeyConstraintcreate_indexf     /Users/theessential/Documents/Github/Quarante/therecruiter-backend/alembic/versions/765a69d5bfe2_add_job_offers_and_applications.pyupgrader9      s    OOLIIdBJJL51IIlBJJL48IIeRYY[51IIgryy{U3IImRWWY7IInbggi$7II "'')d;IIj"))+5IInbiikD9IIoryy{T:IIk299;6IIk2::<$7IIlBKK6rwwwGWbfgIIlBKK6F\N^,<?D!!$ OOBDD+,lTF5QOOBDD,-|eWTROO&IIdBJJL51IInbjjlT:IIi6IIh		d3IIlBKK6rwwwGWbfg^,.?BD! OOBDD124FW\]r7   c                  T   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.r'   r"   )
table_namer!   r   r   N)r   
drop_indexr5   
drop_tabler6   r7   r8   	downgrader>   9   sf     MM"$$/0=OPMM$%MM"$$*+EMM"$$)*|DMM,r7   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr)   r   str__annotations__r	   r
   r   r9   r>   r6   r7   r8   <module>rF      s{    #   # 1?uS(3--. ?15uS(3--. 5.2
E#x}d*+ 2 ^H r7   