· 9 years ago · Feb 03, 2017, 03:38 PM
1-- Server version 5.7.17-0ubuntu0.16.04.1
2
3/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
5/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
6/*!40101 SET NAMES utf8 */;
7/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
8/*!40103 SET TIME_ZONE='+00:00' */;
9/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
13
14--
15-- Table structure for table `audit_log`
16--
17
18DROP TABLE IF EXISTS `audit_log`;
19/*!40101 SET @saved_cs_client = @@character_set_client */;
20/*!40101 SET character_set_client = utf8 */;
21CREATE TABLE `audit_log` (
22 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
23 `user` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
24 `ip_address` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
25 `action` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
26) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
27/*!40101 SET character_set_client = @saved_cs_client */;
28
29--
30-- Table structure for table `autorelease`
31--
32
33DROP TABLE IF EXISTS `autorelease`;
34/*!40101 SET @saved_cs_client = @@character_set_client */;
35/*!40101 SET character_set_client = utf8 */;
36CREATE TABLE `autorelease` (
37 `id` bigint(20) NOT NULL AUTO_INCREMENT,
38 `msg_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
39 `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
42/*!40101 SET character_set_client = @saved_cs_client */;
43
44--
45-- Table structure for table `blacklist`
46--
47
48DROP TABLE IF EXISTS `blacklist`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `blacklist` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `to_address` mediumtext COLLATE utf8mb4_unicode_ci,
54 `to_domain` mediumtext COLLATE utf8mb4_unicode_ci,
55 `from_address` mediumtext COLLATE utf8mb4_unicode_ci,
56 PRIMARY KEY (`id`),
57 UNIQUE KEY `blacklist_uniq` (`to_address`(100),`from_address`(100))
58) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Table structure for table `inq`
63--
64
65DROP TABLE IF EXISTS `inq`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `inq` (
69 `id` longtext COLLATE utf8mb4_unicode_ci,
70 `cdate` date DEFAULT NULL,
71 `ctime` time DEFAULT NULL,
72 `from_address` longtext COLLATE utf8mb4_unicode_ci,
73 `to_address` longtext COLLATE utf8mb4_unicode_ci,
74 `subject` longtext COLLATE utf8mb4_unicode_ci,
75 `message` longtext COLLATE utf8mb4_unicode_ci,
76 `size` longtext COLLATE utf8mb4_unicode_ci,
77 `priority` longtext COLLATE utf8mb4_unicode_ci,
78 `attempts` longtext COLLATE utf8mb4_unicode_ci,
79 `lastattempt` longtext COLLATE utf8mb4_unicode_ci,
80 `hostname` longtext COLLATE utf8mb4_unicode_ci,
81 KEY `inq_hostname` (`hostname`(50))
82) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Table structure for table `maillog`
87--
88
89DROP TABLE IF EXISTS `maillog`;
90/*!40101 SET @saved_cs_client = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE TABLE `maillog` (
93 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
94 `id` longtext COLLATE utf8mb4_unicode_ci,
95 `size` bigint(20) DEFAULT '0',
96 `from_address` longtext COLLATE utf8mb4_unicode_ci,
97 `from_domain` longtext COLLATE utf8mb4_unicode_ci,
98 `to_address` longtext COLLATE utf8mb4_unicode_ci,
99 `to_domain` longtext COLLATE utf8mb4_unicode_ci,
100 `subject` longtext COLLATE utf8mb4_unicode_ci,
101 `clientip` longtext COLLATE utf8mb4_unicode_ci,
102 `archive` longtext COLLATE utf8mb4_unicode_ci,
103 `isspam` tinyint(1) DEFAULT '0',
104 `ishighspam` tinyint(1) DEFAULT '0',
105 `issaspam` tinyint(1) DEFAULT '0',
106 `isrblspam` tinyint(1) DEFAULT '0',
107 `isfp` tinyint(1) DEFAULT '0',
108 `isfn` tinyint(1) DEFAULT '0',
109 `spamwhitelisted` tinyint(1) DEFAULT '0',
110 `spamblacklisted` tinyint(1) DEFAULT '0',
111 `sascore` decimal(7,2) DEFAULT '0.00',
112 `spamreport` longtext COLLATE utf8mb4_unicode_ci,
113 `virusinfected` tinyint(1) DEFAULT '0',
114 `nameinfected` tinyint(1) DEFAULT '0',
115 `otherinfected` tinyint(1) DEFAULT '0',
116 `report` longtext COLLATE utf8mb4_unicode_ci,
117 `ismcp` tinyint(1) DEFAULT '0',
118 `ishighmcp` tinyint(1) DEFAULT '0',
119 `issamcp` tinyint(1) DEFAULT '0',
120 `mcpwhitelisted` tinyint(1) DEFAULT '0',
121 `mcpblacklisted` tinyint(1) DEFAULT '0',
122 `mcpsascore` decimal(7,2) DEFAULT '0.00',
123 `mcpreport` longtext COLLATE utf8mb4_unicode_ci,
124 `hostname` longtext COLLATE utf8mb4_unicode_ci,
125 `date` date DEFAULT NULL,
126 `time` time DEFAULT NULL,
127 `headers` longtext COLLATE utf8mb4_unicode_ci,
128 `quarantined` tinyint(1) DEFAULT '0',
129 KEY `maillog_datetime_idx` (`date`,`time`),
130 KEY `maillog_id_idx` (`id`(20)),
131 KEY `maillog_clientip_idx` (`clientip`(20)),
132 KEY `maillog_from_idx` (`from_address`(200)),
133 KEY `maillog_to_idx` (`to_address`(200)),
134 KEY `maillog_host` (`hostname`(30)),
135 KEY `from_domain_idx` (`from_domain`(50)),
136 KEY `to_domain_idx` (`to_domain`(50)),
137 KEY `maillog_quarantined` (`quarantined`),
138 KEY `timestamp_idx` (`timestamp`),
139 FULLTEXT KEY `subject_idx` (`subject`)
140) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
141/*!40101 SET character_set_client = @saved_cs_client */;
142
143--
144-- Table structure for table `mcp_rules`
145--
146
147DROP TABLE IF EXISTS `mcp_rules`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `mcp_rules` (
151 `rule` char(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
152 `rule_desc` char(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
153 PRIMARY KEY (`rule`)
154) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Table structure for table `mtalog`
159--
160
161DROP TABLE IF EXISTS `mtalog`;
162/*!40101 SET @saved_cs_client = @@character_set_client */;
163/*!40101 SET character_set_client = utf8 */;
164CREATE TABLE `mtalog` (
165 `timestamp` datetime DEFAULT NULL,
166 `host` longtext COLLATE utf8mb4_unicode_ci,
167 `type` longtext COLLATE utf8mb4_unicode_ci,
168 `msg_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
169 `relay` longtext COLLATE utf8mb4_unicode_ci,
170 `dsn` longtext COLLATE utf8mb4_unicode_ci,
171 `status` longtext COLLATE utf8mb4_unicode_ci,
172 `delay` time DEFAULT NULL,
173 UNIQUE KEY `mtalog_uniq` (`timestamp`,`host`(10),`type`(10),`msg_id`,`relay`(20)),
174 KEY `mtalog_timestamp` (`timestamp`),
175 KEY `mtalog_type` (`type`(10)),
176 KEY `msg_id` (`msg_id`)
177) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Table structure for table `mtalog_ids`
182--
183
184DROP TABLE IF EXISTS `mtalog_ids`;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!40101 SET character_set_client = utf8 */;
187CREATE TABLE `mtalog_ids` (
188 `smtpd_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
189 `smtp_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
190 UNIQUE KEY `mtalog_ids_idx` (`smtpd_id`,`smtp_id`),
191 KEY `smtpd_id` (`smtpd_id`)
192) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
193/*!40101 SET character_set_client = @saved_cs_client */;
194
195--
196-- Table structure for table `outq`
197--
198
199DROP TABLE IF EXISTS `outq`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!40101 SET character_set_client = utf8 */;
202CREATE TABLE `outq` (
203 `id` longtext COLLATE utf8mb4_unicode_ci,
204 `cdate` date DEFAULT NULL,
205 `ctime` time DEFAULT NULL,
206 `from_address` longtext COLLATE utf8mb4_unicode_ci,
207 `to_address` longtext COLLATE utf8mb4_unicode_ci,
208 `subject` longtext COLLATE utf8mb4_unicode_ci,
209 `message` longtext COLLATE utf8mb4_unicode_ci,
210 `size` longtext COLLATE utf8mb4_unicode_ci,
211 `priority` longtext COLLATE utf8mb4_unicode_ci,
212 `attempts` longtext COLLATE utf8mb4_unicode_ci,
213 `lastattempt` longtext COLLATE utf8mb4_unicode_ci,
214 `hostname` longtext COLLATE utf8mb4_unicode_ci,
215 KEY `outq_hostname` (`hostname`(50))
216) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
217/*!40101 SET character_set_client = @saved_cs_client */;
218
219--
220-- Table structure for table `sa_rules`
221--
222
223DROP TABLE IF EXISTS `sa_rules`;
224/*!40101 SET @saved_cs_client = @@character_set_client */;
225/*!40101 SET character_set_client = utf8 */;
226CREATE TABLE `sa_rules` (
227 `rule` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
228 `rule_desc` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
229 PRIMARY KEY (`rule`)
230) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
231/*!40101 SET character_set_client = @saved_cs_client */;
232
233--
234-- Table structure for table `saved_filters`
235--
236
237DROP TABLE IF EXISTS `saved_filters`;
238/*!40101 SET @saved_cs_client = @@character_set_client */;
239/*!40101 SET character_set_client = utf8 */;
240CREATE TABLE `saved_filters` (
241 `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
242 `col` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
243 `operator` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
244 `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
245 `username` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
246 UNIQUE KEY `unique_filters` (`name`(20),`col`(20),`operator`(20),`value`(20),`username`(20))
247) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
248/*!40101 SET character_set_client = @saved_cs_client */;
249
250--
251-- Table structure for table `spamscores`
252--
253
254DROP TABLE IF EXISTS `spamscores`;
255/*!40101 SET @saved_cs_client = @@character_set_client */;
256/*!40101 SET character_set_client = utf8 */;
257CREATE TABLE `spamscores` (
258 `user` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
259 `lowspamscore` decimal(10,0) NOT NULL DEFAULT '0',
260 `highspamscore` decimal(10,0) NOT NULL DEFAULT '0',
261 PRIMARY KEY (`user`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
263/*!40101 SET character_set_client = @saved_cs_client */;
264
265--
266-- Table structure for table `user_filters`
267--
268
269DROP TABLE IF EXISTS `user_filters`;
270/*!40101 SET @saved_cs_client = @@character_set_client */;
271/*!40101 SET character_set_client = utf8 */;
272CREATE TABLE `user_filters` (
273 `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
274 `filter` longtext COLLATE utf8mb4_unicode_ci,
275 `verify_key` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
276 `active` enum('N','Y') COLLATE utf8mb4_unicode_ci DEFAULT 'N',
277 KEY `user_filters_username_idx` (`username`)
278) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
279/*!40101 SET character_set_client = @saved_cs_client */;
280
281--
282-- Table structure for table `users`
283--
284
285DROP TABLE IF EXISTS `users`;
286/*!40101 SET @saved_cs_client = @@character_set_client */;
287/*!40101 SET character_set_client = utf8 */;
288CREATE TABLE `users` (
289 `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
290 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
291 `fullname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
292 `type` enum('A','D','U','R','H') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
293 `quarantine_report` tinyint(1) DEFAULT '0',
294 `spamscore` tinyint(4) DEFAULT '0',
295 `highspamscore` tinyint(4) DEFAULT '0',
296 `noscan` tinyint(1) DEFAULT '0',
297 `quarantine_rcpt` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
298 PRIMARY KEY (`username`)
299) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
300/*!40101 SET character_set_client = @saved_cs_client */;
301
302--
303-- Table structure for table `whitelist`
304--
305
306DROP TABLE IF EXISTS `whitelist`;
307/*!40101 SET @saved_cs_client = @@character_set_client */;
308/*!40101 SET character_set_client = utf8 */;
309CREATE TABLE `whitelist` (
310 `id` int(11) NOT NULL AUTO_INCREMENT,
311 `to_address` longtext COLLATE utf8mb4_unicode_ci,
312 `to_domain` longtext COLLATE utf8mb4_unicode_ci,
313 `from_address` longtext COLLATE utf8mb4_unicode_ci,
314 PRIMARY KEY (`id`),
315 UNIQUE KEY `whitelist_uniq` (`to_address`(100),`from_address`(100))
316) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
317/*!40101 SET character_set_client = @saved_cs_client */;
318/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
319
320/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
321/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
322/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
323/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
324/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
325/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
326/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
327
328-- Dump completed on 2017-02-03 10:32:57