Module 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);''',
...