Query

branch.sqlite — local_price_lists

SQL

CREATE TABLE "local_price_lists"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_price_lists" PRIMARY KEY,
  "ProductId" TEXT NOT NULL,
  "ChannelCode" TEXT NOT NULL,
  "PriceMinor" INTEGER NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "BranchId" TEXT NULL,
  "TaxIncluded" INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
ProductId TEXT Rename | Drop
ChannelCode TEXT Rename | Drop
PriceMinor INTEGER Rename | Drop
IsActive INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
BranchId TEXT ✓ Rename | Drop
TaxIncluded INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_price_lists_ProductId_ChannelCode_BranchId
  • ProductId
  • ChannelCode
  • BranchId
 ✓ SQL 
CREATE UNIQUE INDEX "IX_local_price_lists_ProductId_ChannelCode_BranchId"
ON "local_price_lists" ("ProductId", "ChannelCode", "BranchId")
Drop
sqlite_autoindex_local_price_lists_1 Id ✓ SQL
-- no sql found --
 Drop