o k`@sgdZddZdS))zDCREATE TEMPORARY TABLE node_change_old AS SELECT * FROM node_change;zDROP TABLE node_change;zCREATE TABLE node_change ( rev text, path text, kind char(1), change char(1), base_path text, base_rev text, UNIQUE(rev, path, change) );zINSERT 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|DtD]}||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=%scSsg|]}t|qS)tuple).0rowrr4/usr/lib/python3/dist-packages/trac/upgrades/db14.py )szdo_upgrade..)executefetchall executemanysql)envvercursorresultsrrr do_upgrades   rN)r rrrrrs