
    ,`oh*                         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)z~modify user and add role permission

Revision ID: 00082cb6be1c
Revises: 3b72170cce99
Create Date: 2025-07-10 09:53:27.773285

    )SequenceUnion)opN)
postgresql00082cb6be1crevision3b72170cce99down_revisionbranch_labels
depends_onc                     t        j                  dt        j                  dt        j                  d      d             t        j                  dt        j                  dt        j                  d      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             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ddt        j
                         d       t        j                  d       t        j                  dddg       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d       t        j                  t        j                   d      ddgd        t        j                  t        j                   d!      ddgd        t        j                  t        j                   d"      ddgd        t        j"                  d#dd$d	gdg       t        j                  dd%       t        j                  d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,t        j                  d+      d      t        j                  d-t        j                  d+      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d)      t        j                  d0t        j                  d1      d      t        j                  d2t        j                  d+      d      t        j                  d3t        j                  d+      d      t        j                  d4t        j                  d+      d      t        j                  d
t        j                         d      t        j                  d5t        j
                         d      t        j(                  d      	       t        j                  t        j                   d6      d/dgd        t        j$                  d7t        j                  dt        j
                         dd)      t        j                  d*t        j*                         d      t        j                  d8t        j*                         d      t        j                  d9t        j                         d      t        j                  dt        j&                         t        j,                  d:      d;      t        j                  d<t        j
                         d      t        j.                  d<gd=g      t        j(                  d      	       t        j                  t        j                   d>      d7dgd        t        j$                  d?t        j                  dt        j
                         dd)      t        j                  d@t        j                  d1      d      t        j                  dAt        j                  d+      d      t        j                  dBt        j*                         d      t        j                  dCt        j                  d+      d      t        j                  dDt        j                  d+      d      t        j                  dEt        j                  d+      d      t        j                  dFt        j                  d+      d      t        j                  dt        j&                         t        j,                  d:      d;      t        j                  dGt        j&                         d      t        j                  dHt        j&                         d      t        j                  dIt        j                         d      t        j                  dJt        j                  d+      d      t        j                  dKt        j                  d+      d      t        j                  dLt        j                  d+      d      t        j                  dMt        j                  d+      d      t        j                  dNt        j                  dO      d      t        j                  dPt        j                  d1      d      t        j                  dQt        j                  d      d      t        j                  dRt        j                  d      d      t        j                  dSt        j                  d      d      t        j                  dTt        j                         d      t        j                  dt        j
                         d      t        j.                  dgd=g      t        j(                  d             t        j                  t        j                   dU      d?dgd        t        j                  t        j                   dV      d?d@gd        t        j$                  dWt        j                  dXt        j
                         d      t        j                  dYt        j
                         d      t        j.                  dYgdZgd[d[\      t        j.                  dXgd]gd[d[\             t        j$                  d^t        j                  dt        j
                         dd)      t        j                  d_t        j                         d      t        j                  dt        j
                         d      t        j                  dXt        j
                         d      t        j                  dYt        j
                         d      t        j.                  dYgdZg      t        j.                  dXg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                  dat        j
                         d             t        j"                  dbd$d(dagdg       yc)dzUpgrade schema.usersuser_id$   )lengthTnullablegender   	avatar_id	is_activeverification_tokend   verification_token_expires_at
deleted_atid_newz2CREATE SEQUENCE IF NOT EXISTS users_id_seq START 1z1UPDATE users SET id_new = nextval('users_id_seq')idFnew_column_nameexisting_typer   zEALTER TABLE users ALTER COLUMN id SET DEFAULT nextval('users_id_seq')
users_pkey
first_namer    r   	last_name
created_at
updated_atusers_username_keyuniquetype_ix_users_id)r(   ix_users_user_idix_users_verification_tokenix_user_avatar_idfilesprofile_imagerolestatuscdnsautoincrementr   label   host	root_path
ix_cdns_idpermissionsmodule2   	submodule	operationoperation_labeldisplay_orderix_permissions_idrolesslug
is_defaultznow())server_defaultr   created_by_idzusers.idix_roles_idsessions
session_idip_addrtokendeviceplatformos
user_agent
expires_atrefreshed_atpersistlocationreferercityregioncountry
   locpostaltimezonebrowser	is_mobileix_sessions_idix_sessions_session_idroles_permissionsrole_idpermission_idzpermissions.idCASCADE)onupdateondeletezroles.iduser_permissions
is_primaryix_user_permissions_idcdn_idix_files_cdn_idN)r   
add_columnsaColumnStringIntegerBoolean	TIMESTAMPexecutedrop_columnalter_columncreate_primary_keyVARCHARr   drop_constraintcreate_indexfcreate_foreign_keycreate_tableDateTimePrimaryKeyConstraintTexttextForeignKeyConstraint     ~/var/www/html/wine-match-dev/backend/winematch-backend/migrations/versions/00082cb6be1c_modify_user_and_add_role_permission.pyupgrader      s	    MM'299Y		0DtTUMM'299Xryy/CdSTMM'299["**,NOMM'299["**,NOMM'299%9299C;P[_`aMM'299%Dblln_cdeMM'299\2<<>DQR MM'299Xrzz|dKL JJCDJJDE NN7D! OOGXt2::<bghJJVW,$8OOG\ZZ\ OOG[ZZ\ OOG\'113 OOG\'113 +WHEOOBDD'4&GOOBDD+,g	{4POOBDD67CWBXafg-w+QUPVWNN7O,NN7F#NN7H%OOFIIdBJJLuEIIgryy,u=IIfbiis+e<IIk299C05AIIk2::<$7IIlBKKME:D! OOBDD&uEOOMIIdBJJLuEIIh		,t<IIk299C04@IIk299C04@II#!6FIIk2::<$7IIorzz|d;D!	 OOBDD,-}tfUSOOGIIdBJJLuEIIgrwwy40IIfbggi$/IIlBJJL48IIlBKKM"''':JUYZIIorzz|d;_-
|>D!	 OOBDD'4&GOOJIIdBJJLuEIIlBIIR04@IIi#.>IIgrwwy40IIh		-=IIj"))3/$?IIdBIIS)D9IIlBIIS1DAIIlBKKM"''':JUYZIIlBKKMD9IInbkkmd;IIi5IIj"))3/$?IIi#.>IIfbiis+d;IIh		-=IIi"-=IIeRYYb)D9IIh		,t<IIj"))3/$?IIi#.>IIk2::<$7IIi5YK*8D!36 OOBDD)*JuMOOBDD12JW[\OO'IIi5IIorzz|d;_-0@/AI`ijYK*	T]^	 OO&IIdBJJLuEIIlBJJL48IIi5IIi5IIorzz|d;_-0@/ADYK*8YK*8D!
 OOBDD124FW\]MM'299Xrzz|eLM+Wfxj4&Qr   c            	      @
   t        j                  ddd       t        j                  dd       t        j                  t        j                  d      d       t        j
                  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
                  d       t        j                  t        j                  d      d       t        j
                  d       t        j                  t        j                  d      d       t        j
                  d       t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  dt        j                  dt        j                         dd             t        j                  ddd       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  dddg       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%t        j                         d&             t        j                  d'       t        j                  d(dd)       t        j                  dd*       t        j                  dd%d*t        j                         d+       t        j                   d(dd*g       t        j                  dd,       t        j                  dd-       t        j                  dd.       t        j                  dd/       t        j                  dd0       t        j                  dd1       t        j                  dd2       y3)4zDowngrade schema.rk   r/   
