SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

formatted_payload

{"content": "Message from Raingull Server\nOriginally sent 2025-12-03 14:17:32 by James Guthrie (jguthrie13@gmail.com)\nSource: IMAP\n---\n", "subject": "Re: Last chance to order dinner", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Re: Last chance to order dinner", "date": "Wed, 3 Dec 2025 06:17:32 -0800", "headers": {"Return-Path": "<ptmurder+bncBDI33BGM54FBBCUNYHEQMGQEB54F66Y@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple ([2607:fb90:ec93:51ca:6133:9fa4:d139:3f59])\r\n        by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-34910bad4ffsm2989692a91.7.2025.12.03.06.17.43\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Wed, 03 Dec 2025 06:17:43 -0800 (PST)", "Return-path": "<ptmurder+bncBDI33BGM54FBBCUNYHEQMGQEB54F66Y@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Wed, 03 Dec 2025 14:17:48 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764771465; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=NIyVgznMnjf/30ZtM99TlH7DoRFU/F3xBCxO46h+Q8KaKsT4+BrDYFep1PdZDhOfOc\r\n         m0OZTQwsUu1AMmuGWq9VEE2unS2vNlTK7e2leizJsNGIwvxzVaXnRX0TfPpR+5NusAPG\r\n         z4uo9DvR0kG9ySDZeOJyyZPvnIPZCpK4NDphgGehyo3wx5AlqfVYXu1w/7pi6xSKcCnh\r\n         YFt6tKaDceJIl47MuO9L3G3WAp2rHJE1WpCKfq+yC6FC3glVVtvAP9mQUG5swozhRGR9\r\n         QXcToKb0CBTvYGWSlYt6MEwHD8CWsZ+pF2G0UCAIBAYm0S8Gbf9plP9SBRpzEYVqOPSd\r\n         +SCA==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:in-reply-to:references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:dkim-signature;\r\n        bh=McHkhELvRs3zY70NIjjfmpTCQKvnmgg8YcpsV/07ySM=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=H/zcHGcSkngrdLbh0WSMmI+BMqPE+brvlgltJAqNG/w6xHJjj3G8/JKX9FCev53eDK\r\n         UlAYETgbjQonv2ckhRb5TZ/7uH1sWBOnOHq/yLzYZ/PLYmkewZDehjPGjhn2NA1h4h2r\r\n         Yql2LtAY9IjOEYMj8px84pPbAyEdXbTspIPKi1RLoPsx2J7PQCCQhA3qsJrIQBiteg00\r\n         fa1AZqoCNbiXvkhRwwHAsZ5mVq/TFrMKPRXTnfcVebTGnbDZghq1eKDwufrPwCREkOIo\r\n         b6quDm3W4quJ7La466k5hu0KOHIgho1xak9yFes0RE9DLuAtMtWQrDnYEecxlhD951UF\r\n         0ffg==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@gmail.com header.s=20230601 header.b=T0U80uVT;\r\n       spf=pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430 as permitted sender) smtp.mailfrom=jguthrie13@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       dara=pass header.i=@googlegroups.com", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=gmail.com; s=20230601; t=1764771467; x=1765376267; darn=raingull.org;\r\n        h=list-unsubscribe:list-archive:list-help:list-post:list-id\r\n         :mailing-list:precedence:reply-to:x-original-authentication-results\r\n         :x-original-sender:to:in-reply-to:references:message-id:date:subject\r\n         :mime-version:from:content-transfer-encoding:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=v8dOv4g83p1FAaBzIo2ko4drU1NvossVXYsHE1vQrMU=;\r\n        b=Ni6dOTaHigzKnoxJTGIb0sOG9x+k5ThBjBCgYnD+Y6+H1qqiMVr6LPigYiliUGMrjw\r\n         5wJJAXi5mf0RbMFwFNNmi2RuhziXF3SrHlsic3RCEh2BFRMkPHBo4skSD5K4Ib1MUTRv\r\n         cfAI5QkB1BaauV23Gfdr5Tza42hzRKHQPuJPV4HCOdPs2AqOCfqrHxDrr7ZiK+LgrOzD\r\n         K60d89G1cALEqAN+gyifBg/ix8hWfppFr4/dKOIbbOd/MDR6h9ae/VUczzo2/lVJBuy9\r\n         k7T/PtFLWH59p784WcsQ4IvOCo2mnGkVDXQWrTeALLXIKVlOeFFz/Ev9WmPXVgOXY3hU\r\n         3H5Q==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764771467; x=1765376267;\r\n        h=list-unsubscribe:list-archive:list-help:list-post\r\n         :x-spam-checked-in-group:list-id:mailing-list:precedence:reply-to\r\n         :x-original-authentication-results:x-original-sender:to:in-reply-to\r\n         :references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:x-gm-gg:x-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=v8dOv4g83p1FAaBzIo2ko4drU1NvossVXYsHE1vQrMU=;\r\n        b=afARUhGE1V6eZTocXa5O5xdwrPKzQgJOJGAawLh24BEGh/eEvk71RQ/kNf+AbBpjU0\r\n         62GrjMgyEf2rrWdynWLegqPriQ6D5ORGbKnyVT3WwZeU6iZeJ1haUYncwpFJJSM5w7ca\r\n         GMgdVBKpywE61P2Al1SzOTgWI9sKHZym5NLgpvKjJUGHzMQL3p34xuzmZQdWWnsUyHwO\r\n         GPw/k2AYGE4gnzf1saK46Tyo7heFSv2jaPbuJ8iIKP5QCKviMtzlwXEVkebqqQBfRKCi\r\n         DyvtzA6uqefCWTi9l6k5YHIxMY4J7D4XVvWsLzF9aLbI9TjVsn1CDllQ5i3MiFKiBvXH\r\n         MujQ==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCWkCrQva/6t+IOuD8sP+TkV/KZ2q4ZWW20DbApUm8FH/qkj7uoHuFlG/+5OdQrJXfNyVzr4@raingull.org", "X-Gm-Message-State": "AOJu0YzfTlW34kmdpPj9BAm6XHG7KC9l4paR2/pN1ZS+Hc87tQsq7Gsm\r\n\tI3jiMbEQ1FY2Mv1KkvXILOeJ/Cdp+91DZT0I9xkcNkOZziLA5vPptTE=", "X-Google-Smtp-Source": "AGHT+IGQbL8zDMVzDKavz3JN0zV+CEiNiMgxdImzmtxNHbh1+GUPHcg1DTQFFyGyv9MZleEhEg/uUQ==", "X-Received": "by 2002:a17:90b:3c8f:b0:340:bfcd:6af9 with SMTP id 98e67ed59e1d1-349126dea39mr2700161a91.3.1764771464232;\r\n        Wed, 03 Dec 2025 06:17:44 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+Zv/MD/3vg6H/+lYDqrXNhUTlkJYhhUPmMWI/BOwgjwnA==\"", "Received-SPF": "pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430 as permitted sender) client-ip=2607:f8b0:4864:20::430;", "X-Gm-Gg": "ASbGncvkrwHLWlvsfkE1N/WNLD1FvLnY16XyqFHk2GwpXYJcn/6kt73R7RUxmYdz68W\r\n\t1hQJmw6ymCN/V8xvTpbAr0U0yPHh8dU5FH7dkielZsTPDjUvEW5ejxYZtvVVJd8pXSFOYsuGrsE\r\n\t80pzRczg5LqmZI2nqfLbDiPNxa8KQdzJcim0jZDqGbP033WTNRVag7oOzPfYjKJ+ijYIQbVC1Tu\r\n\t1FCAL/s/XrL8bdmUbcr0g5HC+iWUPwu2Lm2/QI9hHxfqNOwVKl0QW2Rjav4tGs9DBkQZDYQVsxV\r\n\tF3kpj7JK/LrHTRTyxLo3wCziJD8qPNNegkwdG3xl8i3lXx8Gwg1UGyjmPViPTLw3U1ESUK/P3vc\r\n\t99zdadO3RbTMAVl0inmkk9dr5NVtAjWnLJM4etPTlUBlUTsZ0OUr8duypjWAVk0xM70s7i0VTu7\r\n\tDjaR/BD7h/vwNjBxNEL0RSlHXNJMxPTbQQjjrE+Yo=", "Content-Type": "multipart/alternative; boundary=Apple-Mail-C404E7AF-EE5D-4A9D-94A4-A4E4F72B69FE", "Content-Transfer-Encoding": "7bit", "From": "James Guthrie <jguthrie13@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Last chance to order dinner", "Date": "Wed, 3 Dec 2025 06:17:32 -0800", "Message-Id": "<CE9613FF-1251-4E16-856F-57772C3013E8@gmail.com>", "References": "<CAAamn6h8hzw01+4u8ZOtDLB_dOmpkR_YrBqkRcSVS1fmfsvkdg@mail.gmail.com>", "In-Reply-To": "<CAAamn6h8hzw01+4u8ZOtDLB_dOmpkR_YrBqkRcSVS1fmfsvkdg@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "jguthrie13@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=T0U80uVT;       spf=pass\r\n (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430\r\n as permitted sender) smtp.mailfrom=jguthrie13@gmail.com;       dmarc=pass\r\n (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;       dara=pass header.i=@googlegroups.com", "Reply-To": "ptmurder@googlegroups.com", "Precedence": "list", "Mailing-list": "list ptmurder@googlegroups.com; contact ptmurder+owners@googlegroups.com", "List-ID": "<ptmurder.googlegroups.com>", "X-Spam-Checked-In-Group": "ptmurder@googlegroups.com", "X-Google-Group-Id": "27968096625", "List-Post": "<https://groups.google.com/group/ptmurder/post>, <mailto:ptmurder@googlegroups.com>", "List-Help": "<https://groups.google.com/support/>, <mailto:ptmurder+help@googlegroups.com>", "List-Archive": "<https://groups.google.com/group/ptmurder", "List-Unsubscribe": "<mailto:googlegroups-manage+27968096625+unsubscribe@googlegroups.com>,\r\n <https://groups.google.com/group/ptmurder/subscribe>", "X-DKIM": "signer='gmail.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "4.5 (++++)", "X-Spam-Report": "Spam detection software, running on the system \"heracles.mxrouting.net\", has\r\n performed the tests listed below against this email.\r\n Information: https://mxroutedocs.com/directadmin/spamfilters/\r\n ---\r\n Content analysis details:   (4.5 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.\r\n                             See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block\r\n                              for more information.\r\n                             [URI: googlegroups.com]\r\n  0.0 RCVD_IN_DNSWL_BLOCKED  RBL: ADMINISTRATOR NOTICE: The query to DNSWL\r\n                             was blocked.  See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#DnsBlocklists-dnsbl-block\r\n                              for more information.\r\n                             [209.85.210.188 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.210.188 listed in wl.mailspike.net]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n -0.1 DKIM_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [jguthrie13(at)gmail.com]\r\n  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  2.0 MIME_HTML_ONLY         BODY: Message only has text/html MIME parts\r\n  0.0 MIME_HTML_ONLY_MULTI   Multipart message only has text/html MIME parts\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager", "SpamTally": "Final spam score: 45"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-12-03 14:17:32 by James Guthrie (jguthrie13@gmail.com)\nSource: IMAP\n---\n", "metadata": {"subject": "Re: Last chance to order dinner", "date": "Wed, 3 Dec 2025 06:17:32 -0800", "headers": {"Return-Path": "<ptmurder+bncBDI33BGM54FBBCUNYHEQMGQEB54F66Y@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple ([2607:fb90:ec93:51ca:6133:9fa4:d139:3f59])\r\n        by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-34910bad4ffsm2989692a91.7.2025.12.03.06.17.43\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Wed, 03 Dec 2025 06:17:43 -0800 (PST)", "Return-path": "<ptmurder+bncBDI33BGM54FBBCUNYHEQMGQEB54F66Y@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Wed, 03 Dec 2025 14:17:48 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764771465; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=NIyVgznMnjf/30ZtM99TlH7DoRFU/F3xBCxO46h+Q8KaKsT4+BrDYFep1PdZDhOfOc\r\n         m0OZTQwsUu1AMmuGWq9VEE2unS2vNlTK7e2leizJsNGIwvxzVaXnRX0TfPpR+5NusAPG\r\n         z4uo9DvR0kG9ySDZeOJyyZPvnIPZCpK4NDphgGehyo3wx5AlqfVYXu1w/7pi6xSKcCnh\r\n         YFt6tKaDceJIl47MuO9L3G3WAp2rHJE1WpCKfq+yC6FC3glVVtvAP9mQUG5swozhRGR9\r\n         QXcToKb0CBTvYGWSlYt6MEwHD8CWsZ+pF2G0UCAIBAYm0S8Gbf9plP9SBRpzEYVqOPSd\r\n         +SCA==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:in-reply-to:references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:dkim-signature;\r\n        bh=McHkhELvRs3zY70NIjjfmpTCQKvnmgg8YcpsV/07ySM=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=H/zcHGcSkngrdLbh0WSMmI+BMqPE+brvlgltJAqNG/w6xHJjj3G8/JKX9FCev53eDK\r\n         UlAYETgbjQonv2ckhRb5TZ/7uH1sWBOnOHq/yLzYZ/PLYmkewZDehjPGjhn2NA1h4h2r\r\n         Yql2LtAY9IjOEYMj8px84pPbAyEdXbTspIPKi1RLoPsx2J7PQCCQhA3qsJrIQBiteg00\r\n         fa1AZqoCNbiXvkhRwwHAsZ5mVq/TFrMKPRXTnfcVebTGnbDZghq1eKDwufrPwCREkOIo\r\n         b6quDm3W4quJ7La466k5hu0KOHIgho1xak9yFes0RE9DLuAtMtWQrDnYEecxlhD951UF\r\n         0ffg==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@gmail.com header.s=20230601 header.b=T0U80uVT;\r\n       spf=pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430 as permitted sender) smtp.mailfrom=jguthrie13@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       dara=pass header.i=@googlegroups.com", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=gmail.com; s=20230601; t=1764771467; x=1765376267; darn=raingull.org;\r\n        h=list-unsubscribe:list-archive:list-help:list-post:list-id\r\n         :mailing-list:precedence:reply-to:x-original-authentication-results\r\n         :x-original-sender:to:in-reply-to:references:message-id:date:subject\r\n         :mime-version:from:content-transfer-encoding:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=v8dOv4g83p1FAaBzIo2ko4drU1NvossVXYsHE1vQrMU=;\r\n        b=Ni6dOTaHigzKnoxJTGIb0sOG9x+k5ThBjBCgYnD+Y6+H1qqiMVr6LPigYiliUGMrjw\r\n         5wJJAXi5mf0RbMFwFNNmi2RuhziXF3SrHlsic3RCEh2BFRMkPHBo4skSD5K4Ib1MUTRv\r\n         cfAI5QkB1BaauV23Gfdr5Tza42hzRKHQPuJPV4HCOdPs2AqOCfqrHxDrr7ZiK+LgrOzD\r\n         K60d89G1cALEqAN+gyifBg/ix8hWfppFr4/dKOIbbOd/MDR6h9ae/VUczzo2/lVJBuy9\r\n         k7T/PtFLWH59p784WcsQ4IvOCo2mnGkVDXQWrTeALLXIKVlOeFFz/Ev9WmPXVgOXY3hU\r\n         3H5Q==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764771467; x=1765376267;\r\n        h=list-unsubscribe:list-archive:list-help:list-post\r\n         :x-spam-checked-in-group:list-id:mailing-list:precedence:reply-to\r\n         :x-original-authentication-results:x-original-sender:to:in-reply-to\r\n         :references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:x-gm-gg:x-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=v8dOv4g83p1FAaBzIo2ko4drU1NvossVXYsHE1vQrMU=;\r\n        b=afARUhGE1V6eZTocXa5O5xdwrPKzQgJOJGAawLh24BEGh/eEvk71RQ/kNf+AbBpjU0\r\n         62GrjMgyEf2rrWdynWLegqPriQ6D5ORGbKnyVT3WwZeU6iZeJ1haUYncwpFJJSM5w7ca\r\n         GMgdVBKpywE61P2Al1SzOTgWI9sKHZym5NLgpvKjJUGHzMQL3p34xuzmZQdWWnsUyHwO\r\n         GPw/k2AYGE4gnzf1saK46Tyo7heFSv2jaPbuJ8iIKP5QCKviMtzlwXEVkebqqQBfRKCi\r\n         DyvtzA6uqefCWTi9l6k5YHIxMY4J7D4XVvWsLzF9aLbI9TjVsn1CDllQ5i3MiFKiBvXH\r\n         MujQ==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCWkCrQva/6t+IOuD8sP+TkV/KZ2q4ZWW20DbApUm8FH/qkj7uoHuFlG/+5OdQrJXfNyVzr4@raingull.org", "X-Gm-Message-State": "AOJu0YzfTlW34kmdpPj9BAm6XHG7KC9l4paR2/pN1ZS+Hc87tQsq7Gsm\r\n\tI3jiMbEQ1FY2Mv1KkvXILOeJ/Cdp+91DZT0I9xkcNkOZziLA5vPptTE=", "X-Google-Smtp-Source": "AGHT+IGQbL8zDMVzDKavz3JN0zV+CEiNiMgxdImzmtxNHbh1+GUPHcg1DTQFFyGyv9MZleEhEg/uUQ==", "X-Received": "by 2002:a17:90b:3c8f:b0:340:bfcd:6af9 with SMTP id 98e67ed59e1d1-349126dea39mr2700161a91.3.1764771464232;\r\n        Wed, 03 Dec 2025 06:17:44 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+Zv/MD/3vg6H/+lYDqrXNhUTlkJYhhUPmMWI/BOwgjwnA==\"", "Received-SPF": "pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430 as permitted sender) client-ip=2607:f8b0:4864:20::430;", "X-Gm-Gg": "ASbGncvkrwHLWlvsfkE1N/WNLD1FvLnY16XyqFHk2GwpXYJcn/6kt73R7RUxmYdz68W\r\n\t1hQJmw6ymCN/V8xvTpbAr0U0yPHh8dU5FH7dkielZsTPDjUvEW5ejxYZtvVVJd8pXSFOYsuGrsE\r\n\t80pzRczg5LqmZI2nqfLbDiPNxa8KQdzJcim0jZDqGbP033WTNRVag7oOzPfYjKJ+ijYIQbVC1Tu\r\n\t1FCAL/s/XrL8bdmUbcr0g5HC+iWUPwu2Lm2/QI9hHxfqNOwVKl0QW2Rjav4tGs9DBkQZDYQVsxV\r\n\tF3kpj7JK/LrHTRTyxLo3wCziJD8qPNNegkwdG3xl8i3lXx8Gwg1UGyjmPViPTLw3U1ESUK/P3vc\r\n\t99zdadO3RbTMAVl0inmkk9dr5NVtAjWnLJM4etPTlUBlUTsZ0OUr8duypjWAVk0xM70s7i0VTu7\r\n\tDjaR/BD7h/vwNjBxNEL0RSlHXNJMxPTbQQjjrE+Yo=", "Content-Type": "multipart/alternative; boundary=Apple-Mail-C404E7AF-EE5D-4A9D-94A4-A4E4F72B69FE", "Content-Transfer-Encoding": "7bit", "From": "James Guthrie <jguthrie13@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Last chance to order dinner", "Date": "Wed, 3 Dec 2025 06:17:32 -0800", "Message-Id": "<CE9613FF-1251-4E16-856F-57772C3013E8@gmail.com>", "References": "<CAAamn6h8hzw01+4u8ZOtDLB_dOmpkR_YrBqkRcSVS1fmfsvkdg@mail.gmail.com>", "In-Reply-To": "<CAAamn6h8hzw01+4u8ZOtDLB_dOmpkR_YrBqkRcSVS1fmfsvkdg@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "jguthrie13@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=T0U80uVT;       spf=pass\r\n (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::430\r\n as permitted sender) smtp.mailfrom=jguthrie13@gmail.com;       dmarc=pass\r\n (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;       dara=pass header.i=@googlegroups.com", "Reply-To": "ptmurder@googlegroups.com", "Precedence": "list", "Mailing-list": "list ptmurder@googlegroups.com; contact ptmurder+owners@googlegroups.com", "List-ID": "<ptmurder.googlegroups.com>", "X-Spam-Checked-In-Group": "ptmurder@googlegroups.com", "X-Google-Group-Id": "27968096625", "List-Post": "<https://groups.google.com/group/ptmurder/post>, <mailto:ptmurder@googlegroups.com>", "List-Help": "<https://groups.google.com/support/>, <mailto:ptmurder+help@googlegroups.com>", "List-Archive": "<https://groups.google.com/group/ptmurder", "List-Unsubscribe": "<mailto:googlegroups-manage+27968096625+unsubscribe@googlegroups.com>,\r\n <https://groups.google.com/group/ptmurder/subscribe>", "X-DKIM": "signer='gmail.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "4.5 (++++)", "X-Spam-Report": "Spam detection software, running on the system \"heracles.mxrouting.net\", has\r\n performed the tests listed below against this email.\r\n Information: https://mxroutedocs.com/directadmin/spamfilters/\r\n ---\r\n Content analysis details:   (4.5 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.\r\n                             See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block\r\n                              for more information.\r\n                             [URI: googlegroups.com]\r\n  0.0 RCVD_IN_DNSWL_BLOCKED  RBL: ADMINISTRATOR NOTICE: The query to DNSWL\r\n                             was blocked.  See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#DnsBlocklists-dnsbl-block\r\n                              for more information.\r\n                             [209.85.210.188 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.210.188 listed in wl.mailspike.net]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n -0.1 DKIM_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [jguthrie13(at)gmail.com]\r\n  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  2.0 MIME_HTML_ONLY         BODY: Message only has text/html MIME parts\r\n  0.0 MIME_HTML_ONLY_MULTI   Multipart message only has text/html MIME parts\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager", "SpamTally": "Final spam score: 45"}}, "from_name": "Raingull", "from_address": "list@raingull.org"}}

TEXT NOT NULL

subject

varchar(255)

sender

varchar(255)

recipient

varchar(255)

error_message

TEXT

created_at

datetime NOT NULL

updated_at

datetime NOT NULL

sent_at

datetime

message_id

bigint NOT NULL

service_id

bigint NOT NULL

db.sqlite3 — core_formatted_messages

Update row 194 in core_formatted_messages