DB: Add new view vw_log_history to show database logs in a better way

(cherry picked from commit 9fc4ff9dd29968c1d64f47df4e721b468ac87362)

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2019_06_06_00_auth.sql b/sql/updates/auth/master/2019_06_06_00_auth.sql
new file mode 100644
index 00000000000..7a63c9ea765
--- /dev/null
+++ b/sql/updates/auth/master/2019_06_06_00_auth.sql
@@ -0,0 +1,3 @@
+DROP VIEW IF EXISTS `vw_log_history`;
+
+CREATE VIEW `vw_log_history` AS (SELECT FROM_UNIXTIME(MIN(`logs`.`time`)) AS `First Logged` ,FROM_UNIXTIME(MAX(`logs`.`time`)) AS `Last Logged` ,COUNT(*) AS `Occurrences` ,`realmlist`.`name` AS `Realm` ,`logs`.`type` ,`logs`.`level` ,`logs`.`string` FROM `logs` LEFT JOIN realmlist ON `logs`.`realm` = `realmlist`.`id` GROUP BY `logs`.`string`, `logs`.`type`, `logs`.`realm`);