Query

avatarai.db — AspNetRoleClaims

SQL

CREATE TABLE "AspNetRoleClaims"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_AspNetRoleClaims" PRIMARY KEY AUTOINCREMENT,
  "RoleId" TEXT NOT NULL,
  "ClaimType" TEXT NULL,
  "ClaimValue" TEXT NULL,
  CONSTRAINT "FK_AspNetRoleClaims_AspNetRoles_RoleId" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id INTEGER ✓ Rename | Drop
RoleId TEXT Rename | Drop
ClaimType TEXT ✓ Rename | Drop
ClaimValue TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
RoleId AspNetRoles.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_AspNetRoleClaims_RoleId RoleId SQL 
CREATE INDEX "IX_AspNetRoleClaims_RoleId"
ON "AspNetRoleClaims" ("RoleId")
Drop