
    qh                         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)zCreate category and publication tables

Revision ID: 66f61f4de3a8
Revises: bbd06dd6a66d
Create Date: 2025-07-24 17:46:36.754106

    )SequenceUnion)opN66f61f4de3a8revisionbbd06dd6a66ddown_revisionbranch_labels
depends_onc                  L   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
                         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gdg      t        j                  d             t        j                  t        j                  d      d
dgd       t        j                  ddt        j                         d       t        j                  ddt        j                         t        j
                         d	       t        j                  t        j                  d      ddgd	       t        j                  dt        j                  dt        j
                              } t        j                   | dd idd!idd"idd#idd$idd%ig       y )&N
categoriesidF)nullablenameix_categories_id)uniqueix_categories_nameTpublicationstitlepreviewcountrysourcelink	file_pathstate
created_atpublished_atunpublished_atcategory_idzcategories.idix_publications_idroleslabelexisting_typer   usersstatusr$   type_existing_nullableix_users_phonephoneEconomieSportFinanceu   Appel d’offresu   Marchés PublicsEmploi)r   create_tablesaColumnIntegerStringPrimaryKeyConstraintcreate_indexfDateTimeForeignKeyConstraintalter_columnVARCHARINTEGERtablecolumnbulk_insert)categories_tables    {/Users/theessential/Documents/Github/Lekema-Backend/alembic/versions/66f61f4de3a8_create_category_and_publication_tables.pyupgraderB      s   OOLIIdBJJL51IIfbiikE2D!
 OOBDD+,lTF5QOOBDD-.vhtTOONIIdBJJL51IIgryy{U3IIiu5IIit4IIh		d3IIfbiikD1IIk299;6IIgryy{U3IIlBKKME:IInbkkmd;II=IImRZZ\D9]Oo->AD!  OOBDD-.uUOOGWZZ\ OOGXZZ\YY[!%' OOBDD)*GgYtLxx
		&"))$ NN#Z WY'('(X	
	    c                  z   t        j                  t        j                  d      d       t        j                  ddt	        j
                         t	        j                         d       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       y )Nr*   r%   )
table_namer&   Tr'   r!   r"   r#   r    r   r   r   r   )	r   
drop_indexr7   r:   r1   r4   r<   r;   
drop_table rC   rA   	downgraderI   H   s    MM"$$'(W=OOGXYY[ZZ\!%' OOGWZZ\ MM"$$+,HMM.!MM"$$+,FMM"$$)*|DMM,rC   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr1   r   str__annotations__r	   r
   r   rB   rI   rH   rC   rA   <module>rQ      ss    #   # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 20f rC   