Query
CREATE TABLE external_identities (
id TEXT PRIMARY KEY,
external_user_id TEXT NOT NULL,
channel_type TEXT NOT NULL,
channel_id TEXT NOT NULL DEFAULT '',
platform_user_id TEXT NOT NULL,
platform_name TEXT NOT NULL DEFAULT '',
platform_avatar TEXT NOT NULL DEFAULT '',
linked_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now'))
)