Query

app.db — whatsapp_routing_pref...

SQL

CREATE TABLE whatsapp_routing_preferences  (
  chatbot_id INTEGER PRIMARY KEY,
  inbound_provider TEXT NOT NULL DEFAULT 'follow_provider_preference',
  notify_human_provider TEXT NOT NULL DEFAULT 'follow_provider_preference',
  evolution_inbound_mode TEXT NOT NULL DEFAULT 'store_only',
  updated_at TEXT,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
chatbot_id INTEGER ✓ ✓ Rename | Drop
inbound_provider TEXT Rename | Drop
notify_human_provider TEXT Rename | Drop
evolution_inbound_mode TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?