Query

app.db — whatsapp_lid_phone_map

SQL

CREATE TABLE whatsapp_lid_phone_map  (
  chatbot_id INTEGER NOT NULL,
  lid_digits TEXT NOT NULL,
  phone_digits TEXT NOT NULL,
  updated_at TEXT NOT NULL,
  PRIMARY KEY (chatbot_id, lid_digits)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
chatbot_id INTEGER ✓ Rename | Drop
lid_digits TEXT ✓ Rename | Drop
phone_digits TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_lid_phone_map_phone
  • chatbot_id
  • phone_digits
 SQL 
CREATE INDEX idx_lid_phone_map_phone
ON whatsapp_lid_phone_map (chatbot_id, phone_digits)
Drop
sqlite_autoindex_whatsapp_lid_phone_map_1
  • chatbot_id
  • lid_digits
 ✓ SQL
-- no sql found --
 Drop