Query

app.db — presence_status

SQL

CREATE TABLE presence_status (
  user_id TEXT NOT NULL,
  chatbot_id INTEGER NOT NULL,
  is_online INTEGER DEFAULT 0,
  last_seen TEXT,
  typing_status TEXT,
  updated_at TEXT NOT NULL,
  PRIMARY KEY (user_id, chatbot_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
user_id TEXT ✓ Rename | Drop
chatbot_id INTEGER ✓ Rename | Drop
is_online INTEGER ✓ Rename | Drop
last_seen TEXT ✓ Rename | Drop
typing_status TEXT ✓ Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_presence_status_1
  • user_id
  • chatbot_id
 ✓ SQL
-- no sql found --
 Drop