Query

app.db — whatsapp_provider_pre...

SQL

CREATE TABLE whatsapp_provider_preferences  (
  chatbot_id INTEGER PRIMARY KEY,
  provider TEXT NOT NULL DEFAULT 'evolution_qr',
  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
provider TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?