Query

avatarai.db — AspNetRoles

SQL

CREATE TABLE "AspNetRoles"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_AspNetRoles" PRIMARY KEY,
  "Name" TEXT NULL,
  "NormalizedName" TEXT NULL,
  "ConcurrencyStamp" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Name TEXT ✓ Rename | Drop
NormalizedName TEXT ✓ Rename | Drop
ConcurrencyStamp TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
RoleNameIndex NormalizedName ✓ SQL 
CREATE UNIQUE INDEX "RoleNameIndex"
ON "AspNetRoles" ("NormalizedName")
Drop
sqlite_autoindex_AspNetRoles_1 Id ✓ SQL
-- no sql found --
 Drop