Query

app.db — automation_whatsapp_r...

SQL

CREATE TABLE automation_whatsapp_reply_wait  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  user_key TEXT NOT NULL,
  automation_id INTEGER NOT NULL,
  entry_node_ids TEXT NOT NULL,
  context_json TEXT NOT NULL,
  created_at TEXT NOT NULL,
  UNIQUE(chatbot_id, user_key)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
user_key TEXT Rename | Drop
automation_id INTEGER Rename | Drop
entry_node_ids TEXT Rename | Drop
context_json TEXT Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_awrw_chatbot_user
  • chatbot_id
  • user_key
 SQL 
CREATE INDEX idx_awrw_chatbot_user
ON automation_whatsapp_reply_wait(chatbot_id, user_key)
Drop
sqlite_autoindex_automation_whatsapp_reply_wait_1
  • chatbot_id
  • user_key
 ✓ SQL
-- no sql found --
 Drop