o k`= @s$ddlmZmZmZmZddZdS))TableColumnIndexDatabaseManagerc Cs|dddt|D}|d|d|d|d|d|d td d d td ddtdtdftddd tdddtdddtdddtdtdtddgftddd tdddtdddtdddtdd d!td"d d#d$td%td&tddgfg}t|\}}|D]}||D]}||qq|d'||d(||d)|d*||d+|d,||d-dS).NzvSELECT id FROM repository UNION SELECT repos AS id FROM revision UNION SELECT repos AS id FROM node_change ORDER BY idcSsg|] \}\}|d|fqS)).0inamerr4/usr/lib/python3/dist-packages/trac/upgrades/db24.py szdo_upgrade..z;CREATE TEMPORARY TABLE repo_old AS SELECT * FROM repositoryzDROP TABLE repositoryz8CREATE TEMPORARY TABLE rev_old AS SELECT * FROM revisionzDROP TABLE revisionz:CREATE TEMPORARY TABLE nc_old AS SELECT * FROM node_changezDROP TABLE node_change repository)idr )keyrint)typer valuerevision)reposrevrr)key_sizetimeauthormessage node_change)rrpath change_typer node_typer)sizer)r r base_pathbase_revzs