o

�k�`��@sgd�
Zd
d�Z
dS))zDROP TABLE lock;z<CREATE TEMPORARY TABLE session_old AS SELECT * FROM session;zDELETE FROM session;a
INSERT INTO session (username,var_name,var_value)
  SELECT username,var_name,var_value FROM session_old
  WHERE sid IN (SELECT DISTINCT sid FROM session_old
    WHERE username!='anonymous' AND var_name='last_visit'
    GROUP BY username ORDER BY var_value DESC);z�INSERT INTO session (sid,username,var_name,var_value)
  SELECT sid,username,var_name,var_value FROM session_old
  WHERE username='anonymous';zDROP TABLE session_old;cCstD]}|�
|�

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