trac.upgrades.db9

sql

Value:

['DROP TABLE lock;',
 'CREATE TEMPORARY TABLE session_old AS SELECT * FROM session;',
 'DELETE FROM session;',
 '''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);''',
...

Variables
	sql = `['DROP TABLE lock;', 'CREATE TEMPORARY TABLE session_old...`

Module db9

sql