Query

app.db — conversations

SQL

CREATE TABLE "conversations"  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  channel TEXT NOT NULL DEFAULT 'whatsapp',
  user_id TEXT NOT NULL,
  instance_id INTEGER,
  conversation_name TEXT,
  is_dev_mode INTEGER DEFAULT 0,
  bot_paused INTEGER DEFAULT 0,
  bot_paused_at TEXT,
  started_at TEXT NOT NULL,
  last_message_at TEXT NOT NULL,
  message_count INTEGER DEFAULT 0,
  unread_count INTEGER DEFAULT 0,
  max_follow_ups INTEGER,
  status TEXT DEFAULT 'open',
  tags TEXT,
  profile_picture_url TEXT,
  contact_name TEXT,
  is_online INTEGER DEFAULT 0,
  last_seen TEXT,
  is_group INTEGER DEFAULT 0,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (instance_id) REFERENCES evolution_instances(id) ON DELETE SET NULL,
  UNIQUE(chatbot_id, channel, user_id, is_dev_mode)
)

+ 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_id TEXT Rename | Drop
instance_id INTEGER ✓ Rename | Drop
conversation_name TEXT ✓ Rename | Drop
is_dev_mode INTEGER ✓ Rename | Drop
bot_paused INTEGER ✓ Rename | Drop
bot_paused_at TEXT ✓ Rename | Drop
started_at TEXT Rename | Drop
last_message_at TEXT Rename | Drop
message_count INTEGER ✓ Rename | Drop
unread_count INTEGER ✓ Rename | Drop
max_follow_ups INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
tags TEXT ✓ Rename | Drop
profile_picture_url TEXT ✓ Rename | Drop
contact_name TEXT ✓ Rename | Drop
is_online INTEGER ✓ Rename | Drop
last_seen TEXT ✓ Rename | Drop
is_group INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
instance_id evolution_instances.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_conversations_chatbot_id chatbot_id SQL 
CREATE INDEX idx_conversations_chatbot_id
ON conversations(chatbot_id)
Drop
idx_conversations_last_message_at last_message_at SQL 
CREATE INDEX idx_conversations_last_message_at
ON conversations(last_message_at)
Drop
idx_conversations_unique_channel_user
  • chatbot_id
  • channel
  • user_id
  • is_dev_mode
 ✓ SQL 
CREATE UNIQUE INDEX idx_conversations_unique_channel_user
ON conversations(chatbot_id, channel, user_id, is_dev_mode)
Drop
sqlite_autoindex_conversations_1
  • chatbot_id
  • channel
  • user_id
  • is_dev_mode
 ✓ SQL
-- no sql found --
 Drop