MailQueue database

-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/

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

--
-- Database: `mailqueue`
--
CREATE DATABASE IF NOT EXISTS `mailqueue` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `mailqueue`;

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

--
-- table `attachments`
--

CREATE TABLE `attachments` (
  `attachment_id` int(10) UNSIGNED NOT NULL,
  `attachment_queue_id` int(10) UNSIGNED NOT NULL,
  `attachment_file` varchar(255) NOT NULL,
  `attachment_name` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- table `cc`
--

CREATE TABLE `cc` (
  `cc_id` int(10) UNSIGNED NOT NULL,
  `cc_queue_id` int(10) UNSIGNED NOT NULL,
  `cc_address` varchar(255) NOT NULL,
  `ccn` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- table `queue`
--

CREATE TABLE `queue` (
  `queue_id` int(10) UNSIGNED NOT NULL,
  `queue_app_id` int(10) UNSIGNED NOT NULL,
  `queue_from` varchar(255) NOT NULL,
  `queue_recipient` varchar(255) NOT NULL,
  `queue_subject` varchar(255) NOT NULL DEFAULT '',
  `queue_text_body` text NOT NULL,
  `queue_html_body` text NOT NULL,
  `queue_priority` tinyint(3) UNSIGNED NOT NULL DEFAULT '10',
  `queue_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `queue_schedule` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- table `sent`
--

CREATE TABLE `sent` (
  `sent_id` int(10) UNSIGNED NOT NULL,
  `sent_app_id` int(10) UNSIGNED NOT NULL,
  `sent_from` varchar(255) NOT NULL,
  `sent_recipient` varchar(255) NOT NULL,
  `sent_subject` varchar(255) NOT NULL,
  `sent_text_body` text NOT NULL,
  `sent_html_body` text NOT NULL,
  `sent_priority` tinyint(3) UNSIGNED NOT NULL,
  `sent_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sent_sent` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes
--

--
-- table `attachments`
--
ALTER TABLE `attachments`
  ADD PRIMARY KEY (`attachment_id`),
  ADD KEY `attachment_queue_id` (`attachment_queue_id`);

--
-- table `cc`
--
ALTER TABLE `cc`
  ADD PRIMARY KEY (`cc_id`),
  ADD KEY `cc_queue_id` (`cc_queue_id`);

--
-- table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`queue_id`),
  ADD KEY `queue_schedule` (`queue_schedule`),
  ADD KEY `queue_app_id` (`queue_app_id`);

--
-- table `sent`
--
ALTER TABLE `sent`
  ADD PRIMARY KEY (`sent_id`),
  ADD KEY `sent_sent` (`sent_sent`) USING BTREE;

--
-- AUTO_INCREMENT
--

--
-- table `attachments`
--
ALTER TABLE `attachments`
  MODIFY `attachment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- table `cc`
--
ALTER TABLE `cc`
  MODIFY `cc_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- table `queue`
--
ALTER TABLE `queue`
  MODIFY `queue_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- table `sent`
--
ALTER TABLE `sent`
  MODIFY `sent_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;