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-05 19:43:20 by Michael Crozier (michaelcrozier111@gmail.com)\nSource: IMAP\n---\n", "subject": "Re: A few images of our dress rehearsal - Let's Slay It!", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Re: A few images of our dress rehearsal - Let's Slay It!", "date": "Fri, 5 Dec 2025 11:43:20 -0800", "headers": {"Return-Path": "<ptmurder+bncBC42JQUS7IKRBZHLZTEQMGQEMMDBNXA@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-125-227.wavecable.com. [24.113.125.227])\r\n        by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7e2a0dd6c28sm6051420b3a.30.2025.12.05.11.43.30\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Fri, 05 Dec 2025 11:43:31 -0800 (PST)", "Return-path": "<ptmurder+bncBC42JQUS7IKRBZHLZTEQMGQEMMDBNXA@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 05 Dec 2025 19:43:35 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764963812; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=dSIEwZ0CCEfKSNZj8zFLSOyCP58kTPT18HAMjfKQYRerl9NWM7WzGZ7GyV/3KGhdKU\r\n         NXHCb98TBnzxKXmjBQCjgiDst0D/QF1RAmCrxtsqXDrFi43aYXB6xXXlwkVm4TPPhC9k\r\n         lkDdBGsCw0MxKHaXN/BVkl69XWwnFjq3Zl1150mZtuUSAjoAwPAa4BD27vF/aVBYC9LG\r\n         4Y40KFKKosu3cus+t8oH4R6AUhCjygFiC6B66lvpB2juFmqDQGkDh8lcFHY+MOnfGwVB\r\n         zCa9gJ4nI6guTD5R45NXYo35kejqhvlectnqEkkSXYz9XkqUSjfudI7omZH02vNEO7oO\r\n         2hCA==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:in-reply-to:cc:references:message-id:date:subject:mime-version\r\n         :content-transfer-encoding:from:dkim-signature;\r\n        bh=ICat7Vs8GWosEq2sKaRcgfDL7hv80woE7V1SYPOLNC0=;\r\n        fh=xnZKGtJ0tfhBbhtRolItDIakMTmDN68mgYHcmO0LxAY=;\r\n        b=DcjFduge/OTrGDtlxM+x98f3evkPu1UNVXJnERAKVXz7DZv3egjMIMqZaJlG1SOdJ+\r\n         updwWo/r6dtI3vMezugI4BVehf6HDfGv+7ih+VPmSSqvbMuRaYuy9dFhhf6LmMfj5Sst\r\n         hZSAES0Yr662XrSa7WSbsHCIRp5KSu1TaeMUZBCZ6njk2ejL+D+0TPwu6TqF5EQl6O0O\r\n         8+gpNFyIveTnoiFfRnJhnnFfdcBAc1THcOn+R2Z9tDmYf7KhPWdYvNCz2sRqhfgE84kY\r\n         bWz6DOBNahcFh8SxIKhDzgs8NCI9c6R5W4wl/HUPI4swr4VxAZQRsF/gT3XKQeOHuGCk\r\n         kzYA==;\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=HsZELJak;\r\n       spf=pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::434 as permitted sender) smtp.mailfrom=michaelcrozier111@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=1764963813; x=1765568613; 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:cc:references:message-id:date\r\n         :subject:mime-version:content-transfer-encoding:from:from:to:cc\r\n         :subject:date:message-id:reply-to;\r\n        bh=r/fJjcpbTJC2m9Cr/Bh0EXO4fSOXSpWGpdcfl/usK2k=;\r\n        b=XlcNGzfJ8y8qy6VE4mSroZFpmwN1PWlM91IUuXTzQTNBwncE3y++urWyGcwS8mg4N9\r\n         Wh+cd5u7URZNmUxXGD6D7+HcK6/A2p+/NynVlavmDl5g/ijRbCSqYo2SH4Ha7i32PGq9\r\n         g/7QW2jwHHOzOCIcSiITjZETyFbKuuQKFHkLsFpfldgeKOvSAnkQYbZfJ/3sr5npMz1F\r\n         kow10xHZ5TeVtig2SdRmiKOSZj6EBcRcgDO8GIITVyZpCpW/sC6C8+5fBN0xKeAUwxBn\r\n         7M1PgkqhSKucUExYLteb+tf/rQSJGSvgVe6eqpqRwJ++c2vdfdDyNiGArStOtdJ77vw8\r\n         KqAg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764963813; x=1765568613;\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         :cc:references:message-id:date:subject:mime-version\r\n         :content-transfer-encoding:from:x-gm-gg:x-beenthere\r\n         :x-gm-message-state:sender:from:to:cc:subject:date:message-id\r\n         :reply-to;\r\n        bh=r/fJjcpbTJC2m9Cr/Bh0EXO4fSOXSpWGpdcfl/usK2k=;\r\n        b=uQBO/nm3rGbotzrZ5SWv8E6rcGY7Sf2am9d3hk6ZJmGBpOCc7EH9ZhFKhZk4TsTR1U\r\n         2Xb1yXOg53B5KSXEXu6/2D9PxCQTJaEi6yUlE0jY0LJyr3GRqgz1aZhg6TmCxBW9s/od\r\n         DUXSh0awNrUl8TnBUHd+u9hp814G1GIk79m9fEsitOJauaCPjCdK8U0V5jtPa4Fl6MrN\r\n         EfJd+6sU6j5U4y2XPx/rqC90wU2Rn2YG8sr4Z7/Wv7ZEmbJZAXgm7hHjUDqdSAEMFLbo\r\n         nb0ZyQtS7R3fJildNjWhQJOZXdijtz3AX57YV5KztyPa3RQvjyWORGQjugGWc6ZDRDDF\r\n         iY3Q==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCW41a0ooxL+NeT/C509Mtji9VUvJDR0CtLnmWuvoqHU40rWbmB4vLn+mbmhlRCMA8/qtsYX@raingull.org", "X-Gm-Message-State": "AOJu0YyuY2WB1uOpvJGJclq+wUP6F2rLNdYOxaPMmIdSdI3MJQIW/e4s\r\n\t4+GH/n8iGKyqmH4XJu7NFVLQodympBXV0C4c+3zG2vEqqIywgJmYXog=", "X-Google-Smtp-Source": "AGHT+IFsz/wiqBRN0WCEBtFrsyt4eYg47jvEmQjQ7NdinNBR1f4h2qrGIXXeypRmq+J1W8Q/num4lg==", "X-Received": "by 2002:a05:6a00:140b:b0:77f:4c3e:c19d with SMTP id d2e1a72fcca58-7e8c25d0bdcmr273650b3a.12.1764963811437;\r\n        Fri, 05 Dec 2025 11:43:31 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+a2mXhA1M08ULTzHsQ2dH7rvkno3upT1ea8DJVpeCq0hw==\"", "Received-SPF": "pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::434 as permitted sender) client-ip=2607:f8b0:4864:20::434;", "X-Gm-Gg": "ASbGncvkBE6iO+eRgl63gZuL6s1SjsYplrEFLr3HRgT9T+p4mEKtRdj8u7X99VCkb4f\r\n\tnjfYGnwSXY/i2286uyNMSkOAcppsUi9eEXFnicmtI9acQH4IQZsZgtqYRof7lWpooRegCCtpfI1\r\n\tVNfHgJYh9jHDySSQ8+TK1gfXaZfv5c4nqeXZlCdu/kimKX2X+8bOnmTym9WjHJyZrnAow8qt3qX\r\n\tSR9gBELNrUHK/g4XGeoVrddRKYSBAE3TuihSCNNaLcwSmrVKqMq1U2+FaCVE2WFDm6nqI0x1fd+\r\n\tTODlsfL6yEbJ2opo4k7eIM0V7d8GGFWX9zLfn4XUhN1AsCa3Qh8+O69OjYE4kU0QFFSr4CsL+Is\r\n\tYc1ksX0M0FTAozSV2t8hV5KuT5hMOxE3sOF5dKWf16jwypPPOeKxka4+BfmxaxHonwGjJ0Xzzyx\r\n\tkSlAUekRYxGw7lAZfYjGXuK7EW4jqflsedjkqrZ05NGzgvAC29ic3hj2PyGtSp4scL3YY=", "From": "Michael Crozier <michaelcrozier111@gmail.com>", "Content-Type": "multipart/alternative; boundary=Apple-Mail-6D03D178-86D9-48D1-B07E-7B1DE078C942", "Content-Transfer-Encoding": "7bit", "Mime-Version": "1.0 (1.0)", "Subject": "Re: A few images of our dress rehearsal - Let's Slay It!", "Date": "Fri, 5 Dec 2025 11:43:20 -0800", "Message-Id": "<D6E2CA64-3B6C-482C-831C-C367DE1036C6@gmail.com>", "References": "<CA+HK9iKbNVue8XY1Q2gAU-21mxkJWVkTCMo_OAB_wXEBZaPYeA@mail.gmail.com>", "Cc": "ptmurder@googlegroups.com", "In-Reply-To": "<CA+HK9iKbNVue8XY1Q2gAU-21mxkJWVkTCMo_OAB_wXEBZaPYeA@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "Michaelcrozier111@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=HsZELJak;       spf=pass\r\n (google.com: domain of michaelcrozier111@gmail.com designates\r\n 2607:f8b0:4864:20::434 as permitted sender) smtp.mailfrom=michaelcrozier111@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       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": "7.2 (+++++++)", "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:   (7.2 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\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.160.190 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.160.190 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             Message has at least one valid DKIM or DK signature\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 ARC_SIGNED             Message has a ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\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 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [michaelcrozier111(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains 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.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\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\r\n  2.7 RCVD_IN_PSBL           RBL: Received via a relay in PSBL\r\n                             [209.85.160.190 listed in psbl.surriel.com]", "SpamTally": "Final spam score: 72"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-12-05 19:43:20 by Michael Crozier (michaelcrozier111@gmail.com)\nSource: IMAP\n---\n", "metadata": {"subject": "Re: A few images of our dress rehearsal - Let's Slay It!", "date": "Fri, 5 Dec 2025 11:43:20 -0800", "headers": {"Return-Path": "<ptmurder+bncBC42JQUS7IKRBZHLZTEQMGQEMMDBNXA@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-125-227.wavecable.com. [24.113.125.227])\r\n        by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7e2a0dd6c28sm6051420b3a.30.2025.12.05.11.43.30\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Fri, 05 Dec 2025 11:43:31 -0800 (PST)", "Return-path": "<ptmurder+bncBC42JQUS7IKRBZHLZTEQMGQEMMDBNXA@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 05 Dec 2025 19:43:35 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764963812; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=dSIEwZ0CCEfKSNZj8zFLSOyCP58kTPT18HAMjfKQYRerl9NWM7WzGZ7GyV/3KGhdKU\r\n         NXHCb98TBnzxKXmjBQCjgiDst0D/QF1RAmCrxtsqXDrFi43aYXB6xXXlwkVm4TPPhC9k\r\n         lkDdBGsCw0MxKHaXN/BVkl69XWwnFjq3Zl1150mZtuUSAjoAwPAa4BD27vF/aVBYC9LG\r\n         4Y40KFKKosu3cus+t8oH4R6AUhCjygFiC6B66lvpB2juFmqDQGkDh8lcFHY+MOnfGwVB\r\n         zCa9gJ4nI6guTD5R45NXYo35kejqhvlectnqEkkSXYz9XkqUSjfudI7omZH02vNEO7oO\r\n         2hCA==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:in-reply-to:cc:references:message-id:date:subject:mime-version\r\n         :content-transfer-encoding:from:dkim-signature;\r\n        bh=ICat7Vs8GWosEq2sKaRcgfDL7hv80woE7V1SYPOLNC0=;\r\n        fh=xnZKGtJ0tfhBbhtRolItDIakMTmDN68mgYHcmO0LxAY=;\r\n        b=DcjFduge/OTrGDtlxM+x98f3evkPu1UNVXJnERAKVXz7DZv3egjMIMqZaJlG1SOdJ+\r\n         updwWo/r6dtI3vMezugI4BVehf6HDfGv+7ih+VPmSSqvbMuRaYuy9dFhhf6LmMfj5Sst\r\n         hZSAES0Yr662XrSa7WSbsHCIRp5KSu1TaeMUZBCZ6njk2ejL+D+0TPwu6TqF5EQl6O0O\r\n         8+gpNFyIveTnoiFfRnJhnnFfdcBAc1THcOn+R2Z9tDmYf7KhPWdYvNCz2sRqhfgE84kY\r\n         bWz6DOBNahcFh8SxIKhDzgs8NCI9c6R5W4wl/HUPI4swr4VxAZQRsF/gT3XKQeOHuGCk\r\n         kzYA==;\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=HsZELJak;\r\n       spf=pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::434 as permitted sender) smtp.mailfrom=michaelcrozier111@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=1764963813; x=1765568613; 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:cc:references:message-id:date\r\n         :subject:mime-version:content-transfer-encoding:from:from:to:cc\r\n         :subject:date:message-id:reply-to;\r\n        bh=r/fJjcpbTJC2m9Cr/Bh0EXO4fSOXSpWGpdcfl/usK2k=;\r\n        b=XlcNGzfJ8y8qy6VE4mSroZFpmwN1PWlM91IUuXTzQTNBwncE3y++urWyGcwS8mg4N9\r\n         Wh+cd5u7URZNmUxXGD6D7+HcK6/A2p+/NynVlavmDl5g/ijRbCSqYo2SH4Ha7i32PGq9\r\n         g/7QW2jwHHOzOCIcSiITjZETyFbKuuQKFHkLsFpfldgeKOvSAnkQYbZfJ/3sr5npMz1F\r\n         kow10xHZ5TeVtig2SdRmiKOSZj6EBcRcgDO8GIITVyZpCpW/sC6C8+5fBN0xKeAUwxBn\r\n         7M1PgkqhSKucUExYLteb+tf/rQSJGSvgVe6eqpqRwJ++c2vdfdDyNiGArStOtdJ77vw8\r\n         KqAg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764963813; x=1765568613;\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         :cc:references:message-id:date:subject:mime-version\r\n         :content-transfer-encoding:from:x-gm-gg:x-beenthere\r\n         :x-gm-message-state:sender:from:to:cc:subject:date:message-id\r\n         :reply-to;\r\n        bh=r/fJjcpbTJC2m9Cr/Bh0EXO4fSOXSpWGpdcfl/usK2k=;\r\n        b=uQBO/nm3rGbotzrZ5SWv8E6rcGY7Sf2am9d3hk6ZJmGBpOCc7EH9ZhFKhZk4TsTR1U\r\n         2Xb1yXOg53B5KSXEXu6/2D9PxCQTJaEi6yUlE0jY0LJyr3GRqgz1aZhg6TmCxBW9s/od\r\n         DUXSh0awNrUl8TnBUHd+u9hp814G1GIk79m9fEsitOJauaCPjCdK8U0V5jtPa4Fl6MrN\r\n         EfJd+6sU6j5U4y2XPx/rqC90wU2Rn2YG8sr4Z7/Wv7ZEmbJZAXgm7hHjUDqdSAEMFLbo\r\n         nb0ZyQtS7R3fJildNjWhQJOZXdijtz3AX57YV5KztyPa3RQvjyWORGQjugGWc6ZDRDDF\r\n         iY3Q==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCW41a0ooxL+NeT/C509Mtji9VUvJDR0CtLnmWuvoqHU40rWbmB4vLn+mbmhlRCMA8/qtsYX@raingull.org", "X-Gm-Message-State": "AOJu0YyuY2WB1uOpvJGJclq+wUP6F2rLNdYOxaPMmIdSdI3MJQIW/e4s\r\n\t4+GH/n8iGKyqmH4XJu7NFVLQodympBXV0C4c+3zG2vEqqIywgJmYXog=", "X-Google-Smtp-Source": "AGHT+IFsz/wiqBRN0WCEBtFrsyt4eYg47jvEmQjQ7NdinNBR1f4h2qrGIXXeypRmq+J1W8Q/num4lg==", "X-Received": "by 2002:a05:6a00:140b:b0:77f:4c3e:c19d with SMTP id d2e1a72fcca58-7e8c25d0bdcmr273650b3a.12.1764963811437;\r\n        Fri, 05 Dec 2025 11:43:31 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+a2mXhA1M08ULTzHsQ2dH7rvkno3upT1ea8DJVpeCq0hw==\"", "Received-SPF": "pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::434 as permitted sender) client-ip=2607:f8b0:4864:20::434;", "X-Gm-Gg": "ASbGncvkBE6iO+eRgl63gZuL6s1SjsYplrEFLr3HRgT9T+p4mEKtRdj8u7X99VCkb4f\r\n\tnjfYGnwSXY/i2286uyNMSkOAcppsUi9eEXFnicmtI9acQH4IQZsZgtqYRof7lWpooRegCCtpfI1\r\n\tVNfHgJYh9jHDySSQ8+TK1gfXaZfv5c4nqeXZlCdu/kimKX2X+8bOnmTym9WjHJyZrnAow8qt3qX\r\n\tSR9gBELNrUHK/g4XGeoVrddRKYSBAE3TuihSCNNaLcwSmrVKqMq1U2+FaCVE2WFDm6nqI0x1fd+\r\n\tTODlsfL6yEbJ2opo4k7eIM0V7d8GGFWX9zLfn4XUhN1AsCa3Qh8+O69OjYE4kU0QFFSr4CsL+Is\r\n\tYc1ksX0M0FTAozSV2t8hV5KuT5hMOxE3sOF5dKWf16jwypPPOeKxka4+BfmxaxHonwGjJ0Xzzyx\r\n\tkSlAUekRYxGw7lAZfYjGXuK7EW4jqflsedjkqrZ05NGzgvAC29ic3hj2PyGtSp4scL3YY=", "From": "Michael Crozier <michaelcrozier111@gmail.com>", "Content-Type": "multipart/alternative; boundary=Apple-Mail-6D03D178-86D9-48D1-B07E-7B1DE078C942", "Content-Transfer-Encoding": "7bit", "Mime-Version": "1.0 (1.0)", "Subject": "Re: A few images of our dress rehearsal - Let's Slay It!", "Date": "Fri, 5 Dec 2025 11:43:20 -0800", "Message-Id": "<D6E2CA64-3B6C-482C-831C-C367DE1036C6@gmail.com>", "References": "<CA+HK9iKbNVue8XY1Q2gAU-21mxkJWVkTCMo_OAB_wXEBZaPYeA@mail.gmail.com>", "Cc": "ptmurder@googlegroups.com", "In-Reply-To": "<CA+HK9iKbNVue8XY1Q2gAU-21mxkJWVkTCMo_OAB_wXEBZaPYeA@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "Michaelcrozier111@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=HsZELJak;       spf=pass\r\n (google.com: domain of michaelcrozier111@gmail.com designates\r\n 2607:f8b0:4864:20::434 as permitted sender) smtp.mailfrom=michaelcrozier111@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       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": "7.2 (+++++++)", "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:   (7.2 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\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.160.190 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.160.190 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             Message has at least one valid DKIM or DK signature\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 ARC_SIGNED             Message has a ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\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 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [michaelcrozier111(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains 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.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\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\r\n  2.7 RCVD_IN_PSBL           RBL: Received via a relay in PSBL\r\n                             [209.85.160.190 listed in psbl.surriel.com]", "SpamTally": "Final spam score: 72"}}, "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 210 in core_formatted_messages