o
    Jh(                     @   s@   d Z ddlmZ ddlmZ dd Zdd Zdd	 Zd
d ZdS )z<
Version 2 schema.

Compatible with yoyo-migrations >=  6.0
    )datetime)get_migration_hashc                 C   sD  | j }t|  t|  | d|d d|d d| j }d}tddd}t|jd D ]J\}}t|}t	| 
 d	d
|||d}| j }| d| j d|d d|d d|d d|d d|d d|d d|d d|d d| q,| d|  t|  | d| j d|d d|d d|d d| j d d S )NzSELECT idz, ctimez FROM  i     applyzBthis log entry created automatically by an internal schema upgrade)	operationcommentcreated_at_utcmigration_hashmigration_idz
            INSERT INTO z (
                z,
                r   r   r	   r   usernamehostnamer
   z
            ) VALUES (
                :id, :migration_hash, :migration_id, 'apply', :created_at_utc,
                :username, :hostname, :comment
            )
            z%DROP TABLE {0.migration_table_quoted}z
        INSERT INTO z
        SELECT z
        FROM z	
        )quote_identifiercreate_log_tablecreate_version_tableexecutemigration_table_quotedr   iterfetchoner   dictget_log_datalog_table_quotedformatcreate_migration_table)backendqicursorr   
created_atr   log_data r!   \/var/www/html/pro-man-master/venv/lib/python3.10/site-packages/yoyo/internalmigrations/v2.pyupgrade
   sp   
	r#   c                 C   sF   | j }| d| j d|d d|d d|d d|d d	 d S )
N
        CREATE TABLE  (
            r    VARCHAR(64),
            r    VARCHAR(255),
            applied_at_utc% TIMESTAMP,
            PRIMARY KEY ()
        )
        )r   r   r   r   r   r!   r!   r"   r   >   s   r   c                 C   sx   | j }| d| j d|d d|d d|d d|d	 d
|d d|d d|d d|d d|d d d S )Nr$   r%   r   z VARCHAR(36),
            r   r&   r   r'   r	   z VARCHAR(10),
            r   r   r
   r   r)   r*   )r   r   r   r+   r!   r!   r"   r   P   s0   	
r   c              	   C   s2   | j }| d| j d|d d|d d d S )Nr$   r%   versionz' INT NOT NULL PRIMARY KEY,
            installed_at_utcz TIMESTAMP
        )
        )r   r   version_table_quotedr+   r!   r!   r"   r   c   s   r   N)__doc__r   yoyo.migrationsr   r#   r   r   r   r!   r!   r!   r"   <module>   s    4