Query

app.db — automation_agent_handoffs

SQL

CREATE TABLE automation_agent_handoffs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  channel TEXT NOT NULL,
  user_key TEXT NOT NULL,
  instructions TEXT,
  context_json TEXT,
  is_active INTEGER DEFAULT 1,
  source_automation_id INTEGER,
  replies_sent INTEGER DEFAULT 0,
  max_bot_replies INTEGER,
  created_at TEXT NOT NULL,
  updated_at TEXT,
  UNIQUE(chatbot_id, channel, user_key)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
channel TEXT Rename | Drop
user_key TEXT Rename | Drop
instructions TEXT ✓ Rename | Drop
context_json TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
source_automation_id INTEGER ✓ Rename | Drop
replies_sent INTEGER ✓ Rename | Drop
max_bot_replies INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_automation_handoffs_lookup
  • chatbot_id
  • channel
  • user_key
  • is_active
 SQL 
CREATE INDEX idx_automation_handoffs_lookup
ON automation_agent_handoffs(chatbot_id, channel, user_key, is_active)
Drop
sqlite_autoindex_automation_agent_handoffs_1
  • chatbot_id
  • channel
  • user_key
 ✓ SQL
-- no sql found --
 Drop