Query

avatarai.db — AspNetUserTokens

SQL

CREATE TABLE "AspNetUserTokens"  (
  "UserId" TEXT NOT NULL,
  "LoginProvider" TEXT NOT NULL,
  "Name" TEXT NOT NULL,
  "Value" TEXT NULL,
  CONSTRAINT "PK_AspNetUserTokens" PRIMARY KEY ("UserId", "LoginProvider", "Name"),
  CONSTRAINT "FK_AspNetUserTokens_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
LoginProvider TEXT ✓ Rename | Drop
Name TEXT ✓ Rename | Drop
Value TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
UserId AspNetUsers.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_AspNetUserTokens_1
  • UserId
  • LoginProvider
  • Name
 ✓ SQL
-- no sql found --
 Drop