Query

avatarai.db — AspNetUserClaims

SQL

CREATE TABLE "AspNetUserClaims"  (
  "Id" INTEGER NOT NULL CONSTRAINT "PK_AspNetUserClaims" PRIMARY KEY AUTOINCREMENT,
  "UserId" TEXT NOT NULL,
  "ClaimType" TEXT NULL,
  "ClaimValue" TEXT NULL,
  CONSTRAINT "FK_AspNetUserClaims_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

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

Foreign Keys

Column Destination
UserId AspNetUsers.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_AspNetUserClaims_UserId UserId SQL 
CREATE INDEX "IX_AspNetUserClaims_UserId"
ON "AspNetUserClaims" ("UserId")
Drop