projects
/
platal.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Addresses components list should only contain home components.
[platal.git]
/
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
: