Query

avatarai.db — AspNetUsers

SQL

CREATE TABLE "AspNetUsers"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_AspNetUsers" PRIMARY KEY,
  "FullName" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UserName" TEXT NULL,
  "NormalizedUserName" TEXT NULL,
  "Email" TEXT NULL,
  "NormalizedEmail" TEXT NULL,
  "EmailConfirmed" INTEGER NOT NULL,
  "PasswordHash" TEXT NULL,
  "SecurityStamp" TEXT NULL,
  "ConcurrencyStamp" TEXT NULL,
  "PhoneNumber" TEXT NULL,
  "PhoneNumberConfirmed" INTEGER NOT NULL,
  "TwoFactorEnabled" INTEGER NOT NULL,
  "LockoutEnd" TEXT NULL,
  "LockoutEnabled" INTEGER NOT NULL,
  "AccessFailedCount" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
FullName TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UserName TEXT ✓ Rename | Drop
NormalizedUserName TEXT ✓ Rename | Drop
Email TEXT ✓ Rename | Drop
NormalizedEmail TEXT ✓ Rename | Drop
EmailConfirmed INTEGER Rename | Drop
PasswordHash TEXT ✓ Rename | Drop
SecurityStamp TEXT ✓ Rename | Drop
ConcurrencyStamp TEXT ✓ Rename | Drop
PhoneNumber TEXT ✓ Rename | Drop
PhoneNumberConfirmed INTEGER Rename | Drop
TwoFactorEnabled INTEGER Rename | Drop
LockoutEnd TEXT ✓ Rename | Drop
LockoutEnabled INTEGER Rename | Drop
AccessFailedCount INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
EmailIndex NormalizedEmail SQL 
CREATE INDEX "EmailIndex"
ON "AspNetUsers" ("NormalizedEmail")
Drop
UserNameIndex NormalizedUserName ✓ SQL 
CREATE UNIQUE INDEX "UserNameIndex"
ON "AspNetUsers" ("NormalizedUserName")
Drop
sqlite_autoindex_AspNetUsers_1 Id ✓ SQL
-- no sql found --
 Drop