1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
--- doc/mysql-db-script.sql.orig 2005-07-22 08:57:03 UTC
+++ doc/mysql-db-script.sql
@@ -15,12 +15,12 @@
CREATE TABLE `deferrals` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`timestamp` bigint(20) NOT NULL default '0',
`rcpt` varchar(200) NOT NULL default '',
`rcpt_intermediate` varchar(200) default NULL,
`rcpt_final` varchar(200) NOT NULL default '',
- `host_addr` varchar(15) default NULL,
+ `host_addr` varchar(45) default NULL,
`host_dns` varchar(255) default NULL,
`tls_cipher` varchar(128) default NULL,
`router` varchar(128) default NULL,
@@ -43,12 +43,12 @@ CREATE TABLE `deferrals` (
CREATE TABLE `deliveries` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`timestamp` bigint(20) NOT NULL default '0',
`rcpt` varchar(200) NOT NULL default '',
`rcpt_intermediate` varchar(200) default NULL,
`rcpt_final` varchar(200) NOT NULL default '',
- `host_addr` varchar(15) default NULL,
+ `host_addr` varchar(45) default NULL,
`host_dns` varchar(255) default NULL,
`tls_cipher` varchar(128) default NULL,
`router` varchar(128) default NULL,
@@ -71,12 +71,12 @@ CREATE TABLE `deliveries` (
CREATE TABLE `errors` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`timestamp` bigint(20) NOT NULL default '0',
`rcpt` varchar(200) NOT NULL default '',
`rcpt_intermediate` varchar(200) default NULL,
`rcpt_final` varchar(200) NOT NULL default '',
- `host_addr` varchar(15) default NULL,
+ `host_addr` varchar(45) default NULL,
`host_dns` varchar(255) default NULL,
`tls_cipher` varchar(128) default NULL,
`router` varchar(128) default NULL,
@@ -99,12 +99,12 @@ CREATE TABLE `errors` (
CREATE TABLE `messages` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`timestamp` bigint(20) default NULL,
`msgid` varchar(255) default NULL,
`completed` bigint(20) default NULL,
`mailfrom` varchar(255) default NULL,
- `host_addr` varchar(15) default NULL,
+ `host_addr` varchar(45) default NULL,
`host_rdns` varchar(255) default NULL,
`host_ident` varchar(255) default NULL,
`host_helo` varchar(255) default NULL,
@@ -132,7 +132,7 @@ CREATE TABLE `messages` (
CREATE TABLE `queue` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`mailfrom` varchar(255) NOT NULL default '',
`timestamp` bigint(20) NOT NULL default '0',
`num_dsn` int(11) NOT NULL default '0',
@@ -162,9 +162,9 @@ CREATE TABLE `queue` (
CREATE TABLE `rejects` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary default NULL,
+ `message_id` varchar(23) binary default NULL,
`timestamp` bigint(20) NOT NULL default '0',
- `host_addr` varchar(15) NOT NULL default '',
+ `host_addr` varchar(45) NOT NULL default '',
`host_rdns` varchar(255) NOT NULL default '',
`host_ident` varchar(255) default NULL,
`host_helo` varchar(255) default NULL,
@@ -188,7 +188,7 @@ CREATE TABLE `rejects` (
CREATE TABLE `unknown` (
`server` varchar(32) NOT NULL default '',
- `message_id` varchar(16) binary NOT NULL default '',
+ `message_id` varchar(23) binary NOT NULL default '',
`timestamp` bigint(20) NOT NULL default '0',
`line` varchar(255) NOT NULL default '',
PRIMARY KEY (`server`,`message_id`,`timestamp`,`line`),
|
