
    h|                         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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)zqChange user ID to UUID

Revision ID: 1e6ba0f30ba2
Revises: 57100e5673a5
Create Date: 2025-09-14 12:32:35.210895

    )SequenceUnion)opN)
postgresql1e6ba0f30ba2revision57100e5673a5down_revisionbranch_labels
depends_onc                     t        j                  d       t        j                  d       t        j                  d       t        j                  d       t        j                  ddt        j                         t        j                         dd	       t        j                  d
dt        j                         t        j                         dd	       t        j                  ddt        j                         t        j                         dd	       t        j                  ddt        j                         t        j                         dd	       t        j                  ddt        j                         d        t        j                  ddt        j                         t        j                         d       t        j                  t        j                  d      d       t        j                  t        j                  d      ddgd       t        j                  ddddgdg       t        j                  ddddgdg       t        j                  dd
ddgdg       t        j                  ddddgdg       y )NEALTER TABLE projects DROP CONSTRAINT IF EXISTS projects_owner_id_fkey>ALTER TABLE notes DROP CONSTRAINT IF EXISTS notes_user_id_fkeyPALTER TABLE communications DROP CONSTRAINT IF EXISTS communications_user_id_fkeyeALTER TABLE communication_templates DROP CONSTRAINT IF EXISTS communication_templates_created_by_fkeycommunication_templates
created_byFzcreated_by::text::uuidexisting_typetype_existing_nullablepostgresql_usingcommunicationsuser_idTzuser_id::text::uuidnotesprojectsowner_idzowner_id::text::uuidusersidr   server_defaultzid::text::uuid)r   r   r   ix_users_id
table_nameuniqueprojects_owner_id_fkeynotes_user_id_fkeycommunications_user_id_fkey'communication_templates_created_by_fkey)r   executealter_columnsaINTEGERr   UUID
drop_indexfcreate_indexcreate_foreign_key     /Users/theessential/Documents/Github/40Admission/40-admission-backend/migrations/versions/1e6ba0f30ba2_change_user_id_to_uuid.pyupgrader7      s    JJVWJJOPJJabJJvw OO-|ZZ\__&!& 8	:
 OO$iZZ\__&!% 5	7
 OOGYZZ\__&!& 5	7
 OOJ
ZZ\__&!& 6	8 OOGTZZ\"$ OOGTZZ\__& 02 MM"$$}%':OOBDD'4&G 2J*X\W]^.9+PTvV79I7U^T_bfaghCE^`gjviwz~y  Ar5   c                     t        j                  d       t        j                  d       t        j                  d       t        j                  d       t        j                  t        j                  d      d       t        j                  ddt        j                         d 	       t        j                  ddt        j                         t        j                         d
d       t        j                  t        j                  d      ddgd
       t        j                  ddt        j                         t        j                         d
d       t        j                  ddt        j                         t        j                         dd       t        j                  ddt        j                         t        j                         d
d       t        j                  ddt        j                         t        j                         d
d       t        j                  ddddgdg       t        j                  ddddgdg       t        j                  ddddgdg       t        j                  ddddgdg       y )Nr   r   r   r   r"   r   r#   r   r    Fzid::text::integerr   r%   r   r   zcreated_by::text::integerr   r   Tzuser_id::text::integerr   r   r   zowner_id::text::integerr'   r(   r)   r*   )r   r+   r0   r1   r,   r   r/   r-   r.   r2   r3   r4   r5   r6   	downgrader9   R   s    JJVWJJOPJJabJJvw MM"$$}%':OOGT'__."$ OOGT'__.ZZ\!& 3	5
 OOBDD'4&G OO-|'__.ZZ\!& ;	=
 OO$i'__.ZZ\!% 8	:
 OOGY'__.ZZ\!& 8	:
 OOJ
'__.ZZ\!& 9	; 2J*X\W]^.9+PTvV79I7U^T_bfaghCE^`gjviwz~y  Ar5   )returnN)__doc__typingr   r   alembicr   
sqlalchemyr-   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r7   r9   r4   r5   r6   <module>rB      s    #   * # 1?uS(3--. ?15uS(3--. 5.2
E#x}d*+ 28Ax.Ar5   