From a161674bcee21384a73834e3ca16ad3bf1c70cf3 Mon Sep 17 00:00:00 2001
From: David Timber <mieabby@gmail.com>
Date: Mon, 16 Aug 2021 21:35:20 +1000
Subject: Protocol change: change hostinfo uptime ...

* Change hostinfo parent_uptime and child_uptime to uint32_t (138 years
  is a long time)
---
 src/data/sql/hi-create.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

diff --git a/src/data/sql/hi-create.sql b/src/data/sql/hi-create.sql
index 8859248..52a7596 100644
--- a/src/data/sql/hi-create.sql
+++ b/src/data/sql/hi-create.sql
@@ -3,8 +3,8 @@ CREATE TABLE `prne-hi` (
 	`org_id` binary(16) DEFAULT NULL,
 	`inserted` datetime NOT NULL,
 	`updated` datetime NOT NULL,
-	`parent_uptime` bigint(20) unsigned DEFAULT NULL,
-	`child_uptime` bigint(20) unsigned DEFAULT NULL,
+	`parent_uptime` int(10) unsigned DEFAULT NULL,
+	`child_uptime` int(10) unsigned DEFAULT NULL,
 	`bne_cnt` bigint(20) unsigned DEFAULT NULL,
 	`infect_cnt` bigint(20) unsigned DEFAULT NULL,
 	`parent_pid` int(11) unsigned DEFAULT NULL,
-- 
cgit 

