
    _i
                     :    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
dS )zAdd multi-connection support: max_concurrent_sessions and user_sessions table

Revision ID: 1cbb5a63f3e2
Revises: 2178dd55a2db
Create Date: 2026-01-08 03:08:52.010612

    )opN1cbb5a63f3e22178dd55a2dbc                     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          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dgdg          t          j        d                     t          j        dd           5 } | 	                    | 
                    d          dgd           | 	                    | 
                    d          dgd           | 	                    | 
                    d          dgd           d d d            n# 1 swxY w Y   t          j        dd           5 } |                     t          j        dt          j                    d                     d d d            n# 1 swxY w Y   t          j        d           t          j        dd           5 } |                     dd           d d d            d S # 1 swxY w Y   d S )Nuser_sessionsid$   )lengthF)nullableuser_idsession_token   
ip_address-   T
user_agentdevice_infod   location
created_atlast_activity
expires_atzusers.idschemaix_user_sessions_created_at)uniqueix_user_sessions_session_tokenix_user_sessions_user_idusersmax_concurrent_sessionsz
        UPDATE users 
        SET max_concurrent_sessions = CASE 
            WHEN role = 'admin' THEN -1
            WHEN role = 'manager' THEN 5
            ELSE 1
        END
        WHERE max_concurrent_sessions IS NULL
    )r   create_tablesaColumnStringDateTimeForeignKeyConstraintPrimaryKeyConstraintbatch_alter_tablecreate_indexf
add_columnIntegerexecutealter_columnbatch_ops    e/var/www/html/MCyber-Diagnostic/migrations/versions/1cbb5a63f3e2_add_multi_connection_support_max_.pyupgrader1      s   OOIdBIR(((5999Ii"--->>>Iory444uEEEIlBIR0004@@@IlBIS111DAAAImRYc222TBBBIj")3///$???IlBKMME:::Ior{}}u===IlBKMME:::YK*88D!!   
	od	;	;	; axhjj)FGG,`efffhjj)IJJ_L]fjkkkhjj)CDDykZ_```a a a a a a a a a a a a a a a
 
	gd	3	3	3 _xBI&?X\]]]^^^_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ J  	 	 	 
	gd	3	3	3 Ix7%HHHI I I I I I I I I I I I I I I I I Is7   (BI99I= I=<K""K&)K&L<<M M c                      t          j        dd           5 } |                     d           d d d            n# 1 swxY w Y   t          j        dd           5 } |                     |                     d                     |                     |                     d                     |                     |                     d                     d d d            n# 1 swxY w Y   t          j        d           d S )Nr   r   r   r   r   r   r   )r   r'   drop_column
drop_indexr)   
drop_tabler.   s    r0   	downgrader6   ;   st   		gd	3	3	3 8x67778 8 8 8 8 8 8 8 8 8 8 8 8 8 8 
	od	;	;	; GxHJJ'ABBCCCHJJ'GHHIIIHJJ'DEEFFFG G G G G G G G G G G G G G G
 M/"""""s    9= =A9CC#&C#)__doc__alembicr   
sqlalchemyr!   revisiondown_revisionbranch_labels
depends_onr1   r6        r0   <module>r@      sq               
#I #I #IP
# 
# 
# 
# 
#r?   