Query

branch.sqlite — local_branch_info

SQL

CREATE TABLE "local_branch_info"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_branch_info" PRIMARY KEY,
  "BranchId" TEXT NOT NULL,
  "BrandId" TEXT NOT NULL,
  "OrganizationId" TEXT NULL,
  "NodeId" TEXT NOT NULL,
  "Code" TEXT NOT NULL,
  "Name" TEXT NOT NULL,
  "TimeZone" TEXT NOT NULL,
  "CloudBaseUrl" TEXT NOT NULL,
  "DeviceApiKeyHash" TEXT NOT NULL,
  "LastCloudAuthAt" TEXT NULL,
  "LastSyncAt" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "LastDownstreamHlc" TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
BranchId TEXT Rename | Drop
BrandId TEXT Rename | Drop
OrganizationId TEXT ✓ Rename | Drop
NodeId TEXT Rename | Drop
Code TEXT Rename | Drop
Name TEXT Rename | Drop
TimeZone TEXT Rename | Drop
CloudBaseUrl TEXT Rename | Drop
DeviceApiKeyHash TEXT Rename | Drop
LastCloudAuthAt TEXT ✓ Rename | Drop
LastSyncAt TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
LastDownstreamHlc TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_branch_info_BranchId BranchId ✓ SQL 
CREATE UNIQUE INDEX "IX_local_branch_info_BranchId"
ON "local_branch_info" ("BranchId")
Drop
sqlite_autoindex_local_branch_info_1 Id ✓ SQL
-- no sql found --
 Drop