-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Erstellungszeit: 03. Mrz 2021 um 09:36
-- Server-Version: 5.7.33-0ubuntu0.18.04.1
-- PHP-Version: 7.2.24-0ubuntu0.18.04.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


--
-- Datenbank: `exim4`
--
CREATE DATABASE IF NOT EXISTS `exim4` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `exim4`;

-- --------------------------------------------------------


--
-- Tabellenstruktur für Tabelle `greylist`
--

DROP TABLE IF EXISTS `greylist`;
CREATE TABLE IF NOT EXISTS `greylist` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'just a primary key',
  `SenderIP` varchar(15) NOT NULL COMMENT 'IP of Sender',
  `SenderAddress` varchar(1024) NOT NULL COMMENT 'email-address of Sender',
  `first_seen` int(11) NOT NULL COMMENT 'UNIX TimeStamp of first attempt',
  PRIMARY KEY (`id`),
  KEY `SenderIP` (`SenderIP`),
  KEY `SenderAddress` (`SenderAddress`(333))
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='GreyListing';



--
-- Tabellenstruktur für Tabelle `spamlog`
--

DROP TABLE IF EXISTS `spamlog`;
CREATE TABLE IF NOT EXISTS `spamlog` (
  `ID` int(11) NOT NULL,
  `MessageID` int(11) NOT NULL,
  `SenderIP` varchar(30) NOT NULL,
  `SenderPort` int(11) NOT NULL,
  `SenderHostname` varchar(100) NOT NULL,
  `SenderHelo` varchar(100) NOT NULL,
  `SenderAddress` varchar(100) NOT NULL,
  `RecipientAddress` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Domain` varchar(100) NOT NULL,
  `LoadAverage` decimal(10,0) NOT NULL,
  `SpamScore` decimal(10,0) NOT NULL,
  `MessageSize` varchar(10) NOT NULL,
  `BodySize` varchar(100) NOT NULL,
  `MessageLines` varchar(100) NOT NULL,
  `BodyLines` varchar(100) NOT NULL,
  `ReceivedHeaders` varchar(100) NOT NULL,
  `ReceivedProtocol` varchar(100) NOT NULL,
  `Cipher` varchar(100) NOT NULL,
  `Authenticated` varchar(10) NOT NULL,
  `SenderVerify` varchar(10) NOT NULL,
  `Age` varchar(10) NOT NULL,
  `TimeStamp` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