foreignkeyr)   rj   ri   rg   )
table_namera   r`   rI   r_   rH   rC   rB   r;   r:   r3   r   r2   FTr4   r1   r0   r.   r-   r,   r+   r'   usernamer&   r#   r%   r$   r"   id_oldr   z+UPDATE users SET id_old = gen_random_uuid()r!   primaryr   r   r   r   r   r   r   r   r   N)r   rx   rt   
drop_indexrz   
drop_tablerl   rm   rn   rw   create_unique_constraintru   r   rr   UUIDrs   rv   r   r   r   	downgrader      sA    ('FNN7H%MM"$$/0=OPMM$%MM%&MM"$$/0ZHMM"$$'(Z@MM*MM"$$}%':MM'MM"$$*+FMM- MM"$$|$8MM&MM'299Xrzz|5[_`aMM'299VRZZ\Y]^_MM'299_bjjlRWbfgh*G<HMM"$$45'JMM"$$)*w?MM"$$}%': 4g
|LOOG\'113 OOG\'113 OOG[ZZ\ OOG\ZZ\ MM'299Xrwwy4HI JJ<= |WI>NN7D! OOGXt2779_de ,$8NN7L)NN7;<NN701NN7K(NN7K(NN7H%NN7I&r   )returnN)__doc__typingr   r   alembicr   
sqlalchemyrm   sqlalchemy.dialectsr   r   str__annotations__r
   r   r   r   r   r   r   r   <module>r      sy    #   * # "0uS$Y 015uS(3--. 5.2
E#x}d*+ 2DRTC'r   