xDVaGEwu

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4
5SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
6SET AUTOCOMMIT = 0;
7START TRANSACTION;
8SET time_zone = "+00:00";
9
10--
11-- Database: `mailqueue`
12--
13CREATE DATABASE IF NOT EXISTS `mailqueue` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
14USE `mailqueue`;
15
16-- --------------------------------------------------------
17
18--
19-- table `attachments`
20--
21
22CREATE TABLE `attachments` (
23  `attachment_id` int(10) UNSIGNED NOT NULL,
24  `attachment_queue_id` int(10) UNSIGNED NOT NULL,
25  `attachment_file` varchar(255) NOT NULL,
26  `attachment_name` varchar(255) NOT NULL DEFAULT ''
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29-- --------------------------------------------------------
30
31--
32-- table `cc`
33--
34
35CREATE TABLE `cc` (
36  `cc_id` int(10) UNSIGNED NOT NULL,
37  `cc_queue_id` int(10) UNSIGNED NOT NULL,
38  `cc_address` varchar(255) NOT NULL,
39  `ccn` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41
42-- --------------------------------------------------------
43
44--
45-- table `queue`
46--
47
48CREATE TABLE `queue` (
49  `queue_id` int(10) UNSIGNED NOT NULL,
50  `queue_from` varchar(255) NOT NULL,
51  `queue_recipient` varchar(255) NOT NULL,
52  `queue_subject` varchar(255) NOT NULL DEFAULT '',
53  `queue_text_body` text NOT NULL,
54  `queue_html_body` text NOT NULL,
55  `queue_priority` tinyint(3) UNSIGNED NOT NULL DEFAULT '10',
56  `queue_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
57  `queue_schedule` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60-- --------------------------------------------------------
61
62--
63-- table `sent`
64--
65
66CREATE TABLE `sent` (
67  `sent_id` int(10) UNSIGNED NOT NULL,
68  `sent_from` varchar(255) NOT NULL,
69  `sent_recipient` varchar(255) NOT NULL,
70  `sent_subject` varchar(255) NOT NULL,
71  `sent_text_body` text NOT NULL,
72  `sent_html_body` text NOT NULL,
73  `sent_priority` tinyint(3) UNSIGNED NOT NULL,
74  `sent_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75  `sent_sent` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
76) ENGINE=InnoDB DEFAULT CHARSET=utf8;
77
78--
79-- Indexes
80--
81
82--
83-- table `attachments`
84--
85ALTER TABLE `attachments`
86  ADD PRIMARY KEY (`attachment_id`),
87  ADD KEY `attachment_queue_id` (`attachment_queue_id`);
88
89--
90-- table `cc`
91--
92ALTER TABLE `cc`
93  ADD PRIMARY KEY (`cc_id`),
94  ADD KEY `cc_queue_id` (`cc_queue_id`);
95
96--
97-- table `queue`
98--
99ALTER TABLE `queue`
100  ADD PRIMARY KEY (`queue_id`),
101  ADD KEY `queue_schedule` (`queue_schedule`);
102
103--
104-- table `sent`
105--
106ALTER TABLE `sent`
107  ADD PRIMARY KEY (`sent_id`),
108  ADD KEY `sent_sent` (`sent_sent`) USING BTREE;
109
110--
111-- AUTO_INCREMENT
112--
113
114--
115-- table `attachments`
116--
117ALTER TABLE `attachments`
118  MODIFY `attachment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
119
120--
121-- table `cc`
122--
123ALTER TABLE `cc`
124  MODIFY `cc_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
125
126--
127-- table `queue`
128--
129ALTER TABLE `queue`
130  MODIFY `queue_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
131
132--
133-- table `sent`
134--
135ALTER TABLE `sent`
136  MODIFY `sent_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
137COMMIT;