o k` @s$ddlmZmZmZmZddZdS))TableColumnIndexDatabaseManagerc CsV|d|d|d|dtdddtdtd td ftd d dtd tdddtdddtdtdtd dgftdddtd ddtdddtdddtdddtdddd td!td"td dgfg}t|\}}|D]}||D]}||qq{|d#|d$|d%|d&|d'|d(dS))Nz8CREATE TEMPORARY TABLE rev_old AS SELECT * FROM revisionzDROP TABLE revisionz:CREATE TEMPORARY TABLE nc_old AS SELECT * FROM node_changezDROP TABLE node_change repository)idname)keyrrvaluerevision)reposrevr r )key_sizetimeint)typeauthormessage node_change)r r path change_type8r node_type)sizer)rr base_pathbase_revzcINSERT INTO revision (repos,rev,time,author,message) SELECT '',rev,time,author,message FROM rev_oldzDROP TABLE rev_oldzINSERT INTO node_change (repos,rev,path,node_type,change_type,base_path,base_rev) SELECT '',rev,path,node_type,change_type,base_path,base_rev FROM nc_oldzDROP TABLE nc_oldzxINSERT INTO repository (id,name,value) SELECT '',name,value FROM system WHERE name IN ('repository_dir', 'youngest_rev')zCDELETE FROM system WHERE name IN ('repository_dir', 'youngest_rev'))executerrrr get_connectorto_sql)envvercursortables db_connector_tablestmtr+4/usr/lib/python3/dist-packages/trac/upgrades/db23.py do_upgradesT                      r-N)trac.dbrrrrr-r+r+r+r,s