Query

whitelabel.db — Features

SQL

CREATE TABLE "Features"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_Features" PRIMARY KEY AUTOINCREMENT,
  "FeatureKey" TEXT NOT NULL,
  "FeatureName" TEXT NOT NULL,
  "Description" TEXT NULL,
  "Category" TEXT NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER ✓ Rename | Drop
FeatureKey TEXT Rename | Drop
FeatureName TEXT Rename | Drop
Description TEXT ✓ Rename | Drop
Category TEXT Rename | Drop
IsActive INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_Features_Category Category SQL 
CREATE INDEX "IX_Features_Category"
ON "Features" ("Category")
Drop
IX_Features_FeatureKey FeatureKey ✓ SQL 
CREATE UNIQUE INDEX "IX_Features_FeatureKey"
ON "Features" ("FeatureKey")
Drop