Query

whitelabel.db — TenantFeatureConfigs

SQL

CREATE TABLE "TenantFeatureConfigs"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_TenantFeatureConfigs" PRIMARY KEY AUTOINCREMENT,
  "TenantId" INTEGER NOT NULL,
  "FeatureId" INTEGER NOT NULL,
  "ConfigKey" TEXT NOT NULL,
  "ConfigValue" TEXT NOT NULL,
  "ConfigType" TEXT NOT NULL,
  CONSTRAINT "FK_TenantFeatureConfigs_Features_FeatureId" FOREIGN KEY ("FeatureId") REFERENCES "Features" ("Id") ON DELETE CASCADE,
  CONSTRAINT "FK_TenantFeatureConfigs_Tenants_TenantId" FOREIGN KEY ("TenantId") REFERENCES "Tenants" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER ✓ Rename | Drop
TenantId INTEGER Rename | Drop
FeatureId INTEGER Rename | Drop
ConfigKey TEXT Rename | Drop
ConfigValue TEXT Rename | Drop
ConfigType TEXT Rename | Drop

Foreign Keys

Column Destination
TenantId Tenants.Id
FeatureId Features.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_TenantFeatureConfigs_FeatureId FeatureId SQL 
CREATE INDEX "IX_TenantFeatureConfigs_FeatureId"
ON "TenantFeatureConfigs" ("FeatureId")
Drop
IX_TenantFeatureConfigs_TenantId_FeatureId_ConfigKey
  • TenantId
  • FeatureId
  • ConfigKey
 ✓ SQL 
CREATE UNIQUE INDEX "IX_TenantFeatureConfigs_TenantId_FeatureId_ConfigKey"
ON "TenantFeatureConfigs" ("TenantId", "FeatureId", "ConfigKey")
Drop