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-03 16:30:34 by Megan DeVries (megpixels@gmail.com)\nSource: IMAP\n---\n", "subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "date": "Mon, 3 Nov 2025 08:30:34 -0800", "headers": {"Return-Path": "<ptmurder+bncBC3K3L6FV4GBBOFRUPEAMGQEWEBY3DQ@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-167-77.wavecable.com. [24.113.167.77])\r\n        by smtp.gmail.com with ESMTPSA id d9443c01a7336-295586482c6sm89091275ad.22.2025.11.03.08.30.45\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Mon, 03 Nov 2025 08:30:46 -0800 (PST)", "Return-path": "<ptmurder+bncBC3K3L6FV4GBBOFRUPEAMGQEWEBY3DQ@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Mon, 03 Nov 2025 16:30:50 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1762187447; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=LVAgqB8B500baLVzvMV6AfUWzB2HvOIqQwHYbQIzEyROGU1MdSW1Iq0uTWgKvjrXQn\r\n         sMa7ymoJiD6sLUaSKHoxABdvKB4Qgq/yBNzG9UCoyCpLERZTctA9al5u7KUWMEubT7GH\r\n         3EbYdHHJEWXaxkdushfKLj8hK96mCZ24/HBHFY+W0Sdt3UzGnihecDHlfTLkTLXpyw4/\r\n         tJMQuC/yRSpWfvA6K6lf2FcejxbmZyXZHu9AnJ3RDl649L4wVB03E4v6akRwFOmQzhX3\r\n         HUJA4zdhXwXhvzrwSAfoVW3k+5QNe79i9QgZvaVbHgBPPfuUwMzElNfT3xPAuUL15KaW\r\n         r7CA==", "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=7QGcoanS5v9ht5/ykndrJoXhVcONFVBFt5RYOMjwpwY=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=J1vcE06L4v1RANDLTBRkqfWOR8vTfL4fihiFgTxc0uzHUnHTn9lbOTW1NwVU/bPmlz\r\n         4nYUmTOtzW1CwXLvLvTM0LZIa3u5JpoyxNpzqhDnRKEfThQ2Yx0epjHP5Jc4tJRQHSyS\r\n         RfhmMWyOPAPVocF0pobF4HIzRzq4MD8sWGYUAc7jh1LVUjofMfzWXu4Zu0jAAmlA5JND\r\n         LrvwbJCVuUTAylCf8Mdi4wrkZPw2prHAEUkRui6ZG6QNSu0R+SMsIliXp5LG6M1g0qYE\r\n         6SKU2KmAe96AumKBLGiE5z5EU+RxSKI9/vkuRLcm05W4zABRs4Gt30AM6VnxkbmpqL2z\r\n         xCZA==;\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=l7fAoLD2;\r\n       spf=pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532 as permitted sender) smtp.mailfrom=megpixels@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=1762187449; x=1762792249; 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=xMcI/J7i6vb3ZHBPJhD3V0yIJqOcUcF1cqVQYG2VFMo=;\r\n        b=Z55DYNFCY/DT7lBaQKeXfxMVMfAM8Dr1ADIJfePsamtjvLdIiTLuA0qNKKWy2TFAkU\r\n         dN2JheLhlt+oZS9YPh4yngUWbWz29ydANOHD250511MUz8MRxei2v4v2fpaUOQre4CcA\r\n         OsATYB5rxgnvLXWiVE3lCVyTOwqfsymP0V6NxWdgy4mR+Dkf+omz2FCglBBBqHP8EQ4P\r\n         Y+psmaIHanPpLc/NpkV9L+JHEdXg0hdykTseh/lJh7C7+9Io5v4Pn3FJe00wfDwNtptK\r\n         fcjhP9EVCH/dgyKPP706mPrjf2dGlFqtpf7sniYyo4gTDmwud6eZE2Duai1IQUI4zQDs\r\n         EQPA==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1762187449; x=1762792249;\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-beenthere:x-gm-message-state:sender\r\n         :from:to:cc:subject:date:message-id:reply-to;\r\n        bh=xMcI/J7i6vb3ZHBPJhD3V0yIJqOcUcF1cqVQYG2VFMo=;\r\n        b=BKr8Gmfa8eXe0BLYOJF2itE+Z7hkAqBfw+hnOB6qkshkHM6PxCZ09KUaTAYEPkWWN6\r\n         oq5c7Cw/k1zoTbXcH8MNJB+VirYUPvu6zXzEfE8W2R80geTB2M1B4ifzUeIkU0BJ95Nb\r\n         RsEktbFbGzODRBjRzhNlSRN8BMgb8wJOPCBNZu3ptsPO8h/i87bnitpY1Yj44hv8No4R\r\n         1zgRPTta39ro1TfxnFmjDg8p8yobtXQFQEN1JC1y4GBhmgg87dSLbp7s9+1wJ3K2BRiG\r\n         lsZK1nZuXfyvro57acrAmXqwhe/UEyncMgnQJWujdVEDjnn1idVktCuoYxF2Zs0LF/jC\r\n         etkw==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCV5RVvkQI2+Q5t60yqicNjM8hzza23nawjEjtWYbakwdPvHgFQb9ofnKmVqhIOIrDf7vQ8K@raingull.org", "X-Gm-Message-State": "AOJu0YxD5lqZJyTsKii+kxm24FWmHzy9tMumTW2Np5kxKFsvRGagu/nL\r\n\t/0MbJuNQF8lmxBPhK/Ib7joLPC5UPtDGYHCxJbXKP9sHPGwT3dhPc14=", "X-Google-Smtp-Source": "AGHT+IEkuRwl0AXyuJc8FV+elAgsvRxnUh0qHR/GHCwMG91dFEkPx7FseO1f2QMMMY3+1zztsvRxkw==", "X-Received": "by 2002:a17:903:1666:b0:270:4aa8:2dcc with SMTP id d9443c01a7336-2951a37b515mr164544835ad.19.1762187446421;\r\n        Mon, 03 Nov 2025 08:30:46 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+b8NS0BM5Xla1PgyW5Vzd/K0Wa7luBzf6k4ZbW48NZJ6w==\"", "Received-SPF": "pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532 as permitted sender) client-ip=2607:f8b0:4864:20::532;", "X-Gm-Gg": "ASbGncv4UsFQn5uA0fcHFDCrsuHZF7nr+2NwAdlyPzLo58KCt6IOdtRYk8Hb03Jx/MA\r\n\t3qwpDuetCNFknFX+cYZksQXXIgGi3hzVK2GT55tT4aNs7VQa69xSnITseNP5IJrUcMzkXiNEUL5\r\n\txnv4exuxDrBdb4xEShcxNM0W64Q2baOmtLaMGAlJVwHhsYe6HPkZ2GY4Yo+PjFx9xMb0lHrj4QX\r\n\tYmoDEz6Rc16D3oCyZAtPo8dBNVeHrCu2KyTeWSm1kS7TbAGMQznJGNDuYfj1uBsXHuPmpEpFEcB\r\n\t3CzI5XE2J+oHLxiLDXqLxCeRjpEq8bEHDBd/hFZWS86qCP8uR2C6a9C1tNOdGb3nzVKIGOYrb5I\r\n\tT4rFsXp05Xgw9YE2eiOVF0oBD1d7MrNamte17WS7sd8Yg8ldUj9krFuvOkBBOtAtffReczCOWJV\r\n\tqLJiOiNwuNDc/4KZvOjr0tp8FeWE9wD8UGVagxdzQeEe2+ao2U+oP/Gg==", "Content-Type": "multipart/alternative; boundary=Apple-Mail-3A6049F1-D1E2-4AD5-AB85-A6A3104A88B4", "Content-Transfer-Encoding": "7bit", "From": "Megan DeVries <megpixels@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "Date": "Mon, 3 Nov 2025 08:30:34 -0800", "Message-Id": "<3D7ADE6B-15B9-40A9-B315-0B05E90C7687@gmail.com>", "References": "<59740711-AAE6-4E4E-B4E0-D180D2ACC1DF@gmail.com>", "In-Reply-To": "<59740711-AAE6-4E4E-B4E0-D180D2ACC1DF@gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G86)", "X-Original-Sender": "megpixels@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=l7fAoLD2;       spf=pass\r\n (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532\r\n as permitted sender) smtp.mailfrom=megpixels@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.4 (++++)", "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.4 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: rallly.co]\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.166.55 listed in list.dnswl.org]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n -0.1 ARC_VALID              Message has a valid ARC 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.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [megpixels(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  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\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: 44"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-11-03 16:30:34 by Megan DeVries (megpixels@gmail.com)\nSource: IMAP\n---\n", "metadata": {"subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "date": "Mon, 3 Nov 2025 08:30:34 -0800", "headers": {"Return-Path": "<ptmurder+bncBC3K3L6FV4GBBOFRUPEAMGQEWEBY3DQ@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-167-77.wavecable.com. [24.113.167.77])\r\n        by smtp.gmail.com with ESMTPSA id d9443c01a7336-295586482c6sm89091275ad.22.2025.11.03.08.30.45\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Mon, 03 Nov 2025 08:30:46 -0800 (PST)", "Return-path": "<ptmurder+bncBC3K3L6FV4GBBOFRUPEAMGQEWEBY3DQ@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Mon, 03 Nov 2025 16:30:50 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1762187447; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=LVAgqB8B500baLVzvMV6AfUWzB2HvOIqQwHYbQIzEyROGU1MdSW1Iq0uTWgKvjrXQn\r\n         sMa7ymoJiD6sLUaSKHoxABdvKB4Qgq/yBNzG9UCoyCpLERZTctA9al5u7KUWMEubT7GH\r\n         3EbYdHHJEWXaxkdushfKLj8hK96mCZ24/HBHFY+W0Sdt3UzGnihecDHlfTLkTLXpyw4/\r\n         tJMQuC/yRSpWfvA6K6lf2FcejxbmZyXZHu9AnJ3RDl649L4wVB03E4v6akRwFOmQzhX3\r\n         HUJA4zdhXwXhvzrwSAfoVW3k+5QNe79i9QgZvaVbHgBPPfuUwMzElNfT3xPAuUL15KaW\r\n         r7CA==", "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=7QGcoanS5v9ht5/ykndrJoXhVcONFVBFt5RYOMjwpwY=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=J1vcE06L4v1RANDLTBRkqfWOR8vTfL4fihiFgTxc0uzHUnHTn9lbOTW1NwVU/bPmlz\r\n         4nYUmTOtzW1CwXLvLvTM0LZIa3u5JpoyxNpzqhDnRKEfThQ2Yx0epjHP5Jc4tJRQHSyS\r\n         RfhmMWyOPAPVocF0pobF4HIzRzq4MD8sWGYUAc7jh1LVUjofMfzWXu4Zu0jAAmlA5JND\r\n         LrvwbJCVuUTAylCf8Mdi4wrkZPw2prHAEUkRui6ZG6QNSu0R+SMsIliXp5LG6M1g0qYE\r\n         6SKU2KmAe96AumKBLGiE5z5EU+RxSKI9/vkuRLcm05W4zABRs4Gt30AM6VnxkbmpqL2z\r\n         xCZA==;\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=l7fAoLD2;\r\n       spf=pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532 as permitted sender) smtp.mailfrom=megpixels@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=1762187449; x=1762792249; 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=xMcI/J7i6vb3ZHBPJhD3V0yIJqOcUcF1cqVQYG2VFMo=;\r\n        b=Z55DYNFCY/DT7lBaQKeXfxMVMfAM8Dr1ADIJfePsamtjvLdIiTLuA0qNKKWy2TFAkU\r\n         dN2JheLhlt+oZS9YPh4yngUWbWz29ydANOHD250511MUz8MRxei2v4v2fpaUOQre4CcA\r\n         OsATYB5rxgnvLXWiVE3lCVyTOwqfsymP0V6NxWdgy4mR+Dkf+omz2FCglBBBqHP8EQ4P\r\n         Y+psmaIHanPpLc/NpkV9L+JHEdXg0hdykTseh/lJh7C7+9Io5v4Pn3FJe00wfDwNtptK\r\n         fcjhP9EVCH/dgyKPP706mPrjf2dGlFqtpf7sniYyo4gTDmwud6eZE2Duai1IQUI4zQDs\r\n         EQPA==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1762187449; x=1762792249;\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-beenthere:x-gm-message-state:sender\r\n         :from:to:cc:subject:date:message-id:reply-to;\r\n        bh=xMcI/J7i6vb3ZHBPJhD3V0yIJqOcUcF1cqVQYG2VFMo=;\r\n        b=BKr8Gmfa8eXe0BLYOJF2itE+Z7hkAqBfw+hnOB6qkshkHM6PxCZ09KUaTAYEPkWWN6\r\n         oq5c7Cw/k1zoTbXcH8MNJB+VirYUPvu6zXzEfE8W2R80geTB2M1B4ifzUeIkU0BJ95Nb\r\n         RsEktbFbGzODRBjRzhNlSRN8BMgb8wJOPCBNZu3ptsPO8h/i87bnitpY1Yj44hv8No4R\r\n         1zgRPTta39ro1TfxnFmjDg8p8yobtXQFQEN1JC1y4GBhmgg87dSLbp7s9+1wJ3K2BRiG\r\n         lsZK1nZuXfyvro57acrAmXqwhe/UEyncMgnQJWujdVEDjnn1idVktCuoYxF2Zs0LF/jC\r\n         etkw==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCV5RVvkQI2+Q5t60yqicNjM8hzza23nawjEjtWYbakwdPvHgFQb9ofnKmVqhIOIrDf7vQ8K@raingull.org", "X-Gm-Message-State": "AOJu0YxD5lqZJyTsKii+kxm24FWmHzy9tMumTW2Np5kxKFsvRGagu/nL\r\n\t/0MbJuNQF8lmxBPhK/Ib7joLPC5UPtDGYHCxJbXKP9sHPGwT3dhPc14=", "X-Google-Smtp-Source": "AGHT+IEkuRwl0AXyuJc8FV+elAgsvRxnUh0qHR/GHCwMG91dFEkPx7FseO1f2QMMMY3+1zztsvRxkw==", "X-Received": "by 2002:a17:903:1666:b0:270:4aa8:2dcc with SMTP id d9443c01a7336-2951a37b515mr164544835ad.19.1762187446421;\r\n        Mon, 03 Nov 2025 08:30:46 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+b8NS0BM5Xla1PgyW5Vzd/K0Wa7luBzf6k4ZbW48NZJ6w==\"", "Received-SPF": "pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532 as permitted sender) client-ip=2607:f8b0:4864:20::532;", "X-Gm-Gg": "ASbGncv4UsFQn5uA0fcHFDCrsuHZF7nr+2NwAdlyPzLo58KCt6IOdtRYk8Hb03Jx/MA\r\n\t3qwpDuetCNFknFX+cYZksQXXIgGi3hzVK2GT55tT4aNs7VQa69xSnITseNP5IJrUcMzkXiNEUL5\r\n\txnv4exuxDrBdb4xEShcxNM0W64Q2baOmtLaMGAlJVwHhsYe6HPkZ2GY4Yo+PjFx9xMb0lHrj4QX\r\n\tYmoDEz6Rc16D3oCyZAtPo8dBNVeHrCu2KyTeWSm1kS7TbAGMQznJGNDuYfj1uBsXHuPmpEpFEcB\r\n\t3CzI5XE2J+oHLxiLDXqLxCeRjpEq8bEHDBd/hFZWS86qCP8uR2C6a9C1tNOdGb3nzVKIGOYrb5I\r\n\tT4rFsXp05Xgw9YE2eiOVF0oBD1d7MrNamte17WS7sd8Yg8ldUj9krFuvOkBBOtAtffReczCOWJV\r\n\tqLJiOiNwuNDc/4KZvOjr0tp8FeWE9wD8UGVagxdzQeEe2+ao2U+oP/Gg==", "Content-Type": "multipart/alternative; boundary=Apple-Mail-3A6049F1-D1E2-4AD5-AB85-A6A3104A88B4", "Content-Transfer-Encoding": "7bit", "From": "Megan DeVries <megpixels@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "Date": "Mon, 3 Nov 2025 08:30:34 -0800", "Message-Id": "<3D7ADE6B-15B9-40A9-B315-0B05E90C7687@gmail.com>", "References": "<59740711-AAE6-4E4E-B4E0-D180D2ACC1DF@gmail.com>", "In-Reply-To": "<59740711-AAE6-4E4E-B4E0-D180D2ACC1DF@gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G86)", "X-Original-Sender": "megpixels@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=l7fAoLD2;       spf=pass\r\n (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::532\r\n as permitted sender) smtp.mailfrom=megpixels@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.4 (++++)", "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.4 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: rallly.co]\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.166.55 listed in list.dnswl.org]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n -0.1 ARC_VALID              Message has a valid ARC 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.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [megpixels(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  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\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: 44"}}, "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 80 in core_formatted_messages