Query

branch.sqlite — local_products

SQL

CREATE TABLE "local_products"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_products" PRIMARY KEY,
  "CategoryId" TEXT NOT NULL,
  "Code" TEXT NOT NULL,
  "Name" TEXT NOT NULL,
  "Description" TEXT NULL,
  "ImageUrl" TEXT NULL,
  "ProductType" TEXT NOT NULL,
  "BasePrice" INTEGER NOT NULL,
  "TrackStock" INTEGER NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "SortOrder" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "SectionNo" INTEGER NULL,
  "TaxPercent" INTEGER NOT NULL DEFAULT 2000
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
CategoryId TEXT Rename | Drop
Code TEXT Rename | Drop
Name TEXT Rename | Drop
Description TEXT ✓ Rename | Drop
ImageUrl TEXT ✓ Rename | Drop
ProductType TEXT Rename | Drop
BasePrice INTEGER Rename | Drop
TrackStock INTEGER Rename | Drop
IsActive INTEGER Rename | Drop
SortOrder INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
SectionNo INTEGER ✓ Rename | Drop
TaxPercent INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_products_CategoryId CategoryId SQL 
CREATE INDEX "IX_local_products_CategoryId"
ON "local_products" ("CategoryId")
Drop
IX_local_products_Code Code ✓ SQL 
CREATE UNIQUE INDEX "IX_local_products_Code"
ON "local_products" ("Code")
Drop
IX_local_products_IsActive IsActive SQL 
CREATE INDEX "IX_local_products_IsActive"
ON "local_products" ("IsActive")
Drop
sqlite_autoindex_local_products_1 Id ✓ SQL
-- no sql found --
 Drop