CREATE TABLE im_channels (
id TEXT PRIMARY KEY,
type TEXT NOT NULL CHECK (type IN ('feishu', 'telegram', 'discord', 'weixin', 'dingtalk', 'wecom')),
name TEXT NOT NULL DEFAULT '',
enabled INTEGER NOT NULL DEFAULT 0,
status TEXT NOT NULL DEFAULT 'not_configured' CHECK (status IN ('connected', 'disconnected', 'not_configured', 'error')),
credentials TEXT NOT NULL DEFAULT '{}',
default_workspace_id TEXT NOT NULL DEFAULT '',
default_model TEXT NOT NULL DEFAULT '',
dm_policy TEXT NOT NULL DEFAULT 'open',
group_policy TEXT NOT NULL DEFAULT 'open',
trigger_mode TEXT NOT NULL DEFAULT 'mention',
group_whitelist TEXT NOT NULL DEFAULT '[]',
sender_whitelist TEXT NOT NULL DEFAULT '[]',
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
owner_user_id TEXT NOT NULL DEFAULT ''
)