SQL

CREATE TABLE wxapp_tokens  (
  id TEXT PRIMARY KEY,
  token TEXT NOT NULL UNIQUE,
  external_user_id TEXT NOT NULL,
  workspace_id TEXT NOT NULL,
  openid TEXT NOT NULL,
  expires_at TEXT NOT NULL,
  created_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
token TEXT Rename | Drop
external_user_id TEXT Rename | Drop
workspace_id TEXT Rename | Drop
openid TEXT Rename | Drop
expires_at TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_wxapp_tokens_expiry expires_at SQL 
CREATE INDEX idx_wxapp_tokens_expiry
ON wxapp_tokens(expires_at)
Drop
idx_wxapp_tokens_user
  • external_user_id
  • workspace_id
 SQL 
CREATE INDEX idx_wxapp_tokens_user
ON wxapp_tokens(external_user_id, workspace_id)
Drop
sqlite_autoindex_wxapp_tokens_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_wxapp_tokens_2 token ✓ SQL
-- no sql found --
 Drop