SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
external_user_id TEXT Rename | Drop
channel_type TEXT Rename | Drop
channel_id TEXT Rename | Drop
platform_user_id TEXT Rename | Drop
platform_name TEXT Rename | Drop
platform_avatar TEXT Rename | Drop
linked_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_ext_identities_lookup
  • channel_type
  • channel_id
  • platform_user_id
 ✓ SQL 
CREATE UNIQUE INDEX idx_ext_identities_lookup
ON external_identities(channel_type, channel_id, platform_user_id)
Drop
idx_ext_identities_user external_user_id SQL 
CREATE INDEX idx_ext_identities_user
ON external_identities(external_user_id)
Drop
sqlite_autoindex_external_identities_1 id ✓ SQL
-- no sql found --
 Drop