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-21 19:08:39 by James Guthrie (jguthrie13@gmail.com)\nSource: IMAP\n---\n", "subject": "Re: Who Wants Dinners during the show?", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Re: Who Wants Dinners during the show?", "date": "Fri, 21 Nov 2025 11:08:39 -0800", "headers": {"Return-Path": "<ptmurder+bncBDI33BGM54FBBRPRQLEQMGQEFWA6ITY@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple ([2607:fb90:ec49:c693:69b3:a66f:fea4:4557])\r\n        by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-3472692e5c8sm6365850a91.11.2025.11.21.11.08.50\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Fri, 21 Nov 2025 11:08:50 -0800 (PST)", "Return-path": "<ptmurder+bncBDI33BGM54FBBRPRQLEQMGQEFWA6ITY@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 21 Nov 2025 19:08:55 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763752132; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=Wz61GatO+tVicMD2dshUExrSWuW6G9hW0wQ/edNVQItS+3wbZD/oLM2o/o08Gxq9w/\r\n         ywRLHfCNaou2FHBben3UoEpqqsPfnWNvyOb1TNvhb+wY1E7gje5zL5qwpvDp2FZmn+X9\r\n         cVlbRk8nZHPWcRABxxh9XOubAt3ChzZdamtnZ4lE1qkGgSMKntZTOjdwO+6J00lb/Cdx\r\n         iEwYUKX5UR95hkp8/M/AR9j7kb2NY8bjnJxXBi8wIXXazZCJSKER+MeeDeusQB4mPKdS\r\n         DOgvVXO67g9i9SzD0mFNzo5PDs4kdYRarA8QOtoFFAFvJZ57AQD7GRC5v5tGN2i7HfUg\r\n         mzIQ==", "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=bB5jTggiMp8glGgjlrwKSoOqytSQTjNGFpmeUP2ZcTM=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=Qa3bCYjTt5lkNjQtTNgsNsz/NeZEmCx2YnhvlDg0jG8MOSVrWo824nmzlIEuCgFGmL\r\n         6kVLIPjS8vA3m/jCpUGTCg6I7iOLxXvbawY2G4LtL+Zw2DicPG9oufOySmXs5bbDa5dR\r\n         VAOw7qry4CLNgU+fw6y6lVD7flNE8XEViwDucoVw7arra3rMC3EdAmzdD5BaXKErz/ey\r\n         ly+nTHEg7nEa9e7z+og0hYZzFRyx8dicAWISn01CYemKZgRSFfmWo1nNjLr2+LUEHMqK\r\n         IEt2bqNJ9L5mQ82UBSMnAmp3Rk6E9tv+Z8GROv/8bwmXN04bvFcTHCku+kNrDTLlrZuH\r\n         qRBA==;\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=mXu3uSEL;\r\n       spf=pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031 as permitted sender) smtp.mailfrom=jguthrie13@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=1763752134; x=1764356934; 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=0ogSJWD89MSUdSzyuOS32+dbj0+z8gE6g5Z1MjCFrHY=;\r\n        b=b7iX37e5w0oJJWI7oLeGLWeWR1v5d4GNATYIbxbVTNMbBIaTqsYGjh75SNpOmh97nz\r\n         GAk3pPweZAhxZbXfRJfJAMucsV26A5JnPaAjLVqvACypDKY4imLOKmwgMjcNesvblQyW\r\n         Xb0hfhUxrtxkuFfYQqImZW3zDPOJMJEhIA/nWp8m5B9AW59VDjl9Xa9ABNnAYwgSl46u\r\n         34g66Oj6d60uSOu0vGndL0o9CwsLYIEU4rR3+ODKlvCX3vtNqSNHBTH7CLjXmfS/W2fS\r\n         AAQinV0L3wNUH+9dB8xj903fhUsq57fDChKJFwKeDNQKHcriHovwdDAMG/8k3d8qzyaC\r\n         QiIA==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763752134; x=1764356934;\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-gm-gg:x-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=0ogSJWD89MSUdSzyuOS32+dbj0+z8gE6g5Z1MjCFrHY=;\r\n        b=ItlauwxV0FActVXhq4Jpb48ZiApsKGe//f7qumCtMr4FOI4s0VQDDjkGk4ZS9oT8Lh\r\n         9dt0DPRz84LURhcQNJMVMKrlKI4dH54REoCOo1ggh3x7yx8tRiIZ+rZx2hF6M4K8hXGM\r\n         MmWwoHyisidi+tKGRua2dvIUjpLgLiQWwYh1B15yUGh87laaJIZcCan2rs4Eot5XaFqZ\r\n         FmDGlCDFTGZo9El+TsGWICWZWDBBUuHzc2eZ7WOdg2EMGm/hnbP5qA185E1O31oRlr1Z\r\n         502r61rZwStJiZB1mctFrqavtkam4ZM29fD5MSl6BBWSBDgJjheHoQnJoCLugaRKzuUC\r\n         xq5A==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCXw+1ZIgiX8BDYEFzB6FfItr+EWKv1YkZKGhCN8YJyYS2fJN1q/pJ52D31JnpLDqjf3M7qP@raingull.org", "X-Gm-Message-State": "AOJu0YybMqZ+1Qr+8HrG9auV9OFe4yNN8xeiBWKOqpJ4ez7nyYRKd+eE\r\n\t//Tttu6VwAXBC87p67Cy+NA72n/EiU8dfCU9H2LuabUbqlU+41oqH/E=", "X-Google-Smtp-Source": "AGHT+IEhqJNynin9u53zdCwLnapVIjqlFkXAIW+jnc8Cwno9pT1ZnFt1baDy/bCG1Z6Fde+8rRxOMQ==", "X-Received": "by 2002:a17:90a:e703:b0:340:ad5e:c9 with SMTP id 98e67ed59e1d1-34733e97909mr3809441a91.16.1763752130910;\r\n        Fri, 21 Nov 2025 11:08:50 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+YmyzFtcMqPC4L1VrWW/gXh/sFRmKaMyVIiroOBv6Nmrw==\"", "Received-SPF": "pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031 as permitted sender) client-ip=2607:f8b0:4864:20::1031;", "X-Gm-Gg": "ASbGnctNpyvq4e6+nKIhV9xb/1PSyOrPSScFzYBZ8/qThKjBdj3TtokQwE7hPAaHjgz\r\n\tDTXRMJ3Z9jliDXS62+0TcHPPgZ5BS78idCTLZ91N3UJ+v7Xb4m1vzNFYhTcWkAAll9929JO9WdV\r\n\trjsvuVPey37lKUdUhmiIX8myzDie+Xyk6a/0fYKvGzz8e9ylkLKluDhTFyKrOR4SAkJ7xBBYVXp\r\n\tbZ/f7QKwPdoP1Zbc+yj/vSkiZklooJPAvHlIGqcUzGBL5Y8EOkJFN+SlpNAadOLfu5SxfsqovVo\r\n\t8P/DxKkDFzk3DpUMY4mA+3bFR/I/mfing93HGywkd1fQFl7n7VXu7fA7WTcJ8e8b14LvUwlAxKq\r\n\tPyQAvXukc8L7XDUJZXhH7bLaaDIkblh67hqoTWFFibxGrxiLdJ2FeFMVtY5AreApWS6/WWNuKN3\r\n\tc1f90e9S9gZ/ia1Gnsf2NA2nBEgAgzYt4otSFhAxs=", "Content-Type": "multipart/alternative; boundary=Apple-Mail-161EB19C-3CDD-4837-81F3-04FF98FFAE91", "Content-Transfer-Encoding": "7bit", "From": "James Guthrie <jguthrie13@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Who Wants Dinners during the show?", "Date": "Fri, 21 Nov 2025 11:08:39 -0800", "Message-Id": "<A3F39A25-65CF-46AE-822B-3D67BDAFAD5B@gmail.com>", "References": "<CA+gCv2fjr907TiOtRbVfyFkRGYSdNDswGcXZ7FL_redZTQ-c2w@mail.gmail.com>", "In-Reply-To": "<CA+gCv2fjr907TiOtRbVfyFkRGYSdNDswGcXZ7FL_redZTQ-c2w@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "jguthrie13@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=mXu3uSEL;       spf=pass\r\n (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031\r\n as permitted sender) smtp.mailfrom=jguthrie13@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.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:   (4.5 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.216.60 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.216.60 listed in wl.mailspike.net]\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.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.0 ARC_VALID              Message has a valid ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [jguthrie13(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\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  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 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: 45"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-11-21 19:08:39 by James Guthrie (jguthrie13@gmail.com)\nSource: IMAP\n---\n", "metadata": {"subject": "Re: Who Wants Dinners during the show?", "date": "Fri, 21 Nov 2025 11:08:39 -0800", "headers": {"Return-Path": "<ptmurder+bncBDI33BGM54FBBRPRQLEQMGQEFWA6ITY@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple ([2607:fb90:ec49:c693:69b3:a66f:fea4:4557])\r\n        by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-3472692e5c8sm6365850a91.11.2025.11.21.11.08.50\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Fri, 21 Nov 2025 11:08:50 -0800 (PST)", "Return-path": "<ptmurder+bncBDI33BGM54FBBRPRQLEQMGQEFWA6ITY@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 21 Nov 2025 19:08:55 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763752132; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=Wz61GatO+tVicMD2dshUExrSWuW6G9hW0wQ/edNVQItS+3wbZD/oLM2o/o08Gxq9w/\r\n         ywRLHfCNaou2FHBben3UoEpqqsPfnWNvyOb1TNvhb+wY1E7gje5zL5qwpvDp2FZmn+X9\r\n         cVlbRk8nZHPWcRABxxh9XOubAt3ChzZdamtnZ4lE1qkGgSMKntZTOjdwO+6J00lb/Cdx\r\n         iEwYUKX5UR95hkp8/M/AR9j7kb2NY8bjnJxXBi8wIXXazZCJSKER+MeeDeusQB4mPKdS\r\n         DOgvVXO67g9i9SzD0mFNzo5PDs4kdYRarA8QOtoFFAFvJZ57AQD7GRC5v5tGN2i7HfUg\r\n         mzIQ==", "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=bB5jTggiMp8glGgjlrwKSoOqytSQTjNGFpmeUP2ZcTM=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=Qa3bCYjTt5lkNjQtTNgsNsz/NeZEmCx2YnhvlDg0jG8MOSVrWo824nmzlIEuCgFGmL\r\n         6kVLIPjS8vA3m/jCpUGTCg6I7iOLxXvbawY2G4LtL+Zw2DicPG9oufOySmXs5bbDa5dR\r\n         VAOw7qry4CLNgU+fw6y6lVD7flNE8XEViwDucoVw7arra3rMC3EdAmzdD5BaXKErz/ey\r\n         ly+nTHEg7nEa9e7z+og0hYZzFRyx8dicAWISn01CYemKZgRSFfmWo1nNjLr2+LUEHMqK\r\n         IEt2bqNJ9L5mQ82UBSMnAmp3Rk6E9tv+Z8GROv/8bwmXN04bvFcTHCku+kNrDTLlrZuH\r\n         qRBA==;\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=mXu3uSEL;\r\n       spf=pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031 as permitted sender) smtp.mailfrom=jguthrie13@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=1763752134; x=1764356934; 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=0ogSJWD89MSUdSzyuOS32+dbj0+z8gE6g5Z1MjCFrHY=;\r\n        b=b7iX37e5w0oJJWI7oLeGLWeWR1v5d4GNATYIbxbVTNMbBIaTqsYGjh75SNpOmh97nz\r\n         GAk3pPweZAhxZbXfRJfJAMucsV26A5JnPaAjLVqvACypDKY4imLOKmwgMjcNesvblQyW\r\n         Xb0hfhUxrtxkuFfYQqImZW3zDPOJMJEhIA/nWp8m5B9AW59VDjl9Xa9ABNnAYwgSl46u\r\n         34g66Oj6d60uSOu0vGndL0o9CwsLYIEU4rR3+ODKlvCX3vtNqSNHBTH7CLjXmfS/W2fS\r\n         AAQinV0L3wNUH+9dB8xj903fhUsq57fDChKJFwKeDNQKHcriHovwdDAMG/8k3d8qzyaC\r\n         QiIA==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763752134; x=1764356934;\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-gm-gg:x-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=0ogSJWD89MSUdSzyuOS32+dbj0+z8gE6g5Z1MjCFrHY=;\r\n        b=ItlauwxV0FActVXhq4Jpb48ZiApsKGe//f7qumCtMr4FOI4s0VQDDjkGk4ZS9oT8Lh\r\n         9dt0DPRz84LURhcQNJMVMKrlKI4dH54REoCOo1ggh3x7yx8tRiIZ+rZx2hF6M4K8hXGM\r\n         MmWwoHyisidi+tKGRua2dvIUjpLgLiQWwYh1B15yUGh87laaJIZcCan2rs4Eot5XaFqZ\r\n         FmDGlCDFTGZo9El+TsGWICWZWDBBUuHzc2eZ7WOdg2EMGm/hnbP5qA185E1O31oRlr1Z\r\n         502r61rZwStJiZB1mctFrqavtkam4ZM29fD5MSl6BBWSBDgJjheHoQnJoCLugaRKzuUC\r\n         xq5A==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCXw+1ZIgiX8BDYEFzB6FfItr+EWKv1YkZKGhCN8YJyYS2fJN1q/pJ52D31JnpLDqjf3M7qP@raingull.org", "X-Gm-Message-State": "AOJu0YybMqZ+1Qr+8HrG9auV9OFe4yNN8xeiBWKOqpJ4ez7nyYRKd+eE\r\n\t//Tttu6VwAXBC87p67Cy+NA72n/EiU8dfCU9H2LuabUbqlU+41oqH/E=", "X-Google-Smtp-Source": "AGHT+IEhqJNynin9u53zdCwLnapVIjqlFkXAIW+jnc8Cwno9pT1ZnFt1baDy/bCG1Z6Fde+8rRxOMQ==", "X-Received": "by 2002:a17:90a:e703:b0:340:ad5e:c9 with SMTP id 98e67ed59e1d1-34733e97909mr3809441a91.16.1763752130910;\r\n        Fri, 21 Nov 2025 11:08:50 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+YmyzFtcMqPC4L1VrWW/gXh/sFRmKaMyVIiroOBv6Nmrw==\"", "Received-SPF": "pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031 as permitted sender) client-ip=2607:f8b0:4864:20::1031;", "X-Gm-Gg": "ASbGnctNpyvq4e6+nKIhV9xb/1PSyOrPSScFzYBZ8/qThKjBdj3TtokQwE7hPAaHjgz\r\n\tDTXRMJ3Z9jliDXS62+0TcHPPgZ5BS78idCTLZ91N3UJ+v7Xb4m1vzNFYhTcWkAAll9929JO9WdV\r\n\trjsvuVPey37lKUdUhmiIX8myzDie+Xyk6a/0fYKvGzz8e9ylkLKluDhTFyKrOR4SAkJ7xBBYVXp\r\n\tbZ/f7QKwPdoP1Zbc+yj/vSkiZklooJPAvHlIGqcUzGBL5Y8EOkJFN+SlpNAadOLfu5SxfsqovVo\r\n\t8P/DxKkDFzk3DpUMY4mA+3bFR/I/mfing93HGywkd1fQFl7n7VXu7fA7WTcJ8e8b14LvUwlAxKq\r\n\tPyQAvXukc8L7XDUJZXhH7bLaaDIkblh67hqoTWFFibxGrxiLdJ2FeFMVtY5AreApWS6/WWNuKN3\r\n\tc1f90e9S9gZ/ia1Gnsf2NA2nBEgAgzYt4otSFhAxs=", "Content-Type": "multipart/alternative; boundary=Apple-Mail-161EB19C-3CDD-4837-81F3-04FF98FFAE91", "Content-Transfer-Encoding": "7bit", "From": "James Guthrie <jguthrie13@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Who Wants Dinners during the show?", "Date": "Fri, 21 Nov 2025 11:08:39 -0800", "Message-Id": "<A3F39A25-65CF-46AE-822B-3D67BDAFAD5B@gmail.com>", "References": "<CA+gCv2fjr907TiOtRbVfyFkRGYSdNDswGcXZ7FL_redZTQ-c2w@mail.gmail.com>", "In-Reply-To": "<CA+gCv2fjr907TiOtRbVfyFkRGYSdNDswGcXZ7FL_redZTQ-c2w@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "jguthrie13@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=mXu3uSEL;       spf=pass\r\n (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::1031\r\n as permitted sender) smtp.mailfrom=jguthrie13@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.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:   (4.5 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.216.60 listed in list.dnswl.org]\r\n  0.0 RCVD_IN_MSPIKE_H3      RBL: Good reputation (+3)\r\n                             [209.85.216.60 listed in wl.mailspike.net]\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.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.0 ARC_VALID              Message has a valid ARC signature\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n  0.0 RCVD_IN_MSPIKE_WL      Mailspike good senders\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [jguthrie13(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\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  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 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: 45"}}, "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 164 in core_formatted_messages