Query

whatsapp_automation.db — Sessions

SQL

CREATE TABLE "Sessions"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_Sessions" PRIMARY KEY,
  "Name" TEXT NOT NULL,
  "PhoneNumber" TEXT NULL,
  "Status" INTEGER NOT NULL,
  "QrCode" TEXT NULL,
  "EncryptedSessionData" BLOB NULL,
  "CreatedAt" TEXT NOT NULL,
  "LastConnectedAt" TEXT NULL,
  "LastActivityAt" TEXT NULL,
  "IsActive" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Name TEXT Rename | Drop
PhoneNumber TEXT ✓ Rename | Drop
Status INTEGER Rename | Drop
QrCode TEXT ✓ Rename | Drop
EncryptedSessionData BLOB ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
LastConnectedAt TEXT ✓ Rename | Drop
LastActivityAt TEXT ✓ Rename | Drop
IsActive INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_Sessions_PhoneNumber PhoneNumber SQL 
CREATE INDEX "IX_Sessions_PhoneNumber"
ON "Sessions" ("PhoneNumber")
Drop
IX_Sessions_Status_IsActive
  • Status
  • IsActive
 SQL 
CREATE INDEX "IX_Sessions_Status_IsActive"
ON "Sessions" ("Status", "IsActive")
Drop
idx_sessions_last_activity LastActivityAt SQL 
CREATE INDEX idx_sessions_last_activity
ON Sessions (
    LastActivityAt DESC
)
WHERE IsActive = 1
Drop
sqlite_autoindex_Sessions_1 Id ✓ SQL
-- no sql found --
 Drop