Move logger base in main data base (tables log_*).
[platal.git] / upgrade / account / 06_logs.sql
1 CREATE TABLE log_actions
2 LIKE logger.actions;
3 INSERT INTO log_actions
4 SELECT *
5 FROM logger.actions;
6
7 CREATE TABLE log_events
8 LIKE logger.events;
9 INSERT INTO log_events
10 SELECT *
11 FROM logger.events;
12
13 CREATE TABLE log_last_sessions
14 LIKE logger.last_sessions;
15 INSERT INTO log_last_sessions
16 SELECT *
17 FROM logger.last_sessions;
18
19 CREATE TABLE log_sessions
20 LIKE logger.sessions;
21 INSERT INTO log_sessions
22 SELECT *
23 FROM logger.sessions;
24
25 # vim:set ft=mysql: