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-11-15 16:36:00 by Jan Boutilier (janby55@gmail.com)\nSource: IMAP\n---\nI think either day would work but Thursday would be better.\r\n\r\nOn Sat, Nov 15, 2025 at 7:08\u202fAM Sean DeVries <seangdevries@gmail.com> wrote:\r\n\r\n> Wednesday is better thank you\r\n>\r\n> On Fri, Nov 14, 2025, 9:31\u202fPM Ashley Schenkel <ashley.schenkel@gmail.com>\r\n> wrote:\r\n>\r\n>> Grrrrr Rawr,\r\n>>\r\n>> We want to shoot you all! (On film)\r\n>>\r\n>> Wednesday, November 19th @ 5:45\r\n>> Thursday, November 20th @ 5:45\r\n>>\r\n>> Please tell us your date preference for your talking head interview\r\n>> videos at rehearsal tomorrow!\r\n>>\r\n>> Please be prepared with memorized video lines in case the teleprompter\r\n>> arrives later.\r\n>>\r\n>> Bleeding Chest,\r\n>> Ashley\r\n>>\r\n>> *\"I cannot do all the good that the world needs, but the world needs all\r\n>> the good that I can do.\" ~Jana Stanfield*\r\n>>\r\n>> --\r\n>> You received this message because you are subscribed to the Google Groups\r\n>> \"Port Townsend Murder Mysteries\" group.\r\n>> To unsubscribe from this group and stop receiving emails from it, send an\r\n>> email to ptmurder+unsubscribe@googlegroups.com.\r\n>> To view this discussion visit\r\n>> https://groups.google.com/d/msgid/ptmurder/CAFRDBvf9fG4pQETt97yGq_1%3DjCGyDfQWCz5RTSXrG1Y%3D4AWYmA%40mail.gmail.com\r\n>> <https://groups.google.com/d/msgid/ptmurder/CAFRDBvf9fG4pQETt97yGq_1%3DjCGyDfQWCz5RTSXrG1Y%3D4AWYmA%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n>> .\r\n>>\r\n> --\r\n> You received this message because you are subscribed to the Google Groups\r\n> \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an\r\n> email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit\r\n> https://groups.google.com/d/msgid/ptmurder/CA%2BHK9iJbzUV311x9BV_9u9EG7M6PE%3DOW_kfC-J1YB6d%2BcNTqHQ%40mail.gmail.com\r\n> <https://groups.google.com/d/msgid/ptmurder/CA%2BHK9iJbzUV311x9BV_9u9EG7M6PE%3DOW_kfC-J1YB6d%2BcNTqHQ%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n> .\r\n>\r\n\r\n\r\n-- \r\n*\"Kindness is free. Sprinkle it everywhere.\"*\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAPcF4QZdWVNUqGTtcnHhV733Tnn7tW-DG_08od-2FLeLpxd-WA%40mail.gmail.com.\r\n", "subject": "Re: Video Recording", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Re: Video Recording", "date": "Sat, 15 Nov 2025 08:36:00 -0800", "headers": {"Return-Path": "<ptmurder+bncBDQNHTVFWULRB7OX4LEAMGQEYVWZMVI@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7c7545310b8so151008a34.1\r\n        for <ptmurder@googlegroups.com>; Sat, 15 Nov 2025 08:36:12 -0800 (PST)", "Return-path": "<ptmurder+bncBDQNHTVFWULRB7OX4LEAMGQEYVWZMVI@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Sat, 15 Nov 2025 16:36:15 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763224572; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=Z/27puLG0pQg40ytajwZcoLv+fjANtEDMh3/uqeKt5fN8/J15C9s0P72lwOMi1NHSM\r\n         JXa2ee4j0DPavb5oI9ZAT8jIUXWyv1fgFKoEj1h2W0p2k6Bh89FyEYzyTsnIGG3N3YJd\r\n         LoEXFBdJSY1K3KBczvLUFZXVu8zGbiOHEYEfhsOhQDFgpyQ02JoLU9Ewb044xgWk0RSj\r\n         i+1Duj14fpFbiQQ8eq4gSDMWwzG9gxtrb5GckVQJ7xV5i0e6hDxjDVnRXvHPj7x1jwCb\r\n         cxDgRMktau/yKU/V3x4Gm7Q8wiLVOZUuh62ftMtr21LO1qPD1ginuXGr9fQeK1DN6/K8\r\n         JlKg==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:subject:message-id:date:from:in-reply-to:references:mime-version\r\n         :dkim-signature;\r\n        bh=HYf158V296tPwDl3dlMCkuWusnqhDSb45mM0mMG9G2I=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=edFQXSSO8tw1e266mc95e4wFgQ+UDGCa91/5977NkaIarYSg3255IHK0hPef/urtfu\r\n         k594B+rL9OcWn+5N+Cj5nUwj/lmImE+KYT1I5DHh3CDZGjV0UNq7s5Mn0U3EjcjHN70v\r\n         YybY5NEik//bB7NIijyuCPXPeFG/hK3M9JJqyweBAWsmNQ28yePPsc4ShFEqNg4kWhDX\r\n         Fodptdyi1Z49xJk8wlI2Ikc/fGW1JwyOAW+J858207eScIchnVim0QXs3xDSOnz631Nl\r\n         j/sz5dDCSOl8obwwf1pL5wVNqQCSZH5uG+Nt8fOXo482i8YrLvxyfY72j1JFHFMT9Odi\r\n         Qx5Q==;\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=D1bnYCg+;\r\n       spf=pass (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as permitted sender) smtp.mailfrom=janby55@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=1763224574; x=1763829374; 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:subject:message-id:date:from:in-reply-to\r\n         :references:mime-version:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=CQLVI/ccQ80qqjujR6DGgtmQkJr70ppyTCa9oVNhF8Q=;\r\n        b=KX4YJUq5LU4Ld1XXcORL7PyxaKuV/bY9rZ5fE3ecI2O9QkDcX6E0SksFfrtzKPpiOU\r\n         ZUyh05n86pmzGsvr/6v5z2A4dc9mu2pu/TERF5fj1JKtYuGK/Kf/lwcD8UJbvqjZ1Brt\r\n         H9wY8RERF6GWDOQdLo1zRS9odaV/urArBpXAirrVeKejBJofaAxHdGR/WJOz5vQX9lus\r\n         2HUh1F1D0HYUyvmXKnIVtuubr4ifQE7XXamZqM676N0rcjfUFOlV0NQEIuyT4cbkNpzF\r\n         zWIPEnolMpkjOHMUChHqJUE96ovzvS94oYi+zyc/cwB6W6SxfL13AnXyn5u1zjqQVdIG\r\n         /6Qg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763224574; x=1763829374;\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:subject\r\n         :message-id:date:from:in-reply-to:references:mime-version:x-gm-gg\r\n         :x-beenthere:x-gm-message-state:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=CQLVI/ccQ80qqjujR6DGgtmQkJr70ppyTCa9oVNhF8Q=;\r\n        b=cysTk6T3rUglJDazpt6E+TqgguSc9mf53aaz9kTB9s0DcenpFaLwqkMzjl5xpfGDHs\r\n         Z0cTohAmYzfLmfuC/XRV6Lc0+0VEd8cS8Ldhg8XCazLdht2fZlKmQXZ8GSaZIrXF0BOl\r\n         9lqDQ+lUofTf8tBc7Orqv7zbWSblT5QugXb5U3Pss4I4LFkebiCqzBR1WaLwBdJmX2BY\r\n         4SIfpqSmZ2+MUA3cRJUWzltlQqAE2JXE8BCOnQMnQmPM4CnZQBSzBmjarrjxZE2WSW7j\r\n         1WNad3aYKOjZDwZ/+yZULVteI8qWIAFMS3+V26mYQq84dIVD7myltyCcPADZm377cZ72\r\n         FvUA==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCXDl9bNTaumXj5i6DnUrkmRkcFMuKvMQ5Oyf1Lk2wYEM8PV5rjoqARVGdhb82wTHWlC8nrq@raingull.org", "X-Gm-Message-State": "AOJu0YxbzCKWk0/xifmeph4B+S1zG5x3RA35GAxH0Hr9Ypy6zu7431Pv\r\n\tbTpsFdSf3piWhnpkR9fjRd42cxYniX9ObJZRHo8Yvz1EGQz7gpkokXM=", "X-Google-Smtp-Source": "AGHT+IFkTBtotkJPSwidb7aIL1M2vw/OinBV4+3kqdtBAe/JzjGCiVNU2ASsiw0pQsjEcUBcVuY1qg==", "X-Received": "by 2002:a05:6808:6714:b0:44f:e801:d6d6 with SMTP id\r\n 5614622812f47-450973fb19cmr3762518b6e.6.1763224571255; Sat, 15 Nov 2025\r\n 08:36:11 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+ZbwQ0ymghjyuMIDmJHfVKYgSc0CY7KHOFKvsLewLj+gw==\"", "Received-SPF": "pass (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as permitted sender) client-ip=2607:f8b0:4864:20::32e;", "X-Gm-Gg": "ASbGncubI2frHx9oNOyFditxfeJz7bElkdGPdJqPtAnkr8teBv5JNs7MEtUlIRMhUyN\r\n\tAQji3NYONzjJ2cbMuqInFm3HR6+38h5C2mZaCqyb3X27K0x1sxqt8T0pt/sViab6w7v7/KizYAa\r\n\tuEJ6DtCjZUFB1I0Mq8rU6j/Gb86EItT5ACjrmehC3qNQUf7YpF758nsX5HCV7V0fspR9SbKt0tI\r\n\tHBWYxqk+SKj3rn58JXEtn+FxU+IA2ebY89+owmVom9qDewWLNpjdf1WMoSJNS8CI3x8Vlg4DgVY\r\n\t8bsRBmw=", "MIME-Version": "1.0", "References": "<CAFRDBvf9fG4pQETt97yGq_1=jCGyDfQWCz5RTSXrG1Y=4AWYmA@mail.gmail.com>\r\n <CA+HK9iJbzUV311x9BV_9u9EG7M6PE=OW_kfC-J1YB6d+cNTqHQ@mail.gmail.com>", "In-Reply-To": "<CA+HK9iJbzUV311x9BV_9u9EG7M6PE=OW_kfC-J1YB6d+cNTqHQ@mail.gmail.com>", "From": "Jan Boutilier <janby55@gmail.com>", "Date": "Sat, 15 Nov 2025 08:36:00 -0800", "X-Gm-Features": "AWmQ_bnySTGr_jkIrIgjaehB594TJOa-h9gEvNlXhPhKUxcJwiyUfkGy1Dx41E8", "Message-ID": "<CAPcF4QZdWVNUqGTtcnHhV733Tnn7tW-DG_08od-2FLeLpxd-WA@mail.gmail.com>", "Subject": "Re: Video Recording", "To": "ptmurder@googlegroups.com", "Content-Type": "multipart/alternative; boundary=\"0000000000003a9fd80643a4b6e3\"", "X-Original-Sender": "janby55@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=D1bnYCg+;       spf=pass\r\n (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as\r\n permitted sender) smtp.mailfrom=janby55@gmail.com;       dmarc=pass (p=NONE\r\n 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": "2.8 (++)", "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:   (2.8 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.214.192 listed in list.dnswl.org]\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 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\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_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.0 ARC_VALID              Message has a valid ARC signature\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [janby55(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  1.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to\r\n                             background\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: 28"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-11-15 16:36:00 by Jan Boutilier (janby55@gmail.com)\nSource: IMAP\n---\nI think either day would work but Thursday would be better.\r\n\r\nOn Sat, Nov 15, 2025 at 7:08\u202fAM Sean DeVries <seangdevries@gmail.com> wrote:\r\n\r\n> Wednesday is better thank you\r\n>\r\n> On Fri, Nov 14, 2025, 9:31\u202fPM Ashley Schenkel <ashley.schenkel@gmail.com>\r\n> wrote:\r\n>\r\n>> Grrrrr Rawr,\r\n>>\r\n>> We want to shoot you all! (On film)\r\n>>\r\n>> Wednesday, November 19th @ 5:45\r\n>> Thursday, November 20th @ 5:45\r\n>>\r\n>> Please tell us your date preference for your talking head interview\r\n>> videos at rehearsal tomorrow!\r\n>>\r\n>> Please be prepared with memorized video lines in case the teleprompter\r\n>> arrives later.\r\n>>\r\n>> Bleeding Chest,\r\n>> Ashley\r\n>>\r\n>> *\"I cannot do all the good that the world needs, but the world needs all\r\n>> the good that I can do.\" ~Jana Stanfield*\r\n>>\r\n>> --\r\n>> You received this message because you are subscribed to the Google Groups\r\n>> \"Port Townsend Murder Mysteries\" group.\r\n>> To unsubscribe from this group and stop receiving emails from it, send an\r\n>> email to ptmurder+unsubscribe@googlegroups.com.\r\n>> To view this discussion visit\r\n>> https://groups.google.com/d/msgid/ptmurder/CAFRDBvf9fG4pQETt97yGq_1%3DjCGyDfQWCz5RTSXrG1Y%3D4AWYmA%40mail.gmail.com\r\n>> <https://groups.google.com/d/msgid/ptmurder/CAFRDBvf9fG4pQETt97yGq_1%3DjCGyDfQWCz5RTSXrG1Y%3D4AWYmA%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n>> .\r\n>>\r\n> --\r\n> You received this message because you are subscribed to the Google Groups\r\n> \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an\r\n> email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit\r\n> https://groups.google.com/d/msgid/ptmurder/CA%2BHK9iJbzUV311x9BV_9u9EG7M6PE%3DOW_kfC-J1YB6d%2BcNTqHQ%40mail.gmail.com\r\n> <https://groups.google.com/d/msgid/ptmurder/CA%2BHK9iJbzUV311x9BV_9u9EG7M6PE%3DOW_kfC-J1YB6d%2BcNTqHQ%40mail.gmail.com?utm_medium=email&utm_source=footer>\r\n> .\r\n>\r\n\r\n\r\n-- \r\n*\"Kindness is free. Sprinkle it everywhere.\"*\r\n\r\n-- \r\nYou received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\nTo unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\nTo view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAPcF4QZdWVNUqGTtcnHhV733Tnn7tW-DG_08od-2FLeLpxd-WA%40mail.gmail.com.\r\n", "metadata": {"subject": "Re: Video Recording", "date": "Sat, 15 Nov 2025 08:36:00 -0800", "headers": {"Return-Path": "<ptmurder+bncBDQNHTVFWULRB7OX4LEAMGQEYVWZMVI@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7c7545310b8so151008a34.1\r\n        for <ptmurder@googlegroups.com>; Sat, 15 Nov 2025 08:36:12 -0800 (PST)", "Return-path": "<ptmurder+bncBDQNHTVFWULRB7OX4LEAMGQEYVWZMVI@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Sat, 15 Nov 2025 16:36:15 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763224572; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=Z/27puLG0pQg40ytajwZcoLv+fjANtEDMh3/uqeKt5fN8/J15C9s0P72lwOMi1NHSM\r\n         JXa2ee4j0DPavb5oI9ZAT8jIUXWyv1fgFKoEj1h2W0p2k6Bh89FyEYzyTsnIGG3N3YJd\r\n         LoEXFBdJSY1K3KBczvLUFZXVu8zGbiOHEYEfhsOhQDFgpyQ02JoLU9Ewb044xgWk0RSj\r\n         i+1Duj14fpFbiQQ8eq4gSDMWwzG9gxtrb5GckVQJ7xV5i0e6hDxjDVnRXvHPj7x1jwCb\r\n         cxDgRMktau/yKU/V3x4Gm7Q8wiLVOZUuh62ftMtr21LO1qPD1ginuXGr9fQeK1DN6/K8\r\n         JlKg==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:subject:message-id:date:from:in-reply-to:references:mime-version\r\n         :dkim-signature;\r\n        bh=HYf158V296tPwDl3dlMCkuWusnqhDSb45mM0mMG9G2I=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=edFQXSSO8tw1e266mc95e4wFgQ+UDGCa91/5977NkaIarYSg3255IHK0hPef/urtfu\r\n         k594B+rL9OcWn+5N+Cj5nUwj/lmImE+KYT1I5DHh3CDZGjV0UNq7s5Mn0U3EjcjHN70v\r\n         YybY5NEik//bB7NIijyuCPXPeFG/hK3M9JJqyweBAWsmNQ28yePPsc4ShFEqNg4kWhDX\r\n         Fodptdyi1Z49xJk8wlI2Ikc/fGW1JwyOAW+J858207eScIchnVim0QXs3xDSOnz631Nl\r\n         j/sz5dDCSOl8obwwf1pL5wVNqQCSZH5uG+Nt8fOXo482i8YrLvxyfY72j1JFHFMT9Odi\r\n         Qx5Q==;\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=D1bnYCg+;\r\n       spf=pass (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as permitted sender) smtp.mailfrom=janby55@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=1763224574; x=1763829374; 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:subject:message-id:date:from:in-reply-to\r\n         :references:mime-version:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=CQLVI/ccQ80qqjujR6DGgtmQkJr70ppyTCa9oVNhF8Q=;\r\n        b=KX4YJUq5LU4Ld1XXcORL7PyxaKuV/bY9rZ5fE3ecI2O9QkDcX6E0SksFfrtzKPpiOU\r\n         ZUyh05n86pmzGsvr/6v5z2A4dc9mu2pu/TERF5fj1JKtYuGK/Kf/lwcD8UJbvqjZ1Brt\r\n         H9wY8RERF6GWDOQdLo1zRS9odaV/urArBpXAirrVeKejBJofaAxHdGR/WJOz5vQX9lus\r\n         2HUh1F1D0HYUyvmXKnIVtuubr4ifQE7XXamZqM676N0rcjfUFOlV0NQEIuyT4cbkNpzF\r\n         zWIPEnolMpkjOHMUChHqJUE96ovzvS94oYi+zyc/cwB6W6SxfL13AnXyn5u1zjqQVdIG\r\n         /6Qg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763224574; x=1763829374;\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:subject\r\n         :message-id:date:from:in-reply-to:references:mime-version:x-gm-gg\r\n         :x-beenthere:x-gm-message-state:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=CQLVI/ccQ80qqjujR6DGgtmQkJr70ppyTCa9oVNhF8Q=;\r\n        b=cysTk6T3rUglJDazpt6E+TqgguSc9mf53aaz9kTB9s0DcenpFaLwqkMzjl5xpfGDHs\r\n         Z0cTohAmYzfLmfuC/XRV6Lc0+0VEd8cS8Ldhg8XCazLdht2fZlKmQXZ8GSaZIrXF0BOl\r\n         9lqDQ+lUofTf8tBc7Orqv7zbWSblT5QugXb5U3Pss4I4LFkebiCqzBR1WaLwBdJmX2BY\r\n         4SIfpqSmZ2+MUA3cRJUWzltlQqAE2JXE8BCOnQMnQmPM4CnZQBSzBmjarrjxZE2WSW7j\r\n         1WNad3aYKOjZDwZ/+yZULVteI8qWIAFMS3+V26mYQq84dIVD7myltyCcPADZm377cZ72\r\n         FvUA==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCXDl9bNTaumXj5i6DnUrkmRkcFMuKvMQ5Oyf1Lk2wYEM8PV5rjoqARVGdhb82wTHWlC8nrq@raingull.org", "X-Gm-Message-State": "AOJu0YxbzCKWk0/xifmeph4B+S1zG5x3RA35GAxH0Hr9Ypy6zu7431Pv\r\n\tbTpsFdSf3piWhnpkR9fjRd42cxYniX9ObJZRHo8Yvz1EGQz7gpkokXM=", "X-Google-Smtp-Source": "AGHT+IFkTBtotkJPSwidb7aIL1M2vw/OinBV4+3kqdtBAe/JzjGCiVNU2ASsiw0pQsjEcUBcVuY1qg==", "X-Received": "by 2002:a05:6808:6714:b0:44f:e801:d6d6 with SMTP id\r\n 5614622812f47-450973fb19cmr3762518b6e.6.1763224571255; Sat, 15 Nov 2025\r\n 08:36:11 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+ZbwQ0ymghjyuMIDmJHfVKYgSc0CY7KHOFKvsLewLj+gw==\"", "Received-SPF": "pass (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as permitted sender) client-ip=2607:f8b0:4864:20::32e;", "X-Gm-Gg": "ASbGncubI2frHx9oNOyFditxfeJz7bElkdGPdJqPtAnkr8teBv5JNs7MEtUlIRMhUyN\r\n\tAQji3NYONzjJ2cbMuqInFm3HR6+38h5C2mZaCqyb3X27K0x1sxqt8T0pt/sViab6w7v7/KizYAa\r\n\tuEJ6DtCjZUFB1I0Mq8rU6j/Gb86EItT5ACjrmehC3qNQUf7YpF758nsX5HCV7V0fspR9SbKt0tI\r\n\tHBWYxqk+SKj3rn58JXEtn+FxU+IA2ebY89+owmVom9qDewWLNpjdf1WMoSJNS8CI3x8Vlg4DgVY\r\n\t8bsRBmw=", "MIME-Version": "1.0", "References": "<CAFRDBvf9fG4pQETt97yGq_1=jCGyDfQWCz5RTSXrG1Y=4AWYmA@mail.gmail.com>\r\n <CA+HK9iJbzUV311x9BV_9u9EG7M6PE=OW_kfC-J1YB6d+cNTqHQ@mail.gmail.com>", "In-Reply-To": "<CA+HK9iJbzUV311x9BV_9u9EG7M6PE=OW_kfC-J1YB6d+cNTqHQ@mail.gmail.com>", "From": "Jan Boutilier <janby55@gmail.com>", "Date": "Sat, 15 Nov 2025 08:36:00 -0800", "X-Gm-Features": "AWmQ_bnySTGr_jkIrIgjaehB594TJOa-h9gEvNlXhPhKUxcJwiyUfkGy1Dx41E8", "Message-ID": "<CAPcF4QZdWVNUqGTtcnHhV733Tnn7tW-DG_08od-2FLeLpxd-WA@mail.gmail.com>", "Subject": "Re: Video Recording", "To": "ptmurder@googlegroups.com", "Content-Type": "multipart/alternative; boundary=\"0000000000003a9fd80643a4b6e3\"", "X-Original-Sender": "janby55@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=D1bnYCg+;       spf=pass\r\n (google.com: domain of janby55@gmail.com designates 2607:f8b0:4864:20::32e as\r\n permitted sender) smtp.mailfrom=janby55@gmail.com;       dmarc=pass (p=NONE\r\n 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": "2.8 (++)", "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:   (2.8 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.214.192 listed in list.dnswl.org]\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 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\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_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.0 ARC_VALID              Message has a valid ARC signature\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [janby55(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  1.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to\r\n                             background\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: 28"}}, "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 128 in core_formatted_messages