SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

formatted_payload

{"to": "", "content": "Message from Raingull Server\nOriginally sent 2025-11-03 15:44:20 by Michael Crozier (michaelcrozier111@gmail.com)\nSource: IMAP\n---\n", "from": "+13603822448", "metadata": {"subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "date": "Mon, 3 Nov 2025 07:44:20 -0800", "headers": {"Return-Path": "<ptmurder+bncBC42JQUS7IKRBYU3UPEAMGQE6WE4JKY@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 d9443c01a7336-2952696f0c8sm126861705ad.71.2025.11.03.07.44.31\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 07:44:31 -0800 (PST)", "Return-path": "<ptmurder+bncBC42JQUS7IKRBYU3UPEAMGQE6WE4JKY@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Mon, 03 Nov 2025 15:44:36 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1762184673; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=iqN0ma1jENEY1bNm/KDum/cyZDQoxC/UoUvW5Z8EG0Y7+wdR5ItUdx7ZvVjdTsLSkF\r\n         a9fYDR7UUOP9iHszgU0ScwXHFfPz4xghuXiiPILKWyDCFzBtF3hnZhRMWZA7x2UAd2bA\r\n         uNI6o2yrGKgagCnd1TZrMT/vet6TURg2OSdKXuRhPwkawMRlZjXWqswwtwuNX35yC2lx\r\n         Qh0Ptxd9mK+69cIr76xDUYQZnF0EUNtZnHvr2nPRQM+e2/jjy8ng7qYE0NbPgiyMWUtv\r\n         +EI7iNtVotHUbyCw4IX4T4vUmlL6vmJge2wXIN/EM3I4vXDEvDm5X/isaYAjGtPPkI7N\r\n         AoMQ==", "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=lgUDYOnP9MGdxP+tc1I/jcJD1QRXki81E14OmffeLAQ=;\r\n        fh=xnZKGtJ0tfhBbhtRolItDIakMTmDN68mgYHcmO0LxAY=;\r\n        b=eCHbr55K57E6StKTHO1xiYQ467pkuicnPN1lnxXs69T69W6w4wnCRixm09ziTL5u3f\r\n         862BiLmmn9uu7eyZyCk8vof2kCArH2aN8T1GDjoLgpys9cHdrg7vLDAYBfXBbE2XxAkE\r\n         cm6ulxgfqX1oxv4xWXljSQEXdl9q+tfUyxcNSDbulByQmHpqMa2RauQckBH/1E8C60nq\r\n         uug1uhQFfOHToxaS42NBmXBv/zvNofvzQzK3zicKi/Xhg7RRY48H8W8wvLqp2mSIQyZe\r\n         c0RPi1OySpX9FZtzTeIZ9Ui9DNr6bC7rjxTsnVfjdDr8WAo/sAMY33IajC1JIL4luC6s\r\n         7afg==;\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=\"AAVXPCY/\";\r\n       spf=pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::42e 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=1762184675; x=1762789475; 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=Lv1V6O7oLi4QD+Yne/QZJmOtnmGNiNUJucdVIjodz8s=;\r\n        b=FU3mkIImp4BMXnXVA05zkp74J5cV4KnV7S0G9qQOd4h5cZ4PVdIyZ6EpiWTsUHs+cZ\r\n         qM4rALzk9ZM1ORtsNKcWXlM+9kfGYCFRIaPlYyB+MXc0TwdrPkMNqdtUVkpECQHbZnGd\r\n         yo6+8BESZh5pEPE9Ege8gAeK2HAO7OhjEe1iszAP6j6MwJPpLJI4EfwTsTr7/rfW3x0r\r\n         xm/aN8w4H9SReCWN6ifEKR8Y6+5JSk3Sbqv8jF7X5uylsW6vPRFx8knJ9pjY14hfvvhg\r\n         7noGeeoYmqhM+DccTiGnLxGmtz87BUWihVFdtY2j4haFjp0sQx7RJYKA6Kew1CQ9/nK7\r\n         74OA==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1762184675; x=1762789475;\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-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=Lv1V6O7oLi4QD+Yne/QZJmOtnmGNiNUJucdVIjodz8s=;\r\n        b=D1jzlDE5hvr/EZ/A492OaZt9dhXHVXv2lsbh+mIFCLpR4E83f3lXAolPgsMVt7LA1a\r\n         G4y2JFjHoxZ1C4hoscDkbt5FId2xa+HZMrhQeDk0Jp9XVRJ1ksvO8sPg2MAxe/PFrwAa\r\n         uF4DfilhBJAtt8vT+NJJt/zmrcjfnV1oYRH+UX1lQn6Az5lqpWzWEbbZ2y0K56chQbWH\r\n         TRW1biocNUmj0oMN8AOtKvbcE35lRS+S+T4umhBBeFTXT+Wrk0TKrGFmA6TSykt4Noe4\r\n         FE795oUCVcCwoU0tAw71CAFfxKHoEkRBkSwwjQw4tkhTm+klRacqiKxKFbfpQOkMYBSk\r\n         yMJw==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCXZnt4vmgnmRC5n2nUYSveO0hYrW0T14rR5uYLDaird90JUH5Hy787O71IhXDqFkSpNhqld@raingull.org", "X-Gm-Message-State": "AOJu0YxqWZONfepBUo0w+GS4/ywtT7wKs6+ooYOyXbN2kpUQGBjmsrzu\r\n\tPdWTj0QYHAzUtegHt/dV1wLIsakQC20P6VLI1Js2Kf4YgsqmuFHVA+g=", "X-Google-Smtp-Source": "AGHT+IGv/NEc1mnmS59UIsc0EwOGhafdI7Jhvz5avLFYK95VJWu43PMPqFrNUg6LkCowPNq9OH2dAw==", "X-Received": "by 2002:a17:902:e88d:b0:295:8662:6a4e with SMTP id d9443c01a7336-29586627043mr84025075ad.47.1762184672305;\r\n        Mon, 03 Nov 2025 07:44:32 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+aEakS42TlUjUCBRhgjJGtYx5w/VsPbau3Z82HxtTL3Dw==\"", "Received-SPF": "pass (google.com: domain of michaelcrozier111@gmail.com designates 2607:f8b0:4864:20::42e as permitted sender) client-ip=2607:f8b0:4864:20::42e;", "X-Gm-Gg": "ASbGncv1jxdp66nV66ECedE/2ameOyfwobjbPtqv7vjhCls5VyZtfP/eP59StD0msf6\r\n\tLeqhphPD46GZL2DG9d9r3LNFc6mnbA7KyiDaAN8Lyhp8PvVkUHm9jZGicBeqCaDnlI17q91Uym6\r\n\t3AtpjDwYhNO9hP7Fr1G7vZFLWj0PhryErmRnL+I30BMWXs0uN5PjnljNdvoKhK8kbJP0QetaYZX\r\n\tUL2YeOEL5eh14Yi6V35Coq5aNVQDsKwr0P3v7zucpG03ygXltwZxU1y+zy9UhXf9pdkNYu7NiJ5\r\n\tb3uIwEGrxtrOxlYDheBtmXkHu7BlctesjWknDJC63wM3zNhkB+6BJbLX5kWtRkW3cs6GnKRHnhB\r\n\tS6XzxQ3a/elqaUCLpJreHafgT1WlXoolO8/eDWAxPGtluVj/BbZIbAtw1JyYBjbjfmjWQ+2u6yy\r\n\tBwmtIBqRQI9A8NSyTIdb7jve8hgO86xKph4YPMm0TQ3RsddQ2bqjiiLzha", "From": "Michael Crozier <michaelcrozier111@gmail.com>", "Content-Type": "multipart/alternative; boundary=Apple-Mail-FF35B461-CA51-42AB-8465-879FC0151CD0", "Content-Transfer-Encoding": "7bit", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Schedule Change? Rehearsal Saturday instaed of Sunday?", "Date": "Mon, 3 Nov 2025 07:44:20 -0800", "Message-Id": "<59740711-AAE6-4E4E-B4E0-D180D2ACC1DF@gmail.com>", "References": "<CA+HK9iLzF8WkZnKeU8qvUD-Q-H9QkVzbcpmgsk0GY-A6Lr-AzA@mail.gmail.com>", "Cc": "ptmurder@googlegroups.com", "In-Reply-To": "<CA+HK9iLzF8WkZnKeU8qvUD-Q-H9QkVzbcpmgsk0GY-A6Lr-AzA@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=\"AAVXPCY/\";       spf=pass\r\n (google.com: domain of michaelcrozier111@gmail.com designates\r\n 2607:f8b0:4864:20::42e 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": "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: googlegroups.com]\r\n                             [URI: rallly.co]\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.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n -0.1 ARC_VALID              Message has a valid ARC signature\r\n  0.0 ARC_SIGNED             Message has a 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             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                             [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  2.0 MIME_HTML_ONLY         BODY: Message only has text/html MIME parts\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  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n  0.0 MIME_HTML_ONLY_MULTI   Multipart message only has text/html MIME parts\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 15:44:20 by Michael Crozier (michaelcrozier111@gmail.com)\nSource: IMAP\n---\n"}}

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 75 in core_formatted_messages