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-30 23:11:09 by \"Ramon Dailey\" (ramon@stillcrazy.pro)\nSource: IMAP\n---\nYour emails might be better than the script.\r\n\r\nOn Sun, Nov 30, 2025, at 3:09 PM, Ashley Schenkel wrote:\r\n> Please remember to bring a dish to the fall of Ramon\u2019s youth (and becoming a wise wizard) cast birthday potluck today. \r\n> \r\n> We\u2019ll be bringing the cross!!! For blocking purposes. Edible handcuffs count as a side dish, Urgula. \r\n> \r\n> They who bludgeon the most elves gets front of line privileges!\r\n> \r\n> Roar Rawr,\r\n> Ashley\r\n> \r\n> *\"I cannot do all the good that the world needs, but the world needs all the good that I can do.\" ~Jana Stanfield*\r\n> \r\n> \r\n> -- \r\n> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAFRDBvcqW0UwhAe4X4fnt4zoHju%2B6Yw6NO%2Bv-g4q87%3D-7rzxEg%40mail.gmail.com <https://groups.google.com/d/msgid/ptmurder/CAFRDBvcqW0UwhAe4X4fnt4zoHju%2B6Yw6NO%2Bv-g4q87%3D-7rzxEg%40mail.gmail.com?utm_medium=email&utm_source=footer>.\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/f993ec9c-16c6-4b7a-bdec-1900f53b3856%40app.fastmail.com.\r\n", "from": "+13603822448", "metadata": {"subject": "Re: Raid today @ 4:30pm, then cast celebration potluck!", "date": "Sun, 30 Nov 2025 15:11:09 -0800", "headers": {"Return-Path": "<ptmurder+bncBDG5ZHORTUARBI46WPEQMGQESWEUUHQ@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "by mailuser.phl.internal (Postfix, from userid 501)\r\n\tid AA25A1060066; Sun, 30 Nov 2025 18:11:28 -0500 (EST)", "Return-path": "<ptmurder+bncBDG5ZHORTUARBI46WPEQMGQESWEUUHQ@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Sun, 30 Nov 2025 23:11:33 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1764544290; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=O2Pa1b9hu5Stwc+saNJhMAPY7rThXvcQDT2C7FjEPghgevN3mSz1bERI785Tc15dqs\r\n         xGnDr+9IJ1Vfy5bXpGdYtgpkVKYvM/OgvdWEbNUjrD5kpJFznc5m4xmJWhuEvPPLsUFL\r\n         gxxj2BOiXntaci6NtDVYYZ1+VmiVYbMmmI3EHNgkHJgYRHcB/zyaqLFS7Fr033z/AJRJ\r\n         ER8SBg7AMs/UAXAsfv8a9Pkqo7sPQuuFSOJMfYI834q8sJ1PX2SYtIecpGaIHMTMZZ1b\r\n         NVETrL1hUS+IOyffawSajTv4VQeqTwAJ79VfiqhpuS4j5pBBSrCuQ3BoI7/lceOzhLYM\r\n         hWwQ==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=subject:references:in-reply-to:message-id:to:from:date:mime-version\r\n         :feedback-id:dkim-signature:dkim-signature;\r\n        bh=S6hQO4GKdKy5gugry6GQgDbZONwt4Hnh6JUY1PZ1MCc=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=ZOUGhesXPLEv3OOEz4ln/taX9kAYS+NYQJI7o0u8befc56QfWEGYO7AhxzeudLKVy+\r\n         LJOxiwnLCVvQnoV3FUfg59p6p70Xpux/LjBAOvBW4sCpsQ7xfW5hmTEVd6xlI2wn7FVF\r\n         V4SoKXGQwBXVSCVQR4SZ3uB3L6I2NqyJJM/4grIrPyKbijrWTD/7hSQHLCV9XXwFhIx+\r\n         /IAaM3f4gTI8F7lTPCELqOXU1oiIy+w4FgLvUe0EtnSLLCV3SRd+Snwyw2j+JZ9wLcbf\r\n         4K4lrQgZLKNXwkWdEa1INjhn7kmFXmlmxJePgjaTz6mp1i6VGtfzP1+egPbHbzdoiuNz\r\n         PxeQ==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@stillcrazy.pro header.s=fm1 header.b=MWwYuKbk;\r\n       dkim=pass header.i=@messagingengine.com header.s=fm1 header.b=\"Bo5/d5Xq\";\r\n       spf=pass (google.com: domain of ramon@stillcrazy.pro designates 103.168.172.151 as permitted sender) smtp.mailfrom=ramon@stillcrazy.pro;\r\n       dmarc=pass (p=NONE sp=REJECT dis=NONE) header.from=stillcrazy.pro", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=googlegroups.com; s=20230601; t=1764544292; x=1765149092; 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:subject:references:in-reply-to:message-id:to:from\r\n         :date:mime-version:feedback-id:sender:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=kkt6n2SadkUctRvHiV4c7RyT45DEcTZ4F7uZW18UleM=;\r\n        b=arjcoYVH5lH+5/Agz+HQpSnHre2yDURlTwarPWfVcGuQHEqpyg70u4I4EeFpgtEL89\r\n         zLW86dVnF52dyGOPx0kRebkwdacSGFX0xdbqAU2Eah3Tbl0XR4NGJmKEkr1YBtXPLI10\r\n         JxPbTVEwfcr5QCU1NWmidpvBzO34E8H6o/DEJBw8oCjPQsEmg0n14Xp9NXOph3CbVEUp\r\n         o6R+WIADIMpNx9nNZ1+kKxjfUqTs6grp/gw4og+IMYkdXz32bU01MQpTuAFZwScdNDpf\r\n         YOzITpDsYjD7An/xAzXsX9+/YQE+vjg0ry7pwcREzAzH1tEhuXaVAdqwFGm/MAwZEN6s\r\n         TpcQ==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1764544292; x=1765149092;\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:subject\r\n         :references:in-reply-to:message-id:to:from:date:mime-version\r\n         :feedback-id:x-beenthere:x-gm-message-state:sender:from:to:cc\r\n         :subject:date:message-id:reply-to;\r\n        bh=kkt6n2SadkUctRvHiV4c7RyT45DEcTZ4F7uZW18UleM=;\r\n        b=eLeltJ+HXWqRhDNC67qgzy79kb7XLJZxQG2x+nDJeUPAj3NH+rRsE62w89kI8QfzEU\r\n         EF9kMVyUn0A6aPsAbCqjQCBica2YHRAJ/Dq4gH0cpQDNIXs4ab96hdSa+ojx3jJIlTiq\r\n         MQyurxjO5YCOA/V6cSLViLUN301ruVF7MGHHC9JE2NquWz5NkuCZt4voH40uCcDMzqMZ\r\n         fTviCG27gp7IWXTkheNEroP6B3o43EYIYcB//Lq8dWdWwL9nHwgIRc0YGpdIU6x4dxB9\r\n         J43ZyJdfNvGoiKy/xBZoOLjcfq9LwYxWM5CY+AGk2Q/+Rhqzuo8vC7uJh1ak+MwivKqB\r\n         rE8Q==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCUDma3txj1u3h1RnNt/NT9AdftucOIhf425nELbgBLzpr9nK1TgmRBCroaxUtxYp1A5LroH@raingull.org", "X-Gm-Message-State": "AOJu0YwJn7XWIz1uDRUJW3pfYMdeGH4c+iF7ruhAIDr0ZD2pfACqgohw\r\n\t5xZ5AoxOjM+YIArtRDgpnET1aVgVrcr/QaxRjhgrEuh3/HOd2ZxYKiQ=", "X-Google-Smtp-Source": "AGHT+IFvv6NSmD5qbY+3qpQGQbRLW+KTx0AyQHRadkDpfdXzNsJDQy9CeaOjzTHL5vRpQx6w2ahfDw==", "X-Received": "by 2002:a17:903:ace:b0:295:350a:f9b8 with SMTP id d9443c01a7336-29b6c685132mr367031035ad.29.1764544290131;\r\n        Sun, 30 Nov 2025 15:11:30 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+Ym74Q/PmRE4ivkm0wmt6f6RA5NjUON8fIg8i700fBQsQ==\"", "Received-SPF": "pass (google.com: domain of ramon@stillcrazy.pro designates 103.168.172.151 as permitted sender) client-ip=103.168.172.151;", "X-ME-Sender": "<xms:IM8saVhNgD92KaBgi-IaU81uQBOW4j1uFEGyRhrCspDWBXDX5xcP6g>\r\n    <xme:IM8saU3SzMd15Bo2lIQMblzOdKd4ZvSzOnhOF_Y3uNt_zOZQByhTcvFbKXAjpdSQl\r\n    ODgYhdi_cKRkUWklp9JgTJBn9ThYO4LuKFsZTcCbgwxJ53Kq-BdSf8>", "X-ME-Proxy-Cause": "gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvheeiuddvucetufdoteggodetrf\r\n    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu\r\n    rghilhhouhhtmecufedttdenucgoufhushhpvggtthffohhmrghinhculdegledmnecujf\r\n    gurhepofggfffhvffkjghfufgtsegrtderreertdejnecuhfhrohhmpedftfgrmhhonhcu\r\n    ffgrihhlvgihfdcuoehrrghmohhnsehsthhilhhltghrrgiihidrphhroheqnecuggftrf\r\n    grthhtvghrnhepgfdtjeetgfeugedtfeejveejvdeltddtheduveevuefhffefieejieeu\r\n    keehteehnecuffhomhgrihhnpehgohhoghhlvgdrtghomhenucevlhhushhtvghrufhiii\r\n    gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehrrghmohhnsehsthhilhhltghrrgii\r\n    hidrphhrohdpnhgspghrtghpthhtohepuddpmhhouggvpehsmhhtphhouhhtpdhrtghpth\r\n    htohepphhtmhhurhguvghrsehgohhoghhlvghgrhhouhhpshdrtghomh", "X-ME-Proxy": "<xmx:IM8saXFrqaFJv7l801eeBQB73KR5YJwUAMEkTbTBy7hUEgQOdWLKdA>\r\n    <xmx:IM8sabRZdrzbjdl4WkfMXtgO3nu6KpLHJUtTWvTy5LncLV5WK4Xu4w>\r\n    <xmx:IM8saexUDtkFAGNnKy9DS3WFICPJEyHch69uaN3Ccng5kpQShHGfRg>\r\n    <xmx:IM8saaOxa6UsPnFdrF7494VjDz1UCuQ48XnStOpauv9udoHN6h6jHQ>\r\n    <xmx:Ic8saWHqHHF9JN8aInTZ-uJQUlrhIRng7sSW74qTEx4hHdInFaBrvN4U>", "Feedback-ID": "i44f64897:Fastmail", "X-Mailer": "MessagingEngine.com Webmail Interface", "MIME-Version": "1.0", "X-ThreadId": "A9xH1-If43_B", "Date": "Sun, 30 Nov 2025 15:11:09 -0800", "From": "\"Ramon Dailey\" <ramon@stillcrazy.pro>", "To": "ptmurder@googlegroups.com", "Message-Id": "<f993ec9c-16c6-4b7a-bdec-1900f53b3856@app.fastmail.com>", "In-Reply-To": "<CAFRDBvcqW0UwhAe4X4fnt4zoHju+6Yw6NO+v-g4q87=-7rzxEg@mail.gmail.com>", "References": "<CAFRDBvcqW0UwhAe4X4fnt4zoHju+6Yw6NO+v-g4q87=-7rzxEg@mail.gmail.com>", "Subject": "Re: Raid today @ 4:30pm, then cast celebration potluck!", "Content-Type": "multipart/alternative;\r\n boundary=53a5f140af2e40c8b9e910020f258ff5", "X-Original-Sender": "ramon@stillcrazy.pro", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@stillcrazy.pro header.s=fm1 header.b=MWwYuKbk;       dkim=pass\r\n header.i=@messagingengine.com header.s=fm1 header.b=\"Bo5/d5Xq\";\r\n       spf=pass (google.com: domain of ramon@stillcrazy.pro designates\r\n 103.168.172.151 as permitted sender) smtp.mailfrom=ramon@stillcrazy.pro;\r\n       dmarc=pass (p=NONE sp=REJECT dis=NONE) header.from=stillcrazy.pro", "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='googlegroups.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "1.9 (+)", "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:   (1.9 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.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.186 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.214.186 listed in wl.mailspike.net]\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_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 ARC_VALID              Message has a valid ARC signature\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.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\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 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager\r\n -0.0 DKIMWL_WL_MED          DKIMwl.org - Medium trust sender", "SpamTally": "Final spam score: 19"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-11-30 23:11:09 by \"Ramon Dailey\" (ramon@stillcrazy.pro)\nSource: IMAP\n---\nYour emails might be better than the script.\r\n\r\nOn Sun, Nov 30, 2025, at 3:09 PM, Ashley Schenkel wrote:\r\n> Please remember to bring a dish to the fall of Ramon\u2019s youth (and becoming a wise wizard) cast birthday potluck today. \r\n> \r\n> We\u2019ll be bringing the cross!!! For blocking purposes. Edible handcuffs count as a side dish, Urgula. \r\n> \r\n> They who bludgeon the most elves gets front of line privileges!\r\n> \r\n> Roar Rawr,\r\n> Ashley\r\n> \r\n> *\"I cannot do all the good that the world needs, but the world needs all the good that I can do.\" ~Jana Stanfield*\r\n> \r\n> \r\n> -- \r\n> You received this message because you are subscribed to the Google Groups \"Port Townsend Murder Mysteries\" group.\r\n> To unsubscribe from this group and stop receiving emails from it, send an email to ptmurder+unsubscribe@googlegroups.com.\r\n> To view this discussion visit https://groups.google.com/d/msgid/ptmurder/CAFRDBvcqW0UwhAe4X4fnt4zoHju%2B6Yw6NO%2Bv-g4q87%3D-7rzxEg%40mail.gmail.com <https://groups.google.com/d/msgid/ptmurder/CAFRDBvcqW0UwhAe4X4fnt4zoHju%2B6Yw6NO%2Bv-g4q87%3D-7rzxEg%40mail.gmail.com?utm_medium=email&utm_source=footer>.\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/f993ec9c-16c6-4b7a-bdec-1900f53b3856%40app.fastmail.com.\r\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 187 in core_formatted_messages