SIEM@Home

myslq-syslog.sql

-- 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;