Create a gist now

Instantly share code, notes, and snippets.

@Zrubi /myslq-syslog.sql Secret
Last active Dec 19, 2017

What would you like to do?
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