Query

whatsapp_automation.db — Messages

SQL

CREATE TABLE "Messages"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_Messages" PRIMARY KEY,
  "SessionId" TEXT NOT NULL,
  "ChatId" TEXT NOT NULL,
  "FromNumber" TEXT NULL,
  "ToNumber" TEXT NULL,
  "Content" TEXT NOT NULL,
  "Type" INTEGER NOT NULL,
  "Direction" INTEGER NOT NULL,
  "Status" INTEGER NOT NULL,
  "Timestamp" TEXT NOT NULL,
  "MessageId" TEXT NULL,
  "ErrorMessage" TEXT NULL,
  "SentBy" INTEGER NOT NULL,
  CONSTRAINT "FK_Messages_Sessions_SessionId" FOREIGN KEY ("SessionId") REFERENCES "Sessions" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
SessionId TEXT Rename | Drop
ChatId TEXT Rename | Drop
FromNumber TEXT ✓ Rename | Drop
ToNumber TEXT ✓ Rename | Drop
Content TEXT Rename | Drop
Type INTEGER Rename | Drop
Direction INTEGER Rename | Drop
Status INTEGER Rename | Drop
Timestamp TEXT Rename | Drop
MessageId TEXT ✓ Rename | Drop
ErrorMessage TEXT ✓ Rename | Drop
SentBy INTEGER Rename | Drop

Foreign Keys

Column Destination
SessionId Sessions.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_Messages_MessageId MessageId SQL 
CREATE INDEX "IX_Messages_MessageId"
ON "Messages" ("MessageId")
Drop
IX_Messages_SessionId_Timestamp
  • SessionId
  • Timestamp
 SQL 
CREATE INDEX "IX_Messages_SessionId_Timestamp"
ON "Messages" ("SessionId", "Timestamp")
Drop
idx_messages_chatid_timestamp
  • ChatId
  • Timestamp
 SQL 
CREATE INDEX idx_messages_chatid_timestamp
ON Messages(ChatId, Timestamp)
Drop
sqlite_autoindex_Messages_1 Id ✓ SQL
-- no sql found --
 Drop