SQL

CREATE TABLE external_users  (
  id TEXT PRIMARY KEY,
  owner_user_id TEXT NOT NULL,
  display_name TEXT NOT NULL DEFAULT '',
  avatar_url TEXT NOT NULL DEFAULT '',
  phone TEXT,
  status TEXT NOT NULL DEFAULT 'active',
  metadata TEXT NOT NULL DEFAULT '{}',
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  last_active_at TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
owner_user_id TEXT Rename | Drop
display_name TEXT Rename | Drop
avatar_url TEXT Rename | Drop
phone TEXT ✓ Rename | Drop
status TEXT Rename | Drop
metadata TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
last_active_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_external_users_owner
  • owner_user_id
  • last_active_at
 SQL 
CREATE INDEX idx_external_users_owner
ON external_users(owner_user_id, last_active_at)
Drop
idx_external_users_owner_phone
  • owner_user_id
  • phone
 ✓ SQL 
CREATE UNIQUE INDEX idx_external_users_owner_phone
ON external_users(owner_user_id, phone) WHERE phone IS NOT NULL
Drop
sqlite_autoindex_external_users_1 id ✓ SQL
-- no sql found --
 Drop