SQL

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 ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
type TEXT Rename | Drop
name TEXT Rename | Drop
enabled INTEGER Rename | Drop
status TEXT Rename | Drop
credentials TEXT Rename | Drop
default_workspace_id TEXT Rename | Drop
default_model TEXT Rename | Drop
dm_policy TEXT Rename | Drop
group_policy TEXT Rename | Drop
trigger_mode TEXT Rename | Drop
group_whitelist TEXT Rename | Drop
sender_whitelist TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
owner_user_id TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_im_channels_1 id ✓ SQL
-- no sql found --
 Drop