Query

branch.sqlite — local_stock_items

SQL

CREATE TABLE "local_stock_items"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_stock_items" PRIMARY KEY,
  "Code" TEXT NOT NULL,
  "Name" TEXT NOT NULL,
  "StockGroupId" TEXT NULL,
  "BaseUnitId" TEXT NOT NULL,
  "ItemType" TEXT NOT NULL,
  "TaxPercent" INTEGER NOT NULL,
  "DefaultPriceMinor" INTEGER NOT NULL,
  "MinStockLevel" TEXT NOT NULL,
  "SafetyStockLevel" TEXT NOT NULL,
  "HasRecipe" INTEGER NOT NULL,
  "IsMenuItem" INTEGER NOT NULL,
  "IsActive" INTEGER NOT 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
Code TEXT Rename | Drop
Name TEXT Rename | Drop
StockGroupId TEXT ✓ Rename | Drop
BaseUnitId TEXT Rename | Drop
ItemType TEXT Rename | Drop
TaxPercent INTEGER Rename | Drop
DefaultPriceMinor INTEGER Rename | Drop
MinStockLevel TEXT Rename | Drop
SafetyStockLevel TEXT Rename | Drop
HasRecipe INTEGER Rename | Drop
IsMenuItem INTEGER Rename | Drop
IsActive INTEGER 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_local_stock_items_Code Code ✓ SQL 
CREATE UNIQUE INDEX "IX_local_stock_items_Code"
ON "local_stock_items" ("Code")
Drop
IX_local_stock_items_IsMenuItem IsMenuItem SQL 
CREATE INDEX "IX_local_stock_items_IsMenuItem"
ON "local_stock_items" ("IsMenuItem")
Drop
sqlite_autoindex_local_stock_items_1 Id ✓ SQL
-- no sql found --
 Drop