
    yj=                         U d Z ddlmZ ddlZddlmZ ddlmZ ddl	m
Z
 ddlmZ dZeed	<   dZedz  ed
<   dZeee         z  dz  ed<   dZeee         z  dz  ed<   ddZddZdS )zeInitial schema creation

Revision ID: a1b2c3d4e5f6
Revises:
Create Date: 2024-01-01 00:00:00.000000

    )SequenceN)op)Vector)
postgresql)settingsa1b2c3d4e5f6revisiondown_revisionbranch_labels
depends_onreturnc                  +   t           j        j        } t          j        dt          j        dt          j                    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        t          j	                              dd          t          j        dd          t          j        d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        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        t          j        d          ddgd|            t          j        d t          j        dt          j                    t          j                    d          t          j        dt          j	                    d          t          j        dt          j	                    d          t          j        dt          j        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          t          j        dd          t          j        d!g|  d"gt          j        d#                    t          j        dt          j        d$                    t          j        dd!d%          t          j        dt          j        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        t          j        d*          d dgd|            t          j        t          j        d+          d dgd|            t          j        d,t          j        dt          j                    t          j                    d          t          j        dt          j	                    d          t          j        d-t          j                    dd.          t          j        dt          j        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          t          j        d/g|  d0gt          j        d1                    t          j        dt          j        d2                    t          j        dt          j        d3                    |            t          j        t          j        d4          d,dgd|            t          j        t          j        d5          d,dgd|            t          j        t          j        d6          d,dgd|            t          j        t          j        d7          d,d/gd|            t          j        d8t          j        dt          j                    t          j                    d          t          j        dt          j	                    d          t          j        d9t          j	                    d          t          j        d:t          j                    d          t          j        d;t          j	                    d          t          j        dt          j        t          j	                              dd          t          j        dt          j
        d	          t          j        d
          d          t          j        dd          t          j        d<d=          t          j        dd          t          j        d9g|  d>gt          j        d?                    t          j        dt          j        d@                    t          j        dt          j        dA                    |            t          j        t          j        dB          d8dgd|            t          j        t          j        dC          d8dgd|            t          j        t          j        dD          d8dgd|            t          j        t          j        dE          d8d9gd|            t          j        dFt          j        dt          j                    t          j                    d          t          j        dt          j	                    d          t          j        dGt          j	                    d          t          j        d;t          j	                    d          t          j        dHt          j	                    d          t          j        dt          j
        d	          t          j        d
          d          t          j        dt          j        t          j	                              dd          t          j        dd          t          j        d<d=          t          j        dIdJ          t          j        dd          t          j        dHg|  dKgt          j        dL                    t          j        dt          j        dM                    t          j        dt          j        dN                    |            t          j        t          j        dO          dFdgd|            t          j        t          j        dP          dFdgd|            t          j        t          j        dQ          dFdHgd|            t          j        t          j        dR          dFdGgd|            t          j        t          j        dS          dFdgd|            t          j        dTt          j        dt          j                    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        t          j	                              dd          t          j        d/t          j	                    d          t          j        dd          t          j        dd          t          j        dd          t          j        d/g|  d0gt          j        dU                    t          j        dt          j        dV                    t          j        dd/dW          t          j        dt          j        dX                    |            t          j        t          j        dY          dTdgd|            t          j        t          j        dZ          dTdgd|            t          j        t          j        d[          dTdgd|            t          j        t          j        d\          dTdgd|            t          j        t          j        d]          dTd/gd|            t          j        d^t          j        dt          j                    t          j                    d          t          j        dt          j	                    d          t          j        dt          j        t          j	                              dd          t          j        d;t          j	                    d          t          j        d_t+          d`          d          t          j        dt          j
        d	          t          j        d
          d          t          j        dat          j	                    d          t          j        dd          t          j        d<d=          t          j        dd          t          j        dag|  dbgt          j        dc                    t          j        dt          j        dd                    t          j        dt          j        de                    |            t          j        t          j        df          d^dagd|            t          j        t          j        dg          d^dgd|            t          j        t          j        dh          d^dgd|            t          j        t          j        di          d^dgd|            t          j        djt          j        dt          j                    t          j                    d          t          j        d9t          j                    d          t          j        dkt          j        t          j	                              d          t          j        dlt          j                    ddm          t          j        d9g|  dngt          j        do                    t          j        dt          j        dp                    |            t          j        t          j        dq          djd9gd|            t          j        drt          j        d9t          j                    d          t          j        dst          j
        d	          t          j        d
          d          t          j        d9g|  dngt          j        dt                    t          j        d9t          j        du                    |            t          j        t          j        dv          drd9gd|            d S )wNappsidF)nullable	public_idname
created_atT)timezoneznow())server_defaultr   metadata)astext_typez{})r   r   zlength(public_id) = 21public_id_length)r   zlength(name) <= 512name_lengthzpublic_id ~ '^[A-Za-z0-9_-]+$'public_id_formatpk_appsuq_apps_nameuq_apps_public_idschemaix_apps_created_at)uniquer    
ix_apps_idix_apps_nameix_apps_public_idusersapp_idz.apps.public_idfk_users_app_id_appspk_usersunique_name_app_useruq_users_public_idix_users_app_idix_users_created_atix_users_idix_users_nameix_users_public_idsessions	is_activetrueuser_idz.users.public_idfk_sessions_user_id_userspk_sessionsuq_sessions_public_idix_sessions_created_atix_sessions_idix_sessions_public_idix_sessions_user_idmessages
session_idis_usercontentzlength(content) <= 65535content_lengthz.sessions.public_idfk_messages_session_id_sessionspk_messagesuq_messages_public_idix_messages_created_atix_messages_idix_messages_public_idix_messages_session_idmetamessagesmetamessage_type
message_idzlength(metamessage_type) <= 512metamessage_type_lengthz.messages.public_id#fk_metamessages_message_id_messagespk_metamessagesuq_metamessages_public_idix_metamessages_created_atix_metamessages_idix_metamessages_message_id ix_metamessages_metamessage_typeix_metamessages_public_idcollectionsfk_collections_user_id_userspk_collectionsunique_name_collection_useruq_collections_public_idix_collections_created_atix_collections_idix_collections_nameix_collections_public_idix_collections_user_id	documents	embeddingi   collection_idz.collections.public_id&fk_documents_collection_id_collectionspk_documentsuq_documents_public_idix_documents_collection_idix_documents_created_atix_documents_idix_documents_public_idqueuepayload	processedfalsez.sessions.idfk_queue_session_id_sessionspk_queueix_queue_session_idactive_queue_sessionslast_updated,fk_active_queue_sessions_session_id_sessionspk_active_queue_sessions#ix_active_queue_sessions_session_id)r   DBSCHEMAr   create_tablesaColumn
BigIntegerIdentityTextDateTimetextr   JSONBCheckConstraintPrimaryKeyConstraintfUniqueConstraintcreate_indexForeignKeyConstraintBooleanr   r   s    W/DATA/AppData/hermes/projects/honcho/migrations/versions/a1b2c3d4e5f6_initial_schema.pyupgrader      s   [F O
	$GGG
	+rwyy5999
	&"'))e444
	K&&&77++		
 	
 	
 		333		
 	
 	
 	3:LMMM
0}EEE
;BTUUU
24	??;;;
Fn)=)=>>>
Kbd3F.G.GHHH/   2 O
!""F\N5QW    OBD&&uVTTTTOBD((&6(5QWXXXXO
 !!6K=v   
 O
	$GGG
	+rwyy5999
	&"'))e444
	333		
 	
 	
 		K&&&77++		
 	
 	
 		(BGII666
3:LMMM
0}EEE
;BTUUU
JF333424@V;W;W	
 	
 	
 	24
+;+;<<<
FH3IJJJ
Kbd3G.H.HIII7   : O
8*U6    O
"##	    OBD''4&vVVVVO
_wv    O
!""Gk]5QW   
 O
	$GGG
	+rwyy5999
	+rz||eFSSS
	333		
 	
 	
 		K&&&77++		
 	
 	
 		)RWYY777
3:LMMM
;BTUUU
K((()122	
 	
 	

 	24+>+>???
Kbd3J.K.KLLL7   : O
%&&	    O

TF5    O
$%%	    O
"##	    O
	$GGG
	+rwyy5999
	,		E:::
	)RZ\\E:::
	)RWYY777
	333		
 	
 	
 		K&&&77++		
 	
 	
 	3:LMMM
5<LMMM
;BTUUU
N+++,788	
 	
 	

 	24+>+>???
Kbd3J.K.KLLL;   > O
%&&	    O

TF5    O
$%%	    O
%&&	    O
	$GGG
	+rwyy5999
	$bgii%@@@
	)RWYY777
	,		D999
	K&&&77++		
 	
 	
 		333		
 	
 	
 	3:LMMM
5<LMMM
-4M	
 	
 	
 	;BTUUU
N+++,;<<	
 	
 	

 	240A+B+BCCC
Kbd3N.O.OPPPA! ! ! !D O
)**	    O
!""NTF5QW    O
)**	    O
/00	    O
())	    O
	$GGG
	+rwyy5999
	&"'))e444
	K&&&77++		
 	
 	
 		333		
 	
 	
 		)RWYY777
3:LMMM
0}EEE
;BTUUU
K((()455	
 	
 	

 	240@+A+ABBB
FI4QRRR
Kbd3M.N.NOOO;   > O
())	    O
 !!=4&v    O
"##	    O
'((	    O
%&&	    O
	$GGG
	+rwyy5999
	333		
 	
 	
 		)RWYY777
	+vd||d;;;
	K&&&77++		
 	
 	
 		/2799u===
3:LMMM
5<LMMM
;BTUUU
.../>??	
 	
 	

 	24+?+?@@@
Kbd3K.L.LMMM;   > O
)**	    O
&''	    O
tfU6    O
%&&	    O
	$GGG
	,%@@@
	)Z-"'))DDDuUUU
	+rz||eGTTT
N$$$%455	
 	
 	

 	24
+;+;<<<    O
"##	    O
	,%@@@
	K&&&77++		
 	
 	
 	N$$$%DEE	
 	
 	

 	248R3S3STTT   " O
233	         c                     t           j        j        } 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 S )Nro   r   rh   r^   rT   rH   r<   r1   r&   r   )r   rt   ru   r   
drop_tabler   s    r   	downgrader     s    [FM)&9999M'&))))M+f----M-////M.0000M*V,,,,M*V,,,,M'&))))M&((((((r   )r   N)__doc__collections.abcr   
sqlalchemyrw   alembicr   pgvector.sqlalchemyr   sqlalchemy.dialectsr   
src.configr   r	   str__annotations__r
   r   r   r   r    r   r   <module>r      s     % $ $ $ $ $           & & & & & & * * * * * *       #    sTz      ,0sXc]"T) 0 0 0)-
C(3-$& - - -q q q qh
) 
) 
) 
) 
) 
)r   