Query

webui.db — oauth_session

SQL

CREATE TABLE oauth_session  (
  id TEXT NOT NULL,
  user_id TEXT NOT NULL,
  provider TEXT NOT NULL,
  token TEXT NOT NULL,
  expires_at BIGINT NOT NULL,
  created_at BIGINT NOT NULL,
  updated_at BIGINT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY(user_id) REFERENCES user (id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
user_id TEXT Rename | Drop
provider TEXT Rename | Drop
token TEXT Rename | Drop
expires_at BIGINT Rename | Drop
created_at BIGINT Rename | Drop
updated_at BIGINT Rename | Drop

Foreign Keys

Column Destination
user_id user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_oauth_session_expires_at expires_at SQL 
CREATE INDEX idx_oauth_session_expires_at
ON oauth_session (expires_at)
Drop
idx_oauth_session_user_id user_id SQL 
CREATE INDEX idx_oauth_session_user_id
ON oauth_session (user_id)
Drop
idx_oauth_session_user_provider
  • user_id
  • provider
 SQL 
CREATE INDEX idx_oauth_session_user_provider
ON oauth_session (user_id, provider)
Drop
sqlite_autoindex_oauth_session_1 id ✓ SQL
-- no sql found --
 Drop