o

�k�`��@sgd�
Zd
d�Z
dS))zDCREATE TEMPORARY TABLE node_change_old AS SELECT * FROM node_change;zDROP TABLE node_change;z�CREATE TABLE node_change (
    rev             text,
    path            text,
    kind            char(1),
    change          char(1),
    base_path       text,
    base_rev        text,
    UNIQUE(rev, path, change)
);z�INSERT INTO node_change (rev,path,kind,change,base_path,base_rev)
    SELECT rev,path,kind,change,base_path,base_rev FROM node_change_old;zDROP TABLE node_change_old;cCsD|�d
�

|�
�}|r|�ddd�|D�
�
tD]}|�|�

qdS)NzoSELECT name, version FROM wiki WHERE name IN (SELECT name FROM wiki WHERE version=0) ORDER BY name,version DESCz>UPDATE wiki SET version=version+1 WHERE name=%s and version=%sc
Ssg|]}
t|
�
�qS�)
�tuple)�.0�rowr
r
�4/usr/lib/python3/dist-packages/trac/upgrades/db14.py�
<listcomp>)szdo_upgrade.<locals>.<listcomp>)�execute�fetchall�executemany�sql)�env�ver�cursor�result�
sr
r
r�
do_upgrades


�
�rN)r
rr
r
r
r�<module>
s