Create
Query
db.sqlite3
—
core_plugins
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 1 in core_plugins
id
Primary key.
INTEGER NOT NULL
name
varchar(100) NOT NULL
friendly_name
varchar(100) NOT NULL
version
varchar(20) NOT NULL
manifest
{"name": "smtp", "friendly_name": "SMTP Email", "version": "1.0", "description": "SMTP email integration for sending messages via email servers", "capabilities": {"incoming": false, "outgoing": true}, "formatting": {"header_template": "**Email to {recipient}:**\n---\n", "message_format": "markdown"}, "config_schema": {"host": {"type": "string", "required": true, "help_text": "SMTP server hostname or IP address"}, "port": {"type": "integer", "required": true, "default": 587, "help_text": "SMTP server port (default: 587 for TLS)"}, "username": {"type": "string", "required": false, "help_text": "Email account username"}, "password": {"type": "password", "required": false, "help_text": "Email account password"}, "use_tls": {"type": "select", "required": true, "default": "STARTTLS", "options": [{"value": "none", "label": "None"}, {"value": "STARTTLS", "label": "STARTTLS"}, {"value": "TLS", "label": "TLS"}], "help_text": "TLS mode for the connection"}, "from_address": {"type": "string", "required": true, "help_text": "Email address to send from"}, "from_name": {"type": "string", "required": false, "help_text": "Display name for the sender"}}, "user_config_schema": {"email_address": {"type": "email", "required": true, "label": "Email Address", "help_text": "The email address where you will receive messages", "default": ""}}, "message_schemas": {"outgoing": {"raingull_id": {"type": "UUIDField", "required": true, "unique": true}, "to": {"type": "EmailField", "max_length": 255, "required": true}, "source_message_id": {"type": "CharField", "max_length": 255, "required": true}, "recipients": {"type": "JSONField", "required": true}, "subject": {"type": "CharField", "max_length": 255, "required": true}, "body": {"type": "TextField", "required": true}, "headers": {"type": "JSONField", "required": false}, "status": {"type": "CharField", "max_length": 20, "choices": ["formatted", "queued", "sending", "sent", "failed"], "default": "formatted"}, "created_at": {"type": "DateTimeField", "auto_now_add": true}, "sent_at": {"type": "DateTimeField", "required": false}, "error_message": {"type": "TextField", "required": false}}}, "translation_rules": {"from_raingull": {"to": "recipients[0]", "recipients": "recipients", "subject": "subject", "body": "body", "headers": "headers"}, "to_raingull": {"sender": "sender", "recipients": "recipients", "subject": "subject", "body": "body", "headers": "headers"}}}
TEXT NOT NULL
enabled
bool NOT NULL
created_at
datetime NOT NULL
updated_at
datetime NOT NULL
Update
Cancel