Query

branch.sqlite — sync_outbox

SQL

CREATE TABLE "sync_outbox"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_sync_outbox" PRIMARY KEY,
  "EntityType" TEXT NOT NULL,
  "EntityId" TEXT NOT NULL,
  "Operation" TEXT NOT NULL,
  "PayloadJson" TEXT NOT NULL,
  "HlcSerialized" TEXT NOT NULL,
  "OriginNodeId" TEXT NOT NULL,
  "Status" TEXT NOT NULL,
  "RetryCount" INTEGER NOT NULL,
  "SentAt" TEXT NULL,
  "ErrorMessage" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
EntityType TEXT Rename | Drop
EntityId TEXT Rename | Drop
Operation TEXT Rename | Drop
PayloadJson TEXT Rename | Drop
HlcSerialized TEXT Rename | Drop
OriginNodeId TEXT Rename | Drop
Status TEXT Rename | Drop
RetryCount INTEGER Rename | Drop
SentAt TEXT ✓ Rename | Drop
ErrorMessage TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_sync_outbox_EntityType_EntityId
  • EntityType
  • EntityId
 SQL 
CREATE INDEX "IX_sync_outbox_EntityType_EntityId"
ON "sync_outbox" ("EntityType", "EntityId")
Drop
IX_sync_outbox_Status Status SQL 
CREATE INDEX "IX_sync_outbox_Status"
ON "sync_outbox" ("Status")
Drop
sqlite_autoindex_sync_outbox_1 Id ✓ SQL
-- no sql found --
 Drop