Commit | Line | Data |
---|---|---|
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: |