SIEM@Home
-- MySQL dump 10.16 Distrib 10.1.28-MariaDB, for Linux (armv5tel) | |
-- | |
-- Host: localhost Database: syslog | |
-- ------------------------------------------------------ | |
-- Server version 10.1.28-MariaDB | |
-- | |
-- Table structure for table `addrwatch` | |
-- | |
DROP TABLE IF EXISTS `addrwatch`; | |
CREATE TABLE `addrwatch` ( | |
`timestamp` datetime NOT NULL, | |
`VLAN` smallint(5) unsigned NOT NULL, | |
`MAC` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`IP` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, | |
KEY `MAC` (`MAC`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | |
-- | |
-- Table structure for table `messages` | |
-- | |
DROP TABLE IF EXISTS `messages`; | |
CREATE TABLE `messages` ( | |
`timestamp` datetime DEFAULT NULL, | |
`host` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`program` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
`pid` smallint(5) unsigned DEFAULT NULL, | |
`severity` tinyint(1) unsigned NOT NULL, | |
`message` tinytext COLLATE utf8mb4_unicode_ci, | |
KEY `messages_datetime_idx` (`timestamp`), | |
KEY `messages_host_idx` (`host`), | |
KEY `messages_program_idx` (`program`), | |
KEY `messages_pid_idx` (`pid`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | |
-- | |
-- Table structure for table `packetfilter` | |
-- | |
DROP TABLE IF EXISTS `packetfilter`; | |
CREATE TABLE `packetfilter` ( | |
`timestamp` datetime NOT NULL, | |
`host` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`IN_Interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`MAC` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`SRC_IP` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`SRC_Port` smallint(5) unsigned NOT NULL, | |
`OUT_Interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`DST_IP` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`DST_Port` smallint(5) unsigned NOT NULL, | |
`Protocol` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`Type` tinyint(3) unsigned NOT NULL, | |
`Action` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, | |
`Chain` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment