Subversion Repositories VORC

## View: v_log
#
# +------------+--------------------+------+-----+---------+-------+
# | Field      | Type               | Null | Key | Default | Extra |
# +------------+--------------------+------+-----+---------+-------+
# | eventid    | bigint(8) unsigned | NO   |     | 0       |       |
# | timestamp  | datetime           | YES  |     | NULL    |       |
# | event      | mediumtext         | NO   |     | NULL    |       |
# | RCid       | int(11)            | YES  |     | NULL    |       |
# | derby_name | varchar(45)        | YES  |     | NULL    |       |
# | email      | varchar(45)        | YES  |     | NULL    |       |
# | real_name  | varchar(45)        | YES  |     | NULL    |       |
# | access     | tinyint(5)         | YES  |     | NULL    |       |
# +------------+--------------------+------+-----+---------+-------+

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