2 files changed, 21 insertions, 18 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`;
diff --git a/src/data/sql/hi-view.sql b/src/data/sql/hi-view.sql
deleted file mode 100644
index 39886db..0000000
--- a/src/data/sql/hi-view.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT
-	HEX(instance_id),
-	inserted,
-	updated,
-	parent_uptime,
-	child_uptime,
-	bne_cnt,
-	infect_cnt,
-	parent_pid,
-	child_pid,
-	HEX(prog_ver),
-	HEX(boot_id),
-	cred_id,
-	cred_pw,
-	crash_cnt,
-	arch,
-	INET6_NTOA(ipaddr)
-FROM prne.`prne-hi`;