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 2 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": "imap", "friendly_name": "IMAP Email", "version": "1.0", "description": "IMAP email integration for fetching messages from email servers", "capabilities": {"incoming": true, "outgoing": false}, "formatting": {"header_template": "\ud83d\udce7 Email from {{ from }}", "message_format": "markdown"}, "config_schema": {"host": {"type": "string", "required": true, "label": "IMAP Server", "help_text": "IMAP server hostname or IP address"}, "port": {"type": "integer", "required": true, "default": 993, "label": "Port", "help_text": "IMAP server port (default: 993 for TLS)"}, "username": {"type": "string", "required": false, "label": "Username", "help_text": "Email account username"}, "password": {"type": "password", "required": false, "label": "Password", "help_text": "Email account password"}, "use_ssl": {"type": "select", "required": true, "default": "TLS", "label": "Security", "help_text": "The security mode to use for the connection", "options": [{"value": "None", "label": "None"}, {"value": "STARTTLS", "label": "STARTTLS"}, {"value": "TLS", "label": "TLS"}]}, "folder": {"type": "string", "required": false, "default": "INBOX", "label": "Source Folder", "help_text": "The IMAP folder to monitor for new messages (default: INBOX)"}, "processed_action": {"type": "select", "required": true, "default": "move", "label": "After Processing", "help_text": "What to do with messages after they are processed", "options": [{"value": "move", "label": "Move to Processed Folder"}, {"value": "delete", "label": "Delete Messages"}]}, "processed_folder": {"type": "string", "required": false, "default": "INBOX/Processed", "label": "Processed Folder", "help_text": "Folder to move processed messages to (e.g., INBOX/Processed)", "depends_on": {"field": "processed_action", "value": "move"}}, "fetch_interval": {"type": "integer", "required": false, "default": 60, "label": "Fetch Interval", "help_text": "How often to check for new messages (in seconds)"}}}
TEXT NOT NULL
enabled
bool NOT NULL
created_at
datetime NOT NULL
updated_at
datetime NOT NULL
Update
Cancel