upgrade/0.10.0/05_logger.sql

   1 use logger;
   2
   3 create table last_sessions (
   4   uid int(6) not null,
   5   id int(6) not null,
   6   primary key uid (uid)
   7 );
   8
   9 insert into last_sessions
  10      select s.uid AS uid, MAX(s.id) AS id
  11        from logger.sessions as s
  12       where s.suid = 0
  13    GROUP BY s.uid;
  14
  15 use x4dat;
  16
  17 # vim:set syntax=mysql: