| 208 |
- |
1 |
## View: v_log
|
|
|
2 |
#
|
|
|
3 |
# +------------+--------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +------------+--------------------+------+-----+---------+-------+
|
|
|
6 |
# | eventid | bigint(8) unsigned | NO | | 0 | |
|
|
|
7 |
# | timestamp | datetime | YES | | NULL | |
|
|
|
8 |
# | event | mediumtext | NO | | NULL | |
|
|
|
9 |
# | RCid | int(11) | YES | | NULL | |
|
|
|
10 |
# | derby_name | varchar(45) | YES | | NULL | |
|
|
|
11 |
# | email | varchar(45) | YES | | NULL | |
|
|
|
12 |
# | real_name | varchar(45) | YES | | NULL | |
|
|
|
13 |
# | access | tinyint(5) | YES | | NULL | |
|
|
|
14 |
# +------------+--------------------+------+-----+---------+-------+
|
|
|
15 |
|
|
|
16 |
CREATE OR REPLACE VIEW `v_log` AS select `log`.`eventid` AS `eventid`,(`log`.`timestamp` + interval -(2) hour) AS `timestamp`,`log`.`event` AS `event`,`log`.`RCid` AS `RCid`,`official`.`derby_name` AS `derby_name`,`official`.`email` AS `email`,`official`.`real_name` AS `real_name`,`official`.`access` AS `access` from (`log` left join `official` on((`log`.`RCid` = `official`.`RCid`))) order by `log`.`eventid` desc
|