o

�k�`�@s,dd
lm
Z

ddlmZmZmZ
dd�ZdS)�)
�DatabaseManager)�Column�Index�Tablec
Cs�t|�
�
�\}}td
dd�tddd�tddd�td	d
d�tdd
d�tddd�tddd�td�
td�
tgd�
�
tgd�
�
f
}|j�*
|�d�

|�d�

|�|�
D]}|�|�

qQ|�d�

|�d�

Wd�
dS1snw



Y
dS)z�Add an auto-increment primary key to `node_change` table and indices
    (repos, rev, path) and (repos, path, rev) (#3676).
    �node_change�id)
�keyT)
�auto_increment�repos�int)
�type�rev�()
�key_size�path��	node_type�
)
�size�change_type�	base_path�base_rev)r
r
r)r
rr
z]CREATE TEMPORARY TABLE node_change_old AS
                          SELECT * FROM node_changezDROP TABLE node_changez�            INSERT INTO node_change
            (repos,rev,path,node_type,change_type,base_path,base_rev)
            SELECT repos,rev,path,node_type,change_type,base_path,base_rev
            FROM node_change_oldzDROP TABLE node_change_oldN)r�
get_connectorrrr�db_transaction�execute�to_sql)�env�ver�cursor�db_connector�
_�table�stmt�r#�4/usr/lib/python3/dist-packages/trac/upgrades/db38.py�
do_upgrades,



















��




"�r%N)�trac.db.apir�trac.db.schemarrrr%r#r#r#r$�<module>
s