diff options
| author | Oleksii Samorukov <samm@FreeBSD.org> | 2024-04-04 11:34:53 +0200 |
|---|---|---|
| committer | Oleksii Samorukov <samm@FreeBSD.org> | 2024-04-04 11:37:40 +0200 |
| commit | add1cc6abc1b6c500ee0bf3666cbe5ac54deec96 (patch) | |
| tree | 2ac263f6180c31a407d88d9102e7ac77647ad20d /mail/exilog/files/patch-doc_pgsql-db-script.sql | |
| parent | 332ec562da3dd5d167319eb9f9032c70ebfbbee6 (diff) | |
mail/exilog: fix to be compatible with new exim msgid format
Recently exim changed msgid format, so tool does not work correctly
anymore. I tried to contact upstream but no reply so far. Also some
minor changes to make portlint happy
Diffstat (limited to 'mail/exilog/files/patch-doc_pgsql-db-script.sql')
| -rw-r--r-- | mail/exilog/files/patch-doc_pgsql-db-script.sql | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/mail/exilog/files/patch-doc_pgsql-db-script.sql b/mail/exilog/files/patch-doc_pgsql-db-script.sql new file mode 100644 index 000000000000..ca287f30388c --- /dev/null +++ b/mail/exilog/files/patch-doc_pgsql-db-script.sql @@ -0,0 +1,65 @@ +--- doc/pgsql-db-script.sql.orig 2024-04-04 09:13:29 UTC ++++ doc/pgsql-db-script.sql +@@ -24,7 +24,7 @@ SET search_path = exilog, pg_catalog; + + CREATE TABLE deferrals ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + "timestamp" bigint NOT NULL, + rcpt character varying(200) NOT NULL, + rcpt_intermediate character varying(200), +@@ -46,7 +46,7 @@ CREATE TABLE deferrals ( + + CREATE TABLE errors ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + "timestamp" bigint NOT NULL, + rcpt character varying(200) NOT NULL, + rcpt_intermediate character varying(200), +@@ -68,7 +68,7 @@ CREATE TABLE errors ( + + CREATE TABLE deliveries ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + "timestamp" bigint NOT NULL, + rcpt character varying(200) NOT NULL, + rcpt_intermediate character varying(200), +@@ -89,7 +89,7 @@ CREATE TABLE deliveries ( + + CREATE TABLE queue ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + mailfrom character varying(255), + "timestamp" bigint, + num_dsn integer, +@@ -111,7 +111,7 @@ CREATE TABLE queue ( + + CREATE TABLE "unknown" ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + "timestamp" bigint NOT NULL, + line character varying(255) NOT NULL + ); +@@ -124,7 +124,7 @@ CREATE TABLE "unknown" ( + + CREATE TABLE messages ( + server character varying(32) NOT NULL, +- message_id character(16) NOT NULL, ++ message_id character(23) NOT NULL, + "timestamp" bigint, + msgid character varying(255), + completed bigint, +@@ -148,7 +148,7 @@ CREATE TABLE messages ( + + CREATE TABLE rejects ( + server character varying(32) NOT NULL, +- message_id character(16), ++ message_id character(23), + "timestamp" bigint NOT NULL, + host_addr inet, + host_rdns character varying(255), |