
    ph                         U d Z ddlmZmZ ddlmZ ddlZddlm	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: 3a9dcbf9a6ce
Revises: bbd06dd6a66d
Create Date: 2025-07-24 17:43:38.066783

    )SequenceUnion)opN)
postgresql3a9dcbf9a6cerevisionbbd06dd6a66ddown_revisionbranch_labels
depends_onc                  l   t        j                  dd       t        j                  d       t        j                  d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d       t        j                  dd       t        j                  d       y )Nix_notifications_idnotifications)
table_nameix_roles_idrolesix_role_permissions_idrole_permissionsix_permissions_idpermissionsspatial_ref_sysix_code_scans_id
code_scansix_users_emailusersix_users_id)r   
drop_index
drop_table     {/Users/theessential/Documents/Github/Lekema-Backend/alembic/versions/3a9dcbf9a6ce_create_category_and_publication_tables.pyupgrader"      s    MM'ODMM/"MM-G4MM'MM*7IJMM$%MM%-@MM- MM#$MM$>MM,MM"w7MM-G4MM'r    c                      t        j                  dt        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  d	t        j                         dd      t        j                  d
t        j
                         dd      t        j                  dt        j                         dd      t        j                  dt        j
                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dgdgd      t        j                  dgdgd       t        j                  dd!      d"       t        j                  d#ddgd$       t        j                  d%dd	gd$       t        j                  d&t        j                  dt        j                         dd      t        j                  d't        j                  d(d)d*d+d,d-      dd      t        j                  d.t        j                         dd      t        j                  dt        j                         dd      t        j                  d/t        j                         dd      t        j                  dt        j                         dd      t        j                  d0t        j                         dd      t        j                  d1t        j                         dd      t        j                  d1gdgd2      t        j                  d0gdgd3      t        j                  dd4             t        j                  d5d&dgd$       t        j                  d6t        j                  d7t        j                         dd      t        j                  d8t        j                  d9:      dd      t        j                  d;t        j                         dd      t        j                  d<t        j                  d=:      dd      t        j                  d>t        j                  d=:      dd      t        j                  d?d@      t        j                  d7dA             t        j                  dBt        j                  dt        j                         t        j                  dC      ddD      t        j                  dEt        j                         dd      t        j                  dFt        j                         dd      t        j                  dt        j                         dd      t        j                  ddG      d"       t        j                  dHdBdgd$       t        j                  dIt        j                  dt        j                         dd      t        j                  dt        j                         dd      t        j                  dJt        j                         dd      t        j                  dJgdKgdL      t        j                  dgdgdM      t        j                  ddN             t        j                  dOdIdgd$       t        j                  dPt        j                  dt        j                         t        j                  dQ      ddD      t        j                  dEt        j                         dd      t        j                  dRt        j                  dSdTdU      dd      t        j                  dt        j                         dd      t        j                  ddV      d"       t        j                  dWdPdgd$       t        j                  dXt        j                  dt        j                         dd      t        j                  dYt        j                         dd      t        j                  dZt        j                         dd      t        j                  d0t        j                         dd      t        j                  dt        j                         dd      t        j                  d[t        j
                         dd      t        j                  dt        j                         dd      t        j                  d0gdgd\      t        j                  dd]      
       t        j                  d^dXdgd$       y )_Nr   idF)autoincrementnullable	firstnameTlastnamenameemailemail_verifyphonephone_verifyotpcountrycitycountry_codepasswordrole_idaddressqr_codedevice_tokensponsor_codebonus_points
created_at
sponsor_idavatarstatuszroles.idusers_role_id_fkey)r)   zusers.idusers_sponsor_id_fkey
users_pkey)postgresql_ignore_search_pathr   )uniquer   r   ratingVERY_BADBADMEDIUMGOOD	VERY_GOOD	emojitypecommentpointsuser_id
company_idcode_scans_company_id_fkeycode_scans_user_id_fkeycode_scans_pkeyr   r   srid	auth_name   )length	auth_sridsrtexti   	proj4textzsrid > 0 AND srid <= 998999spatial_ref_sys_srid_checkspatial_ref_sys_pkeyr   z'nextval('permissions_id_seq'::regclass))server_defaultr%   r&   labeldescriptionpermissions_pkeyr   r   permission_idzpermissions.id#role_permissions_permission_id_fkeyrole_permissions_role_id_fkeyrole_permissions_pkeyr   r   z!nextval('roles_id_seq'::regclass)typeADMINOTHERSroletype
roles_pkeyr   r   titlecontentis_readnotifications_user_id_fkeynotifications_pkeyr   )r   create_tablesaColumnVARCHARBOOLEANINTEGERr   	TIMESTAMPForeignKeyConstraintPrimaryKeyConstraintcreate_indexENUMTEXTCheckConstrainttextr   r    r!   	downgradery   (   s   OOGIIdBJJLFIIk2::<utLIIj"**,edKIIfbjjl%$GIIgrzz|54HIInbjjl%$OIIgrzz|54HIInbjjl%$OIIeRZZ\FIIiUTJIIfbjjl%$GIInbjjl%$OIIj"**,edKIIiUTJIIiUTJIIiUTJIInbjjl%$OIInbjjl%$OIInbjjl%$OIIlJ002%RWXIIlBJJLMIIh

EDIIIh

EDIYK*<PQ\NZL?VWD|4"'7: OOM7TF5AOO$gyFOOLIIdBJJLuEIIh

E8V[_jk  |A  LQ  RIIi%$GIIiUTJIIh

EEJIIlJ002%RWXIIiUTJIIlBJJLM\NZL?[\YK*<UVD'89 OO&tfUKOO%IIfbjjl%%HIIk2::S1QUVIIk2::<utLIIh

$/utTIIk2::T2%RVW4;WXF)?@ OOMIIdBJJL9b1csw  CH  IIIgrzz|54HIImRZZ\NIIh

EDID'9:"' OO'uMOO&IIdBJJLuEIIiUTJIIorzz|54P_-0@/AHmnYK*<[\D'>? OO,.@4&QVWOOGIIdBJJL9\1]mq  }B  CIIgrzz|54HIIfjoogxjIY^inoIIh

EDID|4"' OOM7TF5AOOOIIdBJJLuEIIgrzz|55IIIi%%HIIiUTJIIh

EDIIIiUTJIIlJ002%RWXYK*<XYD';<
 OO)?TF5Qr    )returnN)__doc__typingr   r   alembicr   
sqlalchemyrl   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r"   ry   r   r    r!   <module>r      sw    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2&^Rr    