Create
Query
db.sqlite3
—
core_formatted_messages
auth_group
auth_group_permissions
auth_permission
core_audit_log
core_formatted_messages
core_message_queue
core_messages
core_plugins
core_servicemessagete...
core_services
core_system_configuration
core_systemmessagetemplate
core_user_permissions
core_user_services
core_users
core_users_groups
django_content_type
django_migrations
django_session
sqlite_sequence
user_accounts
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 24 in core_formatted_messages
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-10-03 23:13:46 by Roundcube (send2@raingull.org)\nSource: IMAP\n---\nMessage 40\r\n", "subject": "Message 40", "to": "", "from": "Raingull <list@raingull.org>", "attachments": [], "metadata": {"subject": "Message 40", "date": "Sat, 04 Oct 2025 01:13:46 +0200", "headers": {"Return-Path": "<send2@raingull.org>", "Delivered-To": "list@raingull.org", "Received": "from [127.0.0.1] (helo=heracles.mxrouting.net)\r\n\tby heracles.mxrouting.net with esmtpa (Exim 4.98)\r\n\t(envelope-from <send2@raingull.org>)\r\n\tid 1v4oyA-00000003OXu-1XmN\r\n\tfor list@raingull.org;\r\n\tFri, 03 Oct 2025 23:13:46 +0000", "Return-path": "<send2@raingull.org>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 03 Oct 2025 23:13:46 +0000", "X-Spam-Checker-Version": "SpamAssassin 4.0.0 (2022-12-14) on\r\n\theracles.mxrouting.net", "X-Spam-Level": "", "X-Spam-Status": "No, score=-10.0 required=30.0 tests=ALL_TRUSTED\r\n\tautolearn=disabled version=4.0.0", "MIME-Version": "1.0", "Date": "Sat, 04 Oct 2025 01:13:46 +0200", "From": "Roundcube <send2@raingull.org>", "To": "List <list@raingull.org>", "Subject": "Message 40", "Message-ID": "<b9701da664ee02d8aa24a9c9970e4cb6@raingull.org>", "X-Sender": "send2@raingull.org", "Content-Type": "text/plain; charset=US-ASCII;\r\n format=flowed", "Content-Transfer-Encoding": "7bit"}}, "payload": {"content": "Message from Raingull Server\nOriginally sent 2025-10-03 23:13:46 by Roundcube (send2@raingull.org)\nSource: IMAP\n---\nMessage 40\r\n", "metadata": {"subject": "Message 40", "date": "Sat, 04 Oct 2025 01:13:46 +0200", "headers": {"Return-Path": "<send2@raingull.org>", "Delivered-To": "list@raingull.org", "Received": "from [127.0.0.1] (helo=heracles.mxrouting.net)\r\n\tby heracles.mxrouting.net with esmtpa (Exim 4.98)\r\n\t(envelope-from <send2@raingull.org>)\r\n\tid 1v4oyA-00000003OXu-1XmN\r\n\tfor list@raingull.org;\r\n\tFri, 03 Oct 2025 23:13:46 +0000", "Return-path": "<send2@raingull.org>", "Envelope-to": "list@raingull.org", "Delivery-date": "Fri, 03 Oct 2025 23:13:46 +0000", "X-Spam-Checker-Version": "SpamAssassin 4.0.0 (2022-12-14) on\r\n\theracles.mxrouting.net", "X-Spam-Level": "", "X-Spam-Status": "No, score=-10.0 required=30.0 tests=ALL_TRUSTED\r\n\tautolearn=disabled version=4.0.0", "MIME-Version": "1.0", "Date": "Sat, 04 Oct 2025 01:13:46 +0200", "From": "Roundcube <send2@raingull.org>", "To": "List <list@raingull.org>", "Subject": "Message 40", "Message-ID": "<b9701da664ee02d8aa24a9c9970e4cb6@raingull.org>", "X-Sender": "send2@raingull.org", "Content-Type": "text/plain; charset=US-ASCII;\r\n format=flowed", "Content-Transfer-Encoding": "7bit"}}, "from_name": "Raingull", "from_address": "list@raingull.org"}}
TEXT NOT NULL
subject
varchar(255)
sender
varchar(255)
recipient
varchar(255)
error_message
NULL
TEXT
created_at
datetime NOT NULL
updated_at
datetime NOT NULL
sent_at
datetime
message_id
bigint NOT NULL
service_id
bigint NOT NULL
Update
Cancel