o

�k�`]�@sgd�
Zd
d�Z
dS))z1DELETE FROM milestone WHERE COALESCE(name,'')='';z<CREATE TEMPORARY TABLE version_old AS SELECT * FROM version;zDROP TABLE version;z�CREATE TABLE version (
        name            text PRIMARY KEY,
        time            integer,
        description     text
);zpINSERT INTO version(name,time,description)
    SELECT name,time,'' FROM version_old WHERE COALESCE(name,'')<>'';z@CREATE TEMPORARY TABLE component_old AS SELECT * FROM component;zDROP TABLE component;z�CREATE TABLE component (
        name            text PRIMARY KEY,
        owner           text,
        description     text
);zvINSERT INTO component(name,owner,description)
    SELECT name,owner,'' FROM component_old WHERE COALESCE(name,'')<>'';zDROP TABLE version_old;zDROP TABLE component_old;cCstD]}|�
|�

qdS)
N)�sql�execute)�env�ver�cursor�
s�r�4/usr/lib/python3/dist-packages/trac/upgrades/db11.py�
do_upgrade)s

�r	N)r
r	rrrr�<module>
s