o

�k�`r�@sgd�
Zd
d�Z
dS))z/DELETE FROM session WHERE username='anonymous';z<CREATE TEMPORARY TABLE session_old AS SELECT * FROM session;zDROP TABLE session;z�CREATE TABLE session (
        sid             text,
        authenticated   int,
        var_name        text,
        var_value       text,
        UNIQUE(sid, var_name)
);z�INSERT INTO session(sid,authenticated,var_name,var_value)
    SELECT DISTINCT sid,0,var_name,var_value FROM session_old
    WHERE sid IS NULL;z�INSERT INTO session(sid,authenticated,var_name,var_value)
    SELECT DISTINCT username,1,var_name,var_value FROM session_old
    WHERE sid IS NULL;zDROP TABLE session_old;cCstD]}|�
|�

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