Query

avatarai.db — AspNetUserRoles

SQL

CREATE TABLE "AspNetUserRoles"  (
  "UserId" TEXT NOT NULL,
  "RoleId" TEXT NOT NULL,
  CONSTRAINT "PK_AspNetUserRoles" PRIMARY KEY ("UserId", "RoleId"),
  CONSTRAINT "FK_AspNetUserRoles_AspNetRoles_RoleId" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id") ON DELETE CASCADE,
  CONSTRAINT "FK_AspNetUserRoles_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
UserId TEXT ✓ Rename | Drop
RoleId TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
UserId AspNetUsers.Id
RoleId AspNetRoles.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_AspNetUserRoles_RoleId RoleId SQL 
CREATE INDEX "IX_AspNetUserRoles_RoleId"
ON "AspNetUserRoles" ("RoleId")
Drop
sqlite_autoindex_AspNetUserRoles_1
  • UserId
  • RoleId
 ✓ SQL
-- no sql found --
 Drop