o
    Oh                     @   s<   d Z ddlmZ ddlZdZdZdZdZdd Z	dd Z
dS )	u   Manually add RBAC fields

Revision ID: # METTEZ ICI LE NOUVEL ID GÉNÉRÉ PAR LA COMMANDE
Revises: 
Create Date: 2025-09-26 15:00:00.000000

    )opNZf7ca393a0af4c               	   C   s   t dtjdtjdddd t d t d t jddd	d td
dD ]%} d|  d}t |tjdt dd t 	d| d|ddgdg q'd S )Nuserrole   )lengthT)nullablez9UPDATE "user" SET role = 'admin' WHERE username = 'admin'z5UPDATE "user" SET role = 'manager' WHERE role IS NULLF      gallery_clientscommercial_idfk__commercial_id_userid)
r   
add_columnsaColumnStringexecutealter_columnrangeIntegercreate_foreign_keyi
table_name r   _/var/www/html/figdemos/bartoux_crm/migrations/versions/f7ca393a0af4_manually_add_rbac_fields.pyupgrade   s    


r   c                  C   sP   t ddD ]} d|  d}tjd| d|dd t|d	 qtd
d d S )Nr   r	   r
   r   r   r   
foreignkey)type_r   r   r   )r   r   drop_constraintdrop_columnr   r   r   r   	downgrade-   s
   r#   )__doc__alembicr   
sqlalchemyr   revisiondown_revisionbranch_labels
depends_onr   r#   r   r   r   r   <module>   s    