Query

whitelabel.db — Tenants

SQL

CREATE TABLE "Tenants"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_Tenants" PRIMARY KEY AUTOINCREMENT,
  "TenantSlug" TEXT NOT NULL,
  "TenantName" TEXT NOT NULL,
  "TenantType" TEXT NOT NULL,
  "UserId_AIAgentic" TEXT NULL,
  "BrandName" TEXT NULL,
  "PrimaryColor" TEXT NULL,
  "LogoIcon" TEXT NULL,
  "WelcomeTitle" TEXT NULL,
  "WelcomeMessage" TEXT NULL,
  "SuggestionChips" TEXT NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER ✓ Rename | Drop
TenantSlug TEXT Rename | Drop
TenantName TEXT Rename | Drop
TenantType TEXT Rename | Drop
UserId_AIAgentic TEXT ✓ Rename | Drop
BrandName TEXT ✓ Rename | Drop
PrimaryColor TEXT ✓ Rename | Drop
LogoIcon TEXT ✓ Rename | Drop
WelcomeTitle TEXT ✓ Rename | Drop
WelcomeMessage TEXT ✓ Rename | Drop
SuggestionChips TEXT Rename | Drop
IsActive INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_Tenants_IsActive IsActive SQL 
CREATE INDEX "IX_Tenants_IsActive"
ON "Tenants" ("IsActive")
Drop
IX_Tenants_TenantSlug TenantSlug ✓ SQL 
CREATE UNIQUE INDEX "IX_Tenants_TenantSlug"
ON "Tenants" ("TenantSlug")
Drop
IX_Tenants_TenantType TenantType SQL 
CREATE INDEX "IX_Tenants_TenantType"
ON "Tenants" ("TenantType")
Drop