SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

service_message_id

varchar(255)

subject

varchar(255)

sender

varchar(255)

timestamp

datetime

payload

{"content": "", "attachments": [], "metadata": {"subject": "Re: Video Recording", "date": "Sat, 15 Nov 2025 12:02:18 -0800", "headers": {"Return-Path": "<ptmurder+bncBC3K3L6FV4GBBWFY4PEAMGQEMDRE63A@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-2985c245007sm93316995ad.31.2025.11.15.12.02.29\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Sat, 15 Nov 2025 12:02:29 -0800 (PST)", "Return-path": "<ptmurder+bncBC3K3L6FV4GBBWFY4PEAMGQEMDRE63A@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Sat, 15 Nov 2025 20:02:35 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763236951; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=dN1xzbdIQD8PrahAD+Zco1LOV3sFmf1IiAsn7qNPyJVMiaPYHGr2o+fBQT2UGbIAsC\r\n         lhDGPXpykWIx8tMZhLMoJCrV96e5llepKQKBJ4kE/bdFq+vIe9vrH0GYdfN2zQNcnVCr\r\n         +BdMswFmZ2b7lO4XTG1/vo2QKaJn0x64iXsBTTTLbEskNFEF68biu+DEtnUYjsutz+f1\r\n         x7XhmaKV2llMu9GXfe3+4TzilcggcIMvSPf74keedM7aCcKPep/EU0f1NKCka0uWXVg1\r\n         VbEGLgO4j2fhI6sg4Xkuu4jEq/Hdn0mZAbYN3iApaffTjIHqDzZ92M9FLmXSu06nbcVB\r\n         dlHw==", "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         :from:content-transfer-encoding:dkim-signature;\r\n        bh=VkAsFx/8XV+f8FxYzxw12Wg40SssnrPehHAMre4b/Ho=;\r\n        fh=xnZKGtJ0tfhBbhtRolItDIakMTmDN68mgYHcmO0LxAY=;\r\n        b=MEYnFoSVpuzWSWPiYiATPb/27+/B4DieopR+M3HhsFDBh1l0CDwLvB36CO1UO/2auG\r\n         FmabaD6Pgr1G2wmPf/1PI2jL9ADqfpNNpSUUa0CcmGJt2yo6PRjuuuIbyM5DyCCcUdt0\r\n         dLFLdejHb5rjTIviJ8wywGemmqklkwkRiwsoAoNrjLSPvOIWUJaGVifXV/oHGY144cBv\r\n         /MwwO6JPZgUcmCoivx5iJPMRuHvNN4v9CIl6dIfaTymAQ45tIpqFDGLoxgdRjZDLD2xF\r\n         YQaP6vbptUuvWKMLwxDScb49WdINH1fptmZuezgnJxkh0WHnjySW/v1p7i/P5m5pvuk6\r\n         TvxQ==;\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=fwC1HBEt;\r\n       spf=pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::629 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=1763236953; x=1763841753; 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:from:content-transfer-encoding:from:to:cc\r\n         :subject:date:message-id:reply-to;\r\n        bh=KRcpOnfvbcpwG4pZ6fReL+5XWWiv4xYS9qpR3CalMeI=;\r\n        b=LnS1rca0IC3Pnh7a/Fnt7yu63DRwQGvtJEYBV4qugxrmjPcdLozws6eJClIpTeBqSz\r\n         nOTIqY/M2TJsExw/4PhEo6mDiNWF89XnEPxKsTeLDuscKPgj0Td0avXYvBqdXWZnVN9C\r\n         mB08KAAMoo5H7rjFMtzY/bc9lxAskIeDKDAEzi+E4WsQ/w+AxkFM+jMkY3+HJ/A24CX3\r\n         4BLlVzekZrVd90wk4mFsBPDcXEiNgzjsPG+Odnf0ITJZjpG5kWtCh/YEf/j/FszvVq9Y\r\n         9DnzXvt7e1u9gt3bDoJYAbWCiS6lKzFsEXebeEUrXyIuyAdW+SyfeMlBD92j2WE/ArHN\r\n         fphg==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763236953; x=1763841753;\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: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=KRcpOnfvbcpwG4pZ6fReL+5XWWiv4xYS9qpR3CalMeI=;\r\n        b=GuFbm1JWaJcHeAkLMO37Y27WHewbD13K2uzbucyF3OGo7ZmNlal3zaKDq/OI+8m5av\r\n         uaQGUyL294Qg7r0klRV4iX/Dm5nk8WZypmKTBwdUsNXMB+emKHVvFeuvtdXUCkn0UUFf\r\n         GAQOLIZo861Ybiir9KtPWlr2MFy4M0m3dJWScYrG5zj4DuFFx+svXSakuVX2Wl3diJCC\r\n         vNuPBC0UpYxi8umtuTSJUQ0rjvmC7sUt8l6gPkmamnMPtnlw/XrHwrmCPVyKnCX8n5Mb\r\n         GGabGrWcYDaabBWGx7RIuneKtpNFbY5r2Sw95NAu9aWFlP3Hwc9thGwyzo9oK1mL/37c\r\n         ec1g==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCUrpMra4BOk40xL8kBXXewCLATja/3Gc3VDCMFDjz/n+5eJTa6r00+GnmqFzFOrJrduLD9d@raingull.org", "X-Gm-Message-State": "AOJu0YwMfGp36m4wg0zYxtMgmZSvfWye2UejSJ5oEUcQMDZNftlJO/pb\r\n\tXxj40NEFdU5p+ziQ0jtczNX+jvJecsBZHd3ESneMb3+O2AgFltj1Vx4=", "X-Google-Smtp-Source": "AGHT+IFoaFIBu1SWQBHNtuIKAJx231YJQZkDkMnzeqje5aDRMjRAo90K1K9LnODDCixK/s5Ul93dCQ==", "X-Received": "by 2002:a17:903:1104:b0:295:9b39:4533 with SMTP id d9443c01a7336-2986a73b30emr89094995ad.30.1763236950646;\r\n        Sat, 15 Nov 2025 12:02:30 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+agNjNymYFMJnmYSLyPZJGR859+9A8ZSrdGCOPXyxii5Q==\"", "Received-SPF": "pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::629 as permitted sender) client-ip=2607:f8b0:4864:20::629;", "X-Gm-Gg": "ASbGnctTDFkxEdl00KcL+oZQcoMensHmXW8NnN8Tq7oBeawsrJixbqmZW9MoA07HLBM\r\n\tT+X/PCZjwJIEDsYvMMIM7RX4zLnF2wbYJCewuYM0oH7JbqKUz+brE8QOSizPuKeiRJx7B32jHhU\r\n\t2sM3bcuOfLQAOoJc0+QUsaQjj+G17sW1LlJSRnU7K6pSXf9TN6inxI3/gYcwwciOvBWaysX24UB\r\n\tBC04H/+3y7KVQEzE6cyMa6W78Lwi1LjjEUPkqjqsvxwH2yft55yyIzjUbCUyH476qIwjv9OfZW5\r\n\tqwW7N1MsNtEIlrK/VfmWeEhpKruLE3w5WN8M7LSQ3+PPiWGoNvgGgDzipNPLBnXKsNMzKRxDe5j\r\n\t+gRiPaSWh/RnyFovfRW0RNQXcxQD9mTydia/JB30c6leJ8ugeD3xhC8C4M8/OHQ3e47h7kO/7Uo\r\n\teYt74+zKLdNbt9cYMtlZahZfB0OcLSfYQIGebQGLmWu30=", "Content-Type": "multipart/alternative; boundary=Apple-Mail-55E38394-59CB-48B4-BD60-E43FBAF82617", "Content-Transfer-Encoding": "7bit", "From": "Megan DeVries <megpixels@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Video Recording", "Date": "Sat, 15 Nov 2025 12:02:18 -0800", "Message-Id": "<A472D076-B750-419E-935D-A863692E87DB@gmail.com>", "References": "<D7B2114D-E439-4D41-98AD-7B0DF12526C4@gmail.com>", "Cc": "ptmurder@googlegroups.com", "In-Reply-To": "<D7B2114D-E439-4D41-98AD-7B0DF12526C4@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=fwC1HBEt;       spf=pass\r\n (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::629\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": "5.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:   (5.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 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.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 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.0 ARC_VALID              Message has a valid ARC signature\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                             [megpixels(at)gmail.com]\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  1.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to\r\n                             background\r\n  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\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 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager\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 -0.0 RCVD_IN_DNSWL_NONE     RBL: Sender listed at https://www.dnswl.org/, no\r\n                             trust\r\n                             [209.85.160.190 listed in list.dnswl.org]", "SpamTally": "Final spam score: 55"}}}

TEXT NOT NULL

standardized_payload

TEXT

attachments

TEXT NOT NULL

is_urgent

bool NOT NULL

error_message

TEXT

created_at

datetime NOT NULL

updated_at

datetime NOT NULL

standardized_at

datetime

user_id

varchar(8)

service_id

bigint NOT NULL

db.sqlite3 — core_messages

Update row 61 in core_messages