[platal.git] / upgrade / 0.10.0 / 05_logger.sql

use logger;

create table last_sessions (
  uid int(6) not null,
  id int(6) not null,
  primary key uid (uid)
);

insert into last_sessions
     select s.uid AS uid, MAX(s.id) AS id
       from logger.sessions as s
      where s.suid = 0
   GROUP BY s.uid;

use x4dat;

# vim:set syntax=mysql:
Commit	Line	Data
6a61c46d FB	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: